Live Helper Chat support forum.. Forum is locked. New place for questions - Github Discussions
You are not logged in.
- Topics: Active | Unanswered
Announcement
#1 2017-06-04 01:51:38
- alex43210
- Member
- Registered: 2017-05-14
- Posts: 11
503 in syncadmininterface/(limita)/10/(limitu)/10/(limitp)/10/(limito)
At main admin page - in browser console I could see errors like
DevTools failed to parse SourceMap: http://45.55.192.217/index.php/site_adm … min.js.map
...
Failed to load resource http://45.55.192.217/index.php/site_adm … limitd)/10: the server responded with a status of 503 (Service Temporarily Unavailable)
e84a585….js:212 error"
And errors count increased by an interval.
And response body in the console is clear (just error code?)
In PHP - I have next options:
[== Undefined ==]
error_reporting=E_ALL
log_errors=OnApache error log placed in /var/log/apache2/error.log
But in /var/log/apache2/error.log I couldn't see anything about this error (not messages about caching like in https://forum.livehelperchat.com/viewtopic.php?pid=7979).
So - how can I found error source?
p.s. also - it's clean installation on this server, not migration like in linked topic.
upd. I turned on "debug_output". Now I can see next exception.
[== Undefined ==]
<pre>ezcPersistentQueryException Object
(
[originalMessage] => A query failed internally in Persistent Object: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test_livehelperchat.lh_userdep.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Query: 'SELECT `lh_userdep`.`id`, `lh_userdep`.`user_id`, `lh_userdep`.`dep_id`, `lh_userdep`.`last_activity`, `lh_userdep`.`hide_online`, `lh_userdep`.`last_accepted`, `lh_userdep`.`active_chats` FROM `lh_userdep` WHERE `lh_userdep`.`last_activity` > :ezcValue1 GROUP BY `lh_userdep`.`user_id` ORDER BY active_chats DESC, hide_online ASC LIMIT 10 OFFSET 0'
[message:protected] => A query failed internally in Persistent Object: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test_livehelperchat.lh_userdep.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Query: 'SELECT `lh_userdep`.`id`, `lh_userdep`.`user_id`, `lh_userdep`.`dep_id`, `lh_userdep`.`last_activity`, `lh_userdep`.`hide_online`, `lh_userdep`.`last_accepted`, `lh_userdep`.`active_chats` FROM `lh_userdep` WHERE `lh_userdep`.`last_activity` > :ezcValue1 GROUP BY `lh_userdep`.`user_id` ORDER BY active_chats DESC, hide_online ASC LIMIT 10 OFFSET 0'
[string:Exception:private] =>
[code:protected] => 0
[file:protected] => /var/www/html/ezcomponents/PersistentObject/src/persistent_session.php
[line:protected] => 822
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /var/www/html/ezcomponents/PersistentObject/src/handlers/load_handler.php
[line] => 269
[function] => performQuery
[class] => ezcPersistentSession
[type] => ->
[args] => Array
(
[0] => ezcQuerySelect Object
(
[selectString:protected] => SELECT `lh_userdep`.`id`, `lh_userdep`.`user_id`, `lh_userdep`.`dep_id`, `lh_userdep`.`last_activity`, `lh_userdep`.`hide_online`, `lh_userdep`.`last_accepted`, `lh_userdep`.`active_chats`
[fromString:protected] => FROM `lh_userdep`
[useIndexString:protected] =>
[whereString:protected] => WHERE `lh_userdep`.`last_activity` > :ezcValue1
[groupString:protected] => GROUP BY `lh_userdep`.`user_id`
[havingString:protected] =>
[orderString:protected] => ORDER BY active_chats DESC, hide_online ASC
[limitString:protected] => LIMIT 10 OFFSET 0
[lastInvokedMethod:protected] => order
[lockString:protected] =>
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => user
[password] => pass
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => test_livehelperchat
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=test_livehelperchat;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQuery:private] => Array
(
[id] => `lh_userdep`.`id`
[user_id] => `lh_userdep`.`user_id`
[dep_id] => `lh_userdep`.`dep_id`
[last_activity] => `lh_userdep`.`last_activity`
[hide_online] => `lh_userdep`.`hide_online`
[last_accepted] => `lh_userdep`.`last_accepted`
[active_chats] => `lh_userdep`.`active_chats`
[erLhcoreClassModelUserDep] => lh_userdep
)
[boundCounter:ezcQuery:private] => 1
[boundParameters:ezcQuery:private] => Array
(
)
[boundParametersType:ezcQuery:private] => Array
(
)
[boundValues:ezcQuery:private] => Array
(
[:ezcValue1] => 1496541103
)
[boundValuesType:ezcQuery:private] => Array
(
[:ezcValue1] => 2
)
[expr] => ezcQueryExpression Object
(
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => 6xaz8m4r
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => test_livehelperchat
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=test_livehelperchat;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQueryExpression:private] => Array
(
[id] => `lh_userdep`.`id`
[user_id] => `lh_userdep`.`user_id`
[dep_id] => `lh_userdep`.`dep_id`
[last_activity] => `lh_userdep`.`last_activity`
[hide_online] => `lh_userdep`.`hide_online`
[last_accepted] => `lh_userdep`.`last_accepted`
[active_chats] => `lh_userdep`.`active_chats`
[erLhcoreClassModelUserDep] => lh_userdep
)
[quoteValues:protected] => 1
[intervalMap:protected] => Array
(
[SECOND] => SECOND
[MINUTE] => MINUTE
[HOUR] => HOUR
[DAY] => DAY
[MONTH] => MONTH
[YEAR] => YEAR
)
)
)
)
)
[1] => Array
(
[file] => /var/www/html/ezcomponents/PersistentObject/src/persistent_session.php
[line] => 194
[function] => find
[class] => ezcPersistentLoadHandler
[type] => ->
[args] => Array
(
[0] => ezcQuerySelect Object
(
[selectString:protected] => SELECT `lh_userdep`.`id`, `lh_userdep`.`user_id`, `lh_userdep`.`dep_id`, `lh_userdep`.`last_activity`, `lh_userdep`.`hide_online`, `lh_userdep`.`last_accepted`, `lh_userdep`.`active_chats`
[fromString:protected] => FROM `lh_userdep`
[useIndexString:protected] =>
[whereString:protected] => WHERE `lh_userdep`.`last_activity` > :ezcValue1
[groupString:protected] => GROUP BY `lh_userdep`.`user_id`
[havingString:protected] =>
[orderString:protected] => ORDER BY active_chats DESC, hide_online ASC
[limitString:protected] => LIMIT 10 OFFSET 0
[lastInvokedMethod:protected] => order
[lockString:protected] =>
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => 6xaz8m4r
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => test_livehelperchat
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=test_livehelperchat;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQuery:private] => Array
(
[id] => `lh_userdep`.`id`
[user_id] => `lh_userdep`.`user_id`
[dep_id] => `lh_userdep`.`dep_id`
[last_activity] => `lh_userdep`.`last_activity`
[hide_online] => `lh_userdep`.`hide_online`
[last_accepted] => `lh_userdep`.`last_accepted`
[active_chats] => `lh_userdep`.`active_chats`
[erLhcoreClassModelUserDep] => lh_userdep
)
[boundCounter:ezcQuery:private] => 1
[boundParameters:ezcQuery:private] => Array
(
)
[boundParametersType:ezcQuery:private] => Array
(
)
[boundValues:ezcQuery:private] => Array
(
[:ezcValue1] => 1496541103
)
[boundValuesType:ezcQuery:private] => Array
(
[:ezcValue1] => 2
)
[expr] => ezcQueryExpression Object
(
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => 6xaz8m4r
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => test_livehelperchat
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=test_livehelperchat;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQueryExpression:private] => Array
(
[id] => `lh_userdep`.`id`
[user_id] => `lh_userdep`.`user_id`
[dep_id] => `lh_userdep`.`dep_id`
[last_activity] => `lh_userdep`.`last_activity`
[hide_online] => `lh_userdep`.`hide_online`
[last_accepted] => `lh_userdep`.`last_accepted`
[active_chats] => `lh_userdep`.`active_chats`
[erLhcoreClassModelUserDep] => lh_userdep
)
[quoteValues:protected] => 1
[intervalMap:protected] => Array
(
[SECOND] => SECOND
[MINUTE] => MINUTE
[HOUR] => HOUR
[DAY] => DAY
[MONTH] => MONTH
[YEAR] => YEAR
)
)
)
[1] => erLhcoreClassModelUserDep
)
)
[2] => Array
(
[file] => /var/www/html/lib/models/lhdepartament/erlhcoreclassmodeluserdep.php
[line] => 144
[function] => find
[class] => ezcPersistentSession
[type] => ->
[args] => Array
(
[0] => ezcPersistentFindQuery Object
(
[properties:protected] => Array
(
[className] => erLhcoreClassModelUserDep
[query] => ezcQuerySelect Object
(
[selectString:protected] => SELECT `lh_userdep`.`id`, `lh_userdep`.`user_id`, `lh_userdep`.`dep_id`, `lh_userdep`.`last_activity`, `lh_userdep`.`hide_online`, `lh_userdep`.`last_accepted`, `lh_userdep`.`active_chats`
[fromString:protected] => FROM `lh_userdep`
[useIndexString:protected] =>
[whereString:protected] => WHERE `lh_userdep`.`last_activity` > :ezcValue1
[groupString:protected] => GROUP BY `lh_userdep`.`user_id`
[havingString:protected] =>
[orderString:protected] => ORDER BY active_chats DESC, hide_online ASC
[limitString:protected] => LIMIT 10 OFFSET 0
[lastInvokedMethod:protected] => order
[lockString:protected] =>
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => 6xaz8m4r
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => test_livehelperchat
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=test_livehelperchat;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQuery:private] => Array
(
[id] => `lh_userdep`.`id`
[user_id] => `lh_userdep`.`user_id`
[dep_id] => `lh_userdep`.`dep_id`
[last_activity] => `lh_userdep`.`last_activity`
[hide_online] => `lh_userdep`.`hide_online`
[last_accepted] => `lh_userdep`.`last_accepted`
[active_chats] => `lh_userdep`.`active_chats`
[erLhcoreClassModelUserDep] => lh_userdep
)
[boundCounter:ezcQuery:private] => 1
[boundParameters:ezcQuery:private] => Array
(
)
[boundParametersType:ezcQuery:private] => Array
(
)
[boundValues:ezcQuery:private] => Array
(
[:ezcValue1] => 1496541103
)
[boundValuesType:ezcQuery:private] => Array
(
[:ezcValue1] => 2
)
[expr] => ezcQueryExpression Object
(
[db:protected] => ezcDbHandlerMysql Object
(
[identifierQuoteChars:protected] => Array
(
[start] => `
[end] => `
)
[dbParams:ezcDbHandlerMysql:private] => Array
(
[phptype] => mysql
[dbsyntax] => mysql
[username] => root
[password] => 6xaz8m4r
[protocol] => tcp
[hostspec] => 127.0.0.1
[port] => 3306
[socket] =>
[database] => test_livehelperchat
)
[dsn:ezcDbHandlerMysql:private] => mysql:dbname=test_livehelperchat;host=127.0.0.1;port=3306
[reconnectedCounter:ezcDbHandlerMysql:private] => 0
[transactionNestingLevel:protected] => 0
[transactionErrorFlag:protected] =>
)
[aliases:ezcQueryExpression:private] => Array
(
[id] => `lh_userdep`.`id`
[user_id] => `lh_userdep`.`user_id`
[dep_id] => `lh_userdep`.`dep_id`
[last_activity] => `lh_userdep`.`last_activity`
[hide_online] => `lh_userdep`.`hide_online`
[last_accepted] => `lh_userdep`.`last_accepted`
[active_chats] => `lh_userdep`.`active_chats`
[erLhcoreClassModelUserDep] => lh_userdep
)
[quoteValues:protected] => 1
[intervalMap:protected] => Array
(
[SECOND] => SECOND
[MINUTE] => MINUTE
[HOUR] => HOUR
[DAY] => DAY
[MONTH] => MONTH
[YEAR] => YEAR
)
)
)
)
)
)
)
[3] => Array
(
[file] => /var/www/html/lib/models/lhdepartament/erlhcoreclassmodeluserdep.php
[line] => 176
[function] => getList
[class] => erLhcoreClassModelUserDep
[type] => ::
[args] => Array
(
[0] => Array
(
[filtergt] => Array
(
[last_activity] => 1496541103
)
[limit] => 10
[sort] => active_chats DESC, hide_online ASC
[groupby] => user_id
)
)
)
[4] => Array
(
[file] => /var/www/html/cache/compiledtemplates/796731c98c736092a7f4fc8d2ee2b83b.php
[line] => 2
[function] => getOnlineOperators
[class] => erLhcoreClassModelUserDep
[type] => ::
[args] => Array
(
[0] => erLhcoreClassUser Object
(
[userid:erLhcoreClassUser:private] => 1
[AccessArray:erLhcoreClassUser:private] => Array
(
[*] => Array
(
[*] => 1
)
)
[AccessTimestamp:erLhcoreClassUser:private] => 1496626187
[authentication] =>
[session] => ezcAuthenticationSession Object
(
[options:protected] => ezcAuthenticationSessionOptions Object
(
[properties:protected] => Array
(
[validity] => 86400
[idKey] => lhc_ezcAuth_id
[timestampKey] => lhc_ezcAuth_timestamp
)
)
)
[credentials] => ezcAuthenticationPasswordCredentials Object
(
[id] => admin
[password] =>
)
[authenticated] => 1
[status] =>
[filter] =>
)
[1] => 1
[2] => Array
(
)
[3] => 10
[4] => 300
)
)
[5] => Array
(
[file] => /var/www/html/lib/core/lhcore/lhmodule.php
[line] => 98
[args] => Array
(
[0] => /var/www/html/cache/compiledtemplates/796731c98c736092a7f4fc8d2ee2b83b.php
)
[function] => include
)
[6] => Array
(
[file] => /var/www/html/lib/core/lhcore/lhmodule.php
[line] => 486
[function] => runModule
[class] => erLhcoreClassModule
[type] => ::
[args] => Array
(
)
)
[7] => Array
(
[file] => /var/www/html/index.php
[line] => 39
[function] => moduleInit
[class] => erLhcoreClassModule
[type] => ::
[args] => Array
(
)
)
)
[previous:Exception:private] =>
)I'll try to fix it, but any recomendations are welcome.
Last edited by alex43210 (2017-06-04 02:40:11)
Offline
#2 2017-06-04 02:09:37
- alex43210
- Member
- Registered: 2017-05-14
- Posts: 11
Re: 503 in syncadmininterface/(limita)/10/(limitu)/10/(limitp)/10/(limito)
I fixed error. It's found that this error is mysql-related.
Firstly about my installation:
[== Undefined ==]
# mysql --version
mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper
# cat /etc/lsb*
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION="Ubuntu 16.04.2 LTS"When trying to execute next query (build from exception message):
[== Undefined ==]
SELECT `lh_userdep`.`id`, `lh_userdep`.`user_id`, `lh_userdep`.`dep_id`, `lh_userdep`.`last_activity`, `lh_userdep`.`hide_online`, `lh_userdep`.`last_accepted`, `lh_userdep`.`active_chats` FROM `lh_userdep` WHERE `lh_userdep`.`last_activity` > 1496541103 GROUP BY `lh_userdep`.`user_id` ORDER BY active_chats DESC, hide_online ASC LIMIT 10 OFFSET 0;I getted
[== Undefined ==]
ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test_livehelperchat.lh_userdep.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_bySo - I added next to /etc/mysql/my.cnf
[== Undefined ==]
[ mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"And restarted mysql (sudo service mysql restart). Now I haven't this error
Offline
#3 2017-06-04 05:07:09
- PeopleInside
- Administrator
- From: Italy
- Registered: 2014-04-10
- Posts: 4,046
- Website
Re: 503 in syncadmininterface/(limita)/10/(limitu)/10/(limitp)/10/(limito)
Hi alex43210, how are you?
Thank you for your post report.
May I ask if you are able to see the same error in the live helper chat demo ( livehelperchat.com ) ?
If yes could you take a screenshot and maybe report this issue in GitHub?
Thank you again,
wish you a nice time and day! 
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
#4 2017-06-04 07:00:41
- alex43210
- Member
- Registered: 2017-05-14
- Posts: 11
Re: 503 in syncadmininterface/(limita)/10/(limitu)/10/(limitp)/10/(limito)
PeopleInside wrote:
Hi alex43210, how are you?
Thanks, as I written - I fixed current problem by setting sql_mode in MySQL settings.
PeopleInside wrote:
maybe report this issue in GitHub?
https://github.com/LiveHelperChat/liveh … ssues/1035 - all I know about problem now :-)
Offline
#5 2017-06-04 07:03:41
- PeopleInside
- Administrator
- From: Italy
- Registered: 2014-04-10
- Posts: 4,046
- Website
Re: 503 in syncadmininterface/(limita)/10/(limitu)/10/(limitp)/10/(limito)
alex43210 I asked to test before in the live helper chat demo before open a GitHub topic,
seems you read only what you want read in my reply and you never tested in the demo.
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