No response on clicking the canned messages button after upgrade

rcarrie2011 · 2021-11-29 09:58:01

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.

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!

PeopleInside · 2021-11-29 10:02:26

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

rcarrie2011 · 2021-11-29 11:58:47

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.

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.

rcarrie2011 · 2021-11-29 12:02:33

I login your demo system and find the same problem.

PeopleInside · 2021-11-29 12:23:00

We are checking.

remdex · 2021-11-29 12:23:26

New version requires Mysql Update to support json_extract MySQL

remdex · 2021-11-29 12:24:29

You can verify mysql support by running this

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

rcarrie2011 · 2021-11-29 16:10:01

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

PeopleInside · 2021-11-29 16:36:58

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

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

Announcement

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

No response on clicking the canned messages button after upgrade

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Board footer