OSFL Stats Issues

[aholbert]

Ben,

The database doesnt seem to be updating anymore. None of the transactions since the draft are showing. Any ideas?

[Guest]

Ben,

The database doesnt seem to be updating anymore. None of the transactions since the draft are showing. Any ideas?

Hmmmm...these aren't the ones?

http://www.simgamingnetwork.com/osfl...ansactions.php

[aholbert]

Hmmmm...these aren't the ones?

http://www.simgamingnetwork.com/osfl...ansactions.php

Not showing up in the roster screen. For example none of the rookies are on my team.

http://www.simgamingnetwork.com/osfl....php?teamid=17

[Guest]

Not showing up in the roster screen. For example none of the rookies are on my team.

http://www.simgamingnetwork.com/osfl....php?teamid=17

Ohhh....that's because I haven't done the ratings for rookies yet (it's a tedious manual process). I'm out of town this week, so that won't get done until this weekend at the earliest.

[aholbert]

Ohhh....that's because I haven't done the ratings for rookies yet (it's a tedious manual process). I'm out of town this week, so that won't get done until this weekend at the earliest.

Cool. Thanks Ben.

[aholbert]

Bump for Ben.

[aholbert]

One more time to add the rookies.

[Guest]

One more time to add the rookies.

?

[Lintyfresh85]

Can we fix all the stats from the first couple of years? They're all listed as 32 games and it's really throwing off the record books.

Take your time, not a big deal... but I just thought it was something we could take a look at.

[aholbert]

Tried to fix it by running the updater again but that didnt work. We will have to wait for Ben.

[Guest]

Tried to fix it by running the updater again but that didnt work. We will have to wait for Ben.

I can't really do anything but run the same updater and hope it works. What's happening is that in most attempts, the script is just taking too long to run, which apparently causes it to eventually re-start without emptying the table. And that creates duplicate entries for some seasons, and therefore doubling of stats. It's clearly a server-related issue. The same script works fine for leagues that have run quite a bit longer than this one (and therefore have far more seasons to re-write) when run on my server. IHOF, for example, is in its 18th season, and that same script runs without error in maybe 20-25 seconds, and it's writing roughly 2 1/2 times more information. I'll probably just remedy it by putting the php stuff on my server at some point. That would solve it.

[aholbert]

Can we fix all the stats from the first couple of years? They're all listed as 32 games and it's really throwing off the record books.

Take your time, not a big deal... but I just thought it was something we could take a look at.

The issue is fixed.

[aholbert]

Ben,

There seems to be a small issue with the database. When I go to my team's database through the OSFL link found at the top of the forums, it only shows my team stats through week 7. When I access the database through the "Week 13 Results" thread, it shows the updated stats. It could be related to the forum link being a "simgamingnetwork.com" link and the Results link being a "younglifenorthdekalb" link.

[Guest]

SGN is pointing to old db location. I need to take that down anyway. Will do tonight or tomorrow. Need to change some links at ylnd.

[Guest]

should be working now