Not Solved Usergroup Legend 1046 MySQL Error
#1
Not Solved
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
Reply
#2
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
Reply
#3
Not Solved
Thank you so much! It worked! Can be locked.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)