[General] Getting sql error

[vijayvishwakarma]

Hi,

I am getting this error on my forum after updating it to 1.6, not sure how to fix this. Please advice.

Your copy of MyBB running on FAQ (http://www.faqssite.com) has experienced an error. Details of the error include:
---
Type: 20
File:  (Line no. 0)
Message
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 ')
                       ORDER BY p.dateline' at line 3
Query:
                       SELECT subject, message
                       FROM mybb_posts p
                       WHERE pid IN()
                       ORDER BY p.dateline

[Conor C.]

This happens when you send a PM?

Reupload all your files (Make sure its the same version), overwrite them and check for any plugins which inter-fear with Private Messaging.

[vijayvishwakarma]

Not sure when this error arises, I get email of error.

So I must reinstall mybb.

I will give it a try.

[Conor C.]

Noooooooo, Just re-upload all the files and try again. You do not need to re-install, just upload the files. (Take a backup first)

[vijayvishwakarma]

Got a new error on thread.
Check out the link

http://www.faqssite.com/showthread.php?tid=47

Please advice.

[Matt]

Looks like a plugin is causing it, what ones do you have??