New field in table not detected

philmills1 · January 30, 2020, 11:31am

v2020
I added a new timestamp field to one of my tables
When I synchronised PHPMaker with the database, the change was not detected.
Tried restarting PHPMaker, but still not detected.How can I force detection?

philmills1 · January 30, 2020, 12:31pm

I forced detection by renaming the table

arbei · January 31, 2020, 5:05am

I tried to add a timestamp field to the demo project and then sync, it does work. Can you post the CREATE TABLE statement of your table so other users can try?

philmills1 · February 3, 2020, 1:04pm

it hasn’t done this again, putting this down to a random temporary glitch

christ2000 · February 3, 2020, 8:23pm

i have same problem since last version, sometime need to rename the table and then system detect

hemin · February 3, 2020, 9:05pm

actually there is a solution to it, right click on the specific table and refresh/sync do not try to sync database from the main app, but from the table itself.

philmills1 · February 6, 2020, 8:38am

That made no difference on my table.
Yesterday I had the problem that PHPmaker didn’t even detect that a whole table had been deleted from the database

arbei · February 7, 2020, 1:15am

Make sure the database user you specified in PHPMaker project has permission to the table.
If you use URL connection method, you may have cached response, configure your internet options to get page on every visit.

philmills1 · February 11, 2020, 7:00am

arbei wrote:

Make sure the database user you specified in PHPMaker project has
permission to the table.
If you use URL connection method, you may have cached response,
configure your internet options to get page on every visit.
user has permissions
I’m not using URL connection method

Sometimes right click on the specific table and refresh/sync works, but its not consistent.
Yesterday I also had a new table added to my database which PHPMaker didn’t detect at all. After renaming the table PHPMaker woke up