error 1 from storage engine

[pedrok]

Hi

Hoping someone may be able to help.

I run a forum using Invision (IP.Board). I have named its MYSQL Database - IPB DB

I was trialing a component modification IBPWIKI mod, which runs its own (mediawiki) wiki DB, but adds an interface with my Forum and installs 5 tables in my IPB DB

I last used the mod about 4 months ago and the other day I went to uninstall it. But I found that the Wiki DB was corrupted - maybe when my host was moving server - about a month ago.

I have reloaded a wiki DB backup, and the wiki DB looks fine (I removed the lines in the MediaWiki local sttings file which allows the wiki to run independently from the Invision Forum

I then have tried to drop the tables in my IPB DB, but I am getting this errror

SQL query: DROP TABLE `ipb_ipbwiki_conf`
MySQL said: #1051 - Unknown table 'ipb_ipbwiki_conf'

Got error 1 from storage engine

I also got this error initially when I tried to drop the tables when the DB was corrupt.

I also tried the Repair Function in phpadmin

I have asked on the IPBWIKI forum and it was suggested that I re-run the wiki -Installer (interface with IPB) - but it fails with the same "Got error 1 from storage engine"

I have also asked on the Invision Support Forum but no one can help

Does anyone have any idea how I can clean this up.

What I want to do is completely remove the wiki.

My concern now is that my IPB DB is messed up.

Details are:
Apache version 1.3.41 (Unix)
PHP version 5.2.6
MySQL version 4.1.22-standard
Architecture x86_64
Operating system Linux

thanks
Pete

[Atli]

Hi.

Which storage engine is your table using?
I've heard there was a bug when dropping tables who's data file had been corrupted. The only solution was to delete the corrupted file manually.

Seeing as you are still using MySQL 4, I would recommend starting by upgrading to MySQL 5.0 and see if this has been fixed there.

Alternately. You could try backing up the tables you want to keep and then dropping the entire database. See it that does anything.

[pedrok]

Hi thanks for the`response.

I spoke with my host today, with some suggestions, including yours, and he was able to fix it for me.

once again ta

Pete