2012-07-24, 09:06 PM
Hey, as I reinstalled MyBB and restored some tables such as MyBB_forums, MyBB_users etc (but no plugin tables), I got now database error when I try to use the profile comments plugin ( http://mods.mybb.com/view/profile-comments ).
I can activate it, but when I click on the "Profile comments" link, or visit any profile. This error text pop up:
Is there any way I can fix this?
I believe problem lays in MyBB_users table, where probably settings are saved for this plugin.
How can I solve this, if possible?
I can activate it, but when I click on the "Profile comments" link, or visit any profile. This error text pop up:
Quote: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 * FROM MyBB_profilecomments p LEFT JOIN MyBB_users u ON u.uid = p.sender LEFT JOIN MyBB_usergroups g ON u.usergroup = g.gid WHERE p.user = 1 ORDER BY date DESC LIMIT 0,
Is there any way I can fix this?
I believe problem lays in MyBB_users table, where probably settings are saved for this plugin.
How can I solve this, if possible?