Database error in vBulletin 3.6.7: Help.

**Corey** · 08-12-2007, 11:11 AM

Hey guys, I was wondering if you can help me with something.

Users are getting this error with trying to send a PM to a user on our forum.

The account their trying to send the PM to is an administrator account. The account still exists, and can still post threads. But users cannot click the account name in the thread anymore, it's just a black name.

What would cause this, and how would this be fixed?

Would logging into the Admin CP >> Maintenance >> Repair / Optimize Tables >> Check All >> Continue, fix the problem?

Thanks,
Corey

The error is this;

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
INSERT INTO pm (pmtextid, userid) VALUES (8786, );

MySQL Error : 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
Error Number : 1064
Date : Sunday, August 12th 2007 @ 12:05:48 PM
Script : AdBux Forums
Referrer : AdBux Forums
IP Address : XX.XXX.XXX.XX
Username : Corey
Classname : vB_Database

**Michael Biddle** · 08-12-2007, 11:32 AM

Do you have any hooks at the location private_

It is expecting a userid value, but none is being passed through.