I tried to install XOOPS protector but I get the following error message:

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

Unable to install protector. Error(s)









MultiMenu: 1.74
My-iframe: 1.4
PHP myadmin: 2.51
Database tools: 1.1
ExtCal: 2
Liase 1.26
Smartsection 2.12
WF-downloads 3.1
MyAlbum 2.87

Give information about your site
Copy the following template into your post and fill-in as much information as possible. The more information you give, the more likely you will receive a quick and effective reply to your post.

XOOPS Version:
Module Name/Version:
PHP Version:
MySQL Version:
Web Server Software (Apache/IIS/Other):
Operating System:
Theme you are using:
Custom template: (Yes/No)
PHP Debug Messages:
MySQL Debug Messages:
Smarty Debug Messages:
A full description of the issue:

Probably an outdated version <-tis a link

MultiMenu: 1.74
My-iframe: 1.4
PHP myadmin: 2.51
Database tools: 1.1
ExtCal: 2
Liase 1.26
Smartsection 2.12
WF-downloads 3.1
MyAlbum 2.87


Apache 2
PHP 5
MySQL 5
no customtemplates
Windows 2003 Server




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

Unable to install protector. Error(s):









SELECT * FROM xoops_spl_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_spl_session WHERE sess_id = 'd9gj1ilvrin96ef5bk1vdqfl90'
SELECT * FROM xoops_spl_users WHERE uid=1
SELECT * FROM xoops_spl_modules WHERE dirname = 'system'
SELECT COUNT(*) FROM xoops_spl_modules WHERE dirname = 'protector'
CREATE TABLE xoops_spl_protector_log ( lid mediumint(8) unsigned NOT NULL auto_increment, uid mediumint(8) unsigned NOT NULL default 0, ip varchar(255) NOT NULL default '0.0.0.0', type varchar(255) NOT NULL default '', agent varchar(255) NOT NULL default '', description text NOT NULL default '', extra text NOT NULL default '' , timestamp TIMESTAMP(14) , PRIMARY KEY (lid) , KEY (uid) , KEY (ip) , KEY (type) , KEY (timestamp) ) TYPE=MyISAM
Error number: 1101
Error message: BLOB/TEXT column 'description' can't have a default value
SELECT * FROM xoops_spl_modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_spl_groups
SELECT gperm_itemid FROM xoops_spl_group_permission LEFT JOIN xoops_spl_modules m ON gperm_modid=m.mid WHERE m.dirname='myalbum' AND gperm_name='myalbum_global' AND (gperm_groupid IN (1,2))
SELECT * FROM xoops_spl_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))