Solspace Support Forums | Tag and stripslashes ?

Solspace Support Forums

Tag and stripslashes ?

Posted: 27 July 2008 10:53 PM

[ Ignore ]

Newbie

Total Posts: 5

Joined 2007-10-19

Hello there,

I have never noticed it before but it seems that the tag module has problems with quotes. When I put some tag like : I’m hungry, here’s what I have

MySQL ERROR:

Error Number: 1064

Description: 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 'weblog'' at line 5

Query: SELECT DISTINCT(e.entry_id), t.tag_id FROM exp_tag_entries e LEFT JOIN exp_tag_tags t ON t.tag_id = e.tag_id WHERE t.site_id IN ('1') AND t.tag_name IN ('I'm hungry') AND e.type = 'weblog'

Is there any way to by pass that please ?

Thanks for your support !

Profile

Posted: 28 July 2008 07:14 AM

[ Ignore ] [ # 1 ]

Administrator

Total Posts: 8210

Joined 2006-10-18

evasion,

This is a known issue…

What I’ve noticed is that some web servers give that error, and some handle it ok…

Signature

Profile

Posted: 28 July 2008 07:16 AM

[ Ignore ] [ # 2 ]

Newbie

Total Posts: 5

Joined 2007-10-19

Couldn’t it be related to magic_quote handling in php.ini ?

Profile

Posted: 29 July 2008 06:27 AM

[ Ignore ] [ # 3 ]

Administrator

Total Posts: 8210

Joined 2006-10-18

I guess that’s a possibility

Signature

Profile

Posted: 17 October 2008 10:18 AM

[ Ignore ] [ # 4 ]

Administrator

Total Posts: 8210

Joined 2006-10-18

This is now fixed with the new version of Tag 2.5
http://www.solspace.com/forums/viewthread/661/

Signature

Profile

‹‹ It must be simple: related entries Question about module ... can it be done ››