Help Center Live Community
April 25, 2014, 03:27:38 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: Operators always busy  (Read 4553 times)
twilson
Not too much to say...
*
Offline Offline

Posts: 2


« on: March 26, 2009, 10:10:18 PM »

Our help center live installation has broken.  Nothing has been changed on it, but with operators logged in, we can not start chat requests.  It always says all operators are busy.  It does show on/offline correctly and shows the correct department online, but still we can not chat.

On a possibly related note, if I try to start an operator chat I get this error message.  This happened to me also when I tried a clean install.

Incorrect integer value: 'op_8' for column 'chatid' at row 1

INSERT INTO `sessions` (chatid,assignid,departmentid,operatorid,nick,timeo,timeg,alert) VALUES ("op_8", "0", "0", "8", "Tyler", UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), "opchat")

chatid is an integer so why is it trying to put a string in there?
Logged
MisterP
Not too much to say...
*
Offline Offline

Posts: 2


« Reply #1 on: June 26, 2009, 11:37:46 AM »

Hi.  i'm having exactly the same problem.  Did you manage to find a solution for this?

I installed a fresh instance of HCL

My server: Apache/2. 2. 11 (Win32) PHP/5. 2. 10
Logged
twilson
Not too much to say...
*
Offline Offline

Posts: 2


« Reply #2 on: June 26, 2009, 03:29:20 PM »

Nope, had to switch to another online help system.
Logged
Ast Derek
Not too much to say...
*
Offline Offline

Posts: 6


« Reply #3 on: July 17, 2009, 04:40:01 AM »

Found same problem.  The error message says the column table and the value to be inserted mismatch: trying to insert op_8 into an INTEGER type column (table: sessions, column chatid), so I went to the SQL admin, and changed the column type to VARCHAR.
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.151 seconds with 20 queries.

Google visited last this page April 22, 2014, 03:06:31 PM