I had AI create some tables with Claude in database manager, all went fine. l use Navicat for external database views, and that shows perfectly all the tables. In wappler database manager I refresh Full Schema, and Nothing happens…. Tried to close wappler and start again. no change. It wont refresh and update with the new tables….
Can anybody help !! (maybe its a bug)
Hi Ben… Yes I have tried to refresh list,refresh Full Schema on the screenshot you can see 12 tables. In Navicat there is 24 tables, which should have been shown in wappler database manager
Did you tried refresh full schema when the “tables” node is selected or the connection name, not just a table
Do you have any sub-tables that are hidden from view?
Here I have 6 sub-tables under employees:
Have a look at an expanded view of users.
No sub-tables at all. also tried expanded view of users
Hi George. Yes tried it all I think…on the tables node. On a single table.
I ran an ACT promt with Claude, and when working it stated “The new columns aren't showing yet — this may be a schema cache issue. Let me re-check.“ So even the AI could not see the new columns
I use Navicat as well and here is list all the tables 24 tables + 2 wapplertables. In wappler database manager it only shows 12
All tables has been created in wappler database manager. Navicat is just for view and models
Ah I see so you do use sub tables, those are tables with shared prefixes, so you will find them under their main prefix like tenants.
So all was fine their were just under the others that is why you don’t see them all on the first level.
Please show an expanded view of Users.
I am quite sure that under users you will find
Likewise, under tenants you will find
You and ben is right. Sorry I`ve been away from wappler in 3 years, and much have changed. so the fact that they are located under other tables, can I change that, or do I have to referance them special to get to them, when I do querys ?. Thanks in advance for all the help
