Error in Sql syntax Bulletin Board
Hi installed the bulletin board on my webserver and when i go to the main page I get this 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 'mod, p.update_id, u2.name as updated_by FROM forum_forum f JOIN forum_posts p ON' at line 1
SELECT SQL_CALC_FOUND_ROWS p.id, p.subject, p.body, p.date_posted, p.date_updated, u.name as author, u.id as author_id, u.signature as sig, c.count as postcount, p.forum_id as forum_id, f.forum_moderator as mod, p.update_id, u2.name as updated_by FROM forum_forum f JOIN forum_posts p ON f.id = p.forum_id JOIN forum_users u ON u.id = p.author_id LEFT JOIN forum_users u2 ON u2.id = p.update_id LEFT JOIN forum_postcount c ON u.id = c.user_id WHERE (p.topic_id = 1 OR p.id = 1) ORDER BY p.topic_id, p.date_posted LIMIT 0,10
I cant seem to find out whats wrong with it just wondering if any of you guys/girls could help me put thanks.
Last edited by Azzano62; December 3rd, 2009 at 01:01 AM..
|