Chat, GUID, Stats and Mapstats Logger[1.1.0.1][BF3]

[ImportBot]

Originally Posted by XpKiller*:

 

Then i need to look at it

do have set a time offset?

[ImportBot]

Originally Posted by Quax*:

 

Yea for shure, "-1" hour

[ImportBot]

Originally Posted by XpKiller*:

 

This setting is no timezone setting.

So if your procon server is in the same timezone as you it need to be on 0.

It is a offset to the current serevrtime.

Anyway look like this could cause the problems. So i need to look at this.

[ImportBot]

Originally Posted by Quax*:

 

Offcourse they should be in the same timezone but for real they are not, so I thought it had to be set to -1.

 

OK, now I will change it to "ZERO".

 

Further report will come.....

[ImportBot]

Originally Posted by Quax*:

 

OK have set the offset zo "0" and anything seem to be working correctly.

 

Thx @ XpKiller for your support but it should be deactivated or recoded in the future.

[ImportBot]

Originally Posted by XpKiller*:

 

@Quax

it seems only negative values make problems.

Need to review this part of code.

[ImportBot]

Originally Posted by IceCold*:

 

hi Xpkiller,

 

i have a Player Count of 1561 with this as a country code '--'

is this a county or an error ?

[ImportBot]

Originally Posted by DiD_StratManiac*:

 

I have the same, several players from the UK, Greece and others show as Unkown --

 

http://www.didstats.net/player_stats...countries=View

 

I wonder if the details are being blocked? The players country flag shows on their Battlelog & BF3Stats.

 

Any idea?

 

Strat

[ImportBot]

Originally Posted by Matt-One*:

 

hi Xpkiller,

 

i have a Player Count of 1561 with this as a country code '--'

is this a county or an error ?

I have the same, several players from the UK, Greece and others show as Unkown --

 

http://www.didstats.net/player_stats...countries=View

 

I wonder if the details are being blocked? The players country flag shows on their Battlelog & BF3Stats.

 

Any idea?

 

Strat

here is the "--" answer : HERE *

[ImportBot]

Originally Posted by IceCold*:

 

here is the "--" answer : HERE *

thanks

 

matt

[ImportBot]

Originally Posted by Panther*:

 

Any ideas what went wrong? installed the new 1.0.0.3 with a fresh database

 

[11:30:57 30] Error: Error in Startstreaming:

[11:30:57 34] Index #0

[11:30:57 35] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.48-community]Cannot add or update a child row: a foreign key constraint fails (`fallobst_logger`.`tbl_server_player`, CONSTRAINT `fk_tbl_server_player_tbl_server` FOREIGN KEY (`ServerID`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE NO ACTION)

[11:30:57 43] Native: 1452

[11:30:57 44] Source: myodbc5.dll

[11:30:57 54] SQL: HY000

[ImportBot]

Originally Posted by XpKiller*:

 

did you use a table suffix?

[ImportBot]

Originally Posted by Panther*:

 

Nope, not sure what it was. I have closed procon, changed the name of the database (because the previous database was called the same) and now it works fine.

[ImportBot]

Originally Posted by Cafoni*:

 

Getting this error i have everything installed just don't know what to do from here

 

[08:52:14 68] Error in Tablebuilder:

[08:52:14 68] Index #0

[08:52:14 68] Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[08:52:14 68] Native: 0

[08:52:14 68] Source:

[08:52:14 68] SQL: IM002

[ImportBot]

Originally Posted by XpKiller*:

 

@Cafoni

 

This error is now posted countless times in this Thread....

 

You need to install and configure the MySQL ODBC Driver 5.1

[ImportBot]

Originally Posted by HaNg_MaN*:

 

hi,

i have 2 servers, witch different stats.

I use this Plugin for my homepage:

www.phogue.net/forumvb/showth...-Logger-Plugin*

 

My Problem is:

The Weaponsstats are not for each server_Can i change it, that each server has his own weaponstats?

[ImportBot]

Originally Posted by HaNg_MaN*:

 

hi,

i have 2 servers, witch different stats.

I use this Plugin for my homepage:

www.phogue.net/forumvb/showth...-Logger-Plugin*

 

My Problem is:

The Weaponsstats are not for each server_Can i change it, that each server has his own weaponstats?

[ImportBot]

Originally Posted by XpKiller*:

 

@Hang_Man

Each server has his own weaponstats.

 

If you have problems with the website please post in the right thread.

[ImportBot]

Originally Posted by pyroblood*:

 

Hi xpkiller ^^ is it possible to annonce few things with the yell function ?

 

sry for my english ^^

[ImportBot]

Originally Posted by XpKiller*:

 

is planed for next release

But remember it will be visible for all.

[ImportBot]

Originally Posted by pyroblood*:

 

ok thx and visible for all is no problem... (admin.yell "text" 5 player xxx for example works too.... yell private message!)

[ImportBot]

Originally Posted by CptChaos*:

 

I've got a question, I see that since version 1.0.0.3 some new columns are added. In the playerstats table, there are also columns 'rankScore' and 'rankKills' added. Can you explain what these stats mean?

[ImportBot]

Originally Posted by XpKiller*:

 

these colums are used for faster rank queries ingame.

The db dont need to tablescan anymore for each player.

So rankscore reflect the the rank of the player sorted after score.

[ImportBot]

Originally Posted by EBassie*:

 

Hey XPKiller,

 

lately I have this problem a lot:

 

Code:

[15:38:10 35] Error: Error in Startstreaming: 
[15:38:10 35] Index #0
[15:38:10 35] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.35]Lock wait timeout exceeded; try restarting transaction
[15:38:10 35] Native: 1205
[15:38:10 35] Source: myodbc5.dll
[15:38:10 35] SQL: HY000

