Mysql 4 to Mysql 5 upgraded -- now get a query error but I have no idea why.

[hstraf]

Hello,

Since upgrading to mysql 5.x, one of my PHP applications is giving this error:

Error:db::query() failed.

ERROR MESSAGE IS: Failed to run Query:

insert into ec_event ( title, description, start_date, use_time, use_end_date, end_date, repeat, repeat_untill, repeat_mode, repeat_weekday, repeat_monthly_mode, repeat_every_number, repeat_every_weekday, repeat_every_month, active ) values ( 'Title goes here', 'Description goes here', '1235683200', '1', '', '1235683200', '', '1235721540', '', '4', '1', '1', '0', '0', '1' )

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 'repeat, ' at line 8

I have no idea what is wrong with the query...

... any ideas?

[Dan Grossman]

REPEAT is a statement type, so you can't use it as a column name without surrounding the word in `backticks` in each query.

[hstraf]

Thanks you!