05/07/2010 07:24:44 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM plugin_flowview_schedules WHERE enabled = 'on' AND (1273231484 - sendinterval > lastsent)"
Code: Select all
Server version: 5.1.45-log Gentoo Linux mysql-5.1.45-r1
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use cacti;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> CREATE TABLE `plugin_flowview_schedules` (`id` int(12) NOT NULL auto_increment,`enabled` varchar(3) NOT NULL default 'on',`sendinterval` int(20) NOT NULL,`lastsent` int(20) NOT NULL,`start` datetime NOT NULL,`email` text NOT NULL,`savedquery` int(12) NOT NULL, PRIMARY KEY (`id`), KEY `savedquery` (`savedquery`)) TYPE = HEAP COMMENT = 'Plugin Flowview - Scheduling for running and emails of saved queries';
ERROR 1163 (42000): The used table type doesn't support BLOB/TEXT columns