View Single Post
  #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
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01140 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete