Page 1 of 1
StatsLog overwrites StatsLog
Posted: Mon Oct 20, 2008 12:30 pm
by Donzi
UT3 ,3602 Linux, UTstats 1.02, UTstatsDB 3.05
If run 2 Servers in 1 Directory (2 ConfigPaths, 1 Logpath)
I start Server 1, got a Logfile (StatsFile_Server1).
Starts Server 2, it overwrites/delete StatsFile_Server1, got a StatsFile_Server2
any hints?
And Update 3.04 to 3.05 all Servernames are gone ^^ maybe its all "sv_shortname" to display the names.
(i run UT99, UT2004 and UT3 Servers with UTstatsDB)
//Edit, i found it in the Config "Use Short Name:"
//Edit 2
Code: Select all
Warning: reset() [function.reset]: Passed variable is not an array or object in matchstats.php on line 1587
in all UT2004-Matches since the update
Re: StatsLog overwrites StatsLog
Posted: Mon Oct 20, 2008 1:45 pm
by Panther
The stat files should have time stamps and appear as: Stats-20081020.133242.log
While this doesn't make it impossible for one to get overwritten, it should be rare. I will make future versions include the server port in the filename though. Please send a log file from UT2004.
Re: StatsLog overwrites StatsLog
Posted: Mon Oct 20, 2008 3:43 pm
by Donzi
Code: Select all
Initializing ftp file transfer.
Connected to '' on port '21' for user '.
Enabling passive mode.
Successfully changed ftp directory to '/ut2004/UserLogs/'.
Downloading log 'Stats_64000_2008_10_20_22_31_18.log'....successful - deleted.
Downloading log 'Stats_15000_2008_10_20_22_36_22.log'....successful - deleted.
Downloading log 'Stats_15000_2008_10_20_22_51_54.log'....successful - deleted.
Downloading log 'Stats_64000_2008_10_20_23_12_20.log'....successful - deleted.
Downloading log 'Stats_15000_2008_10_20_23_13_08.log'....successful - deleted.
Downloading log 'Stats_15000_2008_10_20_23_26_34.log'....successful - deleted.
Downloading log 'Stats_64000_2008_10_20_23_30_30.log'....successful - deleted.
Downloading log 'Stats_64000_2008_10_20_23_48_53.log'....successful - deleted.
Downloading log 'Stats_15000_2008_10_20_23_49_35.log'....successful - deleted.
Downloading log 'Stats_64000_2008_10_21_00_01_14.log'....successful - deleted.
Downloading log 'Stats_15000_2008_10_21_00_10_08.log'....successful - deleted.
Downloading log 'Stats_64000_2008_10_21_00_21_03.log'....successful - deleted.
Initializing ftp file transfer.
Connected to '' on port '21' for user ''.
Enabling passive mode.
Successfully changed ftp directory to '/ut/Logs/'.
Downloading log 'Unreal.ngLog.2008.10.19.18.57.36.11337.log'....successful - deleted.
Initializing ftp file transfer.
Connected to '' on port '21' for user ''.
Enabling passive mode.
Successfully changed ftp directory to '/ut3/UTGame/Logs/'.
Downloading log 'Stats-20081020.232146.log'....successful - deleted.
Downloading log 'Stats-20081020.234313.log'....successful - deleted.
Downloading log 'Stats-20081020.235628.log'....successful - deleted.
Downloading log 'Stats-20081021.001305.log'....successful - deleted.
Setting permissions in directory '/UserLogs/' for 'Stats_*':
Processing directory '/serverstats/UserLogs/' for 'Stats_*':
Processing log 'Stats_64000_2008_10_20_20_37_31.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_20_20_44_14.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_20_21_01_27.log'...bad parse in database.
Processing log 'Stats_64000_2008_10_20_21_02_08.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_20_21_18_41.log'...bad parse in database.
Processing log 'Stats_64000_2008_10_20_21_32_46.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_20_21_35_16.log'...bad parse in database.
Processing log 'Stats_64000_2008_10_20_21_49_35.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_20_21_51_26.log'...bad parse in database.
Processing log 'Stats_64000_2008_10_20_22_07_16.log'...bad parse in database.
Processing log 'Stats_64000_2008_10_20_22_09_41.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_20_22_13_30.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_20_22_24_36.log'...bad parse in database.
Processing log 'Stats_64000_2008_10_20_22_31_18.log'...Error saving player data in database.
Backuped the Logs.
Re: StatsLog overwrites StatsLog
Posted: Mon Oct 20, 2008 3:51 pm
by Panther
Except for some of these matches having two start game tags, making for some weird data, they parse fine here. What database and version are you using, and was this a fresh install or an upgrade? What version of PHP? All this is required to post for support.
Re: StatsLog overwrites StatsLog
Posted: Mon Oct 20, 2008 4:24 pm
by Panther
I've added full support for match warmups - all appropriate variables are reset upon the second start game tag.
Re: StatsLog overwrites StatsLog
Posted: Tue Oct 21, 2008 12:49 am
by Donzi
What database and version are you using, and was this a fresh install or an upgrade? What version of PHP? All this is required to post for support.

sry
Upgrade to 3.05, Apache/2.2.3 (Debian) PHP/5.2.6-0.dotdeb.1 with Suhosin-Patch , MySQL-Server 5.0.67-0.dotdeb.1
I remember that I had an error in "gplayers" wenn i update the database

