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

You are not logged in.

Announcement

#1 2018-11-14 03:43:09

rehv
New member
Registered: 2018-11-14
Posts: 2

Upgrading MySQL 5.6 to 5.7 -- chat no longer working

It's simple.

After the MySQL upgrade I can't see online operators or new/pending chats.
Every other setting is fine, everything was showing correctly before mysql upgrade from 5.6 to 5.7.

This is what I get:
1542166625_teste.jpg

List online operators IS checked (was before upgrade, still is after upgrade).
Logged user (me) is default admin/operator.

Tried clearing cache, restarting MySQL, Apache and even the whole server the chat is hosted. Nothing worked.

I've tried searching the forum, but the only similar problem is without answer : viewtopic.php?id=2322


EDIT:

Indeed, this is "common" and "simple". Took a bit of different keywords to search, also a different source:

1st source
2nd

I can't post GitHub links yet (new account) but it's the issue 1026.

I.E., it got resolved, but maybe chat should consider updating SQL code in operators list to adequate to new MySQL default options (this is a issue posted originally on May 4, 2017).

I'll leave the post here in case anyone else search forums using these keywords.

Last edited by rehv (2018-11-14 06:23:23)

Offline

#2 2018-11-14 06:24:04

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

Re: Upgrading MySQL 5.6 to 5.7 -- chat no longer working

Hi rehv,
thank you for your message and report. Welcome on the live helper chat!

Regarding this I opened an issue here: https://github.com/LiveHelperChat/liveh … ssues/1275 , you can subscribe for know if the issue will be confirmed or not.
Enjoy your day smile


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 2018-11-14 06:26:25

rehv
New member
Registered: 2018-11-14
Posts: 2

Re: Upgrading MySQL 5.6 to 5.7 -- chat no longer working

PeopleInside wrote:

Hi rehv,
thank you for your message and report. Welcome on the live helper chat!

Hey there! Thanks for the issue you just opened, I think we were both writing our messages at the same time. The issue is resolved, but as indicated by my edited post, maybe the chat author should consider updating the MySQL code in the online operators list to avoid this issue on installations with default configurations!

Thanks for your support! smile

EDIT: Should I add this to the github issue?

Last edited by rehv (2018-11-14 06:27:57)

Offline

#4 2018-11-14 06:36:45

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

Re: Upgrading MySQL 5.6 to 5.7 -- chat no longer working

Hi rehv , thanks for the update.

rehv wrote:

Should I add this to the github issue?

You can create a post in the issue with all update you want so you will also receive a notification email when the issue will be resolved.
The chat owner should be able to see this topic on the forum, included in the issue opened smile


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