Joomla Templates Club 406,261 posts

[cyclist87 Friend cyclist87Join date: September 2011Posts: 77Downloads:10Uploads:24 Thanks: 44]

#206472

Hi,

I just installed a fresh copy of JA Charity and when saving articles I have this error:

Error
Save failed with the following error: 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 'AND `sha1_hash` = '529d33e3ddbef33be9a9d1d2190ba5de8faa5561' LIMIT 0, 1' at line 3 SQL=SELECT * FROM `fol6n_ucm_history` WHERE `ucm_item_id` = 1 AND `ucm_type_id` = AND `sha1_hash` = '529d33e3ddbef33be9a9d1d2190ba5de8faa5561' LIMIT 0, 1

What should I do ?

Thanks!

[Adam M Moderator Adam MJoin date: May 2014Posts: 5159Downloads:33Uploads:66 Thanks: 95 Thanked: 1271 times in 1235 posts]

#571338

Hi @cyclist87,

Please contact your hosting provider and ask them to upgrade MySQL version, in addition make sure that InnoDB support is required as mentioned here.

P/S: Your PHP 5.3.2 is a bit out-dated, so you might want to ask them to upgrade to 5.4.x as well.

[Author]

Posts