Help Center Live Community

Support => Installation Help & Software Support => Topic started by: jprubio on January 28, 2008, 09:40:32 AM



Title: "Out of range value adjusted for column chatid" bug
Post by: jprubio on January 28, 2008, 09:40:32 AM
Hi,

i'm newbie in HCL and desperating with a bug ...

When i start an operator chat, i get the following message:

Code:
Out of range value adjusted for column 'chatid'

INSERT INTO `hcl_sessions` (chatid,assignid,departmentid,operatorid,nick,timeo,timeg,alert) VALUES ("op_1", "0", "0", "1", "Default", UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), "opchat")

In fact, the chatid field has integer type in DB and HCL tries to insert an alphanumeric value ("op_1").

Does anyone any idea what's happening?

Thanks in advance.

Juan P. Rubio


Title: Re: "Out of range value adjusted for column chatid" bug
Post by: victor on January 30, 2008, 07:53:54 PM
what version are you using?


Title: Re: "Out of range value adjusted for column chatid" bug
Post by: jprubio on February 28, 2008, 09:39:54 AM
My installed version is 2.1.5

Thanks in advance.

Juan P. Rubio.


Title: Re: "Out of range value adjusted for column chatid" bug
Post by: victor on March 07, 2008, 03:52:48 AM
it should work fine, try installing it manually again