Reset the homepage

Permalink
I've completely botched the homepage, I set it back to the version at the very beginning... this appears LIVE but when I login to edit it displays the last one I was working on, I go to edit that one and get a string of errors:

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '1-12-1-38' for key 1] in EXECUTE("insert into CollectionAttributeValues (cID, cvID, akID, avID) values ('1', 12, '1', '38')") ' in /nfs/c03/h04/mnt/56433/domains/m8denim.com/html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /nfs/c03/h04/mnt/56433/domains/m8denim.com/html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /nfs/c03/h04/mnt/56433/domains/m8denim.com/html/concrete/libraries/3rdparty/adodb/adodb.inc.php(998): ADOConnection->_Execute('insert into Col...') #2 /nfs/c03/h04/mnt/56433/domains/m8denim.com/html/concrete/libraries/3rdparty/adodb/adodb.inc.php(766): ADOConnection->Execute('insert into Col...', Array) #3 /nfs/c03/h04/mnt/56433/domains/m8denim.com/html/concrete/libraries/database.php(73): ADOConnection->Query('insert into Col...', Array) #4 [internal functio in /nfs/c03/h04/mnt/56433/domains/m8denim.com/html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


I've cleared the cache on browser and in the c5 system.

Using the latest version of concrete5.

I can't edit the page and save, or change the version.

Any help would be much appreciated.

 
meffid replied on at Permalink Reply
I delete the 'Home' page everything under it will be deleted also I assume including all my filled pages with content... A quick fix without reinstall would be great.
frz replied on at Permalink Reply
frz
concrete5 probably wont let you, but yeah don't do that.

see if you can change versions through the site map.. remove all the new versions, approve the original, see if that behaves.
meffid replied on at Permalink Reply
I went back to the Initial Version (which I didn't try before – only tried a few previous versions) and it has worked.

Am dreading that awful php error again but it hasn't thrown it yet.

Cheers
SteveO replied on at Permalink Reply
SteveO
Had the same exact problem. Deleted all but the original version. Worked for a while longer, and now I'm getting the error again.

Help!
meffid replied on at Permalink Reply
new version and upgrades all installed?

what addition code have you added? like a 'sharethis' button or anything?

how much work would you lose re-upping the themes folder?
meffid replied on at Permalink Reply
also flush the db cache.

mostly the error means there's a duplicate in the database and it doesn't know which to edit or save over and causes the error to best of my knowledge.