Forum Database error - Duplicate entry 'tagcloud' for key 1

محروم.كوم · #1 04-11-2010, 11:40 PM

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{s\"tags\";a{i:2009;a{s\"tagid\" ;s\"593\";s:7:\"tagtext\";s\"2009\";s\"s earchcount\";s\"6\";s\"level\";d:2;s\"ta gtext_url\";s\"2009\";}s\"afc west\";a{s\"tagid\";s\"149\";s:7:\"tagtex t\";s\"afc west\";s\"searchcount\";s\"2\";s\"level\ ";d:1;s\"tagtext_url\";s\"afc+west\";}s \"april fools\";a{s\"tagid\";s\"871\";s:7:\"tagte xt\";s\"april fools\";s\"searchcount\";s\"2\";s\"level \";d:1;s\"tagtext_url\";s\"april+fools\ ";} s\"armstrong\";a{s\"tagid\";s\"766\";s :7:\"tagtext\";s\"armstrong\";s\"searchcoun t\";s\"2\";s\"level\";d:1;s\"tagtext_u rl \";s\"armstrong\";}s\"briefs\";a{s\ "ta gid\";s\"748\";s:7:\"tagtext\";s\"briefs\";s \"searchcount\";s\"2\";s\"level\";d:1;s: 11:\"tagtext_url\";s\"briefs\";}s:7:\"broncos\" ;a{s\"tagid\";s\"8\";s:7:\"tagtext\";s:7: \"broncos\";s\"searchcount\";s\"7\";s \"l evel\";d:2;s\"tagtext_url\";s:7:\"broncos\";}s \"cba\";a{s\"tagid\";s\"518\";s:7:\"ta gtext\";s\"cba\";s\"searchcount\";s\"3\" ;s\"level\";d:1;s\"tagtext_url\";s\"cba\ ";}s\"champ bailey\";a{s\"tagid\";s\"108\";s:7:\"tagt ext\";s\"champ bailey\";s\"searchcount\";s\"2\";s\"leve l\";d:1;s\"tagtext_url\";s\"champ+bailey \" ;}s\"championships\";a{s\"tagid\";s\" 634\";s:7:\"tagtext\";s\"championships\";s \"searchcount\";s\"1\";s\"level\";d:1;s:1 1:\ "tagtext_url\";s\"championships\";}s\"c olts \";a{s\"tagid\";s\"772\";s:7:\"tagtext \"; s\"colts\";s\"searchcount\";s\"3\";s\ "level\";d:1;s\"tagtext_url\";s\"colts\ ";}s \"concussion\";a{s\"tagid\";s\"759\"; s:7:\"tagtext\";s\"concussion\";s\"searchc ount\";s\"2\";s\"level\";d:1;s\"tagtext_ url\";s\"concussion\";}s\"contracts\";a{ s\"tagid\";s\"527\";s:7:\"tagtext\";s\"co ntracts\";s\"searchcount\";s\"2\";s\"lev el\";d:1;s\"tagtext_url\";s\"contracts\";} s \"cutler\";a{s\"tagid\";s\"636\";s:7:\ "tagtext\";s\"cutler\";s\"searchcount\" ;s:1 :\"2\";s\"level\";d:1;s\"tagtext_url\";s: 6: \"cutler\";}s:7:\"defense\";a{s\"tagid\"; s:2 :\"62\";s:7:\"tagtext\";s:7:\"defense\";s\"s ea rchcount\";s\"4\";s\"level\";d:1;s\"tagt ext_url\";s:7:\"defense\";}s:16:\"dogfish\'s domain\";a{s\"tagid\";s\"718\";s:7:\"tagt ext\";s:16:\"dogfish\'s domain\";s\"searchcount\";s\"2\";s\"leve l\";d:1;s\"tagtext_url\";s:18:\"dogfish%27s+ do main\";}s\"doom\";a{s\"tagid\";s\"107\ ";s:7:\"tagtext\";s\"doom\";s\"searchco unt\ ";s\"4\";s\"level\";d:1;s\"tagtext_u rl\" ;s\"doom\";}s\"draft\";a{s\"tagid\";s: 3:\"479\";s:7:\"tagtext\";s\"draft\";s\"se a rchcount\";s\"8\";s\"level\";d:2;s\"tagt ext_url\";s\"draft\";}s\"eddie\";a{s\" tagid\";s\"614\";s:7:\"tagtext\";s\"eddie\"; s\"searchcount\";s\"2\";s\"level\";d:1;s \"tagtext_url\";s\"eddie\";}s\"elway\";a {s\"tagid\";s\"250\";s:7:\"tagtext\";s \"elway\";s\"searchcount\";s\"2\";s\" lev el\";d:1;s\"tagtext_url\";s\"elway\";}s \ "farve\";a{s\"tagid\";s\"536\";s:7:\" tagt ext\";s\"farve\";s\"searchcount\";s\"2\" ;s\"level\";d:1;s\"tagtext_url\";s\"farv e\";}s\"fire_weiss\";a{s\"tagid\";s \" 729\";s:7:\"tagtext\";s\"fire_weiss\";s\"s earchcount\";s\"1\";s\"level\";d:1;s\"ta gtext_url\";s\"fire_weiss\";}s\"free agents\";a{s\"tagid\";s\"647\";s:7:\"tagt ext\";s\"free agents\";s\"searchcount\";s\"2\";s\"leve l\";d:1;s\"tagtext_url\";s\"free+agents\ "; }s\"game day\";a{s\"tagid\";s\"386\";s:7:\"tagtext \";s\"game day\";s\"searchcount\";s\"2\";s\"level\" ;d:1;s\"tagtext_url\";s\"game+day\";}s\ "go back to mania!\";a{s\"tagid\";s\"488\";s:7:\"tagt ext\";s\"go back to mania!\";s\"searchcount\";s\"1\";s\"leve l\";d:1;s\"tagtext_url\";s:19:\"go+back+to+m an ia%21\";}s\"grossman\";a{s\"tagid\";s\ "544\";s:7:\"tagtext\";s\"grossman\";s\ "sea rchcount\";s\"1\";s\"level\";d:1;s\"tagt ext_url\";s\"grossman\";}s\"hillis\";a{s: 5:\"tagid\";s\"520\";s:7:\"tagtext\";s\"hil l is\";s\"searchcount\";s\"3\";s\"level\" ; d:1;s\"tagtext_url\";s\"hillis\";}s\"hum or\";a{s\"tagid\";s\"650\";s:7:\"tagtext \ ";s\"humor\";s\"searchcount\";s\"3\" ;s:5 :\"level\";d:1;s\"tagtext_url\";s\"humor\ "; }s\"jay cutler\";a{s\"tagid\";s\"9\";s:7:\"tagtex t\";s\"jay cutler\";s\"searchcount\";s\"3\";s\"leve l\";d:1;s\"tagtext_url\";s\"jay+cutler\" ;} s\"josh\";a{s\"tagid\";s\"521\";s:7:\" tagtext\";s\"josh\";s\"searchcount\";s\" 16\";s\"level\";d:3;s\"tagtext_url\";s\ " josh\";}s\"klis\";a{s\"tagid\";s\"686\ ";s:7:\"tagtext\";s\"klis\";s\"searchco unt\ ";s\"19\";s\"level\";d:3;s\"tagtext_ url\ ";s\"klis\";}s:7:\"krieger\";a{s\"tag id\" ;s\"712\";s:7:\"tagtext\";s:7:\"krieger\";s \"searchcount\";s\"9\";s\"level\";d:2;s:1 1:\ "tagtext_url\";s:7:\"krieger\";}s\"larsen\" ;a:5 :{s\"tagid\";s\"619\";s:7:\"tagtext\";s\" larsen\";s\"searchcount\";s\"2\";s\"leve l\";d:1;s\"tagtext_url\";s\"larsen\";}s:7 :\ "legwold\";a{s\"tagid\";s\"684\";s:7: \"ta gtext\";s:7:\"legwold\";s\"searchcount\";s\ "38\";s\"level\";d:5;s\"tagtext_url\";s :7:\ "legwold\";}s:16:\"lindsay h. jones\";a{s\"tagid\";s\"685\";s:7:\"tagte xt\";s:16:\"lindsay h. jones\";s\"searchcount\";s\"26\";s\"leve l\";d:4;s\"tagtext_url\";s:16:\"lindsay+h.+j on es\";}s\"mail\";a{s\"tagid\";s\"852\" ; s:7:\"tagtext\";s\"mail\";s\"searchcount\"; s\"1\";s\"level\";d:1;s\"tagtext_url\";s \"mail\";}s:7:\"mailbag\";a{s\"tagid\";s: 3:\"688\";s:7:\"tagtext\";s:7:\"mailbag\";s\" s earchcount\";s\"10\";s\"level\";d:2;s\"t agtext_url\";s:7:\"mailbag\";}s\"mail bag\";a{s\"tagid\";s\"596\";s:7:\"tagtext \";s\"mail bag\";s\"searchcount\";s\"7\";s\"level\" ;d:2;s\"tagtext_url\";s\"mail+bag\";}s:7:\" manning\";a{s\"tagid\";s\"771\";s:7:\"tag text\";s:7:\"manning\";s\"searchcount\";s\" 2\";s\"level\";d:1;s\"tagtext_url\";s:7:\ "m anning\";}s\"marshall\";a{s\"tagid\";s \"516\";s:7:\"tagtext\";s\"marshall\";s\ "se archcount\";s\"29\";s\"level\";d:4;s\"ta gtext_url\";s\"marshall\";}s\"moreno\";a{ s\"tagid\";s\"525\";s:7:\"tagtext\";s\"mo reno\";s\"searchcount\";s\"7\";s\"level\ ";d:2;s\"tagtext_url\";s\"moreno\";}s:6 :\"n o cap\";a{s\"tagid\";s\"786\";s:7:\"tagtext \";s\"no cap\";s\"searchcount\";s\"1\";s\"level\" ;d:1;s\"tagtext_url\";s\"no+cap\";}s\"no lan\";a{s\"tagid\";s\"610\";s:7:\"tagtext \";s\"nolan\";s\"searchcount\";s\"2\" ;s: 5:\"level\";d:1;s\"tagtext_url\";s\"nolan\ " ;}s\"notes\";a{s\"tagid\";s\"599\";s:7 :\"tagtext\";s\"notes\";s\"searchcount\"; s: 1:\"2\";s\"level\";d:1;s\"tagtext_url\";s: 5 :\"notes\";}s\"offensive line\";a{s\"tagid\";s\"16\";s:7:\"tagtext \";s\"offensive line\";s\"searchcount\";s\"1\";s\"level\ ";d:1;s\"tagtext_url\";s\"offensive+li ne\" ;}s\"oline\";a{s\"tagid\";s\"784\";s:7 :\"tagtext\";s\"oline\";s\"searchcount\"; s: 1:\"2\";s\"level\";d:1;s\"tagtext_url\";s: 5 :\"oline\";}s\"orton\";a{s\"tagid\";s:3 :\ "484\";s:7:\"tagtext\";s\"orton\";s\"se arch count\";s\"20\";s\"level\";d:3;s\"tagtex t_url\";s\"orton\";}s:7:\"outlook\";a{s\" tagid\";s\"606\";s:7:\"tagtext\";s:7:\"outlook\ ";s\"searchcount\";s\"2\";s\"level\" ;d:1 ;s\"tagtext_url\";s:7:\"outlook\";}s\"paige \";a{s\"tagid\";s\"657\";s:7:\"tagtext \"; s\"paige\";s\"searchcount\";s\"7\";s\ "level\";d:2;s\"tagtext_url\";s\"paige\ ";}s \"pat\";a{s\"tagid\";s\"552\";s:7:\"ta gtext\";s\"pat\";s\"searchcount\";s\"3\" ;s\"level\";d:1;s\"tagtext_url\";s\"pat\ ";}s\"pat bowlen\";a{s\"tagid\";s\"110\";s:7:\"tagt ext\";s\"pat bowlen\";s\"searchcount\";s\"2\";s\"leve l\";d:1;s\"tagtext_url\";s\"pat+bowlen\" ;} s\"patriots suck\";a{s\"tagid\";s\"698\";s:7:\"tagtex t\";s\"patriots suck\";s\"searchcount\";s\"2\";s\"level\ ";d:1;s\"tagtext_url\";s\"patriots+suc k\"; }s\"player\";a{s\"tagid\";s\"605\";s:7 :\"tagtext\";s\"player\";s\"searchcount\" ;s \"2\";s\"level\";d:1;s\"tagtext_url\";s: 6:\"player\";}s\"position\";a{s\"tagid\" ; s\"595\";s:7:\"tagtext\";s\"position\";s \"searchcount\";s\"2\";s\"level\";d:1;s:1 1:\ "tagtext_url\";s\"position\";}s\"power\" ;a:5 :{s\"tagid\";s\"487\";s:7:\"tagtext\";s\" power\";s\"searchcount\";s\"3\";s\"level \";d:1;s\"tagtext_url\";s\"power\";}s \"p rater\";a{s\"tagid\";s\"519\";s:7:\"tagte xt\";s\"prater\";s\"searchcount\";s\"4\ " ;s\"level\";d:1;s\"tagtext_url\";s\"prat er\";}s\"previews\";a{s\"tagid\";s\"5 9 4\";s:7:\"tagtext\";s\"previews\";s\"sear ch count\";s\"5\";s\"level\";d:1;s\"tagtext _url\";s\"previews\";}s:7:\"q&a\";a{s \"tagid\";s\"689\";s:7:\"tagtext\";s:7:\"q& a\";s\"searchcount\";s\"2\";s\"level\" ;d :1;s\"tagtext_url\";s\"q%26a\";}s:7:\"ranki ng\";a{s\"tagid\";s\"572\";s:7:\"tagtext \ ";s:7:\"ranking\";s\"searchcount\";s\"2 \";s \"level\";d:1;s\"tagtext_url\";s:7:\"rankin g\";}s\"rankings\";a{s\"tagid\";s\"6 02 \";s:7:\"tagtext\";s\"rankings\";s\"sear chc ount\";s\"2\";s\"level\";d:1;s\"tagtext_ url\";s\"rankings\";}s\"replay\";a{s\" tagid\";s\"675\";s:7:\"tagtext\";s\"replay\" ;s\"searchcount\";s\"1\";s\"level\";d:1; s\"tagtext_url\";s\"replay\";}s:7:\"rookies \";a{s\"tagid\";s\"598\";s:7:\"tagtext \"; s:7:\"rookies\";s\"searchcount\";s\"2\";s:5 :\"level\";d:1;s\"tagtext_url\";s:7:\"rookie s\ ";}s\"salary\";a{s\"tagid\";s\"316 \";s :7:\"tagtext\";s\"salary\";s\"searchcount\" ;s\"2\";s\"level\";d:1;s\"tagtext_url\"; s\"salary\";}s\"simms\";a{s\"tagid\";s \"522\";s:7:\"tagtext\";s\"simms\";s\"se archcount\";s\"2\";s\"level\";d:1;s\"tag text_url\";s\"simms\";}s\"sleating\";a{s: 5:\"tagid\";s\"597\";s:7:\"tagtext\";s\"sle a ting\";s\"searchcount\";s\"1\";s\"level\ ";d:1;s\"tagtext_url\";s\"sleating\";}s \ "trade\";a{s\"tagid\";s\"812\";s:7:\" tagt ext\";s\"trade\";s\"searchcount\";s\"2\" ;s\"level\";d:1;s\"tagtext_url\";s\"trad e\";}s\"training camp\";a{s\"tagid\";s\"229\";s:7:\"tagtex t\";s\"training camp\";s\"searchcount\";s\"2\";s\"level\ ";d:1;s\"tagtext_url\";s\"training+cam p\"; }s\"transcripts\";a{s\"tagid\";s\"628 \";s:7:\"tagtext\";s\"transcripts\";s\" sea rchcount\";s\"6\";s\"level\";d:2;s\"tagt ext_url\";s\"transcripts\";}s\"williams\";a {s\"tagid\";s\"831\";s:7:\"tagtext\";s \"williams\";s\"searchcount\";s\"2\";s:5 :\" level\";d:1;s\"tagtext_url\";s\"williams\"; }s\"woody\";a{s\"tagid\";s\"608\";s:7: \"tagtext\";s\"woody\";s\"searchcount\"; s:1 :\"4\";s\"level\";d:1;s\"tagtext_url\";s: 5: \"woody\";}s\"woody paige\";a{s\"tagid\";s\"736\";s:7:\"tagte xt\";s\"woody paige\";s\"searchcount\";s\"5\";s\"level \";d:1;s\"tagtext_url\";s\"woody+paige\ ";} }s\"count\";i:70;s\"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 __DEFINE_LIKE_SHARE__