Menu

#4 "when" is reserved keyword in MySQL >3.23

open
nobody
None
5
2000-10-30
2000-10-30
No

With mysql-3.23.24 I get the following error message when
adding or modifying items:

sql_query: You have an error in your SQL syntax near 'when = 'before'' at line 1
query: 'select function, file, display_name from action_defs where table_defs_id = 3 and trigger = 'add' and when = 'before''

Changing the column name to "whenx" using the SQL alter command and in all PHP scripts fixed the problem!

Discussion


Log in to post a comment.

MongoDB Logo MongoDB