New MySQL error - out of nowhere

[poorvida]

Yesterday, all of the sudden, any page on my site that shows JEvents or and JEvents module is throwing a MySQL error.

Code: Select all

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 'TYPE=MyISAM' at line 8 SQL=CREATE TABLE IF NOT EXISTS xxxx_jev_attendance( id int(11) NOT NULL auto_increment, ev_id int(11) NOT NULL default 0, allowregistration tinyint(1) unsigned NOT NULL default 0, allowcancellation tinyint(1) unsigned NOT NULL default 0, allrepeats tinyint(1) unsigned NOT NULL default 1,    PRIMARY KEY (id) ) TYPE=MyISAM;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 'TYPE=MyISAM' at line 9 SQL=CREATE TABLE IF NOT EXISTS xxxx_jev_attendees( id int(11) NOT NULL auto_increment, at_id int(11) NOT NULL default 0, user_id int(11) NOT NULL default 0, rp_id int(11) NOT NULL default 0, PRIMARY KEY (id), INDEX (at_id,user_id), INDEX (at_id,user_id,rp_id) ) TYPE=MyISAM;

I haven't changed anything, or added anything new, other than articles and events. No components, modules, or plugins have been added or removed, so Im not really sure what could have happened.

I deleted all new events created over the last few days, and that didn't do anything for me either.

[carcam]

Can you please check with your hosting company if they upgraded your MySQL Database?

[Tonyp]

Furthermore, what version of JEvents?

If they upgraded MySQL as Carcam asked for you to check and your on an old version of JEvents it is likely optimized for an older version of MySQL as we do not state the TYPE much now.

Regards
Tony