CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1064'
Error:
12/24/2016 12:30:37 PM - 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;'
Solution:
In "setup.php" under dashboard plugin Change TYPE=MyISAM to ENGINE=MyISAM . It was deprecated in MySQL 4.0 and removed in MySQL 5.5.
12/24/2016 12:30:37 PM - 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;'
Solution:
In "setup.php" under dashboard plugin Change TYPE=MyISAM to ENGINE=MyISAM . It was deprecated in MySQL 4.0 and removed in MySQL 5.5.
No comments