Another Search Page Error

Found a bug? post about it here and your fix if you have one and we will review it and make them part of the official release.
GodOfWonders
Posts: 4
Joined: 24 Nov 2019, 21:10

Another Search Page Error

Postby GodOfWonders » 24 Nov 2019, 21:15

I get this error when I now click on search.

Code: Select all

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'clanlod_amxbans.amx_bans.admin_nick' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

This only recently started happening so I believe maybe a php update?
Database server I'm using:

Code: Select all

Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.7.27 - Gentoo Linux mysql-5.7.27-r1
Protocol version: 10
User: clanlod@localhost
Server charset: UTF-8 Unicode (utf8)

Webserver I'm using:

Code: Select all

Apache
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.2.24

User avatar
indianiso1
Posts: 137
Joined: 16 Oct 2015, 01:59
Contact:

Re: Another Search Page Error

Postby indianiso1 » 24 Nov 2019, 22:19

It depends only on database - maybe there was an update in db version or some config changes.

GodOfWonders
Posts: 4
Joined: 24 Nov 2019, 21:10

Re: Another Search Page Error

Postby GodOfWonders » 24 Nov 2019, 22:23

I use a different database for every plugin or system I use so AMX Bans runs off it's own database. Nothing has been directly changed or altered that I know of within the database itself that hasn't been done through the web interface.

GodOfWonders
Posts: 4
Joined: 24 Nov 2019, 21:10

Re: Another Search Page Error

Postby GodOfWonders » 24 Nov 2019, 22:25

Also get this on the Server page:

Code: Select all

Warning: Use of undefined constant amxmodx_version - assumed 'amxmodx_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 75

Warning: Use of undefined constant amxmodx_version - assumed 'amxmodx_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 75

Warning: Use of undefined constant amxbans_version - assumed 'amxbans_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 76

Warning: Use of undefined constant amxbans_version - assumed 'amxbans_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 76

Warning: Use of undefined constant metamod_version - assumed 'metamod_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 77

Warning: Use of undefined constant metamod_version - assumed 'metamod_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 77

Warning: Use of undefined constant hltv_report - assumed 'hltv_report' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 78

Warning: Use of undefined constant atac_version - assumed 'atac_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 79

Warning: Use of undefined constant atac_version - assumed 'atac_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 79

Warning: Use of undefined constant secure - assumed 'secure' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 82

Warning: Use of undefined constant sbsrv_version - assumed 'sbsrv_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 83

Warning: Use of undefined constant hlg_version - assumed 'hlg_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 84

Warning: Use of undefined constant type - assumed 'type' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 89

Warning: Use of undefined constant version - assumed 'version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 90

Warning: Use of undefined constant name - assumed 'name' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 91

Warning: Use of undefined constant map - assumed 'map' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 92

Warning: Use of undefined constant mod - assumed 'mod' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 93

Warning: Use of undefined constant game - assumed 'game' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 94

Warning: Use of undefined constant appid - assumed 'appid' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 95

Warning: Use of undefined constant activeplayers - assumed 'activeplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 96

Warning: Use of undefined constant maxplayers - assumed 'maxplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 97

Warning: Use of undefined constant botplayers - assumed 'botplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 98

Warning: Use of undefined constant dedicated - assumed 'dedicated' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 99

Warning: Use of undefined constant os - assumed 'os' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 100

Warning: Use of undefined constant password - assumed 'password' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 101

Warning: Use of undefined constant secure - assumed 'secure' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 102

Warning: Use of undefined constant sversion - assumed 'sversion' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 103

Warning: Use of undefined constant amx_timeleft - assumed 'amx_timeleft' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 104

Warning: Use of undefined constant mp_maxrounds - assumed 'mp_maxrounds' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 105

Warning: Use of undefined constant mp_timelimit - assumed 'mp_timelimit' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 106

Warning: Use of undefined constant amx_nextmap - assumed 'amx_nextmap' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 107

Warning: Use of undefined constant mp_friendlyfire - assumed 'mp_friendlyfire' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 108

Warning: Use of undefined constant activeplayers - assumed 'activeplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 116

Warning: Use of undefined constant players - assumed 'players' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 130

Warning: Use of undefined constant amxmodx_version - assumed 'amxmodx_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 75

Warning: Use of undefined constant amxmodx_version - assumed 'amxmodx_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 75

Warning: Use of undefined constant amxbans_version - assumed 'amxbans_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 76

Warning: Use of undefined constant amxbans_version - assumed 'amxbans_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 76

Warning: Use of undefined constant metamod_version - assumed 'metamod_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 77

Warning: Use of undefined constant metamod_version - assumed 'metamod_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 77

Warning: Use of undefined constant hltv_report - assumed 'hltv_report' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 78

Warning: Use of undefined constant atac_version - assumed 'atac_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 79

Warning: Use of undefined constant secure - assumed 'secure' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 82

Warning: Use of undefined constant sbsrv_version - assumed 'sbsrv_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 83

Warning: Use of undefined constant hlg_version - assumed 'hlg_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 84

Warning: Use of undefined constant type - assumed 'type' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 89

Warning: Use of undefined constant version - assumed 'version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 90

Warning: Use of undefined constant name - assumed 'name' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 91

Warning: Use of undefined constant map - assumed 'map' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 92

Warning: Use of undefined constant mod - assumed 'mod' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 93

Warning: Use of undefined constant game - assumed 'game' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 94

