Help Center Live Community

Support => Installation Help & Software Support => Topic started by: tuibm on June 20, 2007, 06:29:14 AM



Title: Field 'picture' doesn't have a default value
Post by: tuibm 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


Title: Re: Field 'picture' doesn't have a default value
Post by: HCL Admin 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!>


Title: Re: Field 'picture' doesn't have a default value
Post by: tuibm 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 (http://www.helpcenterlive.com/downloads/database.sql)

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

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 :/


Title: Re: Field 'picture' doesn't have a default value
Post by: HCL Admin 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?


Title: Re: Field 'picture' doesn't have a default value
Post by: tuibm on June 20, 2007, 07:59:47 PM
hello, mysql version is: 5.0.22
is on my own server, and is windows

thanks!! :) ;)


Title: Re: Field 'picture' doesn't have a default value
Post by: HCL Admin 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.


Title: Re: Field 'picture' doesn't have a default value
Post by: flash383 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.


Title: Re: Field 'picture' doesn't have a default value
Post by: HCL Admin 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?


Title: Re: Field 'picture' doesn't have a default value
Post by: flash383 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.


Title: Re: Field 'picture' doesn't have a default value
Post by: HCL Admin 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 (http://www.helpcenterlive.com/setup.zip) this to your drive, and put in the /hcl/class/ folder.


Title: Re: Field 'picture' doesn't have a default value
Post by: dmy 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


Title: Re: Field 'picture' doesn't have a default value
Post by: dmy on October 01, 2008, 03:25:52 PM
i try the attachment, hope it works, thank you for your nice project!