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 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
  #2  
Old 08-26-2009, 05:46 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sometimes you need to run repair/optimize a couple of times before they are all repaired/optimized.

Right now your thread and post tables are marked as crashed. You need to repair/optimize them until it no longer says that.
Reply With Quote
  #3  
Old 08-26-2009, 05:54 PM
DavidWWL DavidWWL is offline
 
Join Date: Apr 2008
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK I'll try that. For some reason, the site started loading after all, even though I hadn't done anything else.

I'll try the repair/optimize again

--------------- Added [DATE]1251313203[/DATE] at [TIME]1251313203[/TIME] ---------------

Those tables fixed ok after a few tries. Still getting some error in regard to usercss and html snippets displayed next to a member's name wherever it's displayed for "posted by".

Here is the error for he usercss, I'm not sure what to do about that. Do I need to replace a file or something?

usercss Check Error: Incorrect key file for table 'usercss'; try to repair it
usercss Check Error: Corrupt

--------------- Added [DATE]1251313575[/DATE] at [TIME]1251313575[/TIME] ---------------

I had logged out of the forum and now cannot log in. Getting a database error on login attempts. What do I do now?

--------------- Added [DATE]1251316686[/DATE] at [TIME]1251316686[/TIME] ---------------

Login issue seems to have resolved itself.

Corrupt usercss table is still an issue. Not sure what to do.
Reply With Quote
  #4  
Old 08-26-2009, 08:36 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not an expert on databases, so I'm not sure what to do about the corrupt table. You should probably ask over on vb.com.

Also, when asking for help with database errors, you need to copy/paste the exact error. There are soooo many different types of errors a database can give, so we need to know exactly which you are getting.
Reply With Quote
  #5  
Old 08-28-2009, 09:19 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This again proofs why i always stress not to repair a database unless it is needed. Reparing tables will never fix "some HTML appearing". It should only be used if a MySQL errors tells you there is corruption.

Try repairing the usercss table a few more times. If this doesn't fix you issue, then you could try to drop the indexes and re-add them. The full definition of this table is (in 3.8.4):
[sql]CREATE TABLE `usercss` (
`userid` int(10) unsigned NOT NULL default '0',
`selector` varchar(30) NOT NULL default '',
`property` varchar(30) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`userid`,`selector`,`property`),
KEY `property` (`property`,`userid`,`value`(20))
) [/sql]
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 03:39 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.03682 seconds
  • Memory Usage 2,200KB
  • 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)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)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