Hi,
I was trying to install piCal and got the following error.

BLOB/TEXT column 'description' can't have a default value

Unable to install piCal. Error(s):

More detail error:
-----------------------
CREATE TABLE xoops_pical_event ( id int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, uid mediumint(8) unsigned zerofill NOT NULL default 0, groupid smallint(5) unsigned zerofill NOT NULL default 0, summary VARCHAR(255) NOT NULL DEFAULT '' , location VARCHAR(255) NOT NULL DEFAULT '' , organizer VARCHAR(255) NOT NULL DEFAULT '', sequence VARCHAR(255) NOT NULL DEFAULT '', contact VARCHAR(255) NOT NULL DEFAULT '', tzid VARCHAR(255) NOT NULL DEFAULT 'GMT', description text NOT NULL DEFAULT '', dtstamp TIMESTAMP(14), categories VARCHAR(255) NOT NULL DEFAULT '', transp TINYINT NOT NULL DEFAULT 1, priority TINYINT NOT NULL DEFAULT 0, admission TINYINT NOT NULL DEFAULT 0, class VARCHAR(255) NOT NULL DEFAULT 'PUBLIC', rrule VARCHAR(255) NOT NULL DEFAULT '', rrule_pid int(8) unsigned zerofill NOT NULL DEFAULT 0, unique_id VARCHAR(255) NOT NULL DEFAULT '', allday TINYINT NOT NULL DEFAULT 0, start INT(10) unsigned NOT NULL DEFAULT 0, end INT(10) unsigned NOT NULL DEFAULT 0, start_date date, end_date date, cid smallint(5) unsigned zerofill NOT NULL default '0', comments mediumint(8) unsigned NOT NULL default '0', event_tz float(2,1) NOT NULL default 0.0, server_tz float(2,1) NOT NULL default 0.0, poster_tz float(2,1) NOT NULL default 0.0, extkey0 INT(10) unsigned zerofill NOT NULL DEFAULT 0, extkey1 INT(10) unsigned zerofill NOT NULL DEFAULT 0, KEY (admission), KEY (allday), KEY (start), KEY (end), KEY (start_date), KEY (end_date), KEY (dtstamp), KEY (unique_id), KEY (cid), KEY (event_tz), KEY (server_tz), KEY (poster_tz), KEY (uid), KEY (groupid), KEY (class), KEY (rrule_pid), KEY (categories), PRIMARY KEY (id) ) TYPE=MyISAM
Error number: 1101
Error message: BLOB/TEXT column 'description' can't have a default value

I am using Windows XP, Xoops 2.0.15, piCal 0.7 and mysql 5.

Please let me know asap if any of you got this problem and how did you solve it..

Thanks.

2 methods.

- remove "DEFAULT ''" from the line of `description` in sql/pical*.sql
- user MySQL version 4.0.x

the latter is better.

Thanks for replying..

I don't think going for mysql 4.x is an option, but will try to get rid of default thing.. Do you know any problems or consquences I may run into by doing this..??

Thanks.

Just because almost core/module's functions are designed for MySQL 4.0.x/3.23.x

I'll never recommend you to downgrade MySQL if you dare to tread a thorny path.