Uninstall / Install DB error

[Daily_Musician]

I installed 3.0 Beta 2 and it had a couple of bugs. I unistalled it and tried to install 2.0.2. It gave me DB errors, so I tried re-installing 3.0 and it gets errors also. It seems the uninstall doesn't remove the phrasegroups from the language table.

Database error in vBulletin 3.7.1:

Invalid SQL:

ALTER TABLE language
ADD phrasegroup_adv_links MEDIUMTEXT NOT NULL,
ADD phrasegroup_adv_links_addedit MEDIUMTEXT NOT NULL,
ADD phrasegroup_adv_links_cp MEDIUMTEXT NOT NULL,
ADD phrasegroup_adv_links_cp_perms MEDIUMTEXT NOT NULL,
ADD phrasegroup_adv_links_managecats MEDIUMTEXT NOT NULL,
ADD phrasegroup_adv_links_moderate MEDIUMTEXT NOT NULL,
ADD phrasegroup_adv_links_search MEDIUMTEXT NOT NULL;

MySQL Error : Duplicate column name 'phrasegroup_adv_links_addedit'
Error Number : 1060
Request Date : Wednesday, June 11th 2008 @ 08:45:04 PM
Error Date : Wednesday, June 11th 2008 @ 08:45:04 PM
Script : http://.com/admincp/vbalinks_install.php
Referrer : http://.com/admincp/vbalinks_install.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.45-community

[Brian]

Did you make sure to use the 'Unintall' option from the v3.0 vbalinks_install.php file? That phrase group column is definitely removed during the uninstall, so there shouldn't be any way you would get that if so.

[Daily_Musician]

I used the uninstall option on both versions before trying to re-install. It removed everything else, but the phrasegroups. :confused:

[Brian]

I don't really see how that would be possible, but if you would like to submit a support ticket via the Members' Area here I'll be glad to take a look at things for you.

[adblaze]

It's possible. I am experiencing the same issue.

[Daily_Musician]

I tried uploading everything again this morning and re-installing, but get errors, so I want to just remove it until a stable version comes out.

Can I safely remove everything manually?

I don't expect you to do it, since I installed it. - Thanks

[Brian]

adblaze - Please submit a support ticket via the Members' Area here and I will take a look at things for you.

Daily_Musician - All that's necessary to uninstall the product is to run the Uninstall option from the vbalinks_install.php file. You can also remove the files that you uploaded if you would like, but that's not really necessary.

[Daily_Musician]

I fixed mine, so if you have the same problem here is how I did it:

1. Run uninstall script
2. Go to your DB in phpMyAdmin
3. Find the "Language" table
4. View the "structure"
6. Find the phrases listed with adv_links in the name
7. Select these and drop from the table
8. Install as if you never installed before


I had 4 phrases that the uninstall script wouldn't remove. Hope this helps someone else. :D

[Brian]

For anyone else that may be having this issue, the fix has been applied to the admincp/vbalinks_install.php file here. If you will download the files again and replace that file with the updated version, you should then be able to use the Uninstall option and then reinstall.