[brianj]

Originally Posted by DeeperImage

I tried this, can someone make sure I have all the files there ? or is it missing something?

DELETE FROM `phrase` WHERE `varname` = 'settinggroup_adcolumn' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adenable_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adenable_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adleft_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adleft_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adright_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleleft_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleleft_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleright_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleright_desc' LIMIT 1;

DELETE FROM `settinggroup` WHERE `grouptitle` = 'adcolumn' LIMIT 1;

DELETE FROM `setting` WHERE `varname` = 'adenable' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adleft' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adright' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adtitleleft' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adtitleright' LIMIT 1;

Ok, just upgraded to 3.07 and lost the adcolumn (expected), I went in and ran the above to delete any other instance of it in my database, but the install is still failing and I still get the blank adcolumn template, with no options to change :tired: . any suggestions? Here is the error I am getting:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('adcolumn', '600', 1)

mysql error: Duplicate entry 'adcolumn' for key 1

mysql error number: 1062

Date: Monday 04th of April 2005 05:22:34 PM
Script: http://www.xxxxxxxx.com/admincp/install_adcolumns.php
Referer: http://www.xxxxxxxx.com/admincp/install_adcolumns.php
Username: xxxxx
IP Address: xx.xx.xxx.xxx