MySQL Error

[Shane]

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO pm (pmtextid, userid) VALUES (7, ) 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

mysql error number: 1064


Script: http://forum.??.com/private.php
Referer: http://forum.??.com/private.php?do=newpm&pmid=10

[Yves R.]

Have you installed some hacks related with private.php? Can you verify you have this part of code in the same file?:

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "pm (pmtextid, userid) VALUES ($pmtextid, $user[userid])"); 

[Shane]

Do you know what line that is?

I don't have any hacks installed.

[Yves R.]

For me, it's on line 1083.

[Shane]

$DB_site->query("INSERT INTO " . TABLE_PREFIX . "pm (pmtextid, userid) VALUES ($pmtextid, $user[userid])"); 

Yep. Same thing. Same line number also.

[Steve Machol]

The first thing I recommend is that you reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Then change to this style and view your forums with it. You should not get this error with the original files aand templates.

[George L]

by any chance has your forum used the impex importer on the database ? did you make a backup before you used the impex importer ?

[Shane]

No import. I deleted something out of the header template which got rid of the userid. :-)