MyBB Community Forums

Full Version: new user SQL problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
One of my forum have problem and new user get this message
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 tid,uid FROM mybb_posts WHERE uid='136' AND tid IN (421,,)
when they want to open it!
Are they getting this error on a specific page or on te whole site?

Do you have any plugins installed on the forum?

URL?
Just on this forum:
http://www.taahod.com/forumdisplay.php?fid=20
Now all user get this problem!
It is fine here.
Yes but after you login and you want to see you get that error!
The links for the 2 threads that are moved in that forum are broken, they show up as
http://www.taahod.com/showthread.php?tid=

without the tid value at the end. This is most probably the cause of the sql error since it can't read the tid value. As to why its happening, either you moved them incorrectly or theres a plugin interfering.
I don't have any plugin for that !
How can I find them?
(2011-01-08, 12:38 PM)Hamed Wrote: [ -> ]I don't have any plugin for that !
How can I find them?

Where did you move them to?

Can you just remove the redirects? If you really need them then remove them, move the threads back there and then move them again with redirects.