Forums

Internal server error 500 when editing mainpage

Permalink
I have worked with my Concrete installation on a shared hosting for 2-3 months without any problem. But yesterday when I hit "update" after editing a content-block on my main page I get a warning "internal server error 500". All the other pages works just fine. I am still able to roll back to an earlier version of the page.

I have checked and repaired the database and checked all file permissions without any success.

What to do now?

Regards,
Kylis
 
kylis replied on at Permalink Reply
Here is an extract from the Apache error log,

PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '1-98-1-84' for key 1] in EXECUTE("insert into CollectionAttributeValues (cID, cvID, akID, avID) values ('1', 98, '1', '84')")\n'
Mnkras replied on at Permalink Reply
Mnkras
delete the entry from the database specified above (make a backup first)
kylis replied on at Permalink Reply
Deleted the entry '1-98-1-84' in the table "CollectionAttributeValues". Edited the main page(cid=1)once again but sorry to say, it all ended up with the same result as earlier "internal server error 500". Checked the "CollectionAttributeValues" table and the entry 1-98-1-84 was back.

What to try next?

Regards,
Kylis
kylis replied on at Permalink Best Answer Reply
Hi,

I have now uppdated my installation to 5.3.3.1 and all the problems with duplicate entries in the database are gone.
/Kylis
matiriaorganica replied on at Permalink Reply
I am using the latest version 5.4.0.5 and am getting these errors. They started after I ugraded to this version. If I delete the entry in the table specified, the error comes back next time I go to edit the page.

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '40-1' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('1', '45', '40', 'Header', '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): Block- in/home2/materiao/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
matiriaorganica replied on at Permalink Reply
I am using the latest version 5.4.0.5 and am getting these errors. They started after I ugraded to this version. If I delete the entry in the table specified, the error comes back next time I go to edit the page.

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '40-1' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('1', '45', '40', 'Header', '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): Block- in/home2/materiao/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78