Forums - Thread Details
  • State Not Answered
  • Replies 6 replies
  • Subscribers 319 subscribers
  • Views 1454 views
  • Users 0 members are here
Related

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 in reply to Francesca Shiekh

    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 ?

  • 0 in reply to Kunal singh

    Yes, it sounds like your upgrade did not finish.

    I assume you are on site since you are doing your own upgrade.

    When I have such issues I start with setting permissions from root down using:

    sudo chown -R  apache:apache *

    sudo find . -type d -exec chmod 775 {} \;

    sudo find . -type f -exec chmod 664 {} \;

     

    I re-run the upgrade with stage continue:
    see: https://support.sugarcrm.com/Documentation/Sugar_Versions/8.0/Pro/Installation_and_Upgrade_Guide/#Upgrading_via_Silent_Upgrader

    • <stage> : Instructs the upgrader to begin at a specific stage; "healthcheck" will cause only the health check portion to run while "continue" will cause it to start where it stopped on the previous run.

    Check your upgrade log again and see what if anything it is telling you.

    An alternative, though I don't like to do this - proceed at your own risk - is to open the upgrade package, go to upgrade->scripts->sql

    analyze those files and see if you can find the sql that should have executed on your instance but did not. Run it from your RDBMS Then try the QRR again.

Reply Children
No Data