[Forum] Error while upgrading to 4.1: Duplicate entry 'socnet' for key 1

[sarangan]

Please help me to fix this error.. I get this error while I'm trying to upgrade to 4.1.



Database error in vBulletin 4.1.0 Beta 1
Invalid SQL: INSERT INTO setting (varname, grouptitle, value, datatype,defaultvalue)VALUES('socnet', 'user', '', 'integer' ,'63');

MySQL Error : Duplicate entry 'socnet' for key 1
Error Number : 1062
Request Date : Thursday, December 2nd 2010 @ 10:49:55 PM
Error Date : Thursday, December 2nd 2010 @ 10:49:55 PM
Script : http://www.xxx.com/install/upgrade.php
Referrer : http://www.xxx.com/install/upgrade.php
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny4-log

[Steve Machol]

Which version are you upgrading from? Do you have any add-ons?

[sarangan]

I have fixed it by deleted that column 'socnet' and upgraded from beginning. Latest 4.1 PL 1 release also fix this problem.

[ramta]

as you deleted?

[ramta]

same error help

[rjordan]

I am upgrading a site from v4.0.3 to v4.1.0 PL1. I am getting this error as well. The only add-on on the site is for Add-On Chat. Multiple restores later, he is back to v4.0.3.

Note that this was the second error received. The first error was fixed by the following (again, after a restore): http://tracker.vbulletin.com/browse/VBIV-10448

[B]Upgrading to 4.1.0 Beta 1[/B]
Step 1 - Creating apiclient table
Step 2 - Altering session Table (1 of 3)
Step 3 - Altering session Table (2 of 3)
Step 4 - Altering session Table (3 of 3)
Step 5 - Creating apilog table
[B]Processing XML[/B]
Step 1 - Setting global profile customization on
 
Database error in vBulletin 4.1.0
 
Invalid SQL: INSERT INTO setting (varname, grouptitle, value, defaultvalue,
 datatype, optioncode, displayorder, advanced, volatile, validationcode,
 blacklist, product) VALUES ( 'socnet', 'user', '1', '63', 'bitfield',
 'bitfield:misc|socnet', 1, 0, 1, '', 0, 'vbulletin' ), ( 'reqbirthday',
 'user', '0', '0', 'boolean', 'yesno', 5, 0, 1, '', 0, 'vbulletin' ), (
 'ctMaxChars', 'user', '25', '25', 'integer', '', 10, 0, 1, '', 0,
 'vbulletin' ), ( 'ctCensorWords', 'user', 'admin forum moderator vbulletin
 leader', 'admin forum moderator vbulletin leader', 'free', 'textarea',
 20, 0, 1, '', 0, 'vbulletin' ), ( 'ctCensorMod', 'user', '1', '1',
 'boolean', 'yesno', 30, 0, 1, '', 0, 'vbulletin' ), ( 'minifriends_amount',
 'user', '6', '6', 'integer', '', 30, 0, 1, '', 0, 'vbulletin' ), (
 'friends_per_page', 'user', '10', '10', 'posint', '', 40, 0, 1, 'return
 (intval($raw_data) > 0);', 0, 'vbulletin' ), ( 'profilemaxvisitors',
 'user', '10', '10', 'integer', '', 50, 0, 1, 'return ($data >= 2);', 0,
 'vbulletin' ), ( 'profilelastpost', 'user', '0', '', 'boolean', 'yesno',
 60, 0, 1, '', 0, 'vbulletin' ), ( 'profileprivacy', 'user', '1', '1',
 'boolean', 'yesno', 90, 0, 1, '', 0, 'vbulletin' ), ( 'softlinebreakchars',
 'user', '90', '90', 'integer', '', 110, 0, 1, '', 0, 'vbulletin' ), (
 'ignoremods', 'user', '0', '', 'boolean', 'yesno', 300, 0, 1, '', 0,
 'vbulletin' ); 
 
