Jeff VIP
Total posts: 745
26 Апр 2013 01:23

Hi Sergey,

saving a record with a single quote in the title produces a MySQL error:

China's army

Double quotes are accepted, however:

China's army

China"s army

This error appeared after updating to v. 8.71

Best regards,

Jeff

Последние изменения: 02 Март 2014


Konstantin
Total posts: 1,113
26 Апр 2013 04:28

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


Sergey
Total posts: 13,748
26 Апр 2013 05:11


Jeff VIP
Total posts: 745
26 Апр 2013 05:21

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


Jeff VIP
Total posts: 745
26 Апр 2013 05:25


Konstantin
Total posts: 1,113
26 Апр 2013 05:55

This only with Cobalt or with core joomla article too?


Jeff VIP
Total posts: 745
26 Апр 2013 06:14

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


Konstantin
Total posts: 1,113
26 Апр 2013 06:22

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


Jeff VIP
Total posts: 745
26 Апр 2013 06:23

:)


Sergey
Total posts: 13,748
26 Апр 2013 07:34

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

Работает на Cobalt