Topic: What does this error mean?

http://forums.firefusion.org/

Re: What does this error mean?

try doing a repair on the tables in phpmyadmin? assuming its mysql i think error 28 is damaged table

3 (edited by Fire Fusion 2005-04-12 14:29)

Re: What does this error mean?

I think i've found the problem (bare in mind this is my first time in phpmyadmin).

I checked all the tables tick boxes and selected Anazlye and then check. They all came back saying "Table is already up to date" and "OK" expect .online which said "The storage engine for the table doesn't support c..."

I ticked them all and selected repair but the .online one said "The storage engine for the table doesn't support repair"

I clcik on the online table from the side menu. I noticed it said  Overhead 627 Bytes in red.

What now?

Re: What does this error mean?

overhead is not really a problem it can be fixed by optimising it but your forum works now http://forums.firefusion.org/

Re: What does this error mean?

Odd. Thanks anyway.

Re: What does this error mean?

Old thread but...

Connorhd wrote:

overhead is not really a problem it can be fixed by optimising it but your forum works now http://forums.firefusion.org/

It is a problem if you're running an unattended backup script as I am. The backup was stopping at 'online' because the table (presumably) had problems and the script includes a 'halt on an error' which also includes an email report function.

When I went in to repair the table via PhpAdmin, the only tool available was 'Flush'. No 'Repair' or 'Optimize'. That had me stumped for a while until I realised that the table type was 'HEAP'. Resetting it to 'MyISAM' gave me back the missing 'Repair' and 'Optimize' tools which I duly ran and the backup is now working fine again.

What confuses me is why this table was set to type 'HEAP'. The backup script I use does an online 'Check & repair' and it can't handle HEAP tables yet it's been running fine for about 2 months - so I only assume that the table type was reset somewhere between 2am on 24/05 and 2am on 25/05!

Any ideas as to how this could have happened? It's a tiny forum that's hardly used.

Re: What does this error mean?

it is meant to be HEAP, that way it is kept in memory and even faster than MyISAM, overhead should not stop you backing it up.

if it is causing a problem i would simply not back it up, the contents of that table don't matter