vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Incorrect key file for table "searchcore_text.MYI (https://vborg.vbsupport.ru/showthread.php?t=298817)

Bluemax712 06-07-2013 12:26 AM

Incorrect key file for table "searchcore_text.MYI
 
I have a 'renamed' thread causing "searchcore_text" table errors when trying to delete it:

MySQL Error: Incorrect key file for table "searchcore_text.MYI" ; try to repair it
Error Number :126

I can repair and optimize the "searchcore_text" table and it returns Status OK
But then as soon as try deleting a post in the thread same errors return

Also tried the following
-repairing it through the shell using mysql
-tried "myismchk" on searchcore_text.MYI
-there is plenty of disk space left

Google is out of ideas for me to try :(

Any other ideas to try?

kh99 06-07-2013 01:17 PM

You could try using Maintenance > General Update Tools > Rebuild Search Index, there's a link to "empty the search index", and then you can rebuild it. However, if you have a large site with many posts, this could take a long time.

Bluemax712 06-07-2013 03:16 PM

Wow! that worked - thanks Kevin
Didn't even notice that was an option - I would have thought emptying it is the first thing that is done anytime it is rebuilt

You're right it took about 40 minutes to get through 160k posts.


All times are GMT. The time now is 09:26 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01157 seconds
  • Memory Usage 1,705KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (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_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete