[Marco van Herwaarden]

Originally Posted by Nathan2006

I have tried installing this but not working for me

So after trying to un-install the product I am getting this error:

Database error in vBulletin 3.5.4:
 
Invalid SQL:
ALTER TABLE post DROP COLUMN mh_pbc_colorschemeid;
 
MySQL Error  : Can't DROP 'mh_pbc_colorschemeid'; check that column/key exists
Error Number : 1091
Date         : Saturday, July 15th 2006 @ 08:48:54 PM
Script       : http://www.************.com/admincp/plugin.php
Referrer     : http://www.************.com/admincp/plugin.php?do=productdelete&productid=mh_pbc&s=
IP Address   : ************
Username     : ****
Classname    : vb_database

Thank you for any help

I have looked into this and there is a space missing from one of the uninstall steps causing a SQL-error. The error you quoted however can only happen if you try to uninstall twice. You would have gotten a different error the first time.

To fix your current situation (this only applies if you tried to uninstall twice, will upload a fixed version in a few minutes for those that still have to start uninstallation), do the following:

Go to AdminCP->Plugin System->Manage Products, then:
- Select 'Edit' from the dropdown menu behind the Post Background Color product.
- On the edit page you will find 3 rows with each 2 columns with install/uninstall code.
- The right column contains the uninstall codes
- Change the uninstall for version 1.00 (the first row) to contain only (overwrite the current code):

PHP Code:

// Clean Datastore
$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "datastore WHERE title = 'mh_pbc'"); 


- Remove all the code from the version 1.01 uninstall code box (right column, second row)
- Save the product (use the bottom Save button!)

Uninstall again.