AMXBans 6.14.4 - Unable to Login & Search 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.
milly
Posts: 3
Joined: 03 Mar 2019, 22:34

AMXBans 6.14.4 - Unable to Login & Search error

Postby milly » 03 Mar 2019, 22:38

Hello, I have followed this thread to see if it can fix my amxbans install but I am still unable to get it to work because it was not creating the mysql tables. I had the same errors in that thread.
viewtopic.php?t=550

Following that thread, I am now able to get the tables to be created properly, but when I try to login, it's not able to sign me in.
I've tried entering the details for webadmin manually through phpmyadmin and still won't go.

Details of the webserver:

PHP Version 7.1.26
MySQL Version mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
safe_mode Off
register_globals Off
magic_quotes_gpc Off
upload_max_filesize 100M (104857600 bytes)
max_execution_time 30 Seconds

What should I look into?

Creating the table structure
amx_admins_servers successfully created
amx_amxadmins successfully created
amx_bans successfully created
amx_bans_edit successfully created
amx_bbcode successfully created
amx_comments successfully created
amx_files successfully created
amx_levels successfully created
amx_logs successfully created
amx_modulconfig successfully created
amx_reasons successfully created
amx_reasons_set successfully created
amx_reasons_to_set successfully created
amx_serverinfo successfully created
amx_smilies successfully created
amx_usermenu successfully created
amx_webadmins successfully created
amx_webconfig successfully created
amx_flagged successfully created
Enter required data
amx_bbcode successfully registered
amx_smilies successfully registered

Enter settings
Website successfully registered

Set user menu
User menu successfully registered

Install module
iexport successfully registered

Create web admin
Webadmin level successfully registered
Webadmin data failed


After installing, when I click on Search, I get the below error message
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'abc_abans.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

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

Postby indianiso1 » 04 Mar 2019, 14:09

Thank you for bug report. WIll be fixed someday.
Have you tried to upgrade MySQL?

P.S. Transferred to 'Bugs' section.

milly
Posts: 3
Joined: 03 Mar 2019, 22:34

Re: AMXBans 6.14.4 - Unable to Login & Search error

Postby milly » 08 Mar 2019, 20:36

No, I cannot upgrade MySQL as it is on shared hosting with NFOservers

milly
Posts: 3
Joined: 03 Mar 2019, 22:34

Re: AMXBans 6.14.4 - Unable to Login & Search error

Postby milly » 10 Mar 2019, 17:53

I tried installing it on a VPS with Mysql version 5.7.23
Same results

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

Re: AMXBans 6.14.4 - Unable to Login & Search error

Postby indianiso1 » 14 Mar 2019, 08:39

And if you try to allow global `SELECT` permission? Don't remember what was the problem with it but definetly won't be anymore in next upgrade.
P.S. Next version seems to appear in this summer.


Return to “Bugs”

Who is online

Users browsing this forum: No registered users and 1 guest