Database schema does not refresh

[Moustapha]

Hello Team,

I am using a remote db server and noticed that the database is not refreshed some new changes are made. I have noticed this with the version 6 but just to make sure, I downgraded wrappler and used 5.8 and it worked fine. Is there anyone else facing this issue? Any workaround? (Opening the database connector file and saving it again does not also refresh the database).

Thank you

[franse]

Hey!
Are you sure you’re on the right target?

Take a look at this:

Define Database Connection Settings per Target

Intro When working on different targets, for example development and production, they usually have different addresses, database names, usernames and passwords. With Wappler you can easily define different database connection settings for your different targets. Setup Database Connection As you know, the active target you are working on can be selected using the Target menu: [Screenshot_1] Our project has two different targets - the local development target and the remote server which is o…

[Moustapha]

Thanks for your reply @franse

The target does not have issue as it is currently set to the remote target.
With 5.8.2 when I hit the refresh button, I can see that the DB is refreshed right away.

[guptast]

Have you tried Refresh Full Schema option by right clicking on the db or Tables under the Database Connections?

[Moustapha]

This looks to be related to the version. 6.0.0 Beta 16 works fine.

[Teodor]

How are you refreshing the schema exactly? Please make a short video demonstrating what you do in Wappler.

[Moustapha]

Hi @Teodor,

I am using the refresh button :

Also, from an API action file, I open my query and press the refresh button:

This does not refresh the db with 6.0.0. But when do this with earlier version (5.8.2) and the Beta 16 my database tables are refreshed.

I am not using the Refresh Full Schema since thie database is not directly managed.

Thank you!

[Teodor]

@Moustapha

This does not refresh the database connection, it refreshes the panel.

@Moustapha

This does not refresh the db with 6.0.0. But when do this with earlier version (5.8.2) and the Beta 16 my database tables are refreshed.

So what are the changes you don’t see?
What is the database you are using and how are you connected to it?

[Moustapha]

The database is at the remote host server and connection is successful. I am refreshing from the query and this has been working until now.
I just discovered that it is not working earlier with 6.0.0. So I had to use the Beta 16 to refresh it and can see the changes (new tables, or new database fileds) now when restart the latest version (6.0.0). (Did the same with 5.8.2 just to confirm that the issue occurs only with 6.0.0.

[Teodor]

Ok but which changes you don’t see? New tables? New columns? Renamed stuff, etc?

[Moustapha]

Sorry, I did get the question: I am not seeing the new changes (newly created tables, added fields, updates, etc.). I hope this answers your question.

[Teodor]

Please restart Wappler in debug mode, recreate the issue and attach the debug log after this happens here:

How to report bugs together with the Wappler debug log

Updated for Wappler Version 5.0 and higher We have a built-in bug reporting in Wappler that auto post a topic in this forum together with the debug log. Starting from version 1.1.0 the logging isn’t available per default, so you need to restart Wappler with logging. You can do that by clicking on the Wappler’s tray icon (Windows right click) and then choose “Restart with Logging” Then reproduce your problem and choose to submit a bug report from the Wappler menu File / Submit error report … o…

[Moustapha]

Noted. I will test later when I make new changes/updates next time and update this ticket.
Thanks!