Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions
You are not logged in.
Pages: 1
Hello! I just migrated my livechat from ubuntu 16 to rhel 7, with cPanel.
Everything transferred over alright, user accounts, settings, etc.. but now the dashboard isn't displaying active and pending chats on its own.
However, if I change some of the settings for which chats to display, it sends the request and displays the active and pending chats, and updates them as it should.
On the network requests for the initial page load, there is a 500 error for a request to index.php/site_admin/chat/loadinitialdata/(chatopen)/ followed by 4 digit what I presume are user IDs.
However once I update some settings, it starts making regular requests to index.php/site_admin/chat/syncadmininterface
I assume loadinitialdata makes the initial call to syncadmininterface, where it runs on a timer after that?
In my logs I'm getting an error exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Connection refused' in <my_document_root>/ezcomponents/Database/src/handler.php:88
If that's connection error is why loadinitialdata is failing, any ideas why it would fail here but not anywhere else where data is being retrieved?
Any insight appreciated, really appreciate how active you guys are on the forum.
Paul
Offline
Hi Paul ( richardspm ) , welcome on the live helper chat forum!
What version of Live Helper Chat, PHP and Mysql are you using?
I upgraded your forum account to Member group. Can you share the URL where your chat installation is?
You can maybe try to activate debug output https://livehelperchat.com/how-to-enabl … t-58a.html
Have you manually edited the database?
You can try to Google the error 'SQLSTATE[HY000] [2002] Connection refused'
PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]
Offline
So the server that is hosting the admin panel is PHP 5.6.4, MySQL 5.7.25.
A lot of the websites that we have chat widgets on are php 5.3. Would we be able to upgrade to a newer livehelper version, or does it require 5.6+ on every server that makes requests.
Anyway the URL is installed at https://support.napc.pro/chatsupport/
Ill enable debug now and see what we get.
I haven't modified the database, I just made a dump file of it, transferred it to the other server, and made a user with identical credentials and permissions. I know it can at least access the database because all the user and department info and old chats are there though. Didn't find any googles for the SQLSTATE error that are only caused by a single page, since every other page can access the DB.
Thanks for the upgrade!
Paul
Offline
Hi Paul, PHP 5.6 support only security update is an old PHP version no more supported maybe from the last release of live helper chat.
What version of live helper chat are you running?
In any case maybe the database import has been not done successfully?
Seems the error is only a SQL error? Do you have PHP error or server error log file with other errors?
I cannot do much more for help you. Consider the suggestion to search on Google on my previous reply.
If you need a commercial support (not provided be me) you can find more info on my forum signature.
PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]
Offline
Found a solution! I tested the request that was getting the 500 error, index.php/site_admin/chat/loadinitialdata/(chatopen)/4984/4992/4993/4995/4990/4989/4988/4983/4987/4982/4981/4985/4980
Found it returned json data if I removed the (chatopen) section of the URL, so I modified angular.lhc.js in the design/mysite/js folder, removed the part of the function that appends "(chatopen)/", and it's working again.
Bit of an odd fix, especially since it was working with the same exact files on a different folder, but if anyone runs into the same problem that did it for me.
Thanks again!
Offline
Hi richardspm , thank you for the updates!
I am happy to read you was able to resolve!
Enjoy and have a great time!
PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]
Offline
I am having a similar problem as well though, currently users can start a chat, and the operator can respond as many times as they wish, but users cannot send additional messages beyond the one that starts the chat. This time the error seems to be at the module addmsguser. Any ideas? Maybe a permissions thing?
I'm able to rate the chat as thumbs up, it's just the message add that's having an issue
Also are you sure PHP 5.6.4 isn't supported by the latest version? The requirements page says "PHP 5.5 >= version"
Last edited by richardspm (2019-03-12 19:08:18)
Offline
Hi richardspm , I suggest to upgrade the PHP version as some user has solved in this way.
You can try to enable the debug output but maybe the issue can be also done by the PHP version.
PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]
Offline
Upgraded to PHP7, no fix. Can I upgrade LHC if I'm running PHP7 on the hosting server, but PHP 5.3 on some of the websites that contain chat widgets?
Offline
richardspm PHP 5.3 ? Maybe you mean 5.6 I hope.
Your LHC install is migrated recently or is a new installation?
You can use debug. If you are able to reproduce the issue on the demo or on a new install maybe i can help more.
If you need custom support that i cannot give (as my support is imitated on my knowledge) you can follow links on my forum signature
PeopleInside - Live helper chat - free limited forum support!
For commercial support or GitHub [see FAQ here]
If you want to support this open source project, just donate [see support page]
Something wrong with the forum? [contact a superhero]
Offline
Pages: 1