I don't know how to do anything, and I have a FATAL ERROR

Permalink March 24, 2011 at 11:36 PM

Whenever I try to edit several of my pages I get this:

 
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '70-53-1-611' for key 'PRIMARY'] in EXECUTE("UPDATE CollectionAttributeValues SET avID=611 WHERE cID=70 and cvID=53 and akID=1")
' in /home4/thelosu3/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home4/thelosu3/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'UPDATE Collecti...', false, Object(ADODB_mysql))
#1 /home4/thelosu3/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('UPDATE Collecti...', false)
#2 /home4/thelosu3/public_html/concrete/libraries/3rdparty/adodb/adodb-lib.inc.php(174): ADOConnection->Execute('UPDATE Collecti...')
#3 /home4/thelosu3/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1658): _adodb_replace(Object(ADODB_mysql), 'CollectionAttri...', Array, Array, false, false)
#4 [internal function]: ADOConnection->Replace('CollectionA in /home4/thelosu3/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78 

I am not familiar with coding AT ALL and have no idea of what to do to solve this problem...I have looked at other discussions about this, but unfortunately they all are basically speaking in a different language to me. I have no clue what to do.

jordanlev replied on Mar 26, 2011 at 3:26 am Permalink Reply

I'm sorry you're having this problem, I know it is quite frustrating. Unfortunately it is difficult to know what is going on without having any idea of the context here. Did you recently install a new addon or theme from the marketplace? Did you recently upgrade your Concrete5 system to a new version? Did you recently make a change to your theme or any block code? etc.

Also, if you can post links to the other forum threads about this, I can see if I might be able to interpret them into less techno-jargon for you.

-Jordan

stromberg replied on Mar 26, 2011 at 7:57 am Permalink Reply

Hello Paul,

did you recently update your c5 installation from 5.3.x to 5.4.x? If so, I can refer to another thread about this problem, because I (and many others) had a very similar issue, i.e. the same error message about "duplicate entries" but in connection with a different table (CollectionVersionBlockStyles, not CollectionAttributeValues).

Have a look here: http://www.concrete5.org/community/forums/installation/error-upgrad...

If you have problems understanding the technical mumbo-jumbo, post back here or send me a message.

(Okay, next time I *really* read what others write - Jordan already offered that) %-)

Cheers!
stromberg

Mnkras replied on Mar 26, 2011 at 11:28 am Permalink Reply