Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2007, 09:11 PM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
  #2  
Old 12-02-2007, 09:19 PM
TigerWare TigerWare is offline
 
Join Date: Feb 2007
Location: England, UK
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kinkarso View Post
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]

HTH
Reply With Quote
  #3  
Old 12-02-2007, 09:28 PM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #4  
Old 12-02-2007, 09:31 PM
TigerWare TigerWare is offline
 
Join Date: Feb 2007
Location: England, UK
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 12-02-2007, 09:31 PM
kinkarso kinkarso is offline
 
Join Date: May 2006
Location: Canada
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Fixed . It was vBSEO. I had to import the updated product.
Reply With Quote
  #6  
Old 12-02-2007, 09:33 PM
TigerWare TigerWare is offline
 
Join Date: Feb 2007
Location: England, UK
Posts: 282
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:01 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04428 seconds
  • Memory Usage 2,208KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete