Problem reinstalling a plug-in

[JohnnyNorCal]

I downloaded an award system plugin from Cypher for vBulletin 4.0 and installed it. I was having problems with it so I installed it.

Now when I try to reinstall it I get this database error.

Database error in vBulletin 4.0.3:

Invalid SQL:
ALTER TABLE award ADD award_allowrecommend TINYINT( 1 ) DEFAULT 1 NOT NULL,ADD award_pointvalue TINYINT( 3 ) DEFAULT 0 NOT NULL;

MySQL Error : Duplicate column name 'award_allowrecommend'
Error Number : 1060
Request Date : Friday, June 11th 2010 @ 12:14:23 AM
Error Date : Friday, June 11th 2010 @ 12:14:24 AM
Script : http://www.adultgamersnetwork.com/ad...=productimport
Referrer : http://www.adultgamersnetwork.com/ad...?do=productadd
IP Address : 76.20.125.245
Username : JNC
Classname : vB_Database
MySQL Version : 5.0.67-community-nt

It must have left table info in the database but have no idea how to fix this problem so I can reinstall it and get it working.

[your24hourstore]

MySQL Error : Duplicate column name 'award_allowrecommend'

did you uninstall or write just install over the product?

you can back up to before
and uninstall the product

best thing i ever did was install the database backup mod

--------------- Added 11 Jun 2010 at 07:32 ---------------

https://vborg.vbsupport.ru/showthread.php?t=231481

[JohnnyNorCal]

did you uninstall or write just install over the product?

I'm sorry, I don't understand what your asking me?

I went to the "manage products" area of the acp and found the list of products. Since this was my first plugin there were only 3 listed. Vbulletin, Blog, and "Yet another award system". I used the drop down box and chose uninstall and hit go. Then only two products were shown.

Now when I try to reinstall I keep getting that database error message.

I appreciate the help, but adding another mod is not exactly the answer I am looking for. I just want to fix my database so I can reinstall this mod and try to get it to work right.

Before I tried installing the mod, I did make a backup through phpMyAdmin using the export feature and zipped it up. I'm just thinking or hoping I don't have to import the backup to fix this problem. It seems minor but I'm not sure what to do.

Is there someone that can help me out a little?

[your24hourstore]

goto admincp/maintenance/repair optimize

run that then try and reinstall it

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

but a database backup would do it too

[JohnnyNorCal]

Sounds good, I will try that and give an update once I've done it.

I sure wish the developer of that mod gave better directions. I think I might have had it installed right the first time before I uninstalled it but it never showed me the new options in the admincp and also the new awards tab on the navbar was just directing me to a 404 error page.

Ugghhhh. So frustrated

[your24hourstore]

what awards that may help and have you posted in that mods thread about this ?

lol try 50 hacks out for a headache

[JohnnyNorCal]

Nope, did not work. I keep getting that same database error. It's like the tables never uninstalled correctly.

I'm so unhappy

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

Originally Posted by harleyparts

what awards that may help and have you posted in that mods thread about this ?

lol try 50 hacks out for a headache

"Yet another award system" 4.0.2 (I think)

And yes, I posted in that forum with no response...yet anyway

[your24hourstore]

ok 4.0.2 is not 4.03 so that may be a problem altough a lot of peeps run that mod.

i cant tell you how to go delete that table that would be a disaster, probibly host on godaddy :>

so If you can wait i would maybe someone will support that mod. but if you cant I would do this. upload 4.0.3 pl1 to your server open it and remove install.php from install/install.php

if you have all stock images and no favicone you can just move all the files in upload to their folders over writing it and install over it by going to yoursite.icom/install/upgrade.php

or here is anouther option it sounds like your board is new, if you dont have any users or just a few you can delete your database and remake it but first i would just do a database back up ... so those are the options to fix the table if you dont know how to do it in php administration

[Rafa-el]

I've installed that hack sucessfully, but as far as I remember the upgrade script make it incompatible with lower versions...

[your24hourstore]

ahh heres some help as i have never even tried to install it...do a database backup :>