Moved Domain and Concrete5 Now getting errors on edit

Permalink May 14, 2010 at 9:38 PM

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '1-58' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('58', '25', '1', 'Header Nav', 0)") ' in /home2/materiao/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home2/materiao/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home2/materiao/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 /home2/materiao/public_html/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 [internal function]: Database->__call(Array, Array) #4 /home2/materiao/public_html/concrete/models/block.php(393): Database->Execute('Execute', Array) #5 /home2/materiao/public_html/concrete/models/collection.php(82): Bloc in /home2/materiao/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

matiriaorganica replied on May 15, 2010 at 2:08 pm Permalink Reply

I fixed it. I had to remove all versions that were bad. The last version I could not remove through C5, had to do through phpMyAdmin. I also had to use phpMyAdmin to remove current entries in the table CurrentVersionBlockStyles for that page before I did the edit. The page had a bunch of MS Word code carried over from a paste from an MS Word file.

After this when I did the edit to remove the MS Word code, it worked. Thank goodness for page versions.