MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    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 7
Query:
    SELECT COUNT(post.dateline) AS postcount, post.uid, user.uid, user.username, user.usergroup, user.displaygroup, user.avatar FROM mybb_posts AS post JOIN mybb_users AS user ON (post.uid=user.uid) WHERE dateline > 1304698083 GROUP BY post.uid ORDER BY postcount DESC LIMIT 

I get that when accessing any page (I believe).

Any ideas?

Can you please list the Installed plugins ?

Top Posters by Yaldaram.

I've checked my plugin again. There is nothing issue here. Please de-activate the plugin, re-upload a new plugin from the fresh download and activate.

The problem is the limit.

$limit = $mybb->settings['ttposters_howmany'];

Recheck your settings for that plugin, especially the howmany field.