Search found 5 matches

by GodOfWonders
10 Mar 2020, 21:32
Forum: Support and Help
Topic: SQL syntax error
Replies: 2
Views: 5207

Re: SQL syntax error

I can do whatever testing you need. I have a couple of servers that I have with 1.6 and would be willing to help out with bug testing on 1 of them if needed.
by GodOfWonders
25 Nov 2019, 04:39
Forum: Bugs
Topic: Another Search Page Error
Replies: 4
Views: 2567

Re: Another Search Page Error

I was able to bypass the error by adding $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 // sql functions funct...
by GodOfWonders
24 Nov 2019, 22:25
Forum: Bugs
Topic: Another Search Page Error
Replies: 4
Views: 2567

Re: Another Search Page Error

Also get this on the Server page: 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'...
by GodOfWonders
24 Nov 2019, 22:23
Forum: Bugs
Topic: Another Search Page Error
Replies: 4
Views: 2567

Re: Another Search Page Error

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.
by GodOfWonders
24 Nov 2019, 21:15
Forum: Bugs
Topic: Another Search Page Error
Replies: 4
Views: 2567

Another Search Page Error

I get this error when I now click on search. 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 on...