I am getting multiple errors since upgrading our civicrm to the latest version.

When I try to enable debugging i receive db constraint issues and log file shows: Apr 06 11:54:29 [error] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_setting (`component_id`,`contact_id`,`created_date`,`created_id`,`domain_id`,`id`,`is_domain`,`name`,`value`) VALUES

(NULL,NULL,"20210406115429","2","1",NULL,"1","debug_enabled","s:1:"1";") [nativecode=1048 ** Column 'id' cannot be null] [type] => DB_Error [user_info] => INSERT INTO civicrm_setting (component_id,contact_id,created_date,created_id,domain_id,id,is_domain,name,value) VALUES (NULL,NULL,"20210406115429","2","1",NULL,"1","debug_enabled","s:1:"1";") [nativecode=1048 ** Column 'id' cannot be null] [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_setting (component_id,contact_id,created_date,created_id,domain_id,id,is_domain,name,value) VALUES (NULL,NULL,"20210406115429","2","1",NULL,"1","debug_enabled","s:1:"1";") [nativecode=1048 ** Column 'id' cannot be null]"] )

Also when I click on civicrm in wordpress menu the screen only shows: Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred. DB Error: no such field

New contributor
Office Administrator is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Could you share what version you upgraded from? – Jon G - Megaphone Tech Apr 6 at 19:27
  • I cant be exact but it was a version 5.x that was no longer supported due to security enhancements – Office Administrator Apr 7 at 12:37

Do you have advanced logging (Administer menu » System Settings » Misc) on? If so can you turn it off before upgrading and try enabling it after upgrade?

  • 1
    Hi, I get an error when trying to switch on the logging (no option or advanced logging - just logging) and get black alert box on screen but when I click on show and manage alerts i just get a blank empty screen with with CiviCRM and footer underneath – Office Administrator Apr 7 at 12:17
  • 1
    @OfficeAdministrator What does the black alert box say? The alerts screen itself probably won't work until you resolve this underlying issue. Also - are you doing this on a test server? If not, do you have a backup? – Jon G - Megaphone Tech Apr 7 at 15:13

Your Answer

Office Administrator is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.