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?