Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions

You are not logged in.

Announcement

#1 2021-11-29 09:58:01

rcarrie2011
Member
Registered: 2020-07-10
Posts: 27

No response on clicking the canned messages button after upgrade

Hi, my LHC instance is set to be automatically updated. Recently I find that the canned messages button in the chat dialog stops working any more. The browser reported the following errors.
1638178893_lhc-cannedmsg.png
Then I checked the server log and found the error like "ezcPersistentQueryException: A query failed internally in Persistent Object: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION databasename.JSON_EXTRACT does not exist Query: 'SELECT `lh_canned_msg`.`id`, `lh_canned_msg`.`title`, ...".

I searched the internet and it seems that JSON_EXTRACT requires mysql 5.7+. Currently I'm using CentOS 7 with php 7.4.26 and MariaDB 5.5.68. Is it because mariadb version is too low? But I checked LHC requirements and see it only requires MariaDB 5.5 or higher.

Thank you for your time!

Offline

#2 2021-11-29 10:02:26

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: No response on clicking the canned messages button after upgrade

Hi rcarrie2011,
thank you for your message!

What is your LHC version?
The issue happen when you are chatting?

I'm unable to reproduce the issue on version 3.88 with PHP 8.0
Are you able to post a GIF of the error?

What PHP version are you using?
Are you able to reproduce in the demo? https://livehelperchat.com/demo-12c.html


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

#3 2021-11-29 11:58:47

rcarrie2011
Member
Registered: 2020-07-10
Posts: 27

Re: No response on clicking the canned messages button after upgrade

Hi PeopleInside,

Thank you for your prompt response!

I make a screenshot of the problem. When I click the "Canned messages", the message list does not appear.
1638186257_lhc-cannedmsg2.jpg

LHC is version 3.88 as I said LHC automatically checks and updates to the latest version everyday. I can confirm LHC 3.86 has no problem, but I'm not sure whether 3.87 or 3.88 caused this problem.

Other information: CentOS 7, PHP 7.4.26, MariaDB 5.5.68.

Thank you.

Offline

#4 2021-11-29 12:02:33

rcarrie2011
Member
Registered: 2020-07-10
Posts: 27

Re: No response on clicking the canned messages button after upgrade

I login your demo system and find the same problem.

Offline

#5 2021-11-29 12:23:00

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: No response on clicking the canned messages button after upgrade

We are checking.


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

#6 2021-11-29 12:23:26

remdex
Administrator
From: Lithuania
Registered: 2012-09-23
Posts: 3,661
Website

Re: No response on clicking the canned messages button after upgrade

New version requires Mysql Update to support json_extract MySQL

Offline

#7 2021-11-29 12:24:29

remdex
Administrator
From: Lithuania
Registered: 2012-09-23
Posts: 3,661
Website

Re: No response on clicking the canned messages button after upgrade

You can verify mysql support by running this

SELECT JSON_EXTRACT('[10, 20, [30, 40]]', '$[1]');

Offline

#8 2021-11-29 16:10:01

rcarrie2011
Member
Registered: 2020-07-10
Posts: 27

Re: No response on clicking the canned messages button after upgrade

Hi remdex, thank you for the confirmation. I have upgraded mariadb to 10.6 and now everything goes back to normal.

Offline

#9 2021-11-29 16:36:58

PeopleInside
Administrator
From: Italy
Registered: 2014-04-10
Posts: 4,046
Website

Re: No response on clicking the canned messages button after upgrade

rcarrie2011, glad to hear that now works.
Thanks for the update!

Please remember to follow also update instructions: https://doc.livehelperchat.com/docs/upgrading/


lol PeopleInside - Live helper chat - free limited forum support!
wink For commercial support or GitHub [see FAQ here]
ops If you want to support this open source project, just donate [see support page]
glasses Something wrong with the forum? [contact a superhero]

Offline

Board footer