vb.org Archive - An odd error in MySQL.. (thread.MYI?)

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - An odd error in MySQL.. (thread.MYI?) (https://vborg.vbsupport.ru/showthread.php?t=51330)

Velocd

04-08-2003 12:39 AM

An odd error in MySQL.. (thread.MYI?)

It seems some strange outside interference has caused my forum to temporarily shut down.

I am receiving a strange database error that says:

Code:

Database error in vBulletin 2.3.0:



Invalid SQL: 

  SELECT threadid,forumid,title,replycount,postusername,dateline,views,postuserid

  FROM thread

  WHERE visible=1 AND open<>10 

  ORDER BY dateline DESC LIMIT 8



mysql error: Can't open file: 'thread.MYI'. (errno: 145)



mysql error number: 1016



Date: Monday 07th of April 2003 09:22:23 PM

Script: http://www.animesystem.com/forums/

Referer:

I'm not sure what it is referring to when it says "thread.MYI"

Anyone have any ideas? The most recent thing I've done was create a new subdomain on my server, but I hardly see how this could be causing a problem. I was browsing a thread on my site at school today and it loaded just fine, but sometime between 7 hours ago and now this error occurred.

Thanks if you can help. ;)

Velocd

04-08-2003 12:44 AM

Never mind, just noticed a thread that hopefully will solve my problem.

https://vborg.vbsupport.ru/showthrea...ght=thread.myi

Ironic this error just happened with someone recently as well.

I do have one question though, how can a thread table become corrupted by simply viewing threads or regular browsing on the forum?

Dean C

04-08-2003 07:58 AM

I had this problem on localhost yesteday. But it was after hacking a file so i thought nothing of it. How odd :S

- miSt

Xenon

04-08-2003 09:23 AM

well i don't know how these errors can occur, but they can....

just run repair.php ;)

Steve Machol

04-08-2003 05:18 PM

By any chance does your server use CPanel? We have a theory that the latest version of CPanel is updating MySQL on a daily basis. Unfortunately if your database is being written to when this occurs, then you could get database corruption.

Find out if you are using CPanel and if so, what version it is. Also find out what the update schedule is set to.

http://www.vbulletin.com/forum/showt...605#post438605

Velocd

04-09-2003 04:18 PM

Cpanel 6.4.0-EDGE Build 1

MySQL 4.0.12

Webhost Manager Update preferences unknown-- how do I find this info in Cpanel?

I just got this MYI error again yesterday, and a few of my threads were lost as well. Strange error..

Steve Machol

04-09-2003 09:37 PM

Quote:

Today at 10:12 AM Velocd said this in Post #6
Cpanel 6.4.0-EDGE Build 1

MySQL 4.0.12

Webhost Manager Update preferences unknown-- how do I find this info in Cpanel?

This info is not in CPnael. It's in WebHost Manage which reuires root access to the server. If you are on a shared server you'll need to contact your host about this.

Kriek

04-09-2003 09:46 PM

Quote:

04-07-03 at 09:33 PM Velocd said this in Post #1
Can't open file: 'thread.MYI'. (errno: 145)

Run this query:

Code:

REPAIR TABLE thread

SysRq

06-13-2003 02:06 AM

so has anyone actually found a fix for this that doesnt require doing every night?

Steve Machol

06-13-2003 04:43 AM

1. Read this thread:

http://www.vbulletin.com/forum/showt...threadid=69803

2. Quick fix:

Try using mysqldump to create a sql backup your database - mysqldump guide at http://www.sitepoint.com/article/678

Then create a new empty database name and import the mysql sql backup back into the empty database, and edit config.php to point to the new database

Also take a read of

http://www.mysql.com/doc/en/Corrupte...AM_tables.html

and

http://www.vbulletin.com/forum/showt...threadid=69803
mysql4

All times are GMT. The time now is 07:12 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01183 seconds Memory Usage 1,738KB 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 (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: