Quote:
Originally Posted by rolfw1
Well unfortunately I installed from the readme file, so hadn't done that.
Now if I unistall version 2, then try and reinstall version 1 so that I can unimnstall it gives me a database error, any idea how i can solve this?
Code:
Database error in vBulletin 4.0.8:
Invalid SQL:
ALTER TABLE usergroup ADD akvbghsfs_akismet_permissions INT(10) UNSIGNED DEFAULT "0" NOT NULL;
MySQL Error : Duplicate column name 'akvbghsfs_akismet_permissions'
Error Number : 1060
Request Date : Wednesday, February 9th 2011 @ 02:42:40 AM
Error Date : Wednesday, February 9th 2011 @ 02:42:40 AM
Script : http://www.thamesvalleybirds.co.uk/admincp/plugin.php?do=productimport
Referrer : http://www.thamesvalleybirds.co.uk/admincp/plugin.php?do=productadd
IP Address : **.**.**.**
Username : *******
Classname : vB_Database
MySQL Version : 4.1.22-standard
|
This seems to be the result of not uninstalling version 1 before installing version 2.
If you have access to PHPmyadmin you can simply delete the akvbghsfs_akismet_permissions column and re-install version 2.
Or,
remove this:
Code:
'ALTER TABLE usergroup ADD akvbghsfs_akismet_permissions INT UNSIGNED DEFAULT "0" NOT NULL;'
from the plugin installation code.
Than install it, and uninstall it.