Fatal error due to duplicate content for some reason...

Permalink
Hi,

I'm building a site locally, and keep coming up against this error every time I try to add a new block:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '14-1' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('1', '10', '14', 'Sidebar', '0')") ' in /Applications/MAMP/htdocs/1stsightfilm/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /Applications/MAMP/htdocs/1stsightfilm/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /Applications/MAMP/htdocs/1stsightfilm/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 /Applications/MAMP/htdocs/1stsightfilm/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 [internal function]: Database->__call(Array, Array) #4 /Applications/MAMP/htdocs/1stsightfilm/concrete/models/block.php(404): Database->Execute('Execute', Array) #5 /Applications/ in /Applications/MAMP/htdocs/1stsightfilm/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


Any idea of what I can do to fix? I'm assuming it's to do with some duplicate content in the database, but not sure how or where I'd go to sort.

Thanks for any advice,

osu

osu
 
nteaviation replied on at Permalink Reply
nteaviation
osu replied on at Permalink Reply
osu
Hi nteaviation,

In the end I just did a clean install as I was trying to upgrade the site and it didn't work despite re-running the upgrade script.

Thanks for getting back to me though

osu