#41 Data corruption or bad SQL?

open
nobody
None
5
2012-12-11
2011-01-27
Anonymous
No

When adding or editing a Family record and trying to save we get the error:

Cannot execute query.

REPLACE INTO family_custom SE, fam_ID = 643

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SE, fam_ID = 643' at line 1
We suspect corruption because we have a second install on the same server that does not have this problem.
We think "SE," should be "SET," and that the wrong SQL is being generated by the PHP.
We cannot use our database until this is fixed. This bug seem to appear when we added a new custom
Family Field "Waiver".

Discussion