When this happens some new records in tbl_playerstats won't be created.

 

Code:

[02:43:31] Error: Error in UpdateRanking: 
[02:43:31] Index #0
[02:43:31] Message: [MySQL][ODBC 5.1 Driver][mysqld-5.1.35]Deadlock found when trying to get lock; try restarting transaction
[02:43:31] Native: 1213
[02:43:31] Source: myodbc5.dll
[02:43:31] SQL: HY000

When this happens I know some records are missing.

 

So I have to add them manually. Not a real biggie, but since a few weeks this happens a couple of times a day.

 

This are my settings:

Close Connection after each request: no

High Performance: on

 

Connection Pooling in ODBC driver is on for 90 secs

Retry Wait time is on 160 secs

 

Is there something I've missed to get the connection steady again?

[ImportBot]

Originally Posted by CptChaos*:

 

these colums are used for faster rank queries ingame.

The db dont need to tablescan anymore for each player.

So rankscore reflect the the rank of the player sorted after score.

Thanks for the explanation, I think I found a bug: the type88 sniper is not added after a complete reinstall of the database, I've added them manually now, version I use is 1.0.0.3, the one which counts wins and losses etc as wel.

[ImportBot]

Originally Posted by XpKiller*:

 

@EBastard

 

you need to increase the innodb_lock_wait_timeout to a high value

The transaction get a timeout from the server.

 

"So I have to add them manually. Not a real biggie, but since a few weeks this happens a couple of times a day."

How do you add the manually?

 

Also possible could be that other plugins might causes that the end of round event is fired twice.

 

How large is you DB?

 

 

@CptChaos

You shouldn't add manually columns to any tables.

If a weapon is missing you bf3.def files is faulty.

[ImportBot]

Originally Posted by EBassie*:

 

@XpKiller:

 

When this error happens, the database is not updated / inserted correctly.

It won't make new records in tbl_playerstats.

 

When this happens the tbl_server_player & tbl_playerstats do not have the same amount of records.

 

So I check the database with:

Code:

SELECT * FROM tbl_server_player
WHERE tbl_server_player.StatsID
NOT IN (
SELECT tbl_playerstats.StatsID
FROM tbl_playerstats
WHERE tbl_server_player.StatsID=tbl_playerstats.StatsID
)

Then I notice some StatsID's missing. While the player exists in tbl_playerdata and also in tbl_server_player

These records won't be fixed / created after time, so I will add those ID's myself using phpMyAdmin. These records will be empty with only a statsID in it

 

The database now hold records of 128,418 players

[ImportBot]

Originally Posted by XpKiller*:

 

yes it works as intended the the transaction is rolled back to prevent an inconsistent state in the statstable.

So its no real error of the plugin. The rollback is triggered by the lock timeout error.

 

Could you run the plugin on debuglevel info for a few rounds. It will post how long the update took in the plugin console.

 

How many server are streaming?

 

Did host your db and layer by your own?

[ImportBot]

Originally Posted by EBassie*:

 

We stream 3 servers from one layer. The procon layer is on a dedicated server running VM ware.

The MySQL DB is on another remote dedicated (our webserver)

 

I will change the debuglevel to info on all machines. Will post back later

 

Just wondering:

what happens when the stats-record is not created, but the player-record and the player-server record are.

Will the statsrecord be created eventually at a later stage?

 

Will also try to set a high value for "innodb_lock_wait_timeout".

But I don't have access to the config. Need to wait for a clanmate to fix it

[ImportBot]

Originally Posted by XpKiller*:

 

Jep the the statsrecord is created later.

I may need to shorten the transactions to avoid those the locking problems.

With a small db you dont get such errors :-)

Always the same:

Runs great on dev, sucks on Prod^^