StatsLab12

[Cooleyvol]

Originally Posted by eMLBCommish

Mark,

What I've done is read the instructions, and removed anything that would update settings. (IE config.txt) So far, so good.

But I only did this yesterday with one SQL dump to update my new members to be included. Not sure the next time I do a dump if it'll still work.

Appreciate the info. I don't see why any SQL dump would have anything to do with statslab settings. If they were there to begin with, they should always be there.

[JWay]

Originally Posted by cody8200

Running Career metrics in 12 always results in an error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/career.php on line 160

Warning: Cannot modify header information - headers already sent by (output started at /home/ootpbeli/public_html/StatsLab/career.php:160) in /home/ootpbeli/public_html/StatsLab/career.php on line 229

I'm in the same boat. Is there any fix?

[DigitalMikey]

I'm having a few problems with images showing up in weird places or out of whack.

Examples:

Managers - StatsLab for OOTP12
&
Export Tracker - StatsLab for OOTP12

[Cooleyvol]

Originally Posted by DigitalMikey

I'm having a few problems with images showing up in weird places or out of whack.

Examples:

Managers - StatsLab for OOTP12
&
Export Tracker - StatsLab for OOTP12

There's nothing out of whack. However, you have an image that it cannot find.

[DigitalMikey]

Originally Posted by Cooleyvol

There's nothing out of whack. However, you have an image that it cannot find.

So the bottom footer is not aligned to the far left for you? I'm already aware that one of the logos is missing but I'm more concerned about the alignment of the footer on those two pages.

Thoughts/help?

[Cooleyvol]

Yes, its misaligned.

[DigitalMikey]

Right but how do I fix that if I did everything that I needed to do in the install? I didn't do anything to make it misaligned.

[Cooleyvol]

There's an image missing above it which might throw it out of line.

[DigitalMikey]

Which image? I can't seem to tell.

[DigitalMikey]

Along with my other question I have one more.

How does one import players drafted in the draft utility in to the actual game? Please tell me I don't have to manually add each player to every team...

[mikev]

We are running Statslab 11 v2.2.0 beta in the GUBA. Recently we switched our ratings from 1-10 to 1-20.

Now I'm getting messages from my hosting service saying that the Development Update is running abnormally slow and causing a high load on the server:

# Time: 120125 15:28:46
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8770138 Schema: mikev_statslab
# Query_time: 24.989241 Lock_time: 0.516042 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120125 17:19:05
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8824650 Schema: mikev_statslab
# Query_time: 9.571378 Lock_time: 0.000067 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
SELECT DISTINCT year FROM players_development ORDER BY year;
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8824238 Schema: mikev_statslab
# Query_time: 67.771235 Lock_time: 0.000045 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
SELECT DISTINCT year FROM players_development ORDER BY year;
--
# Time: 120125 20:30:22
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8913333 Schema: mikev_statslab
# Query_time: 12.640040 Lock_time: 0.035106 Rows_sent: 22 Rows_examined: 2777961 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120125 21:01:07
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 8928368 Schema: mikev_statslab
# Query_time: 7.101949 Lock_time: 0.000036 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
SELECT DISTINCT year FROM players_development ORDER BY year;
--
# Time: 120125 23:50:02
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9015930 Schema: mikev_statslab
# Query_time: 16.751881 Lock_time: 0.021958 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 0:24:42
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9032508 Schema: mikev_statslab
# Query_time: 9.751383 Lock_time: 0.014868 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 2:01:13
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9068513 Schema: mikev_statslab
# Query_time: 16.671415 Lock_time: 0.000037 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 4:30:05
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9121038 Schema: mikev_statslab
# Query_time: 18.299787 Lock_time: 0.000041 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 6:07:16
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9155964 Schema: mikev_statslab
# Query_time: 18.130149 Lock_time: 0.000033 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;
--
# Time: 120126 6:44:21
# User@Host: mikev_statslab[mikev_statslab] @ localhost []
# Thread_id: 9171540 Schema: mikev_statslab
# Query_time: 11.517437 Lock_time: 0.031952 Rows_sent: 22 Rows_examined: 2783292 Rows_affected: 0 Rows_read: 22
use mikev_statslab;

What I'm being told is that the dev update is an inefficient SQL query that needs to be optimized -- were any changes made to newer versions or would updating to Statslab12 make a difference?

