hi,i added a new field into a mysql table.Previously i created a view from this table (with CREATE OR REPLACE VIEW etudiants_etudiants AS SELECT * FROM etudiants) : so i include all the fields.
when i do synchronyze phpmaker, only new field in the table have been discovered by phpmaker.
The same new field in the view is not seen by phpmaker.
If i recreate my view with the exact same syntaxe CREATE OR REPLACE VIEW etudiants_etudiants AS SELECT * FROM etudiants) then PHPmaker discovered the new field!So i guess PHPmaker does not count the numbers of fields in the view to know if there is a change or not.have a good day
Cannot reproduce the issue.
I tried to change my Database View by including a new field that has not been selected before when creating it for the very first time. Then, when I synchronized it with my PHPMaker project, it can be seen as a new change properly.
does your VIEW is create using explicit all fields (SELECT *) or using implicite fields (SELECT field1, fields2, field3…).
My problem came with explicit fields creation in the VIEW. (so when i add a new field into the table source, i don’t need to recreate the view SQL). But PHPmaker did not detect it (whereas it detects the new fields in the table source). So i need to recreate the view to “trigger” phpmaker update.
My DBS is mysql mariaDB 10.4.8-MariaDB under xamp win10 x64.
I am using the implicite fields.