FUDforum: Bug Reports » RDF causes SQL error

Home » FUDforum Development » Bug Reports » RDF causes SQL error

Show: Today's Messages :: Polls :: Message Navigator

RDF causes SQL error [message #15929]

Fri, 09 January 2004 18:50

Squeebee

Messages: 110
Registered: November 2003

Karma: 0

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?

Report message to a moderator