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 Query:SELECT a.*, u.uid, u.username, u.avatar, u.usergroup, u.displaygroup, t.code FROM mybbcp_alerts a LEFT JOIN mybbcp_users u ON (a.from_user_id = u.uid) INNER JOIN mybbcp_alert_types t ON (a.alert_type_id = t.id) WHERE a.uid = 4 AND (a.alert_type_id IN (1,2,3,4,5,6,7,8) OR a.forced = 1 OR t.can_be_user_disabled = 0) AND t.enabled = 1 ORDER BY a.id DESC LIMIT 0, ;

Website: pasteninja.pw
Version: Latest 1.8.6 It was a new Installation.
Test account: [email protected] pass: Joseph7089
What happened?: Whenever a user trys to login or view their information this happens!

which version of MyAlerts plugin you are using ? you can disable it at present

That's an interesting one. The limit seems to be missing. What do you have set in the ACP settings for alerts per page?

All we had to do is Delete MyAlerts plugin and it works! For anyone in the future who has the error. Delete the plugin!