Recently, my web host upgraded to MySQL to 5.0.27 from 4.0 series. Since then i’m unable to edit or add events to the events calendar. I get an error message like this:

MySQL Error: 1064 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,t_stamp,year,month,day,show_time,title,description) values (’’,’70969935’ at line 1
Query: insert into pm_events

I’m very unfaniliar with all this scripting mumbo-jumbo. Is there anyone who would be able to help me fix this problem? I love pmachine pro and would hate to have to give it up.

Thanks!

Hey AnnMath,

This is because your version of MySQL was probably updated from V4 to V5.

“repeat”, which is used in the insert is now a reserved word. You cannot use it as a field name.

What you have to do is go to /pm/cp/events.cp.php and search for repeat, until you find the line that is the insert. It will look like your error message query.

Just put back ticks -"`" around the repeat, save the file, upload it to the same place and overwrite the existing file and you should be set.  On my keyboard, the back tick is uderneath the tilda - “~” repeat should now look like - `repeat`

At least it just worked for me.

Good luck,

Lyman

Thanks so much—i’ll give that a try!!

I just ran into this on our site <a href="http://www.shoobedoo.com">http://www.shoobedoo.com</a>.  Thanks for this resource!

Sorry - I screwed up the link…