I've been dealing with security metrics to ensure a site is PCI compliant.

They have found the following problem with the site, do you know what it is and how I could fix it?

http://www.iamhappie.com/index.php?m...ewid&post_id=1'

Note the ' at the end of the Url.

Code:
1064 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 '/%' ) AND status = 1 ORDER BY length(link_alias) DESC' at line 1
in:
[SELECT DISTINCT link_url, link_alias FROM zen_links_aliases WHERE (link_url LIKE '%/mode/%' OR link_url LIKE '%/viewid/%' OR link_url LIKE '%/post_id/%' OR link_url LIKE '%/1'/%' ) AND status = 1 ORDER BY length(link_alias) DESC]