vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   How to automatically fix mysql database error? (https://vborg.vbsupport.ru/showthread.php?t=311625)

postcd 05-24-2014 06:30 AM

How to automatically fix mysql database error?
 
From time to time i got issue with this table. It happend again now when tried to delete some topic. One topic was deleted but second one happens this error:

Quote:

Database error in vBulletin 4.1.10:

Invalid SQL:

DELETE searchgroup, searchgroup_text
FROM searchgroup AS searchgroup JOIN
searchgroup_text AS searchgroup_text ON
searchgroup.searchgroupid = searchgroup_text.searchgroupid
WHERE searchgroup.contenttypeid = 2 AND
searchgroup.groupid = 8220;

MySQL Error : Table './mydb_vb/searchgroup_text' is marked as crashed and should be repaired
Error Number : 145
I know there is myisamchk or mysqlcheck or such tools, but they dont works to fix tables , i already tried its fix opperators, but it did not repaired. Only when i use some repair command, but then it somehow repair all tables not only those crashed.

Please idea on how to automatically detect error and auto fix such erroneous table? im under my own linux server.

RichieBoy67 05-24-2014 12:10 PM

You can go into either vbulletin admincp or phpadmin to choose the table you want to repair. Just choose the search table and repair it. Or use something like this in ssh -

repair table searchgroup_text;


All times are GMT. The time now is 11:49 PM.

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.01005 seconds
  • Memory Usage 1,710KB
  • 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)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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