Dashboard database table query failing

[scorecomms]

A few weeks ago my dashboards database table was deleted. Through the help of some people on here, I managed to recreate the table.

However now I get the following error when I click on the dashboards tab:

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

I'm running the latest Sugarcrm community version

any help please anyone? i assume it's to do with the table I created. Thanks

ps. this is the code I used to recreate the dashboard 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]

could anyone help me?

[mapm]

Try to rename da database, to not loose any data and then make a quick repair, if it doesn't work drop the new database and rename the old one back to it's name.

[scorecomms]

I don't understand what you're trying to say exactly. I've run a repair before and it's just not worked