This is frustrating, I am still having issue with the database scheme not updating when I add anew field in wappler using MYSQL on docker direct target even though in Navicat it has added the field as expected.
Is anyone else having these issues. Sometimes I have to shut down and start or restart and it may decide to update or not…
Anyone else or is it just me.
MYSQL 8 docker on Mac?
4.1.3 currently but happened in previous too and hoped this version would fix it.
Hi Steven,
Sometimes I have the same issue with postgres + docker. When it’s persistent on not updating/changing I’m changing stuff on pgadmin (postgres database management tool) and then refresh the database on wappler.
Perhaps you could use a tool for mysql like MySQL Workbench until this bug is resolved
Ah nevermind I see that you tried that with navicat… So then I don’t know…
Hi. I have found that refreshing the schema on tables node & then on the actualy table’s node helps.
Or, in the query builder, there is a refresh icon that helps as well.
I have never seen the schema update automatically, so don’t think that is even an option.
Indeed, there are refresh options placed there exactly for this purpose.
Yes it is but the point is it doesn’t always work.
I can refresh until the sun goes down and it doesn’t work.
It’s inconsistent.
Well, if it is not working for you please restart wappler with logging, recreate the issue and send us the debug log 
Shut down for the day but will do 
It will be helpful to know exactly when the refresh doesn’t work. So we can check it.
So please supply reproduction steps.
These types of bugs are the worst. If you can't reproduce it, there's a slim chance anyone can help.
Hope you can capture it when logging is on.
For me, it has be very consistent.
I am working with MariaDB and Docker and have not found this to be a problem, although saying that maybe I am just used to it, so after making any database alteration, I instantly go to Database manager, right click the table I know i just altered and refresh schema, then back to server connect to use it and it never fails.
Using the refresh inside the query builder itself seems inconsistent, sometimes it works fine for me, which is why i have always used the database manager refresh first.
Exactly the same for me.
The inherent problem is that a) you have to restart Wappler to turn on logging and b) restarting Wappler solves most problems.
The trick I have found here is, after refresh, if the columns or tables don't show up: close the query builder and open it again.
I raised a bug report for it a few weeks ago as well. Acknowledged, but not fixed yet.
To our knowledge all schema refreshes from the Database Query Builder or Insert/Update query should work just fine.
If you have a case that it is now working, with the latest version, and you can still reproduce it - please post a new bug topic.
Could you specify which part of the query builder is not refreshing.
All parts. In other words, you add a column outside of Wappler and come back to an existing query or insert, etc. For a query, the new column does not show in the list of columns nor in the conditions dropdowns, even after clicking the refresh icon within the builder. For insert, the new column is not available in the Add column dropdown.