Trouble inatalling Weathermap plugin

[Durski]

Joost - if you get it working, and don't mind dumbing down the process for me, can you post what you did to get it working and what tools you had to use?

[JImuns]

Code: Select all

CREATE TABLE weathermap_maps (
id int(11) NOT NULL auto_increment,
sortorder int(11) NOT NULL default 0,
group_id int(11) NOT NULL default 1,
active set('on','off') NOT NULL default 'on',
configfile text NOT NULL,
imagefile text NOT NULL,
htmlfile text NOT NULL,
titlecache text NOT NULL,
filehash varchar (40) NOT NULL default '',
warncount int(11) NOT NULL default 0,
config text NOT NULL,
thumb_width int(11) NOT NULL default 0,
thumb_height int(11) NOT NULL default 0,
schedule varchar(32) NOT NULL default '*',
archiving set('on','off') NOT NULL default 'off',
PRIMARY KEY  (id)
) ENGINE=MyISAM;

config text NOT NULL, changed from config text NOT NULL default '', because of the mysql error:

Code: Select all

ERROR 1101 (42000): BLOB/TEXT column 'config' can't have a default value

mysql Ver 14.14 Distrib 5.6.22

[Howie]

Is this still an issue in 0.97c? I thought it was fixed...