[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

[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

[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.

[xiesi]

This error appeared when submitting new stories on step3。
and sometimes submitting new stories work fine,sometimes show this error.

[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

[ShanePike]

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:

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.

[xiesi]

i will test it.Thanks.

[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

[coreyvf]

Bump, I also get this error randomly. Sometimes I am also able to submit stories, other times I am now.

[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