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

0 Francesca Shiekh over 4 years ago

I just ran your query in my 8.0.2 and it runs fine:

SELECT dashboards.id, dashboards.date_modified dashboards__date_modified
FROM dashboards
LEFT JOIN sugarfavorites sf_dashboards ON (sf_dashboards.module = 'Dashboards')
AND (sf_dashboards.record_id = dashboards.id) AND (sf_dashboards.assigned_user_id = 1)
AND (sf_dashboards.deleted = 0) WHERE ((dashboards.dashboard_module = 'pmse_Business_Rules') AND ((sf_dashboards.id IS NOT NULL)
OR (dashboards.default_dashboard = 1)) AND (dashboards.view_name = 'records')) AND (dashboards.deleted = '0')
ORDER BY dashboards.date_modified DESC, dashboards.id DESC LIMIT 18446744073709551615 OFFSET 0

Here is my create table:

CREATE TABLE `dashboards` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) DEFAULT NULL,
`dashboard_module` varchar(100) DEFAULT NULL,
`view_name` varchar(100) DEFAULT NULL,
`metadata` text,
`default_dashboard` tinyint(1) DEFAULT '0',
`team_id` char(36) DEFAULT NULL,
`team_set_id` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_dashboards_date_modfied` (`date_modified`),
KEY `idx_dashboards_id_del` (`id`,`deleted`),
KEY `idx_dashboards_date_entered` (`date_entered`),
KEY `user_module_view` (`assigned_user_id`,`dashboard_module`,`view_name`),
KEY `idx_dashboards_name_del` (`name`,`deleted`),
KEY `idx_dashboards_assigned_del` (`assigned_user_id`,`deleted`),
KEY `idx_dashboards_tmst_id` (`team_set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Hope that helps,

Francesca

Reply

0 Francesca Shiekh over 4 years ago

I just ran your query in my 8.0.2 and it runs fine:

Here is my create table:

CREATE TABLE `dashboards` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text,
`deleted` tinyint(1) DEFAULT '0',
`assigned_user_id` char(36) DEFAULT NULL,
`dashboard_module` varchar(100) DEFAULT NULL,
`view_name` varchar(100) DEFAULT NULL,
`metadata` text,
`default_dashboard` tinyint(1) DEFAULT '0',
`team_id` char(36) DEFAULT NULL,
`team_set_id` char(36) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_dashboards_date_modfied` (`date_modified`),
KEY `idx_dashboards_id_del` (`id`,`deleted`),
KEY `idx_dashboards_date_entered` (`date_entered`),
KEY `user_module_view` (`assigned_user_id`,`dashboard_module`,`view_name`),
KEY `idx_dashboards_name_del` (`name`,`deleted`),
KEY `idx_dashboards_assigned_del` (`assigned_user_id`,`deleted`),
KEY `idx_dashboards_tmst_id` (`team_set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Hope that helps,

Francesca

Children

No Data