FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » RDF causes SQL error
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
RDF causes SQL error [message #15929] Fri, 09 January 2004 18:50 Go to previous message
Squeebee is currently offline  Squeebee   Canada
Messages: 110
Registered: November 2003
Karma:
Senior Member
Hi All;

A user of mine wants to get the latest content without clicking refresh so much so I suggested he get a rss aggregator and use the rss of the forums. Problem is when a uses clicks onthe sample link for the latest 10 feeds (http://www.vbmysql.com/forums/rdf.php?mode=m&l=1&n=10&basic=1) he gets this:

Quote:

UNABLE TO WRITE TO SQL LOG FILE
(/var/www/vbmysql/html/forums/rdf.php:155
/var/www/vbmysql/html/forums/rdf.php:497
) 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 '' at line 21
Query: SELECT m.*, u.alias, t.forum_id, p.name AS poll_name, p.total_votes, m2.subject AS th_subject, m3.subject AS reply_subject, f.name AS frm_name, c.name AS cat_name FROM fud26_msg m INNER JOIN fud26_thread t ON m.thread_id=t.id INNER JOIN fud26_forum f ON t.forum_id=f.id INNER JOIN fud26_cat c ON c.id=f.cat_id INNER JOIN fud26_msg m2 ON t.root_msg_id=m2.id LEFT JOIN fud26_msg m3 ON m3.id=m.reply_to LEFT JOIN fud26_users u ON m.poster_id=u.id LEFT JOIN fud26_poll p ON m.poll_id=p.id WHERE m.apr=1 AND m.post_stamp >= 1073245580 ORDER BY m.post_stamp DESC LIMIT 0,
Server Version: 4.0.17-standard-log


Any ideas?
[Message index]
 
Read Message
Read Message
Read Message
Previous Topic: Anchor text mangled in auto-created [url] tags
Next Topic: Forum hangs with apparent locking problems (V2.5.2)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 14:02:03 GMT 2024

Total time taken to generate the page: 0.04732 seconds