Thread Details
  • State Not Answered
  • Replies 6 replies
  • Subscribers 368 subscribers
  • Views 2261 views
  • Users 0 members are here
Forum Actions

default_dashboard unknown column

Kunal singh

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
  • 0

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

  • 0 Sugar Employee Badge in reply to Francesca Shiekh

    During the uprade the database is changed, esp. the table dashboards is extendend by some new columns. These new columns are not in your upgraded installation.

    Possible reasons: the sql upgrade script did not run or the system runs with an old version eg. a manually upgraded database.

    I would discard the update result and start the upgrade again with the old version.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Reply
  • 0 Sugar Employee Badge in reply to Francesca Shiekh

    During the uprade the database is changed, esp. the table dashboards is extendend by some new columns. These new columns are not in your upgraded installation.

    Possible reasons: the sql upgrade script did not run or the system runs with an old version eg. a manually upgraded database.

    I would discard the update result and start the upgrade again with the old version.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Children
No Data