Database error - Duplicate entry 'tagcloud' for key 1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tnedator
    Senior Member
    • Aug 2007
    • 329

    Database error - Duplicate entry 'tagcloud' for key 1

    My server had become unresponsive and had to be rebooted and now I am getting these errors when trying to load the forum index. Any idea how to fix?

    Database error in vBulletin 3.8.4:

    Invalid SQL:
    REPLACE INTO datastore
    (title, data, unserialize)
    VALUES
    ('tagcloud', 'a:3:{s:4:\"tags\";a:70:{i:2009;a:5:{s:5:\"tagid\";s:3:\"593\";s:7:\"tagtext\";s:4:\"2009\ ";s:11:\"searchcount\";s:1:\"6\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:4:\"2009\";}s:8: \"afc west\";a:5:{s:5:\"tagid\";s:3:\"149\";s:7:\"tagtext\";s:8:\"afc west\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"afc+wes t\";}s:11:\"april fools\";a:5:{s:5:\"tagid\";s:3:\"871\";s:7:\"tagtext\";s:11:\"april fools\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"april +fools\";}s:9:\"armstrong\";a:5:{s:5:\"tagid\";s:3:\"766\";s:7:\"tagtext\";s:9:\"armstrong \";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"armstrong\" ;}s:6:\"briefs\";a:5:{s:5:\"tagid\";s:3:\"748\";s:7:\"tagtext\";s:6:\"briefs\";s:11:\"sear chcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"briefs\";}s:7:\"broncos\" ;a:5:{s:5:\"tagid\";s:1:\"8\";s:7:\"tagtext\";s:7:\"broncos\";s:11:\"searchcount\";s:1:\"7 \";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"broncos\";}s:3:\"cba\";a:5:{s:5:\"tagid\"; s:3:\"518\";s:7:\"tagtext\";s:3:\"cba\";s:11:\"searchcount\";s:1:\"3\";s:5:\"level\";d:1;s :11:\"tagtext_url\";s:3:\"cba\";}s:12:\"champ bailey\";a:5:{s:5:\"tagid\";s:3:\"108\";s:7:\"tagtext\";s:12:\"champ bailey\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:12:\"cham p+bailey\";}s:13:\"championships\";a:5:{s:5:\"tagid\";s:3:\"634\";s:7:\"tagtext\";s:13:\"c hampionships\";s:11:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13: \"championships\";}s:5:\"colts\";a:5:{s:5:\"tagid\";s:3:\"772\";s:7:\"tagtext\";s:5:\"colt s\";s:11:\"searchcount\";s:1:\"3\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"colts\";}s :10:\"concussion\";a:5:{s:5:\"tagid\";s:3:\"759\";s:7:\"tagtext\";s:10:\"concussion\";s:11 :\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"concussion\";}s:9 :\"contracts\";a:5:{s:5:\"tagid\";s:3:\"527\";s:7:\"tagtext\";s:9:\"contracts\";s:11:\"sea rchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:9:\"contracts\";}s:6:\"cutle r\";a:5:{s:5:\"tagid\";s:3:\"636\";s:7:\"tagtext\";s:6:\"cutler\";s:11:\"searchcount\";s:1 :\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"cutler\";}s:7:\"defense\";a:5:{s:5:\"t agid\";s:2:\"62\";s:7:\"tagtext\";s:7:\"defense\";s:11:\"searchcount\";s:1:\"4\";s:5:\"lev el\";d:1;s:11:\"tagtext_url\";s:7:\"defense\";}s:16:\"dogfish\'s domain\";a:5:{s:5:\"tagid\";s:3:\"718\";s:7:\"tagtext\";s:16:\"dogfish\'s domain\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:18:\"dogf ish%27s+domain\";}s:4:\"doom\";a:5:{s:5:\"tagid\";s:3:\"107\";s:7:\"tagtext\";s:4:\"doom\" ;s:11:\"searchcount\";s:1:\"4\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:4:\"doom\";}s:5:\ "draft\";a:5:{s:5:\"tagid\";s:3:\"479\";s:7:\"tagtext\";s:5:\"draft\";s:11:\"searchcount\" ;s:1:\"8\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:5:\"draft\";}s:5:\"eddie\";a:5:{s:5:\" tagid\";s:3:\"614\";s:7:\"tagtext\";s:5:\"eddie\";s:11:\"searchcount\";s:1:\"2\";s:5:\"lev el\";d:1;s:11:\"tagtext_url\";s:5:\"eddie\";}s:5:\"elway\";a:5:{s:5:\"tagid\";s:3:\"250\"; s:7:\"tagtext\";s:5:\"elway\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagt ext_url\";s:5:\"elway\";}s:5:\"farve\";a:5:{s:5:\"tagid\";s:3:\"536\";s:7:\"tagtext\";s:5: \"farve\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"farv e\";}s:10:\"fire_weiss\";a:5:{s:5:\"tagid\";s:3:\"729\";s:7:\"tagtext\";s:10:\"fire_weiss\ ";s:11:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"fire_weiss\ ";}s:11:\"free agents\";a:5:{s:5:\"tagid\";s:3:\"647\";s:7:\"tagtext\";s:11:\"free agents\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"free +agents\";}s:8:\"game day\";a:5:{s:5:\"tagid\";s:3:\"386\";s:7:\"tagtext\";s:8:\"game day\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"game+day \";}s:17:\"go back to mania!\";a:5:{s:5:\"tagid\";s:3:\"488\";s:7:\"tagtext\";s:17:\"go back to mania!\";s:11:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:19:\"go+b ack+to+mania%21\";}s:8:\"grossman\";a:5:{s:5:\"tagid\";s:3:\"544\";s:7:\"tagtext\";s:8:\"g rossman\";s:11:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"gros sman\";}s:6:\"hillis\";a:5:{s:5:\"tagid\";s:3:\"520\";s:7:\"tagtext\";s:6:\"hillis\";s:11: \"searchcount\";s:1:\"3\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"hillis\";}s:5:\"hum or\";a:5:{s:5:\"tagid\";s:3:\"650\";s:7:\"tagtext\";s:5:\"humor\";s:11:\"searchcount\";s:1 :\"3\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"humor\";}s:10:\"jay cutler\";a:5:{s:5:\"tagid\";s:1:\"9\";s:7:\"tagtext\";s:10:\"jay cutler\";s:11:\"searchcount\";s:1:\"3\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"jay+ cutler\";}s:4:\"josh\";a:5:{s:5:\"tagid\";s:3:\"521\";s:7:\"tagtext\";s:4:\"josh\";s:11:\" searchcount\";s:2:\"16\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"josh\";}s:4:\"klis\" ;a:5:{s:5:\"tagid\";s:3:\"686\";s:7:\"tagtext\";s:4:\"klis\";s:11:\"searchcount\";s:2:\"19 \";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:4:\"klis\";}s:7:\"krieger\";a:5:{s:5:\"tagid\" ;s:3:\"712\";s:7:\"tagtext\";s:7:\"krieger\";s:11:\"searchcount\";s:1:\"9\";s:5:\"level\"; d:2;s:11:\"tagtext_url\";s:7:\"krieger\";}s:6:\"larsen\";a:5:{s:5:\"tagid\";s:3:\"619\";s: 7:\"tagtext\";s:6:\"larsen\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagte xt_url\";s:6:\"larsen\";}s:7:\"legwold\";a:5:{s:5:\"tagid\";s:3:\"684\";s:7:\"tagtext\";s: 7:\"legwold\";s:11:\"searchcount\";s:2:\"38\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:7:\ "legwold\";}s:16:\"lindsay h. jones\";a:5:{s:5:\"tagid\";s:3:\"685\";s:7:\"tagtext\";s:16:\"lindsay h. jones\";s:11:\"searchcount\";s:2:\"26\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:16:\"lind say+h.+jones\";}s:4:\"mail\";a:5:{s:5:\"tagid\";s:3:\"852\";s:7:\"tagtext\";s:4:\"mail\";s :11:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:4:\"mail\";}s:7:\"m ailbag\";a:5:{s:5:\"tagid\";s:3:\"688\";s:7:\"tagtext\";s:7:\"mailbag\";s:11:\"searchcount \";s:2:\"10\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:7:\"mailbag\";}s:8:\"mail bag\";a:5:{s:5:\"tagid\";s:3:\"596\";s:7:\"tagtext\";s:8:\"mail bag\";s:11:\"searchcount\";s:1:\"7\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:8:\"mail+bag \";}s:7:\"manning\";a:5:{s:5:\"tagid\";s:3:\"771\";s:7:\"tagtext\";s:7:\"manning\";s:11:\" searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"manning\";}s:8:\"mars hall\";a:5:{s:5:\"tagid\";s:3:\"516\";s:7:\"tagtext\";s:8:\"marshall\";s:11:\"searchcount\ ";s:2:\"29\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:8:\"marshall\";}s:6:\"moreno\";a:5:{ s:5:\"tagid\";s:3:\"525\";s:7:\"tagtext\";s:6:\"moreno\";s:11:\"searchcount\";s:1:\"7\";s: 5:\"level\";d:2;s:11:\"tagtext_url\";s:6:\"moreno\";}s:6:\"no cap\";a:5:{s:5:\"tagid\";s:3:\"786\";s:7:\"tagtext\";s:6:\"no cap\";s:11:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"no+cap\" ;}s:5:\"nolan\";a:5:{s:5:\"tagid\";s:3:\"610\";s:7:\"tagtext\";s:5:\"nolan\";s:11:\"search count\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"nolan\";}s:5:\"notes\";a:5: {s:5:\"tagid\";s:3:\"599\";s:7:\"tagtext\";s:5:\"notes\";s:11:\"searchcount\";s:1:\"2\";s: 5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"notes\";}s:14:\"offensive line\";a:5:{s:5:\"tagid\";s:2:\"16\";s:7:\"tagtext\";s:14:\"offensive line\";s:11:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:14:\"offens ive+line\";}s:5:\"oline\";a:5:{s:5:\"tagid\";s:3:\"784\";s:7:\"tagtext\";s:5:\"oline\";s:1 1:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"oline\";}s:5:\"or ton\";a:5:{s:5:\"tagid\";s:3:\"484\";s:7:\"tagtext\";s:5:\"orton\";s:11:\"searchcount\";s: 2:\"20\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:5:\"orton\";}s:7:\"outlook\";a:5:{s:5:\" tagid\";s:3:\"606\";s:7:\"tagtext\";s:7:\"outlook\";s:11:\"searchcount\";s:1:\"2\";s:5:\"l evel\";d:1;s:11:\"tagtext_url\";s:7:\"outlook\";}s:5:\"paige\";a:5:{s:5:\"tagid\";s:3:\"65 7\";s:7:\"tagtext\";s:5:\"paige\";s:11:\"searchcount\";s:1:\"7\";s:5:\"level\";d:2;s:11:\" tagtext_url\";s:5:\"paige\";}s:3:\"pat\";a:5:{s:5:\"tagid\";s:3:\"552\";s:7:\"tagtext\";s: 3:\"pat\";s:11:\"searchcount\";s:1:\"3\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:3:\"pat\ ";}s:10:\"pat bowlen\";a:5:{s:5:\"tagid\";s:3:\"110\";s:7:\"tagtext\";s:10:\"pat bowlen\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:10:\"pat+ bowlen\";}s:13:\"patriots suck\";a:5:{s:5:\"tagid\";s:3:\"698\";s:7:\"tagtext\";s:13:\"patriots suck\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"patrio ts+suck\";}s:6:\"player\";a:5:{s:5:\"tagid\";s:3:\"605\";s:7:\"tagtext\";s:6:\"player\";s: 11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"player\";}s:8:\" position\";a:5:{s:5:\"tagid\";s:3:\"595\";s:7:\"tagtext\";s:8:\"position\";s:11:\"searchco unt\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"position\";}s:5:\"power\";a:5 :{s:5:\"tagid\";s:3:\"487\";s:7:\"tagtext\";s:5:\"power\";s:11:\"searchcount\";s:1:\"3\";s :5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"power\";}s:6:\"prater\";a:5:{s:5:\"tagid\";s:3 :\"519\";s:7:\"tagtext\";s:6:\"prater\";s:11:\"searchcount\";s:1:\"4\";s:5:\"level\";d:1;s :11:\"tagtext_url\";s:6:\"prater\";}s:8:\"previews\";a:5:{s:5:\"tagid\";s:3:\"594\";s:7:\" tagtext\";s:8:\"previews\";s:11:\"searchcount\";s:1:\"5\";s:5:\"level\";d:1;s:11:\"tagtext _url\";s:8:\"previews\";}s:7:\"q&a\";a:5:{s:5:\"tagid\";s:3:\"689\";s:7:\"tagtext\";s: 7:\"q&a\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\" q%26a\";}s:7:\"ranking\";a:5:{s:5:\"tagid\";s:3:\"572\";s:7:\"tagtext\";s:7:\"ranking\";s: 11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:7:\"ranking\";}s:8:\ "rankings\";a:5:{s:5:\"tagid\";s:3:\"602\";s:7:\"tagtext\";s:8:\"rankings\";s:11:\"searchc ount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"rankings\";}s:6:\"replay\";a :5:{s:5:\"tagid\";s:3:\"675\";s:7:\"tagtext\";s:6:\"replay\";s:11:\"searchcount\";s:1:\"1\ ";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:6:\"replay\";}s:7:\"rookies\";a:5:{s:5:\"tagid\ ";s:3:\"598\";s:7:\"tagtext\";s:7:\"rookies\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\" ;d:1;s:11:\"tagtext_url\";s:7:\"rookies\";}s:6:\"salary\";a:5:{s:5:\"tagid\";s:3:\"316\";s :7:\"tagtext\";s:6:\"salary\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagt ext_url\";s:6:\"salary\";}s:5:\"simms\";a:5:{s:5:\"tagid\";s:3:\"522\";s:7:\"tagtext\";s:5 :\"simms\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"sim ms\";}s:8:\"sleating\";a:5:{s:5:\"tagid\";s:3:\"597\";s:7:\"tagtext\";s:8:\"sleating\";s:1 1:\"searchcount\";s:1:\"1\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"sleating\";}s:5:\ "trade\";a:5:{s:5:\"tagid\";s:3:\"812\";s:7:\"tagtext\";s:5:\"trade\";s:11:\"searchcount\" ;s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"trade\";}s:13:\"training camp\";a:5:{s:5:\"tagid\";s:3:\"229\";s:7:\"tagtext\";s:13:\"training camp\";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:13:\"traini ng+camp\";}s:11:\"transcripts\";a:5:{s:5:\"tagid\";s:3:\"628\";s:7:\"tagtext\";s:11:\"tran scripts\";s:11:\"searchcount\";s:1:\"6\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:11:\"tra nscripts\";}s:8:\"williams\";a:5:{s:5:\"tagid\";s:3:\"831\";s:7:\"tagtext\";s:8:\"williams \";s:11:\"searchcount\";s:1:\"2\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:8:\"williams\"; }s:5:\"woody\";a:5:{s:5:\"tagid\";s:3:\"608\";s:7:\"tagtext\";s:5:\"woody\";s:11:\"searchc ount\";s:1:\"4\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:5:\"woody\";}s:11:\"woody paige\";a:5:{s:5:\"tagid\";s:3:\"736\";s:7:\"tagtext\";s:11:\"woody paige\";s:11:\"searchcount\";s:1:\"5\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:11:\"woody +paige\";}}s:5:\"count\";i:70;s:8:\"dateline\";i:1271012830;}', 1);

    MySQL Error : Duplicate entry 'tagcloud' for key 1
    Error Number : 1062
    Request Date : Sunday, April 11th 2010 @ 02:07:10 PM
    Error Date : Sunday, April 11th 2010 @ 02:07:10 PM
    Classname : vB_Database_MySQLi
    MySQL Version : 5.0.90-community-log
    BroncosForums.com - Broncos Fan Forum
    Total Broncos - Denver Broncos Blog and News
  • thanhdat
    Member
    • Feb 2005
    • 79
    • 3.8.x

    #2
    I have the same problem
    Vui Ve Club - www.vuiveclub.net

    Comment

    • tnedator
      Senior Member
      • Aug 2007
      • 329

      #3
      Sorry, I posted this in the VB 4.0 forum by accident. Should have been in the vB 3.8 forum.
      BroncosForums.com - Broncos Fan Forum
      Total Broncos - Denver Broncos Blog and News

      Comment

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