Problem With Activity Mod

[pspuser007]

Hello!


I have Vbulletin 3.8.
I have a problem with the Activity mod.
My co-Admin unistalled it and removed it's code from the Main CSS.
Then when I tried to reistall it I got the following errors:
Invalid SQL:
ALTER TABLE `user` ADD `wwu002activity` INT UNSIGNED NOT NULL ,
ADD `wwu002activitydate` INT UNSIGNED NOT NULL ,
ADD `wwu002memberlevel` TINYINT UNSIGNED DEFAULT "1" NOT NULL ,
ADD `wwu002fullmemberdate` INT UNSIGNED NOT NULL ,
ADD `wwu002lastvisit` INT UNSIGNED NOT NULL;

MySQL Error : Duplicate column name 'wwu002activity'
Error Number : 1060

As i understand,the unistall did not work properly..
So what can I do?

I have seen this as a solution : http://www.vbulletin.org/forum/showpost.php?p=1108272&postcount=340
Thank you for your time!

 

[clarksta]

it did not remove the tables that where made from the install

make sure nothing else is using them tables then remove them manually

via phpmyadmin

 

[pspuser007]

My friend this is the first time this happens to me.
Can you please tell me how to do what you said?

Thank you very much for the reply!!!

 

[swapnil0545]

In short!

When your friend uninstalled that Activity mod, the tables were not removed.

So you will have to remove the tables manually.
Before you try the installer again.

 

[pspuser007]

Could you please tell me what I am searching exactly,in what tables should I search it and what should I do?:S

Thank you for your time!

 

[pspuser007]

Anyone please?