On Sun, April 24, 2005 5:20 am, Mike Blezien said:
> we started getting these table handler errors 12, not all the time, but
> just now
> then. this is a FreeBSD 4.9-RELEASE O/S, w/MySQL 4.0.24 installed. The
> database
> in question is used by this vBulletin BBS system. Not sure
sec)
if you redefine it, it may work better in memory.
Else use temporary tables.
Mathias
-Original Message-
From: Jigal van Hemert [mailto:[EMAIL PROTECTED]
Sent: dimanche 24 avril 2005 17:08
To: [EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: Table handler errors
> Yes, I've going
> Yes, I've going through the docs and the manual i have hear locally,
couldn't
> really find a specific reason and/or causing for the error. The table type
that
> was causing the error was a HEAP table, changed it to a MyISAM table type
and
> the error disappeared, no more handler errors now... go
Jigal van Hemert wrote:
From: "Mike Blezien"
we started getting these table handler errors 12, not all the time, but
just now
For errors from the operating system you can use perror to find out the
description of the code:
http://dev.mysql.com/doc/mysql/en/perror.html
Regards, Jigal.
From: "Mike Blezien"
> we started getting these table handler errors 12, not all the time, but
just now
For errors from the operating system you can use perror to find out the
description of the code:
http://dev.mysql.com/doc/mysql/en/perror.html
Regards, Jigal.
--
MySQL General
Hello,
we started getting these table handler errors 12, not all the time, but just now
then. this is a FreeBSD 4.9-RELEASE O/S, w/MySQL 4.0.24 installed. The database
in question is used by this vBulletin BBS system. Not sure it's a problem with
the BBS or how MySQL is configured. Was w
possible table corruption. Run myisamchk on the table to check it and then,
if needed, repair it.
Bhavin.
- Original Message -
From: "Amit Lonkar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 22, 2002 10:52 PM
Subject: Table Handler Errors
&g
Hi All!
I am using mysql-.3.23.49 on windows. It generates the
following error:-
General error: Incorrect key file for table: 'lotjob'.
Try to repair it .
or some times it generates a table handler error.
why do these errors occur?
Regards
Amit Lonkar
>Description:
Users enter data from a php based web site and receive no errors
or warnings of any kind that something is amiss, but the data isn't
entered into the tables. When I go to the mysql command line and run
commands i get a table handler error.
>How-To-Repeat:
this happen