Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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)

  • #2
    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

    Comment


    • #3
      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

      Comment


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

        http://www.vbulletin.com/docs/html/mysql_duplicatekey
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          thanks we will try

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X