[B]MySQL Error[/B] : Duplicate entry 'socnet' for key 1
[B]Error Number[/B] : 1062
[B]Request Date[/B] : Friday, December 3rd 2010 @ 12:08:04 AM
[B]Error Date[/B] : Friday, December 3rd 2010 @ 12:08:05 AM
[B]Script[/B] : http://www.susanminor.org/forums/install/upgrade.php
[B]Referrer[/B] : http://www.susanminor.org/forums/install/upgrade.php
[B]Classname[/B] : vB_Database
[B]MySQL Version[/B] : 5.0.91-community

[sarangan]

I'm not sure it's correct to delete that socnet column in database. Take a backup of your database and delete 'socnet' from 'settings' table. And try to upgrade.. It should work :-)

[Boofo]

Steve Machol, is this the proper way to fix it or will there be a fix coming for it? I am holding off from upgrading from 4.0.6 to 4.1 PL1 until I hear from you, sir.

[samiro]

i habe also error !!!!
i have a big board - please help !!!!

Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate, apiclientid, apiaccesstoken)
VALUES
('879f2bc58e0f5535af9f9913b373e955', 0, '84.228.254.224', 'cb554b842d1ca038d5e8c9d3436a28bd', 1291366329, '/forums/showthread.php/3690-׳ž׳׳₪׳”-׳‘׳¦׳§-׳¢׳œ׳™׳-׳¢׳-׳‘׳©׳¨', 0, 0, 0, 0, 0, 0, 2, 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)', 0, 0, 0, '');

MySQL Error : Unknown column 'apiclientid' in 'field list'
Error Number : 1054
Request Date : Friday, December 3rd 2010 @ 10:52:09 AM
Error Date : Friday, December 3rd 2010 @ 10:52:09 AM
Script : http://www.bwoman.co.il/forums/showt...1523;©׳¨
Referrer : http://www.google.co.il/search?source=ig&hl=iw&rlz=&q=%D7%91%D7%A9%D7%A8+%D7%98%D7%97%D7%95%D7%9F+%D7%91%D7%91%D7% A6%D7%A7+%D7%A2%D7%9C%D7%99%D7%9D&aq=4&oq=%D7%91%D7%A9%D7%A8+%D7%98%D7%97%D7%95%D7%9F
IP Address : 84.228.254.224
Username : אורח/ת
Classname : vB_Database
MySQL Version :

[Trevor Hannant]

That's a different error. If you look at that, it says error in 4.0.8 which means you haven't upgraded correctly.

Can you try re-downloading the ZIP file from the Members Area and re-upload all files (except install/install.php and includes/config.php.new) making sure you overwrite all files currently on your server. Then, re-run the upgrade script.

Does this resolve the problem?

[ramta]

I'm not sure it's correct to delete that socnet column in database. Take a backup of your database and delete 'socnet' from 'settings' table. And try to upgrade.. It should work :-)

I do not find that option

[Steve Machol]

Regarding the 'socnet' issue, there is a bug report and fix for this:

http://tracker.vbulletin.com/browse/VBIV-10448

[Lynne]

If you get the "Duplicate entry 'socnet' for key 1" error after you had originally gotten the "Unknown column 'default_value' in 'field list'" error and fixed it, then just go into your database and remove the row from the setting table where varname = socnet. Then run the upgrade script again.

If you look at this error "Unknown column 'apiclientid' in 'field list'" you'll see it was done on your main pages after you had uploaded the 4.1 files, but before you ran the upgrade script. Once you upgrade the database to 4.1, you will not longer be getting those errors.

[Boofo]

Is this happening to everyone on upgrade or just a select few? I was hoping to upgrade from 4.0.6 to 4.1.0 PL1 this weekend but I'm not sure I will if everyone is getting these kinds of errors.

[Steve Machol]

Is this happening to everyone on upgrade or just a select few? I was hoping to upgrade from 4.0.6 to 4.1.0 PL1 this weekend but I'm not sure I will if everyone is getting these kinds of errors.

It definitely does not happen on all upgrades. However it happens often enough that it made my 'canned responses' list.