Got error -1 from table handler

Napster

So I got onto my website this morning and I got this error on one of my scripts:

Got error -1 from table handler

However I do not know what it means or how to fix it. I tried searching these forums and the search does not seem to be working. I also tried repairing all tables in my database and no luck either. I also tried searching in a search engine and all I get is results for error -127 and I know how to fix that. I also tried looking on mysql.com and I didnt find anything.

So, can someone either please explain to me what this means and how to fix it, or show me a site that explains this.

Thank you in advance.

tsinka

Hi,

is that site hosted on your own server or somewhere at a hosting company ?

EDIT: The reason could be a full disk or some other kind of limit (quota, temp file size limit or something like that) or table corruption.

Thomas

Napster

No, it is not hosted on my server, but on a webhosts server.

Now the error says: Got error 28 from table handler

tsinka

Ok,

I think that at least one partition is full or something like that. Do you have a chance to login to the server (ssh, telnet ...) ? If yes, then log in and execute the command

df -m

That should return a table with all partitions (mount points) and info about total/used/free spache in MB.

I think you need to get in contact with your hoster.

Another possible reason: Do you have very large tables so that one of the database file might be hitting a 2GB limit or something like that ?

Thomas

Napster

Hmm... that is wierd as my database is like 5 megs. I better go bug the host then.