New Thread MySQL Error - Please help
 

Hi,

I get this error whenever I try to make a new thread on my forum, http://www.battleforums.com.

I just recently changed servers (I did it manually - download files, upload - export mysql, import). I reinstalled/upgraded vBulletin as well as vBSEO, which solved a few issues. At the moment, this is the only issues. This is the error message I get:

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO thread_serviceupdate
(s_threadid, s_updated)
VALUES
('130172', 0);

MySQL Error : Table 'bf_forums.thread_serviceupdate' doesn't exist
Error Number : 1146
Date : Sunday, December 2nd 2007 @ 03:09:47 PM
Script : http://www.battleforums.com/forums/n...stthread&f=399
Referrer : http://www.battleforums.com/forums/n...ewthread&f=399
IP Address : 24.87.17.236
Username : kinkarso
Classname : vB_Database

Thank You,
Donny

That isn't a default vBulletin table, so you are missing a modification, or one has been incorrectly uninstalled. Search your downloaded product installation files for the phrase. This has also been mentioned here too [link]

HTH

Thank you very much. I have a very long list of modifications installed. Is there any way to search for the table, and pinpoint exactly which mod is causing the problem?

Depends on your OS. Windows has a search feature (though lousy) which you can set a search phrase... might help. I am not familiar with other OS.

Fixed :). It was vBSEO. I had to import the updated product.

You were seconds in front of me. Just hopped on to Google and found this [link]. Glad you got it sorted.