StatsLog overwrites StatsLog

[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

[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.

[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.

[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.

[Panther]

I've added full support for match warmups - all appropriate variables are reset upon the second start game tag.

[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

[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

[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 :/

[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.

[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)

[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?

[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?

[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