Version 5.4.1.1 MySQL duplicate
Permalink
I am getting the following error when I try to go back into a page and change whether it is shown in the navigation or update the other attributes in the properties:
<b>Fatal error</b>: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '67-4-1-94' for key 'PRIMARY'] in EXECUTE("UPDATE CollectionAttributeValues SET avID=94 WHERE cID=67 and cvID=4 and akID=1")
' in /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'UPDATE Collecti...', false, Object(ADODB_mysql))
#1 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('UPDATE Collecti...', false)
#2 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb-lib.inc.php(174): ADOConnection->Execute('UPDATE Collecti...')
#3 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb.inc.php(1658): _adodb_replace(Object(ADODB_mysql), 'CollectionAttri...', Array, Array, false, false in <b>/home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php</b> on line <b>78</b><br>
I noticed there were similar problems when updating from 5.3 to 5.4. I have read all the other forum discussions about similar problems, and none of them have worked yet. I can still edit content in the page, and I can add pages, I just can't edit the attributes.
<b>Fatal error</b>: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '67-4-1-94' for key 'PRIMARY'] in EXECUTE("UPDATE CollectionAttributeValues SET avID=94 WHERE cID=67 and cvID=4 and akID=1")
' in /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'UPDATE Collecti...', false, Object(ADODB_mysql))
#1 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('UPDATE Collecti...', false)
#2 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb-lib.inc.php(174): ADOConnection->Execute('UPDATE Collecti...')
#3 /home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb.inc.php(1658): _adodb_replace(Object(ADODB_mysql), 'CollectionAttri...', Array, Array, false, false in <b>/home2/ohiobldg/public_html/associatedpg/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php</b> on line <b>78</b><br>
I noticed there were similar problems when updating from 5.3 to 5.4. I have read all the other forum discussions about similar problems, and none of them have worked yet. I can still edit content in the page, and I can add pages, I just can't edit the attributes.
So, I have worked on it more and I have noticed that I can change the meta tags to the pages that I included them in during setup. If I left them out, it gives me the 1062 MySQL error. It looks like this is because the auto-increment does not work. I am still trying to figure out why this is turned off though. Any help is still appreciated.
