ERROR 1062 (23000) at line 2175: Duplicate entry '4368-15973' for key 1

[Q8vbhacks]

hi all

we have some problem when we want restore forum

mysql -uxxxx -pxxx databasename < forum.sql

this nesaage come

ERROR 1062 (23000) at line 2175: Duplicate entry '4368-15973' for key 1

hope somebody help

mysql version mysql (5.0.24-standard)

[Q8vbhacks]

also other account
mysql -uxxxx -pxxx databasename < forum.sql

ERROR 1074 (42000) at line 962: Column length too big for column 'banner' (max = 255); use BLOB or TEXT instead

[Q8vbhacks]

after when click getnew post

Database error in vBulletin 3.5.4:

Invalid SQL:

REPLACE INTO search (userid, showposts, ipaddress, personal, forumchoice, sortby, sortorder, searchtime, orderedids, dateline, displayterms, searchhash)
VALUES (183, 0, '168.187.211.201', 1, '', 'lastpost', 'DESC', 0.036269903183, '44102,43908,44082,43773,42499,28398,44067,9811,44092,44080,44023,44101,41437,41570,43408, 42765,43578,44044,44063,44021,43523,36797,44048,23536,37478,43904,36488,43944,30657,44078, 43968,44089,42261,44015,43715,43177,43929,42444,43903,44000,26818,43943,29665,17907,43997, 44100,30464,44093,12115,38893,44099,44064,43464,44054,9920,11473,43654,44014,44042,44098,4 3496,39628,43972,44032,44077,44073,38051,43771,43564,43828,42142,41922,43954,43397,43931,4 4066,44051,8198,43880,43982,40301,43598,44094,5359,41358,43977,41712,44005,43899,43434,427 47,43520,44053,42300,20125,44057,36129,40810,42746,37024,42131,42673,36559,44040,43978,275 89,24393,40728,44027,36561,4201,44090,42238,24964,44097,43935,14962,36174,20826,43449,4406 9,44020,44058,43957,44045,34630,18723,44096,39981,9233,43975,12203,41135,40827,20518,43521 ,44095,44083,18475,43452,9532,31646,43976,44088,43901,39629,43465,43447,9990,1827,42505,41 978,43614,42834,4292,5111,43758,12091,43450,43078,4398,44059,22016,43253,4014,40990,42878, 43988,43656,44012,44086,41344,3654,43415,44091,43676,44061,14,2147,42587,42993,41309,43980 ,42778,44087,38877,21910,43468,39541,43983,43970,30303,33820,43335,30216,43952,44052,43735 ,44074,3269,43915,44072,43933,43955,43900,44084,42977,44019,44055,44038,43932,44056,21258, 44003,44022,23585,44046,43324,39807,44085,34434,44035,36631,44075,43412,43911,36998,43905, 43998,43333,43753,43909,43827,37836,42032,44060,43294,44031,39448,43991,44081,44068,44049, 41329,43745,44065,42959,44006,938,43818,10983,37673,8740,43748,43147,35718,1840,38499,4396 0,43979,41710,44076,44071,40257,39850,43587,43736,24350,31412,43017,29109,43128,44028,4278 7,43551,43509,44037,43765,43958,43924,36045,42939,43264,29015,44047,44070,41102,44017,4375 2,15530,43470,14286,44024,1271,4804,28407,43690,27027,44062,43912,44025,44036,42290,44016, 35065,43432,21202,9071,42233,28894,43459,42794,44013,43917,40961,40775,43841,43949,42621,4 3926,41722,9139,44018,38544,41295,9988,41443,578,41761,41129,38606,40527,44033,23266,43965 ,39393,43144,43886,43877,44026,43994,43430,43411,43403,23553,43740,12180,43667,38047,43678 ,44030,44050,28648,43340,2406,42761,42902,41533,39038,44001,43942,44039,32363,43536,44043, 43847,11717,43425,36001,32579,38540,43685,43791,44041,44011,43272,43964,43176,44034,43453, 43562,44029,28504,43940,43798,38333,29348,44008,36580,43669,16519,12389,14647,44004,43906, 19524,43973,40769,43541,43331,41256,43488,39087,15037,42852,33448,37189,39022,6082,43276,3 0646,3647,1495,20701,31010,31502,34546,1257,26949,42395,36371,24526,28341,14663,15036,1010 1,43918,43835,43875,43632,42113,43717,27071,43590,39365,17648,43725,43218,43288,41168,4176 9,16604,43996,43751,43279,43829,44002', 1160771773, 'a:7:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:0:{ }s:6:\"forums\";N;s:7:\"options\";a:3:{s:11:\"starteronly\";b:0;s:11:\"childforums\";b:1;s :6:\"action\";s:6:\"getnew\";}s:6:\"getnew\";i:1;}', 'c72d10496a2d4b3c7a43c999cb9c04d9');

MySQL Error : Duplicate entry '272579' for key 1
Error Number : 1062
Date : Friday, October 13th 2006 @ 04:36:14 PM

[Steve Machol]

See this page for a solution to the 'duplicate key' error:

http://www.vbulletin.com/docs/html/mysql_duplicatekey

[Q8vbhacks]

thanks we will try