Page 1 of 1

MYSQL ERROR !27 problem

Posted: Sat Jul 12, 2003 1:51 pm
by mzfp2
this problem seems to occur every so often which doesnt allow access to certain tables that are affected, database returns a GET TABLE HANDLE ERROR 127, and leaves me no choice but to drop the table and recreate it,

but is there a reason why this happens?

Posted: Sat Jul 12, 2003 3:14 pm
by twigletmac
What are you trying to do when you get the error?

Mac

Posted: Sat Jul 12, 2003 11:19 pm
by m3mn0n
I think your SQL version might be the problem.

Posted: Sat Jul 12, 2003 11:31 pm
by johnm1019
What OS is the Mysql running on....

And i would agree with sami... update your MySQL and try again...

Also are u accessing the db from something like mysql control panel or are u sitting at a console on the localhost?

Posted: Sun Jul 13, 2003 7:38 am
by mzfp2
both my local machine and host are using MYSQL 3.23 .. and i use MY CC panel on my machine, and some database adminstration tools on the host that they've provided.

The problem happens on both without warning

Posted: Sun Jul 13, 2003 8:52 am
by m3mn0n
This could be a result of bad information within tables. Or a very sloppy table setup/configuration. It happened to me before, not that particular error I'm not sure which one really...

Can you post table structure/data?