MySql Database with PHP
I created a new table in Navicat then updated the database schema in Wappler. The table is showing in the database window. However, when I go to server actions it’s not there. I’ve tried refreshing in the server action, using custom queries, update queries etc, restarting Wappler, and upgrading to latest version. Still, the table is missing.
Did you try refreshing the schema?
Yes. I updated the database schema in the Database manager nd the table is showing there. I also refreshed the database schema in several different types of queries but it won’t show in the Server Actions.
When I have a problem like that, I usually kill the database connection and create a new one.
I hope this helps in your case.
I have noticed, when doing a lot of db changes. Restarting Wappler works for me, most of the time.
It could be that the table is listed somewhere else in the list, due to the new nested tables setup.
I have never seen any issue with listing of tables in builder, once schema is refreshed on DB Manager.
There is a bug post where some table do not show when trying to do a join. So try finding the table in regular selection, in case you have been looking when doing a join.
This was recently resolved.