PDA


View Full Version : sql error on install

Ramses
06-03-2008, 02:28 PM
I got following on upgrade:
Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:

ALTER TABLE vb3_language
ADD phrasegroup_adv_links_cp_perms MEDIUMTEXT NOT NULL,
ADD phrasegroup_adv_links_addedit 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_cp_perms'
Error Number : 1060
Request Date : Tuesday, June 3rd 2008 @ 07:23:07 PM
Error Date : Tuesday, June 3rd 2008 @ 07:23:07 PM
Script : http://www.myforum.de/forum/admincp/vbalinks_install.php
Referrer : http://www.myforum.de/forum/admincp/vbalinks_install.php
IP Address : 77.189.27.183
Username : **
Classname : vb_database
MySQL Version : 5.0.18-max

This was the second sql error, the first one couldn't save it because my computer got a blue screen. I only remember it had to do anything with custom fields. Thanks.
Brian
06-04-2008, 12:18 PM
Sounds like the upgrade was half-way run and didn't complete... Would you mind submitting a support ticket so I can take a look at see what still needs to be run from the upgrade script?
Ramses
06-06-2008, 01:05 AM
Ticket was submitted yesterday. Thanks.
adblaze
06-10-2008, 08:26 PM
Hey, I'm having this same issue. I got this error after installing vblinks, deleting it, then reinstalling later. I have checkd to make sure no old MySQL tables remained from the previous install. Did you guys figure out a fix for this?
adblaze
06-10-2008, 08:27 PM
Actually I notice my error is a little different.

Database error in vBulletin 3.7.0:

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'
Error Number : 1060
Request Date : Tuesday, June 10th 2008 @ 06:35:57 PM
Error Date : Tuesday, June 10th 2008 @ 06:35:57 PM
Script : http://www.thegameforum.com/admincp/vbalinks_install.php
Referrer : http://www.thegameforum.com/admincp/vbalinks_install.php
IP Address : 71.243.251.24
Username : gameforum
Classname : vb_database
MySQL Version : 4.1.20
adblaze
06-12-2008, 12:40 AM
Anything? I see others are having this problem as well.
Brian
06-12-2008, 10:58 AM
You need to use the "Uninstall" option from the install file if you have previously installed it and want to reinstall.