tuibm
Not too much to say...
 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
|
|
« 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
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.sqlHello 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 :/ |
|
|
|
|
Logged
|
|
|
|
|
HCL Admin
|
|
« 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
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!!   |
|
|
|
|
Logged
|
|
|
|
|
HCL Admin
|
|
« 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
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
|
|
« 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
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
|
|
« 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
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
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
|
|
|
|
|
