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

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2013, 02:35 PM
wootriffic wootriffic is offline
 
Join Date: May 2012
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default error that i cant seem to fix

Code:
vbsearchlog	Check	Warning: Table is marked as crashed
vbsearchlog	Check	Warning: 1 client is using or hasn't closed the table properly
vbsearchlog	Check	Error: Record at pos: 2483628 is not remove-marked
vbsearchlog	Check	Error: record delete-link-chain corrupted
vbsearchlog	Check	Error: Corrupt
vbsearchlog

vbtagsearch	Check	Warning: 1 client is using or hasn't closed the table properly
vbtagsearch	Check	Error: Record at pos: 6048 is not remove-marked
vbtagsearch	Check	Error: record delete-link-chain corrupted
vbtagsearch	Check	Error: Corrupt
vbtagsearch
all of vb 4.2 works other than the articles section. my vps had an issue and they sent an email saying a hard drive fell out of the raid array and they had to fix some things. i didnt change anything with the site in about a year so not sure what to do with it to fix this issue.
i went into mysql and rebuilt the tables also did the same thing in vbulletin admin area but no luck.
anyone able to assist me in fixing this?

just for your info, i'm somewhat limited in my knowledge of fixing databases and tables. i know enough to get things from scratch up and running.
Reply With Quote
  #2  
Old 03-23-2013, 03:55 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Since your host is responsible for the problem in the first place, have you tried showing those errors to your host and asking the to try to fix the database?
Reply With Quote
  #3  
Old 03-23-2013, 05:05 PM
wootriffic wootriffic is offline
 
Join Date: May 2012
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

they said "your best option may be to contact vB about this directly. The rest of your script works fine which is another confirmation that the mysql service and database are perfectly fine. They probably have some sort of logging tool that may be able to help identify the issue. Unfortunately, as we are not experts with their software, we wouldn't know how to do this offhand."

could i just backup the mysql without those tables selected, reinstall the script, import the backup and be good to go?
Reply With Quote
  #4  
Old 03-23-2013, 05:07 PM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have any mods that interact with the search function?
If so, try disabling them and seeing if it's still an issue.
If it is, disable all mods but the cms and see if it works.
Reply With Quote
  #5  
Old 03-23-2013, 09:25 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You can probably just drop the searchlog and tagsearch table and then create them again.
Reply With Quote
  #6  
Old 03-23-2013, 09:35 PM
Christos Teriakis Christos Teriakis is offline
 
Join Date: Jul 2011
Location: Thessaloniki, Greece
Posts: 1,228
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just as a way to be sure that none plugin causes this error, turn on the plugin system by adding at the top of includes/config.php file (just below <?php):
Code:
define('DISABLE_HOOKS', true);
Then check your system again.

Chris
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 11:55 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.03873 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
  • (2)bbcode_code
  • (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