2

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

Improve this question
7
  • 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
    – df23
    Commented Feb 10, 2019 at 11:17
  • Look in media/civicrm for the log file.
    – Demerit
    Commented Feb 10, 2019 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']
    – df23
    Commented Feb 10, 2019 at 12:25
  • You can edit your original question to post more of the log.
    – Demerit
    Commented Feb 10, 2019 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
    Commented Feb 10, 2019 at 12:46

1 Answer 1

Reset to default
2

On the Finish page of the CiviCRM 5.10.1 and 5.10.4 component installation, there is a little link called "Utility for Updating the Database structure" or something similar. Up til running that little link, we received the "DB Error: Field missing" error when running some reports.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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