New Thread MySQL Error - Please help

[kinkarso]

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/newthread.php?do=postthread&f=399
Referrer : http://www.battleforums.com/forums/newthread.php?do=newthread&f=399
IP Address : 24.87.17.236
Username : kinkarso
Classname : vB_Database

Thank You,
Donny

[TigerWare]

thread_serviceupdate

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 (https://vborg.vbsupport.ru/showthread.php?t=163980)]

HTH

[kinkarso]

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?

[TigerWare]

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.

[kinkarso]

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

[TigerWare]

You were seconds in front of me. Just hopped on to Google and found this [link (http://www.vbseo.com/f77/upgrade-problems-2-0-3-1-a-18383/)]. Glad you got it sorted.