{"comment":{"created_at":"2011-10-24T07:21:33Z","body":"Het is nu denk ik ook niet echt spannend om te achterhalen waar dit door is gekomen. Belangrijker is dat het gewoon simpel opgelost kan worden (ook voor anderen die op GoT hetzelfde hadden op een of andere manier. :)","updated_at":"2011-10-24T07:21:33Z","url":"https://api.github.com/repos/spotweb/spotweb/issues/comments/2500449","id":2500449,"user":{"gravatar_id":"14e320a810a72d10ae9203555f666f0f","avatar_url":"https://secure.gravatar.com/avatar/14e320a810a72d10ae9203555f666f0f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/nightspirit81","id":641394,"login":"nightspirit81"}},"action":"created","issue":{"number":1071,"created_at":"2011-10-23T09:02:43Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"Vanmorgen een pull en upgrade_db gedaan, nu krijg ik errors bij het updaten. De laatste update is echter van 2 dagen geleden, dus ik vermoed dat ie eerder al in de soep is gelopen dan bij deze commit.\r\n\r\n\r\n```\r\nRetrieving 1716114 till 1717114 (parsed 0 headers, 0 full, verified 0, moderated 0, skipped 0 of 0 total messages)\r\nRetrieving 1717114 till 1718114 (parsed 0 headers, 0 full, verified 0, moderated 0, skipped 0 of 0 total messages)\r\nRetrieving 1718114 till 1719114 (parsed 0 headers, 0 full, verified 0, moderated 0, skipped 0 of 0 total messages)\r\n\r\n\r\nFatal error occured retrieving messages:\r\n  Error executing query: Duplicate entry '1719114' for key 3\r\n\r\n\r\n#0 /var/www/tcit.nl/subdomains/spotweb/httpdocs/lib/dbeng/dbeng_abs.php(88): dbeng_mysql->rawExec('INSERT INTO nnt...')\r\n#1 /var/www/tcit.nl/subdomains/spotweb/httpdocs/lib/dbeng/dbeng_mysql.php(115): dbeng_abs->exec('INSERT INTO nnt...', Array)\r\n#2 /var/www/tcit.nl/subdomains/spotweb/httpdocs/lib/SpotDb.php(516): dbeng_mysql->modify('INSERT INTO nnt...', Array)\r\n#3 /var/www/tcit.nl/subdomains/spotweb/httpdocs/lib/retriever/SpotRetriever_Spots.php(249): SpotDb->setMaxArticleId('news.lightningu...', 1719114)\r\n#4 /var/www/tcit.nl/subdomains/spotweb/httpdocs/lib/retriever/SpotRetriever_Abs.php(123): SpotRetriever_Spots->process(Array, 1718114, 1719114)\r\n#5 /var/www/tcit.nl/subdomains/spotweb/httpdocs/retrieve.php(106): SpotRetriever_Abs->loopTillEnd(1474067, 1000)\r\n#6 {main}\r\n```\r\n\r\nAls ik ga spieken in de MySQL database in de tabel nntp heb ik daar drie records; 'comments', 'news.lightningusenet.com' en 'reports'. Bij de eerste twee staat 1719114 als 'maxarticleid'...\r\n\r\nEn Index 3 op die tabel is 'maxarticleid'. Index 1 en 2 zijn dezelfde index, beide op de kolom 'server'. MySQL geeft daar ook een melding op.\r\n\r\n```\r\nThe indexes PRIMARY and idx_nntp_1 seem to be equal and one of them could possibly be removed.\r\n```\r\n\r\nSuggesties? :)","comments":7,"title":"Duplicate entry for key 3","updated_at":"2011-10-24T07:21:33Z","url":"https://api.github.com/repos/spotweb/spotweb/issues/1071","id":2026101,"assignee":null,"milestone":null,"closed_at":"2011-10-23T13:29:34Z","user":{"gravatar_id":"513778e0e418985aaa15eb14e0b073d3","avatar_url":"https://secure.gravatar.com/avatar/513778e0e418985aaa15eb14e0b073d3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/rowdynl","id":672760,"login":"rowdynl"},"html_url":"https://github.com/spotweb/spotweb/issues/1071","labels":[],"state":"closed"},"legacy":{"issue_id":2026101,"comment_id":2500449}}