Jump to content


Limit Concurrent Chat Amount being exceeded


2 replies to this topic

#1 BrandonH75

    Newbie

  • Members
  • Pip
  • 9 posts
  • LocationBurnsville, MN

Posted 10 September 2019 - 05:28 PM

We recently updated LiveZilla from 8.0.1.2 to 8.0.1.3. 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

Thanks!

#2 Patrick Keil

    Administrator

  • Administrators
  • 3854 posts
  • LocationSingen, Germany

Posted 12 September 2019 - 06:54 AM

Hi,

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

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

https://www.livezill...ver_8.0.1.3.zip

That should fix it.

Cheers.

#3 BrandonH75

    Newbie

  • Members
  • Pip
  • 9 posts
  • LocationBurnsville, MN

Posted 12 September 2019 - 04:59 PM

Thanks!





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users