Quote:
Originally Posted by PotatoPeeler
Couple of quick questions.
1. When I try the Run Career Metrics after loading the SQL files, I get the following error:
Code:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <path to StatsLab>/career.php on line 43
Warning: Cannot modify header information - headers already sent by (output started at <path to StatsLab>/career.php:43) in <path to StatsLab>/career.php on line 218
|
The players_league_leader file isn't getting loaded into your database.
Quote:
Originally Posted by PotatoPeeler
2. After loading the SQL files, I keep seeing a message on the Admin page that reads "LOADING: players_batting.mysql.sql" (see the first attached image).
|
Any time you see the "LOADING: filename" message, it means that file isn't getting fully loaded into your database. Usually, this is caused by your server timing out on the script while it's still trying to load. Servers have a limited amount of time they allow php scripts to run for before they kill the process. StatsLab requests additional time regularly for long running scripts, but not all servers allow scripts to override their settings for that timeout. If you're running into this, try loading the larger files individually, or possibly splitting them first.
Quote:
Originally Posted by PotatoPeeler
3. After loading the SQL files, I'm not seeing anything in the Top Players section on the Top Performances page (see the second attached image).
Any idea what's causing these issues?
|
This would be related to the fact that you're not getting all your data into the database.
Quote:
Originally Posted by mikev
It is, I verified it by logging into the SQL DB via shell, and I also deleted and recreated the user/password for the SQL DB.
|
Perhaps your SQL server isn't configured to permit connections from where you have StatsLab running? You might also check dbopen.php in your SQL load folder to make sure StatsLab was able to generate it correctly.
Quote:
Originally Posted by snnort
Has anyone used the widgets feature that can point to a website in which they've used them? I'm hoping to get some time myself to mess with them and see if I can't get something set up on my league frontpage. I thought it'd be nice to see a few examples of what others are doing with them.
|
I know the PEBA is using them on their front page to display standings, and Corsairs has even contacted me to say he's willing to share the CSS that they've employed to display them in their format. I'm not sure if he's posted in this thread, but I do know he posted in the OOTP9 StatsLab thread.