Thanks

[BobDylanRH]

Originally Posted by fhomess

Hi all,
On the StatsLab Admin screen, under Export Tracker settings, in the League Name field, enter vMLB.tar.gz, and StatsLab will use that extension rather than the old OOTP11 default of .lg.

The error still registers even without inputting .lg into the file format.

[DigitalMikey]

Getting an annoying memory error when I try to run my draft.

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2048 bytes) in /home/digitalm/public_html/pbdl/statslab/gen_functions.php on line 9

My memory limit is set at 64M which is the max for most shared servers. Any help on how to fix this?

[Cooleyvol]

Originally Posted by DigitalMikey

Along with my other question I have one more.

How does one import players drafted in the draft utility in to the actual game? Please tell me I don't have to manually add each player to every team...

You have to action each pick inside the game. Statslab merely makes it easier on the owners to select.

You'd have to action the picks in game anyway.

[f.montoya]

Originally Posted by mikev

We are running Statslab 11 v2.2.0 beta in the GUBA. Recently we switched our ratings from 1-10 to 1-20.

Now I'm getting messages from my hosting service saying that the Development Update is running abnormally slow and causing a high load on the server:



What I'm being told is that the dev update is an inefficient SQL query that needs to be optimized -- were any changes made to newer versions or would updating to Statslab12 make a difference?

Thanks

Mike, I have a few online leagues on allsimbaseball that are experiencing the same thing. Some very high CPU usage as queries are taking a long time to retrieve stuff from the database. I sent a PM to fhomess regarding some SQL subqueries that were found and one acquaintance of mine familiar with SQL advised using "joins" in the SQL queries instead. Hopefully he can address this issue soon.

[mikev]

I got a PM back from him with a suggested fix, but I'm still getting nastygrams from my host.

A friend of mine is going to help me troubleshoot in the next few days, hopefully.

[f.montoya]

Originally Posted by mikev

I got a PM back from him with a suggested fix, but I'm still getting nastygrams from my host.

A friend of mine is going to help me troubleshoot in the next few days, hopefully.

Let us know what your friend finds.

[BobDylanRH]

I've got a team showing up as CPU controlled when they are not. Because of it, the owner can't use his team with StatsLab. Anyone else seen this?

[trendon]

Hoping to get some help on this one. Also please let me know if/where there is a donation box for this lovely mod. Anyway ...

We just switched over from X to 12. As such, I installed a new instance of StatsLab on a different domain, so it isn't any issue like that. When I go to load the SQL files, I get this:

ERROR in team_history:
insert into `team_history` VALUES (1237, 2013, 104, 1, 0, "Colquitt", "COL", "Monarchs", 3313, 1972, 0, 595, 1, 0, 0, 0), (1237, 2014, 104, 1, 0, "Colquitt", "COL", "Monarchs", 3921, 9031, 0, 595, 1, 0, 0, 0), (1237, 2015, 104, 1, 0, "Colquitt", "COL", "Monarchs", 2661, 3026, 0, 259, 0, 0, 0, 0), (1238, 2010, 104, 1, 0, "Yorktown Heights", "YKT", "Hellstorm", 9205, 7923, 0, 331, 0, 0, 0, 0), (1238, 2011, 104, 1, 0, "Yorktown Heights", "YKT", "Hellstorm", 1826, 1919, 2817, 331, 0, 0, 0, 0), (1238, 2012, 104, 1, 0, "Yorktown Heights", "YKT", "Hellstorm", 11185, 3482, 543, 1046, 0, 0, 0, 0), (1238, 2013, 104, 1, 0, "Yorktown Heights", "YKT", "Hellstorm", 3218, 4114, 0, 702, 0, 0, 0, 0) ... etc etc

I get that error for a few of them. When I go to the individual table screen, I see a few of them not loaded. When I try to load them individually, the browser hangs.

Meanwhile, while the two StatsLabs are installed on different domains, the dump folder is in the same location. So, I tried to load the files with the X version of StatsLab and it loads fine, but no data is available (i.e. Last Sim is blank).

Any help would be greatly appreciated.

[JoeyBats]

Originally Posted by f.montoya

Let us know what your friend finds.

Have you heard anything on a solution?