Error when submitting new stories

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 08-03-2008, 02:11 AM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
Error when submitting new stories

--------------------------------------------------------------------------------

I get this error when submitting stories, I'm not sure why:

Warning: 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 `link_author` = 5 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/sxy366/public_html/libs/db.php on line 233
Reply With Quote
  #2 (permalink)  
Old 08-09-2008, 02:12 PM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
Warning: 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 `link_author` = 2 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/sxy366/public_html/libs/db.php on line 233
Reply With Quote
  #3 (permalink)  
Old 08-09-2008, 02:54 PM
Yankidank's Avatar
Pligg Founder/Coder/Designer
Pligg Version: SVN
Pligg Template: Wistie
 
Join Date: Dec 2005
Location: Ocala, FL
Posts: 4,934
Send a message via AIM to Yankidank
One of my first suggestions with these types of errors is that you just try re-uploading the latest version of Pligg, sometimes FTP transfers get corrupted and it's always smart to check this before proceeding on. Let me know if that makes any difference.
Nice template by the way.

The Twitter Module for Pligg CMS!
Register, Login, and Submit Stories with Twitter. An absolute MUST HAVE for all Pligg sites!
Reply With Quote
  #4 (permalink)  
Old 08-10-2008, 02:58 AM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
This error appeared when submitting new stories on step3。
and sometimes submitting new stories work fine,sometimes show this error.
Reply With Quote
  #5 (permalink)  
Old 08-14-2008, 09:50 AM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
Warning: 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 `link_author` = 90 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/sxy366/public_html/libs/db.php on line 236
Reply With Quote
  #6 (permalink)  
Old 08-15-2008, 08:51 PM
New Pligger
Pligg Version: 9.9.0
Pligg Template: yget
 
Join Date: Apr 2008
Location: Atlanta, GA
Posts: 12
Whenever I'm getting an error like this, I always output the actual SQL so that I can see what's going on. Could you add a line in libs/db.php right after line 236 like this:

Code:
echo '<p>SQL: [' . $query . ']</p>';
You may not want to leave it in there for good (it will display anytime there's an error), but it will at least give you another clue as to what's going on in this particular situation.
Reply With Quote
  #7 (permalink)  
Old 08-17-2008, 12:44 PM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
i will test it.Thanks.
Reply With Quote
  #8 (permalink)  
Old 08-28-2008, 09:25 AM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
Warning: 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 `link_author` = 90 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/sxy366/public_html/libs/db.php on line 236
Reply With Quote
  #9 (permalink)  
Old 08-30-2008, 11:54 AM
New Pligger
 
Join Date: Aug 2008
Posts: 19
Bump, I also get this error randomly. Sometimes I am also able to submit stories, other times I am now.
Reply With Quote
  #10 (permalink)  
Old 09-01-2008, 10:56 AM
xiesi's Avatar
Constant Pligger
Pligg Version: 9.95
Pligg Template: yget + diy
 
Join Date: Jun 2007
Posts: 223
Send a message via MSN to xiesi
Warning: 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 `link_author` = 3 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/sxy366/public_html/libs/db.php on line 236
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Captcha for submitting stories cruz Questions and Comments 2 02-13-2009 10:50 PM
Error when submitting new stories rwallen Questions and Comments 10 08-29-2008 01:32 PM
[Huge Modification] Instead of Submitting stories, getting stories off RSS feeds kappa Questions and Comments 2 10-09-2007 06:08 PM
Submitting stories vissu Questions and Comments 2 09-10-2007 12:04 PM
Submitting stories...again kingp Questions and Comments 5 05-07-2007 01:58 PM


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