Go Back   Pligg CMS Forum > Pligg Development > Modification Tutorials

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-18-2007, 08:22 AM
frankenc's Avatar
Pligg Donor
 
Join Date: Feb 2007
Posts: 10
Thanks: 6
Thanked 1 Time in 1 Post
RSS Module Problem: Special Characters like apostrophe, ampersand Cause mySQL Error

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, 01:18 PM
frankenc's Avatar
Pligg Donor
 
Join Date: Feb 2007
Posts: 10
Thanks: 6
Thanked 1 Time in 1 Post
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
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Similar Threads
Thread Thread Starter Forum Replies Last Post
Special Characters error in title url freakblue General Help 3 09-19-2008 03:50 PM
special characters (ä,ü,ö,ß) problem 911 General Help 67 06-28-2008 01:55 PM
Special characters problem RSS and IE 7 markoi Bug Report 1 08-09-2007 01:52 PM
Got This Parse Error on c_ file on line 141 endph General Help 0 02-14-2007 06:44 PM
video module mysql error nero General Help 1 12-25-2006 01:02 AM


Search Engine Friendly URLs by vBSEO 3.2.0