"when" is reserved keyword in MySQL >3.23
Brought to you by:
hroberts
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!