Error during install #8
Description
Ben,
I get this error when I try to install the maps plugin on geeklog 2.1.1 using Windows 10 IIS with the following environment:
Microsoft-IIS/10.0
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 -
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 5.6.14
Error on screen is E_USER_ERROR(256) - An SQL error has occurred. Please see error.log for details. @ C:\wamp\www\geeklog211\system\databases\mysqli.class.php line 279
Error.log file is:
08/01/16 14:02:21 - 192.168.0.3 - Attempting to install the 'maps' plugin
08/01/16 14:02:21 - 192.168.0.3 - Attempting to create 'Maps Admin' group
08/01/16 14:02:21 - 192.168.0.3 - 1101: BLOB/TEXT column 'remark' can't have a default value in C:\wamp\www\geeklog211\public_html\admin\plugins.php:1160. SQL in question:
CREATE TABLE gl_maps_markers (
mkid BIGINT NOT NULL,
name varchar(80) NOT NULL default '',
address varchar(255) NOT NULL default '',
lat FLOAT( 10, 6 ) NOT NULL ,
lng FLOAT( 10, 6 ) NOT NULL ,
mid INT NOT NULL,
mk_default tinyint(1) unsigned NOT NULL default '1',
mk_pcolor VARCHAR(7) NOT NULL default '#666666',
mk_scolor VARCHAR(7) NOT NULL default '#666666',
mk_label char(1),
mk_label_color tinyint(1) unsigned NOT NULL default '0',
mk_icon smallint(5) unsigned default '0',
payed tinyint(1) unsigned NOT NULL default '0',
created datetime NOT NULL,
modified datetime NOT NULL,
validity tinyint(1) unsigned NOT NULL default '0',
validity_start datetime NOT NULL,
validity_end datetime NOT NULL,
active tinyint(1) unsigned NOT NULL default '1',
hidden tinyint(1) unsigned NOT NULL default '0',
remark text NOT NULL default '',
description TEXT NOT NULL default '',
street varchar(255) NOT NULL default '',
code varchar(10) NOT NULL default '',
city varchar(255) NOT NULL default '',
state varchar(255) NOT NULL default '',
country varchar(255) NOT NULL default '',
tel varchar(20) NOT NULL default '',
fax varchar(20) NOT NULL default '',
web varchar(255) NOT NULL default '',
item_1 varchar(255) NOT NULL default '',
item_2 varchar(255) NOT NULL default '',
item_3 varchar(255) NOT NULL default '',
item_4 varchar(255) NOT NULL default '',
item_5 varchar(255) NOT NULL default '',
item_6 varchar(255) NOT NULL default '',
item_7 varchar(255) NOT NULL default '',
item_8 varchar(255) NOT NULL default '',
item_9 varchar(255) NOT NULL default '',
item_10 varchar(255) NOT NULL default '',
hits int(11) NOT NULL default '0',
url varchar(255) NOT NULL default '',
type varchar(20) NOT NULL default '',
owner_id mediumint(8) unsigned NOT NULL default '1',
group_id mediumint(8) unsigned NOT NULL default '1',
perm_owner tinyint(1) unsigned NOT NULL default '3',
perm_group tinyint(1) unsigned NOT NULL default '2',
perm_members tinyint(1) unsigned NOT NULL default '2',
perm_anon tinyint(1) unsigned NOT NULL default '2',
submission tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (mkid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
Same error whether I auto-install or manually install.
Michael