PaulV888
Member
Hi,
I ran into a strange problem during my upgrade journey. 1.5 -> 2.5 -> 3.2
On saving a form, Parent with 3 child tables I consistently get an error on saving the 3 child. Something like:
#1064 - You have an error in your SQL syntax; "UPDATE `homeautomation`.`ha_mf_devices_thermostat` SET `empty1` = '1' WHERE"
It turned out that 1 of the children having a different primary key name was causing the problem.
Parent, PK = myid
Child 1, PK = myid
Child 2, PK = myid
Child 3, PK = id <---
After cleaning up my database structure to give them all the same PK name the issue was gone.
Just sharing
Paul
I ran into a strange problem during my upgrade journey. 1.5 -> 2.5 -> 3.2
On saving a form, Parent with 3 child tables I consistently get an error on saving the 3 child. Something like:
#1064 - You have an error in your SQL syntax; "UPDATE `homeautomation`.`ha_mf_devices_thermostat` SET `empty1` = '1' WHERE"
It turned out that 1 of the children having a different primary key name was causing the problem.
Parent, PK = myid
Child 1, PK = myid
Child 2, PK = myid
Child 3, PK = id <---
After cleaning up my database structure to give them all the same PK name the issue was gone.
Just sharing
Paul