MyBB Community Forums

Full Version: Fix this sql error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
[Image: 2gxl2so.png]

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 tid,uid FROM mybb_posts WHERE uid='1' AND tid IN (27514,27765,28045,27882,27920,27887,28590,28471,28584,29529,29217,28650,29140,28835,28796,28747,28717,28736

when I click the last page of the forumdisplay. Sad
I think this is a known bug and has been fixed for the next version (unless I'm mistaken)
What version of MyBB are you using? I am not aware on any bugs regarding this and looking at the MyBB source for 1.6.2 I don't see any problem with the query. In your error message it says its missing the ending ) which is there in the code.

Can you run the file verification tool in Admincp >> Tools & Maintenance and see if theres any missing or changed files? Also what plugins are you running?
(2011-03-29, 09:42 PM)- G33K - Wrote: [ -> ]What version of MyBB are you using? I am not aware on any bugs regarding this and looking at the MyBB source for 1.6.2 I don't see any problem with the query. In your error message it says its missing the ending ) which is there in the code.

Can you run the file verification tool in Admincp >> Tools & Maintenance and see if theres any missing or changed files? Also what plugins are you running?

verification no changed file/s.

Admins can log into Users' accounts (1.0)

Awards (2.0)

Spider Bots (1.1)

Facebook Like Button (1.0)

Fit on Page (2.3)

Quick Reply PM (1.3)

Undo Delete (1.2.1)


Sad
What version of MyBB? Also could we have the URL?
1.6.2
URL??