RSS Module Problem: Special Characters like apostrophe, ampersand Cause mySQL Error

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 02-18-2007, 09:22 AM
frankenc's Avatar
Pligg Donor
 
Join Date: Feb 2007
Posts: 9
Well, the topic about says it. Everything works great except that when an RSS feed has an apostrophe (') or an ampersand (&) in the title it creates the link but if you try to view its detail page it gives a mySQL error like this:

Quote:
SQL/DB 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-Home-City-San-Francisco'' at line 1]
Reply With Quote
  #2 (permalink)  
Old 02-20-2007, 02:18 PM
frankenc's Avatar
Pligg Donor
 
Join Date: Feb 2007
Posts: 9
The answer is found in this thread: http://www.pligg.com/forum/showthrea...ist+characters

and also seems to be fixed (for all the foreign characters I use) in the latest beta.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Warning: Error establishing mySQL database connection. - Errors on all pages - HELP! comptalk Questions and Comments 3 04-21-2009 12:44 PM
Special Characters error in title url freakblue Questions and Comments 3 09-19-2008 04:50 PM
Special characters problem RSS and IE 7 markoi Questions and Comments 1 08-09-2007 02:52 PM
Got This Parse Error on c_ file on line 141 endph Questions and Comments 0 02-14-2007 07:44 PM
video module mysql error nero Questions and Comments 1 12-25-2006 02:02 AM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development