MySQLQuerierException

invalid query. (ERRNO 1055) Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fah-addict-fr.phpboost_stats_referer.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
query: SELECT id, count(*) as count, relative_url, SUM(total_visit) as total_visit, SUM(today_visit) as today_visit, SUM(yesterday_visit) as yesterday_visit, nbr_day, MAX(last_update) as last_update
FROM phpboost_stats_referer
WHERE type = 1
GROUP BY relative_url
ORDER BY total_visit DESC
LIMIT 15 OFFSET 0
STACKTRACE
METHODFILELINE
+MySQLQuerier->execute(string, array)/kernel/framework/io/db/driver/mysql/MySQLQuerier.class.php48
+MySQLQuerier->select(string, array, int)/kernel/framework/io/db/DBQuerier.class.php50
+DBQuerier->select(string, array, int)/kernel/framework/db/Sql.class.php548
+Sql->select(string)/kernel/framework/db/Sql.class.php164
+Sql->query_while(string, int, string)/stats/phpboost/StatsHomePageExtensionPoint.class.php1024
StatsHomePageExtensionPoint->get_view()/stats/phpboost/StatsHomePageExtensionPoint.class.php39
StatsHomePageExtensionPoint->get_home_page()/stats/stats.php36
output buffer
You see this page because your site is configured to use the DEBUG mode.
If you want to see the related user error page, you have to disable the DEBUG mode from the administration panel.
HTTP Request
GET
keyword1
SERVER
REDIRECT_STATUS200
HTTP_USER_AGENTCCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_HOSTfr.fah-addict.net
HTTP_CONNECTIONKeep-Alive
HTTP_ACCEPT_ENCODINGgzip
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE
SERVER_SOFTWAREApache/2.4.18 (Ubuntu)
SERVER_NAMEfr.fah-addict.net
SERVER_ADDR87.98.172.206
SERVER_PORT80
REMOTE_ADDR34.203.245.76
DOCUMENT_ROOT/home/fah-addict-fr
REQUEST_SCHEMEhttp
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT/home/fah-addict-fr
SERVER_ADMINadmin@fah-addict.net
SCRIPT_FILENAME/home/fah-addict-fr/stats/stats.php
REMOTE_PORT60570
REDIRECT_URL/stats/stats-keyword.php
REDIRECT_QUERY_STRINGkeyword=1
GATEWAY_INTERFACECGI/1.1
SERVER_PROTOCOLHTTP/1.1
REQUEST_METHODGET
QUERY_STRINGkeyword=1
REQUEST_URI/stats/stats-keyword.php
SCRIPT_NAME/stats/stats.php
PHP_SELF/stats/stats.php
REQUEST_TIME_FLOAT1547710779.793
REQUEST_TIME1547710779