I have just updated CiviCRM under Joomla! from 4.7.6 to 5.10.0. The upgrade went well, with no issues. I have following the instructions on the page "Upgrading CiviCRM for Joomla". I can use CiviCRM except whenever i access any report menu i get :

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: unknown error

Items on here say to look in the ConfigAndLog file which i think for Joomla should be at administrator/components/com_civicrm/civicrm but i do not see it there.

Anyone have any suggestions on how this can be resolved?

thanks Dave

  • should just add Joomla! is v3.6.5 and running on php5.6. Once the CiviCRM upgrade is successful and i have tested Joomla! upgrade to latest i will replicate updates in the production site and move to php v7.2 – dave Feb 10 at 11:17
  • Look in media/civicrm for the log file. – Demerit Feb 10 at 12:11
  • thanks - found it. Contents dont mean much to me but look like they give a lead, can anyone suggest what is wrong and how to fix it? Here is as much as SE will allow me to post $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle ) [code] => -19 [message] => DB Error: no such field [mode] => 16 [debug_info] => INSERT INTO civicrm_menu (domain_id , path , title , access_callback , access_arguments , page_callback , breadcrumb , is_ssl , we ... Unknown column 'module_data' in 'field list'] – dave Feb 10 at 12:25
  • You can edit your original question to post more of the log. – Demerit Feb 10 at 12:36
  • Even though you said the upgrade went well it sounds like some database columns didn't get added. This one specifically: issues.civicrm.org/jira/browse/CRM-20927 – Demerit Feb 10 at 12:46

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.