Warning: Use of undefined constant appid - assumed 'appid' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 95

Warning: Use of undefined constant activeplayers - assumed 'activeplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 96

Warning: Use of undefined constant maxplayers - assumed 'maxplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 97

Warning: Use of undefined constant botplayers - assumed 'botplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 98

Warning: Use of undefined constant dedicated - assumed 'dedicated' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 99

Warning: Use of undefined constant os - assumed 'os' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 100

Warning: Use of undefined constant password - assumed 'password' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 101

Warning: Use of undefined constant secure - assumed 'secure' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 102

Warning: Use of undefined constant sversion - assumed 'sversion' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 103

Warning: Use of undefined constant amx_timeleft - assumed 'amx_timeleft' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 104

Warning: Use of undefined constant mp_maxrounds - assumed 'mp_maxrounds' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 105

Warning: Use of undefined constant mp_timelimit - assumed 'mp_timelimit' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 106

Warning: Use of undefined constant amx_nextmap - assumed 'amx_nextmap' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 107

Warning: Use of undefined constant mp_friendlyfire - assumed 'mp_friendlyfire' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 108

Warning: Use of undefined constant activeplayers - assumed 'activeplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 116

Warning: Use of undefined constant players - assumed 'players' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 130

Warning: Use of undefined constant amxmodx_version - assumed 'amxmodx_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 75

Warning: Use of undefined constant amxmodx_version - assumed 'amxmodx_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 75

Warning: Use of undefined constant amxbans_version - assumed 'amxbans_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 76

Warning: Use of undefined constant amxbans_version - assumed 'amxbans_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 76

Warning: Use of undefined constant metamod_version - assumed 'metamod_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 77

Warning: Use of undefined constant metamod_version - assumed 'metamod_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 77

Warning: Use of undefined constant hltv_report - assumed 'hltv_report' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 78

Warning: Use of undefined constant atac_version - assumed 'atac_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 79

Warning: Use of undefined constant secure - assumed 'secure' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 82

Warning: Use of undefined constant sbsrv_version - assumed 'sbsrv_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 83

Warning: Use of undefined constant hlg_version - assumed 'hlg_version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 84

Warning: Use of undefined constant type - assumed 'type' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 89

Warning: Use of undefined constant version - assumed 'version' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 90

Warning: Use of undefined constant name - assumed 'name' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 91

Warning: Use of undefined constant map - assumed 'map' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 92

Warning: Use of undefined constant mod - assumed 'mod' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 93

Warning: Use of undefined constant game - assumed 'game' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 94

Warning: Use of undefined constant appid - assumed 'appid' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 95

Warning: Use of undefined constant activeplayers - assumed 'activeplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 96

Warning: Use of undefined constant maxplayers - assumed 'maxplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 97

Warning: Use of undefined constant botplayers - assumed 'botplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 98

Warning: Use of undefined constant dedicated - assumed 'dedicated' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 99

Warning: Use of undefined constant os - assumed 'os' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 100

Warning: Use of undefined constant password - assumed 'password' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 101

Warning: Use of undefined constant secure - assumed 'secure' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 102

Warning: Use of undefined constant sversion - assumed 'sversion' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 103

Warning: Use of undefined constant amx_timeleft - assumed 'amx_timeleft' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 104

Warning: Use of undefined constant mp_maxrounds - assumed 'mp_maxrounds' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 105

Warning: Use of undefined constant mp_timelimit - assumed 'mp_timelimit' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 106

Warning: Use of undefined constant amx_nextmap - assumed 'amx_nextmap' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 107

Warning: Use of undefined constant mp_friendlyfire - assumed 'mp_friendlyfire' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 108

Warning: Use of undefined constant activeplayers - assumed 'activeplayers' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 116

Warning: Use of undefined constant players - assumed 'players' (this will throw an Error in a future version of PHP) in /usr/www/clanlod/public/amxbans/view.php on line 130

GodOfWonders
Posts: 4
Joined: 24 Nov 2019, 21:10

Re: Another Search Page Error

Postby GodOfWonders » 25 Nov 2019, 04:39

I was able to bypass the error by adding

Code: Select all

$query=$mysql->query("SET SESSION sql_mode = '';");
to sql.inc.php. The error is due to SQL running in strict mode. I use a service that doesn't allow you to change it in global settings so you have to do it per session. So where it has

Code: Select all

// sql functions
function sql_set_websettings() {
   global $config, $mysql;
   $query = $mysql->query("SELECT * FROM `".$config->db_prefix."_webconfig`") or die ($mysql->error);
   $result = $query->fetch_object();

you change it to

Code: Select all

// sql functions
function sql_set_websettings() {
   global $config, $mysql;
   $query=$mysql->query("SET SESSION sql_mode = '';");
   $query = $mysql->query("SELECT * FROM `".$config->db_prefix."_webconfig`") or die ($mysql->error);
   $result = $query->fetch_object();

and it will bypass the error each session and allow the search form to display again. With MySQL changing how it handles different functions now I believe there's somewhere in the code that it's not passing strict mode that was fine before. I've had this happen to me with several other php scripts. This only temporarily fixes the problem but I'll see if I can dive deeper into it to see what needs to be altered for it to pass strict mode without having to disable strict mode. I'm still looking into the server page error.


Return to “Bugs”

Who is online

Users browsing this forum: No registered users and 0 guests