MYSQL ERROR !27 problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mzfp2
Forum Contributor
Posts: 137
Joined: Mon Nov 11, 2002 9:44 am
Location: UK
Contact:

MYSQL ERROR !27 problem

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

What are you trying to do when you get the error?

Mac
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

I think your SQL version might be the problem.
johnm1019
Forum Newbie
Posts: 4
Joined: Sat Jul 12, 2003 11:26 pm

Post 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?
mzfp2
Forum Contributor
Posts: 137
Joined: Mon Nov 11, 2002 9:44 am
Location: UK
Contact:

Post 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
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post 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?
Post Reply