Troubleshooting

UTStats not working for you? Maybe the following will help:

Requirements

• Access to the Unreal Tournament log files
• PHP & MySQL enabled webserver
• PHP needs to allow ftpconnect etc. if you wish to use auto-ftp of logs

Errors and Warnings

UTStats is getting pretty old so errors or warnings you'll encounter are most likely caused by deprecated or functions that are not supported any more. If you find any please file an issue so it can be fixed.

MySQL Mode

Most database related errors are likely to be caused by MySQL STRICT Mode. You can fix these by clearing sql_mode in your MySQL config:

[mysqld]
sql_mode=""

Or by executing the following SQL statements:

SET GLOBAL sql_mode='';
SET SESSION sql_mode='';

To determine the current sql_mode value, use the following statements:

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

Known errors that might occur:

---

Incorrect integer value: '' for column 'team' at row 1

Errors similar to this are caused by the STRICT_ALL_TABLES or STRICT_TRANS_TABLES SQL Mode.
You can fix this by clearing the sql_mode value.

---

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'utstats.uts_player.gamescore' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Errors similar to this are caused by the ONLY_FULL_GROUP_BY SQL Mode.
You can fix this by clearing the sql_mode value.

Still Having a Problem?

Check the UTStats Forums on unrealadmin.org
File an issue - be sure to include as many details as possible.
Contact me on IRC (#passionategaming @ Quakenet.org)