MyBB Community Forums

When i try to open homepage i faced internal sql error .

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 ') AND time>'1421981170' ORDER BY u.username ASC,
s.time DESC' at line 4

Query :
SELECT s.sid, s.ip, s.uid,
u.username, s.time, u.avatar,
u.usergroup, u.displaygroup,
u.invisible FROM
mybb_sessions s LEFT JOIN
mybb_users u ON (s.uid=u.uid) WHERE u.usergroup IN (4,3,6,)
AND time>'1421981170' ORDER
BY u.username ASC, s.time
DESC

when i disable the plugins the error was gone .

are you using a plugin related to fake users online ? if so deactivate and uninstall it.

(2015-01-23, 03:38 AM).m. Wrote: [ -> ]are you using a plugin related to fake users online ? if so deactivate and uninstall it.

no i have no such plugin installed .

^ what are the plugins you have (in activated state) ?

Date of On Registration
Advance index ads
Attachment download log
Avatar Gallery
BAM
Ban user
Country flag
Edit reputation comment
Favorite Thread
Team online
Latest posts on side box
Latest visitors on profile
Limit no. Of pms
Limit no. Of threads
mood manager
My advertisement
Mybb tags
Mybot
Myfacebook or Mytwitter connect
Mylikes
My profile
Newpoints
Ougc Custom reputation
Pm menu counter
Pms log
Private Profile
Profile picture
Public ban reason
Recent Thread
Report center plus
Share this page
Social sites
Strict username
Style username
Thanks
The Inferno shoutbox
Top stats
Username change approval
User Browsed Topic
View all posts by a user
View groups
Vip membership

^ you can try deactivating & uninstalling Team online plugin

Yes you are right team online is the plugin that cause the problem but the problem occur few minutes of plugin installation

Looks like you entered wrong group list in settings. It should be a comma separated list, so 4,3,6 and not 4,3,6,

O.k Thanks Problem solved .