problem updateding contetnt

Permalink 1 user found helpful March 25, 2011 at 3:30 PM

hi

if anyone can help. After upgrading to version 5.4.1.1 i had updated the content few times and everything worked fine, and than after i tried to update a content block happened this error:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '24-57' for key 1] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('57', '20', '24', 'Header', '0')") ' in /home/lacohr/public_html/inside/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/lacohr/public_html/inside/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home/lacohr/public_html/inside/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 /home/lacohr/public_html/inside/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 /home/lacohr/public_html/inside/concrete/models/block.php(404): Database->__call(Array, Array) #4 /home/lacohr/public_html/inside/concrete/models/block.php(404): Database->Execute('Execute', Array) #5 /home/lacohr/ in /home/lacohr/public_html/inside/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

-the page become empty , all content disapeared after saving the page edits.

Any idea?

TechBlessings replied on Mar 25, 2011 at 9:57 pm Permalink Reply

This looks like there is an error in the coding of the block and it is attempting to write a new record to the database with duplicate information.

I might try removing the block that you changed, saving the page, and then installing the block again cleanly.

Hope that helps.

Jason

stromberg replied on Mar 25, 2011 at 10:02 pm Permalink Best Answer Reply

Hi,

this seems to be a common problem after upgrading. I've posted a solution in this thread: http://www.concrete5.org/community/forums/installation/error-upgrad...
(look for the highlighted answer)

Please have a look there and if you still have questions, please post back in said thread.

Hope this helps!

stromberg

rutrem replied on Mar 28, 2011 at 5:04 pm Permalink Reply

thnx for the replays i will try to solve as u explained in that thread. Thnx again stromberg and TechBlessing

rutrem replied on Apr 1, 2011 at 4:46 pm Permalink Reply

thnx for the help, now works just fine.
the doubled entrys in the table was the problem.

:) thnx a lot

stromberg replied on Apr 1, 2011 at 5:14 pm Permalink Reply

Good to hear that!

Happy editing :)