svoec
Fri 27th Jun '03, 12:05am
I have recently started having myi errors
my database is about 70 megs, and I am running 2.29 (yea.. I am planning on upgrading ASAP) -- in the last 2 weeks, I have repaired or restored the database 4 times. -- (my host just upgraded to mysql 4.0.12)
I spoke with them, and they say they do have other customers having issues also, and that they are researching the problem.
Any help would be GREATLY APPRECIATED!!!
Tuesday, I repaired the database, did a backup (from mysqldump) created a new database, and dumped the info into it, and changed the config file. Today, it crashed again....
I am using shared hosting, so I don't know the specifics of processors, or hard drives..
here are the specs from c-panel
Cpanel Version/Build6.4.2
RELEASE Build 5Operating SystemLinuxApache Version1.3.27 (Unix)
Perl Version5.006001
Perl Path/usr/bin/perl
Installed Perl Modules
PHP Version4.3.1
Mysql Version4.0.12
I'll post a link to the phpinfo page if you need it.
the last time I got the error, I got a couple of DB errors before the MYI error --- here they are.
-----------------------
Database error in vBulletin 2.2.9:
Invalid SQL: UPDATE thread SET lastpost='1056666534',replycount='1',lastposter='s vo1fast4' WHERE threadid='2805'
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:28:54 PM
-----------------------------------------
Database error in vBulletin 2.2.9:
Invalid SQL: SELECT * FROM thread WHERE threadid=2805
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:29:31 PM
-------------------------------------------
Database error in vBulletin 2.2.9:
Invalid SQL:
SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 2
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1054074592 AND sticky=0
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:29:52 PM
-----------------------------------------------------'
Database error in vBulletin 2.2.9:
Invalid SQL:
SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 2
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1054074972 AND sticky=0
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:36:12 PM
-----------------------------------------------
after this, I got the MYI errors...
my database is about 70 megs, and I am running 2.29 (yea.. I am planning on upgrading ASAP) -- in the last 2 weeks, I have repaired or restored the database 4 times. -- (my host just upgraded to mysql 4.0.12)
I spoke with them, and they say they do have other customers having issues also, and that they are researching the problem.
Any help would be GREATLY APPRECIATED!!!
Tuesday, I repaired the database, did a backup (from mysqldump) created a new database, and dumped the info into it, and changed the config file. Today, it crashed again....
I am using shared hosting, so I don't know the specifics of processors, or hard drives..
here are the specs from c-panel
Cpanel Version/Build6.4.2
RELEASE Build 5Operating SystemLinuxApache Version1.3.27 (Unix)
Perl Version5.006001
Perl Path/usr/bin/perl
Installed Perl Modules
PHP Version4.3.1
Mysql Version4.0.12
I'll post a link to the phpinfo page if you need it.
the last time I got the error, I got a couple of DB errors before the MYI error --- here they are.
-----------------------
Database error in vBulletin 2.2.9:
Invalid SQL: UPDATE thread SET lastpost='1056666534',replycount='1',lastposter='s vo1fast4' WHERE threadid='2805'
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:28:54 PM
-----------------------------------------
Database error in vBulletin 2.2.9:
Invalid SQL: SELECT * FROM thread WHERE threadid=2805
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:29:31 PM
-------------------------------------------
Database error in vBulletin 2.2.9:
Invalid SQL:
SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 2
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1054074592 AND sticky=0
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:29:52 PM
-----------------------------------------------------'
Database error in vBulletin 2.2.9:
Invalid SQL:
SELECT
thread.threadid
FROM thread
WHERE thread.forumid = 2
AND thread.sticky=0
AND thread.visible=1
AND lastpost >= 1054074972 AND sticky=0
ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Thursday 26th of June 2003 06:36:12 PM
-----------------------------------------------
after this, I got the MYI errors...