MyBB Community Forums

Full Version: Usergroup Legend 1046 MySQL Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello.
I install the plugin and then the forum goes on this error:
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 1
Query:
SELECT uid,username FROM mybb_users WHERE uid IN ()
Please contact the MyBB Group for technical support.

MyBB Version 1.8.6
open the plugin file in an advanced editor like notepad++ or through file manager at web host panel
find below code at line 437
$query = $db->simple_select('users', 'uid,username', 'uid IN ('.implode(',', array_keys($leaders)).')');
change 'uid,username', with 'uid','username', and save & use the file

note: php files should be saved with utf encoding without BoM
Thank you so much! It worked! Can be locked.