Invalid SQL - Error, please help

[Killsparer]

Hi,

without installing a hack or messing around with the code,
all users suddenly get this error-message while attempting to access the control panel:

Datenbank Fehler in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=2 ORDER BY title
mysql error: Got error 28 from table handler

mysql error number: 1030

Datum: Tuesday 06th of May 2003 09:20:02 PM
Script: http://www.projektstarwars.de/forum/forum/usercp.php
Referer:

Could you please identify the error or give me a hint?

I hope, this is no database-corruption. And another mystery for me is the "/forum/forum/usercp.php" part.

[filburt1]

It means that the partition on which the MySQL data is stored is full. Shut down your forums immediately and contact your host.

Ignore the double /forum/ bit.

[Killsparer]

Thanks for the help,
but my forum is on my employers webspace,
which is far from being full.

(and no limit was set up for my board)

And this error just appears while accessing the control-panel, nowwhere else.

[Boofo]

Filburt, is there a place to go that lists these errors and what they mean? In layman terms, that is, so we can all understand them like you told it here.

[filburt1]

I just seached good ol' Google.

[Xenon]

hmm, tablehandler errors can sometimes be other problems, too.

try to REPAIR the tables.

if it doesn't work, maybe this trick will:
in phpmyadmin add a field to the table, and after the delete the field again.
last itme i could solve the error this way..

[Killsparer]

Today at 08:59 PM Xenon said this in Post #6
hmm, tablehandler errors can sometimes be other problems, too.

try to REPAIR the tables.

if it doesn't work, maybe this trick will:
in phpmyadmin add a field to the table, and after the delete the field again.
last itme i could solve the error this way..

I repaired all tables via phpmyadmin, but the error is still there.

As a newbie... to what table shall i add a field? subscribeforum?

Just asking, before i destroy even more of my board...

[filburt1]

As I said, tell your host first.

[Xenon]

to subscribeforum and to forum table,
just one then test, then the other

but filburt is right, if it happens from nowhere contacting the host wouldn'T hurt

[Killsparer]

Nothing helped,
so i´ll question my host tommorrow.

But many thanks for your support!