Multiple errors with Update plugin

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
Leddy
Cacti User
Posts: 93
Joined: Sun May 15, 2005 6:55 pm

Multiple errors with Update plugin

Post by Leddy »

mysql cacti < update.sql
ERROR 1101 (42000) at line 2: BLOB/TEXT column 'changes' can't have a default value

**Edit update.sql ************************************
DROP TABLE IF EXISTS `plugin_update_info`;
CREATE TABLE plugin_update_info (
plugin varchar(32) default NULL,
name varchar(32) default NULL,
version varchar(24) default NULL,
author varchar(64) default NULL,
homepage varchar(64) default NULL,
email varchar(64) default NULL,
released varchar(18) default NULL,
changes TEXT NOT NULL
) TYPE=MyISAM;
** End Edit *****************************************

Click on Updates on Console yields the following message

PHP Notice: Undefined index: cacti in c:\Inetpub\wwwroot\cacti\plugins\update\update.php on line 147 PHP Notice: Undefined index: cacti_plugin_arch in c:\Inetpub\wwwroot\cacti\plugins\update\update.php on line 153
cigamit
Developer
Posts: 3369
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Post by cigamit »

Bah! That was added since other users would get errors stating that it must have a default value. What version of MySQL?
Leddy
Cacti User
Posts: 93
Joined: Sun May 15, 2005 6:55 pm

Post by Leddy »

cigamit wrote:Bah! That was added since other users would get errors stating that it must have a default value. What version of MySQL?
Windows Server 2003 SP1 w/mySQL 5.0.27 (Doesn't Work)

Linux (CentOS 4.4) mySQL 4.1.20 (Works)
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests