Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Prev Previous Post   Next Post Next
  #1  
Old 08-26-2009, 05:31 PM
DavidWWL DavidWWL is offline
 
Join Date: Apr 2008
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default SQL errors and etc

I hope this is the right section of the forum to post this subject in.

This morning, there were html snippets displayed next to somebody's username on my forum.

I went to the maintenance area in admincp and ran the "repair tables" to see if that would fix the issue, and after that, started getting msql errors, and the site does not load any more (webworldlounge.com)

When I went back to poke around in admincp, it brought me to a screen saying that "There are currently 102 customized template(s) that need to be updated or reverted. Some sections of vBulletin may not function if you do not do this!"

I'm not sure whether it's safe to click on "revert" (see screenshot here: http://img29.imageshack.us/img29/396...dtemplates.jpg), or if I need to do something manually to fix/save these files so that they will be the same as they were before this problem happened.

Database repair was tried through cpanel, and resulted in many errors, examples from the generated report; I edited out the "ok" items to show just the error items:

-----------------
MySQL Account Maintenance

Repairing Database
webworld_forum is now being repaired.
webworld_forum.calendarpermission OK
webworld_forum.cpsession
note : The storage engine for the table doesn't support repair
webworld_forum.pollvote OK
webworld_forum.post
Error : Table './webworld_forum/post' is marked as crashed and should be repaired
Error : Table 'post' is marked as crashed and should be repaired
status : Table is already up to date
webworld_forum.session
note : The storage engine for the table doesn't support repair
webworld_forum.templatehistory OK
webworld_forum.thread
Error : Table './webworld_forum/thread' is marked as crashed and should be repaired
Error : Table 'thread' is marked as crashed and should be repaired
status : Table is already up to date
webworld_forum.usercss
Error : Incorrect key file for table 'usercss'; try to repair it
error : Corrupt
-------------------------------

If anybody could offer any help or advice I'd greatly appreciate it.
Reply With Quote
 

Thread Tools
Display Modes

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:44 AM.


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.03924 seconds
  • Memory Usage 2,346KB
  • Queries Executed 12 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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