Forum: Ruby on Rails acts_as_taggable and escaping apostrophe's

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
7fc62c7ce136d50a68b13beb00765218?d=identicon&s=25 Piers Young (piers)
on 2007-07-23 15:34
I've got the acts as taggable gem installed.  For the main it works
great, but when someone tags something with an apostrophe in it hangs.
Is there an easy way round this?

An example error is:

Mysql::Error: #42000You 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')
                AND = tags_bookmarks.bookmark_id GROUP BY
bookm' at line 2: SELECT bookmarks.* FROM tags_bookmarks, bookmarks,
tags WHERE tags_bookmarks.tag_id =
                AND ( = 'children's')
                AND = tags_bookmarks.bookmark_id GROUP BY HAVING COUNT( = 1

Thanks for any help!
This topic is locked and can not be replied to.