my dashboard database table doesn't exist

[scorecomms]

Somehow, overnight, the mysql database table for the dashboard has been deleted. I keep getting this error:

Error running count query for Dashboard List: Query Failed: SELECT count(*) c FROM dashboards where (dashboards.assigned_user_id='1') AND dashboards.deleted=0::MySQL error 1146: Table '####.dashboards' doesn't exist

does anyone have a mysql dump file that I could have or use to recreate this table with the necesarry fields etc.?

Am using sugarcrm community edition 5.5.0 (Build 6653)

thanks

[scorecomms]

can anyone help me?

[AlexAv]

Hi,

This is structure of the dashboards table

CREATE TABLE IF NOT EXISTS `dashboards` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) NOT NULL,
  `assigned_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text,
  `content` text,
  PRIMARY KEY (`id`),
  KEY `idx_dashboard_name` (`name`,`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[scorecomms]

Hi,

This is structure of the dashboards table

CREATE TABLE IF NOT EXISTS `dashboards` (
  `id` char(36) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `date_entered` datetime NOT NULL,
  `date_modified` datetime NOT NULL,
  `modified_user_id` char(36) NOT NULL,
  `assigned_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` text,
  `content` text,
  PRIMARY KEY (`id`),
  KEY `idx_dashboard_name` (`name`,`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Thank you so much! Lifesaver

[AlexAv]

Glad to be help

[daniel.passarini]

Another option is to run a Quick Repair. It'll sync your database with your vardefs. If havent deleted the vardefs files, the application will re-create the missing tables.

[scorecomms]

Hi, I've just got round to doing this now. Thanks again. However I now have this error when I go to the dashboard:

Query Failed:INSERT into dashboards set ::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

any help please anyone? thanks