Help Center Live Community

Support => Installation Help & Software Support => Topic started by: DeadBeet on July 05, 2007, 01:57:06 PM



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!