MyBB Community Forums

I make a forum with mybb recently. But I face SQL Error 1064. I put the SQL error message below. Please help me someone.




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 * FROM mybb_users WHERE uid IN()

Please contact the MyBB Group for support.

if you have recently added a plugin (eg. fake users online) or code modification then can you remove that and check

We can't help with this info alone, post your forum url!

Yes , I recently added a plugin, Fake users online.
I deactivate that Plugin and now I didn't have any SQL errors.
But I want to activate Fake users online plugin. If you have any solution please share with me.



My forum URL is http://www.forumforu.uni.me

Open up the plugin file and look for the following:

$query = $db->simple_select('users', '*', 'uid IN'.$fkl, 1); 

Replace it with

$query = $db->simple_select('users', '*', 'uid IN'.$fkl.'', 1); 

I replace that but it didn't work.

It occurs by an unwanted apostrophe in the syntax.

http://yaldaram.com/thread-4574.html

(2013-08-07, 06:35 AM)effone Wrote: [ -> ]It occurs by an unwanted apostrophe in the syntax.

http://yaldaram.com/thread-4574.html

I don't understand that.

Wait a minute. Isn't Fake Users Online a premium plugin from Yaldaram.com? If so then why don't you try asking for support there, especially from the developer?

I think op is using free one
http://mods.mybb.com/view/fake-who-s-online
try paid one if your not using
http://yaldaram.com/thread-619.html