Help Center Live Community
April 23, 2014, 04:57:21 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Error During Setup  (Read 6645 times)
DeadBeet
Not too much to say...
*
Offline Offline

Posts: 17


« 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?
Logged
DeadBeet
Not too much to say...
*
Offline Offline

Posts: 17


« Reply #1 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
Logged
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #2 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.
Logged

how may I help you today?
DeadBeet
Not too much to say...
*
Offline Offline

Posts: 17


« Reply #3 on: July 05, 2007, 02:18:22 PM »

You're not expected to be perfect:)
Logged
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #4 on: July 05, 2007, 02:44:11 PM »

Yes but it's fun trying! Cheesy
Logged

how may I help you today?
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #5 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!
Logged

how may I help you today?
DeadBeet
Not too much to say...
*
Offline Offline

Posts: 17


« Reply #6 on: July 05, 2007, 03:18:25 PM »

Thank you for the help!
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.8 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.159 seconds with 18 queries.

Google visited last this page April 16, 2014, 03:44:54 PM