Not Solved Usergroup Legend 1046 MySQL Error
Not Solved
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
SELECT uid,username FROM mybb_users WHERE uid IN ()
Please contact the MyBB Group for technical support.

MyBB Version 1.8.6
Not Solved
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
Not Solved
Thank you so much! It worked! Can be locked.

Forum Jump:

Users browsing this thread: 1 Guest(s)