tags with apostrophe don’t work? 
Posted: 11 April 2008 10:05 AM   [ Ignore ]
Newbie
Rank
Total Posts:  2
Joined  2008-04-11

While doing some testing, I made a tag with the name: you’re it

This shows up in the tag cloud fine, but when I click on the link to visit the tag entries page (example.com/tag/you’re+it), I get this MySQL error:

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 're it') AND e.type = '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 ('you're it') AND e.type = 'weblog'

Here’s the code I’m using to list out the tag links:

{exp:tag:cloud groups="4" step="2" limit="20"}
<li><a href="{path=tag}{websafe_tag}" title="{tag_name}" style="font-size:{step}px;">{tag}</a></li>
{/exp:tag:cloud}

Is there a way to get tags with apostrophes in them to not error when you link to them? Thanks.

Profile
 
 
Posted: 14 April 2008 06:50 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  2732
Joined  2006-10-18

chrisrhee,

I can duplicate this issue, though it only seems to happen on some web servers. I have one site that generates this error, and a few that don’t (when running a tag with an apostrophe in the URL).

I’ll note this bug and we’ll try to get it fixed as shortly smile

Thanks for your patience…

 Signature 
Profile