Can't Uninstall Product

[Lombardo]

I've already contacted the maker of this hack, but he's in america so it'll be a while before i get a reply, different time difference. I'm desperate to get rid of this problem as im trying to upgrade. This is the error message i get when i try to uninstall this hack, can anyone help please?

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE `vbulltournaments`
DROP `jackpot`,
DROP `jackpot_type`;

MySQL Error : Can't DROP 'jackpot'; check that column/key exists
Error Number : 1091
Date : Friday, May 2nd 2008 @ 12:30:03 PM
Script : http://mydomain/admincp/plugin.php?do=productkill
Referrer : http://mydoamain/admincp/plugin.php?...ibproarcade&s=

[snakes1100]

Did you run a repair thru phpmyadmin and then try to uninstall the hack?

If you have root access, you can try the following as well.

cd to db dir
myisamchk -r *.MYI
myisamchk -o *MYI

[Lombardo]

I don't know how to do that mate

[snakes1100]

Which part?

Do you not at least have phpmyadmin access for your site?

You could try using the DB feature in the vb admincp as well.

[Lombardo]

Both.

Yeah in plesk i have phpadmin access mate.

[snakes1100]

If you have phpmyadmin access in plesk, then run a repair on the db.

If you do not know how to use phpmyadmin, there are plenty of guides out there to step you thru, but in the left column click the db name in question, in the right pane after all the tables is a check all option, then to the right in the drop menu opt for repair.

[Lombardo]

Ok i tried that mate, but still can't uninstall this product. I still get the same error message.

[snakes1100]

Did all the tables report back as being ok?

To recover the key, it would be best to ssh in and use myisamchk to try and recover it.

[Paul M]

Try changing the product version number to 0 in the ACP, then install it again, then uninstall it.

[Lombardo]

No mate most of them say this "The storage engine for the table doesn't support r..." i can't read the end bit it just cuts of there.

I don't have a clue about ssh.

--------------- Added [DATE]1209730715[/DATE] at [TIME]1209730715[/TIME] ---------------

Originally Posted by Paul M

Try changing the product version number to 0 in the ACP, then install it again, then uninstall it.

I get an error page when i install it again paul

Invalid SQL:
ALTER TABLE `vbullgames_session` ADD `credits_paid` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'credits_paid'
Error Number : 1060
Date : Friday, May 2nd 2008 @ 01:17:35 PM
Script : http://mydomain/admincp/plugin.php?do=productimport
Referrer : http://mydomain/admincp/plugin.php?do=productadd