|
Title: Error During Setup Post by: DeadBeet on July 05, 2007, 01:57:06 PM Invalid default value for 'useragent'
CREATE TABLE `hcl_traffic` (`id` int(255) NOT NULL auto_increment,`timestamp` int(255) default NULL,`ip` varchar(255) NOT NULL default '',`useragent` text NOT NULL default NULL,`hostname` varchar(255) NOT NULL default '',`referrer` text NOT NULL default NULL,`requests` int(255) NOT NULL default '0',`visits` int(255) NOT NULL default '1',`start` int(255) NOT NULL default '0',PRIMARY KEY (`id`)) TYPE=MyISAM; I get this error when I am setting up the new version, did I miss something? Title: Re: Error During Setup Post by: DeadBeet on July 05, 2007, 02:11:26 PM I figured it out with the Update file in the same directory.
If you run into the same problem replace the two lines with these: `useragent` text default NULL, `referrer` text default NULL, Yes, I know theres a line in the middle between those two, but it doesn't need to be modified Title: Re: Error During Setup Post by: HCL Admin on July 05, 2007, 02:16:42 PM Exactly, I'm releasing a database.sql update today and 2.1.3a will be uploaded to SF. This was a packaging error on my part.
Title: Re: Error During Setup Post by: DeadBeet on July 05, 2007, 02:18:22 PM You're not expected to be perfect:)
Title: Re: Error During Setup Post by: HCL Admin on July 05, 2007, 02:44:11 PM Yes but it's fun trying! :D
Title: Re: Error During Setup Post by: HCL Admin on July 05, 2007, 03:11:01 PM Hotfix has been uploaded to: http://www.helpcenterlive.com/dru/fileshare/files/17/hcl-hotfix-2.1.3-19.zip This will repair any 2.1.3 install that is failing due to errors in the creation of MySQL tables. Sorry about that folks!
Title: Re: Error During Setup Post by: DeadBeet on July 05, 2007, 03:18:25 PM Thank you for the help!
|