FlowView errors.

[MrRat]

05/07/2010 07:24:44 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1163', SQL:"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''
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

[ursal]

You should change mysql table type, HEAP tables are fast but dosnt support auto_increment and TEXT columns
mysql table for old PA had MyISAM type. To change type of table with PA 2.0++ you should edit setup.php

File: setup.php
$data['type'] = 'MyISAM';