hi all
After lots of smooth installations, for the first time I got this error when trying to install myReferer:
=========================
ERROR
Installing myReferer
Invalid default value for 'startdate'
Unable to install myReferer. Error(s):
Back to Module Administration page
=======================================
Compared to early installs, the only environment differnce is NOW using mySql 5
Anyone know how to fix this?
Thanks in advance,
Wilson
PS. just in case, follows the mysql.sql code:
CREATE TABLE myref_referer (
id int(8) NOT NULL auto_increment,
engine tinyint(2) unsigned default '0',
referer varchar(255) default NULL,
ref_url varchar(255) default NULL,
page varchar(255) default NULL,
visit int(8) unsigned default '0',
startdate int(11) unsigned NOT NULL default '',
date int(11) unsigned NOT NULL default '',
hide tinyint(2) unsigned default 'd',
PRIMARY KEY (id)
);
CREATE TABLE myref_robots (
id int(8) NOT NULL auto_increment,
robots varchar(255) default NULL,
ref_url varchar(255) default NULL,
page varchar(255) default NULL,
visit int(8) unsigned default '0',
startdate int(11) unsigned NOT NULL default '',
date int(11) unsigned NOT NULL default '',
hide tinyint(2) unsigned default 'd',
PRIMARY KEY (id)
);
CREATE TABLE myref_query (
id int(8) NOT NULL auto_increment,
query varchar(24) default NULL,
page varchar(255) default NULL,
visit int(8) unsigned default '0',
startdate int(11) unsigned NOT NULL default '',
date int(11) unsigned NOT NULL default '',
hide tinyint(2) unsigned default 'd',
PRIMARY KEY (id)
);