Re: StatsLog overwrites StatsLog
Posted: Tue Oct 21, 2008 2:55 am
by Donzi
I had fixed the php-errors with an DB-Backup.
Imported the Backup and updated the UTstatsDB once more.
had an error in gplayers, maybe a filetransfer-problem of the first FTP-Update
hope this fix the UT3-Stats.Log too
//Edit, Nope, all errors are the same
Re: StatsLog overwrites StatsLog
Posted: Tue Oct 21, 2008 5:31 am
by Donzi
Code: Select all
Warning: reset() [function.reset]: Passed variable is not an array or object in /serverstats/matchstats.php on line 1587
Code: Select all
Setting permissions in directory '/serverstats/UserLogs/' for 'Stats_*':
Processing directory '/serverstats/UserLogs/' for 'Stats_*':
Processing log 'Stats_64000_2008_10_21_12_16_01.log'...bad parse in database.
Processing log 'Stats_64000_2008_10_21_12_29_00.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_21_13_32_18.log'...bad parse in database.
Processing log 'Stats_15000_2008_10_21_13_51_18.log'...bad parse in database.
0 of 4 logs processed - No new logs added.
Setting permissions in directory '/serverstats/UserLogs/' for 'Unreal.ngLog.*':
Processing directory '/serverstats/UserLogs/' for 'Unreal.ngLog.*':
No log files to process.
Setting permissions in directory '/serverstats/UserLogs/' for 'Stats-*':
Processing directory '/serverstats/UserLogs/' for 'Stats-*':
Processing log 'Stats-20081021.123748.log'...bad parse in database.
Processing log 'Stats-20081021.123852.log'...bad parse in database.
Processing log 'Stats-20081021.124334.log'...bad parse in database.
Processing log 'Stats-20081021.124557.log'...bad parse in database.
Processing log 'Stats-20081021.124735.log'...bad parse in database.
Processing log 'Stats-20081021.124939.log'...bad parse in database.
0 of 6 logs processed - No new logs added.
Uff. create SQL-Error in my DB.... i reinitialize the complete DB :/
Re: StatsLog overwrites StatsLog
Posted: Tue Oct 21, 2008 10:29 am
by Panther
I had fixed the php-errors with an DB-Backup.
Imported the Backup and updated the UTstatsDB once more.
had an error in gplayers, maybe a filetransfer-problem of the first FTP-Update
The problem is likely with this error you're having in gplayers. What version are you upgrading from? Perhaps if you send me the backup from before the upgrade I can see where it's going wrong.
Re: StatsLog overwrites StatsLog
Posted: Tue Oct 21, 2008 10:49 am
by Donzi
i had made a big mistake....
all sql-files in /tables/mysql/are 303
the php´s are 303
than i only uploaded the 304 php´s, not the 304 sql´s......
than i updated to 305 (all files)
dont know why the hell i do this....drunked or/and tired ^^
ill send u per pm 2 zip´s, 1 from 19.10.2008 and 1 from 20.10.2008 (SQL-backups from my root)
Re: StatsLog overwrites StatsLog
Posted: Wed Oct 22, 2008 3:19 am
by Donzi
okay
i had reset all.
- uploaded/configured UTstatsDB 3.03, insert my DB-backup with 3.03
- Parse Logs --> OK
- uploaded UTstatsDB 3.04
- updated Database to 3.04 (no errors)
- Parse Logs --> OK
- uploaded UTstatsDB 3.05
- updated Databse to 3.05 (no errors)
- Parse Logs --> Error
*snip*
Code: Select all
Processing log 'Unreal.ngLog.2008.10.21.12.14.31.11337.log'...*Error in database query: 'REPLACE INTO ut_players VALUES
1136: Column count doesn't match value count at row 1
Error saving player data in database.
Processing log 'Stats_15000_2008_10_20_00_15_28.log'...*Error in database query: 'REPLACE INTO ut_players VALUES
1136: Column count doesn't match value count at row 1
Error saving player data in database.
Processing log 'Stats-20081021.200937.log'...*Error in database query: 'REPLACE INTO ut_players VALUES
1136: Column count doesn't match value count at row 1
Error saving player data in database.
HOLYSHIT!
We had modified before 8 months the includes/logsave.php
Code: Select all
/* UTzone TAM */
$plr_overkill, $plr_darkhorse, $plr_bukkake
/* UTzone TAM Ende */
and these 3 tables brings up the errors....
i delete them, allready ok!
can you add the TAM-Kills?

Re: StatsLog overwrites StatsLog
Posted: Wed Oct 22, 2008 11:52 am
by Panther
We had modified before 8 months the includes/logsave.php
Code: Select all
/* UTzone TAM */
$plr_overkill, $plr_darkhorse, $plr_bukkake
/* UTzone TAM Ende */
and these 3 tables brings up the errors....
i delete them, allready ok!
can you add the TAM-Kills?

Glad that's figured out. TAM-Kills? What are those?
Re: StatsLog overwrites StatsLog
Posted: Thu Oct 23, 2008 3:49 am
by Donzi
Custom Announcements:
-Overkill - awarded for excessive damage in killing an enemy. Must do at least 50 hp more than necessary
AND at least double the damage of the remaining health. For example, 55 hp damage necessary to
Overkill an enemy with 5 health, 120 damage necessary to Overkill an enemy with 60 health.
-DarkHorse - awarded for winning a 1v3 situation to win the round.
Bukkake like HeadHunter, 5 or 6 Kills with BioRifle