Help Center Live Community
April 23, 2014, 07:47:35 AM *
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: Field 'picture' doesn't have a default value  (Read 12318 times)
tuibm
Not too much to say...
*
Offline Offline

Posts: 17


« on: June 20, 2007, 06:29:14 AM »

Hello all, i install hcl, i created a database, but when i install it from: http://www.mysite.com/hcl/setup, in the step 4:

"Step Four
A new set of HCL database tables will be installed
Database:    hcl
Prefix:    hcl_"


When i click submit, i get this error:


Field 'picture' doesn't have a default value

INSERT INTO `hcl_operators` (`username`, `password`, `firstname`, `lastname`, `email`, `showpic`, `autosave`, `level`) VALUES ("admin", "21232f297a57a5a743894a0e4a801fc3", "Default", "User", "admin@example.com", "0", "1", "0")

i don't know what to do, all my settings are correct I'm sure, i read all topics and installation manual following step by step but the error still there

any suggestion??

The version of my hcl is 2.1.2
Logged
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #1 on: June 20, 2007, 06:58:13 AM »

Sounds like something may have gotten corrupted.  Try replacing the hcl/setup/database.sql with the attached version.  See if that works for you.

Right click here to download <File removed as it can cause issues!>
« Last Edit: June 22, 2007, 04:20:50 AM by mlzhosting » Logged

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

Posts: 17


« Reply #2 on: June 20, 2007, 04:34:33 PM »

Sounds like something may have gotten corrupted.  Try replacing the hcl/setup/database.sql with the attached version.  See if that works for you.

Right click here to download database.sql

Hello again, with that file that u provide me, i get now this error Sad

BLOB/TEXT column 'picture' can't have a default value

CREATE TABLE `hcl_operators` (`id` int(255) NOT NULL auto_increment,`username` varchar(255) NOT NULL default '',`password` varchar(255) NOT NULL default '',`firstname` varchar(255) NOT NULL default '',`lastname` varchar(255) NOT NULL default '',`email` varchar(255) NOT NULL default '',`level` int(1) NOT NULL default '0',`timestamp` int(255) default '0',`autosave` int(1) NOT NULL default '1',`showpic` int(1) NOT NULL default '0',`status` int(1) NOT NULL default '0',`sounds` int(1) NOT NULL default '1',`picture` blob NOT NULL default '',`accepts` int(255) NOT NULL default '0',`declines` int(255) NOT NULL default '0',`accepts_transfer` int(255) NOT NULL default '0',`declines_transfer` int(255) NOT NULL default '0',`accepts_opchat` int(255) NOT NULL default '0',`declines_opchat` int(255) NOT NULL default '0',`initiates` int(255) NOT NULL default '0',`onlinetime` int(255) NOT NULL default '0',PRIMARY KEY (`id`)) TYPE=MyISAM;

What is wrong :/
Logged
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #3 on: June 20, 2007, 04:39:20 PM »

What version of MySQL are you running?  Not sure what the issue is, I tried setting a default for it, but forgot that blobs can't have them. 

Let me know what version of MySQL your using is, and we'll try to figure out why yours is behaving differently from others.

Also is this on your own server, and if so, is it windows or Unix?
Logged

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

Posts: 17


« Reply #4 on: June 20, 2007, 07:59:47 PM »

hello, mysql version is: 5.0.22
is on my own server, and is windows

thanks!! Smiley Wink
Logged
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #5 on: June 20, 2007, 08:14:38 PM »

That may be the problem.  I have not tested on windows, and the only MySQL5 we have tested with has been 5.0.41, which is quite a bit newer.  I would first recommend that you check your db users permissions.  Second, that is pretty old, you may wish to update it to something a little more current, or downgrade to one of the more stable, and better supported 4 version (4.1.2x would be good)

It definately sounds like somethings not right with the DB, we just need to find the reason.
Logged

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

Posts: 2


« Reply #6 on: June 21, 2007, 10:06:22 PM »

I am having the exact same problem and have the same version of MySQL as well as being on a Win2k3 server.
Logged
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #7 on: June 21, 2007, 10:09:38 PM »

Hmm, ok, we may have to do a work around on that one then.  I assume flash383, that you are also running 2.1.2?
Logged

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

Posts: 2


« Reply #8 on: June 21, 2007, 10:12:30 PM »

That's correct.  I started with the same problem as the orig poster, tried the new sql file and got the same new problem.
« Last Edit: June 21, 2007, 10:14:47 PM by flash383 » Logged
HCL Admin
Administrator
HCL Superstar
*****
Offline Offline

Posts: 882


WWW
« Reply #9 on: June 21, 2007, 10:16:26 PM »

The old file is probably the best to use.  I'm going to try to put together a patched setup.php file . to see if that fixes it.  Should only take a few hours (using the Scotty principle for time, probably only a few minutes...)
right click and save this to your drive, and put in the /hcl/class/ folder.
« Last Edit: June 21, 2007, 10:23:39 PM by mlzhosting » Logged

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

Posts: 3


« Reply #10 on: October 01, 2008, 03:22:27 PM »

hi  i got the same error when i install the hcl , i try to install the older verstion, and get the same problem

the server info

Platform Type
Debian
 
MySQL Version
5. 0. 45
 
Perl Version
5. 8. 8
 
PHP Version
4. 4. 7
Logged
dmy
Not too much to say...
*
Offline Offline

Posts: 3


« Reply #11 on: October 01, 2008, 03:25:52 PM »

i try the attachment, hope it works, thank you for your nice project!
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.195 seconds with 19 queries.

Google visited last this page Today at 03:38:34 AM