default_dashboard unknown column

hi All,

We have just upgraded our instance from 7.9.5 to 8.0.2 , upgrade failed at post_upgrade checks

we are witnessing following error on all module pages - Unknown column 'dashboards.default_dashboard'

HTTP: 500 Internal Server Error

An exception occurred while executing 'SELECT dashboards.id, dashboards.date_modified dashboards__date_modified FROM dashboards LEFT JOIN sugarfavorites sf_dashboards ON (sf_dashboards.module = ?) AND (sf_dashboards.record_id = dashboards.id) AND (sf_dashboards.assigned_user_id = ?) AND (sf_dashboards.deleted = ?) WHERE ((dashboards.dashboard_module = ?) AND ((sf_dashboards.id IS NOT NULL) OR (dashboards.default_dashboard = ?)) AND (dashboards.view_name = ?)) AND (dashboards.deleted = ?) ORDER BY dashboards.date_modified DESC, dashboards.id DESC LIMIT 18446744073709551615 OFFSET 0' with params ["Dashboards", "1", 0, "pmse_Business_Rules", 1, "records", 0]: Unknown column 'dashboards.default_dashboard' in 'where clause'

could someone provide me with dashboards table create query please post 8.0.2 upgrade.

Parents
  • BTW did you try a QRR to see if there were any pending SQL queries that needed to be executed?

  • Francesca Shiekh its a strange one for me , QRR is non responsive from front end , nothing happens, when i run via backend i am getting database error, basically what has happened is we are trying to upgrade our instance from 7.9.5 to 8.0.2 , upgrade failed at post_upgrade checks. now we are trying to investigate what went wrong as logs are not very helpful. we are also missing data_privacy table. when i look via studio data privacy module exists but no entry in db, i guess QRR should have resolved the issue by giving option to create if i would have been able to run it. so basically none of 8.0.2 tables are updated which is causing me greif also i am able to see records in list view but unable to create any , it says permission denied but all files and folders are set as owner : apache:apache and permissions 755. any ideas ?

Reply
  • Francesca Shiekh its a strange one for me , QRR is non responsive from front end , nothing happens, when i run via backend i am getting database error, basically what has happened is we are trying to upgrade our instance from 7.9.5 to 8.0.2 , upgrade failed at post_upgrade checks. now we are trying to investigate what went wrong as logs are not very helpful. we are also missing data_privacy table. when i look via studio data privacy module exists but no entry in db, i guess QRR should have resolved the issue by giving option to create if i would have been able to run it. so basically none of 8.0.2 tables are updated which is causing me greif also i am able to see records in list view but unable to create any , it says permission denied but all files and folders are set as owner : apache:apache and permissions 755. any ideas ?

Children