Error on upgrade: vbulletin settings import

[kontrabass]

I'm using Eva's upgrade method (thank goodness), as I've hit this error near the tail end of the upgrade process from 3.0.5 to 3.5.2:

Step1) Import latest options
Importing vbulletin-settings.xml

There seems to have been a problem with the TalkBass Forums database etc etc etc

MySQL Error : Duplicate entry 'smtp_host' for key 1
Error Number : 1062
Date : Tuesday, January 3rd 2006 @ 11:28:34 AM
Script : http://www.talkbass.com/forum2/install/finalupgrade.php?step=1 (http://www.talkbass.com/forumtemp/install/finalupgrade.php?step=1)
Referrer : http://www.talkbass.com/forum2/install/finalupgrade.php (http://www.talkbass.com/forumtemp/install/finalupgrade.php)
IP Address : 66.68xxxxx
Username :
Classname : vb_database


Any ideas? My first reaction was it was due to a hack (I've got a couple installed), but the error message looks suspicious...

[Colin F]

This seems to be because of a hack. Did you install a hack that had anything to do with SMTP mailing?

[kontrabass]

Ureka - After going through old records I did find a very old hack from 2002 that installed to enable smtp before vbulletin supported it...

It requested the following:
INSERT INTO setting VALUES (300,11,'Use MIME/HTML','html_use','1','This will send mail as MIME/HTML unsless the user selects otherwise.','yesno',5);
INSERT INTO setting VALUES (301,11,'Use SMTP','smtp_use','1','This will use SMTP to send all emails on this board instead of using the server wide settings in your php.ini file.','yesno',10);
INSERT INTO setting VALUES (302,11,'SMTP Host','smtp_host','localhost','','',15);
INSERT INTO setting VALUES (303,11,'SMTP Port','smtp_port','25','','',16);
INSERT INTO setting VALUES (304,11,'This Hostname','smtp_helo','dbforums.com','','',17);
INSERT INTO setting VALUES (305,11,'Requires Authorization','smtp_auth','','Does your SMTP server require you to authenticate?','yesno',18);
INSERT INTO setting VALUES (306,11,'SMTP Username','smtp_user','','Username if required for authentication','',19);
INSERT INTO setting VALUES (307,11,'SMTP Password','smtp_pass','','Password if required for authentication','',


I've deleted these fields from the 'setting' table and the upgrade step worked now. I'm missing some helptext in my admincp for my smtp settings now, but the settings are at least there.