MySQL error after saving record with a single quote

Check please php setting **magic_quotes_gpc ** it must be off. This is joomla requirements. This error we can't reproduce.

Hi kudinov.k,

Check please php setting magic_quotes_gpc it must be off.

Checked and is off.

Error:

Check please php setting magic_quotes_gpc it must be off.

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 's Sichuan' AND type_id = 1 AND id NOT IN(11)' at line 1 SQL=SELECT id from wxxxx_js_res_record WHERE title = 'Earthquake in China's Sichuan' AND type_id = 1 AND id NOT IN(11)

I'm using Joomla 3.1.0 btw

This only with Cobalt or with core joomla article too?

Hmmm,

try editing a layout in index.php?option=com_cobalt&view=type&layout=edit.

and set Unique title to Yes.

Then see if you get an error saving an article with a single quote....

Best regards,

Jeff

Thanks a lot for you research. We find a bug and fix it.

:)

Good. Right now you can trun unique title off or do not enter title with quotes till next update :)