Hey guys, I was having the same AJAX error that everyone else was having when attempting to use the Players or Staff tabs (Error that sent you here: https://datatables.net/manual/tech-notes/7) and figured out a solution, so I wanted to share.

For starters, it appears the file /inc/server_processing.php was causing a 404 error, which in turn made DataTables put off an error. The datatables.net page that it links to does not really offer a solution, only ideas to point you in a direction. So I searched for why a php file that exists would put off a 404 error, which indicates a file does not exist. Apparently, the problem here is occurring because the server_processing.php file is creating a URL that is longer than stock web hosting setups allows (you can see this insanely long URL by looking at the developer tab in your browser).

I am no longer receiving the AJAX error and all pages are functioning correctly. This is on AChaosCoder's version, but this fix should also work on Sinclair's version as well, since it's putting out the same error.

ALTERNATIVELY, you can do this same thing a bit more simply by going into your web.config file and adding the following:

I just noticed that the plugin have some trouble dealing with local IP adresses.

I attached a picture showing a pice of a table that contain some of my servers. sometimes it register the external address, and others, it register the local adress. All the servers are on the same host, but running on different ports

In case anyone else has / had the same issues with the webpanel, at least the one I used from "theChaosCoder", this is what helped me. I got that from a reply on his end on Github.

Code:

It's a configuration problem on your end. You need to allow write permission for the folder /cache/SQL.

Code:

There are many tuts out there for this.
But for a quick test you could try to change the cache location
From
FileSystemCache::$cacheDir = $dir.'/../cache';
To
FileSystemCache::$cacheDir = '/tmp/player_analytics';
in app.php
https://github.com/theChaosCoder/player_analytics/blob/master/inc/app.php#L34

He replied twice on my issues, you see both replies above. For me, the first solution did it. Just in case more having the same issue.

Hey,
I have a problem with the webpanel, when I press on the players list I get this error:

Quote:

DataTables warning: table id=players - An SQL error occurred: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'csgotimes.player_analytics.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by