Failed to create dashboard_graphs table

[thebobop]

Dear All,


I have problems cacti cannot display graph and I have identify problems error log :

--
04/11/2013 10:27:15 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE dashboard_graphs ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL, local_graph_id mediumint(8) unsigned NOT NULL default '0', rra_id smallint(8) unsigned NOT NULL default '0', title varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;'
04/11/2013 10:26:15 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE dashboard_graphs ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL, local_graph_id mediumint(8) unsigned NOT NULL default '0', rra_id smallint(8) unsigned NOT NULL default '0', title varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;'
04/11/2013 10:25:15 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064', SQL:"CREATE TABLE dashboard_graphs ( id int(11) NOT NULL auto_increment, userid int(11) NOT NULL, local_graph_id mediumint(8) unsigned NOT NULL default '0', rra_id smallint(8) unsigned NOT NULL default '0', title varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM;'
--

for the specification cacti :
Cacti Version : 0.8.8a
Cacti OS : win32
SNMP Version : NET-SNMP version: 5.6.1.1
RRDTool Version : RRDTool 1.4.x
MySql : ver 5.5

please help me for solved this problems.

Thanks before..

[BSOD2600]

A quick search on google for that error number...

MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

What plugins are you using? this isnt a standard Cacti table.

[thebobop]

for plugins :

dashboard ver 1.2
monitor ver 1.3
settings ver 0.71
boots 5.1
realtime 0.5
thold 0.4.9

have problems for the plugins? or may be crash with mysql ?

[BSOD2600]

Ah, most likely a problem with the dashboard plugin. time to contact its author for support. Moving the thread to the appropriate forum.

or may be crash with mysql ?

Does the technical support page show any database errors?