Jump to content

Limit Concurrent Chat Amount being exceeded

2 replies to this topic

#1 BrandonH75


  • Members
  • Pip
  • 9 posts
  • LocationBurnsville, MN

Posted 10 September 2019 - 05:28 PM

We recently updated LiveZilla from to Since then I've received reports that some users are occasionally getting more chats than their maximum is set at. Their "maximum number of concurrent chats" is set to 1 for everyone, but they sometimes will get a second chat offered when they already have one going.

The LiveZilla SQL log shows a lot of messages similar to...

10.09.19 12:05:44 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) as `ccount` FROM `lz_visitor_chats` AS `t1` INNER JOIN `lz_visitor_chat_opera' at line 1
SQL: SELECT COUNT (*) as `ccount` FROM `lz_visitor_chats` AS `t1` INNER JOIN `lz_visitor_chat_operators` AS `t2` ON `t1`.`chat_id`=`t2`.`chat_id` WHERE `t1`.`exit`=0 AND `t1`.`internal_declined`=0 AND `t2`.`status`<9 AND `t2`.`user_id`='360983e2a267419';

Ubuntu 18.04.3 LTS
PHP 7.2.22
Apache 2.4.29
MySQL 5.7.27


#2 Patrick Keil


  • Administrators
  • 3854 posts
  • LocationSingen, Germany

Posted 12 September 2019 - 06:54 AM


There was a problem with initial file that has been fixed in the meantime.

Please re-run the update using this updated setup file:


That should fix it.


#3 BrandonH75


  • Members
  • Pip
  • 9 posts
  • LocationBurnsville, MN

Posted 12 September 2019 - 04:59 PM


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users