AnsweredAssumed Answered

default_dashboard unknown column

Question asked by Kunal singh on Jul 1, 2019
Latest reply on Jul 2, 2019 by Harald Kuske

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.

Outcomes