|
||||
|
08-11-2011, 12:16 AM | #61 |
Major Leagues
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
|
One more screenshot. I am sure I am doing something wrong for it to look like that.
|
08-13-2011, 03:10 PM | #62 |
Hall Of Famer
|
Another question, after every sim do you still have to load the SQL files in a particular order like you did before or can you just load them all at once? Also, what post-load functions should you run each time?
__________________
From the wise mind of Davey Eckstein "Now all you need is a signature. A quote or initial, perhaps." [ |
08-13-2011, 04:23 PM | #63 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
You can load them in any order. Just run the season, park factors, etc afterwards.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
08-13-2011, 08:19 PM | #64 |
Hall Of Famer
|
I tried loading the new files I uploaded, like half of them work fine but some of them have an error, I reuploaded the games.mysql.sql file but it still shows the error when I try to load it:
Loading games.mysql.sql ... 1000 queries executed ... 2000 queries executed ... 3000 queries executed ... 4000 queries executed ... 5000 queries executed ... 6000 queries executed ... 7000 queries executed ... 8000 queries executed ... 9000 queries executed ... 10000 queries executed ... 11000 queries executed ... 12000 queries executed ... 13000 queries executed insert into `games` VALUES (1, 103, 191, 198, 5685, "2011-3-31", 1800, 0, 1, 0, 9, 4, 1, 9, 3, 2, 0, 31905, 24215, 32250, 31905, 24215); -> Duplicate entry '1' for key 'PRIMARY' insert into `games` VALUES (2, 103, 196, 194, 5413, "2011-3-31", 1835, 0, 1, 0, 9, 1, 3, 7, 8, 0, 0, 30308, 31031, 33580, 31031, 30308); -> Duplicate entry '2' for key 'PRIMARY' insert into `games` VALUES (3, 103, 189, 192, 5710, "2011-3-31", 1835, 0, 1, 0, 9, 0, 3, 1, 5, 0, 1, 32720, 30551, 26035, 30551, 32720); -> Duplicate entry '3' for key 'PRIMARY' insert into `games` VALUES (4, 103, 197, 195, 5576, "2011-3-31", 1900, 0, 1, 0, 9, 3, 4, 8, 9, 1, 1, 31185, 25992, 18853, 25992, 31185); -> Duplicate entry '4' for key 'PRIMARY' insert into `games` VALUES (5, 103, 193, 187, 6160, "2011-3-31", 1905, 0, 1, 0, 9, 11, 2, 15, 7, 0, 1, 35120, 27006, 0, 35120, 27006); -> Duplicate entry '5' for key 'PRIMARY' insert into `games` VALUES (6, 103, 190, 188, 5587, "2011-3-31", 1905, 0, 1, 0, 9, 1, 5, 9, 6, 0, 0, 31680, 27181, 0, 27181, 31680); -> Duplicate entry '6' for key 'PRIMARY' insert into `games` VALUES (7, 103, 191, 198, 1954, "2011-4-1", 1800, 0, 1, 0, 9, 5, 2, 6, 4, 0, 1, 19207, 19553, 32250, 33208, 19553); -> Duplicate entry '7' for key 'PRIMARY' insert into `games` VALUES (8, 103, 196, 194, 3014, "2011-4-1", 1835, 0, 1, 0, 10, 5, 6, 12, 12, 0, 1, 35148, 25903, 0, 30769, 31399); -> Duplicate entry '8' for key 'PRIMARY' insert into `games` VALUES (9, 103, 190, 188, 2925, "2011-4-1", 1835, 0, 1, 0, 10, 1, 2, 6, 6, 0, 1, 33296, 30840, 0, 27612, 33568); -> Duplicate entry '9' for key 'PRIMARY' insert into `games` VALUES (10, 103, 189, 192, 3115, "2011-4-1", 1835, 0, 1, 0, 9, 3, 10, 7, 9, 2, 2, 30194, 23193, 0, 23193, 30194); -> Duplicate entry '10' for key 'PRIMARY' insert into `games` VALUES (11, 103, 197, 195, 3065, "2011-4-1", 1900, 0, 1, 0, 11, 5, 6, 11, 12, 0, 1, 31310, 26544, 0, 32636, 27497); -> Duplicate entry '11' for key 'PRIMARY' insert into `games` VALUES (12, 103, 193, 187, 3073, "2011-4-1", 1905, 0, 1, 0, 9, 2, 10, 5, 10, 0, 0, 27636, 30478, 0, 30478, 27636); -> Duplicate entry '12' for key 'PRIMARY' insert into `games` VALUES (13, 103, 191, 198, 3195, "2011-4-2", 1300, 0, 1, 0, 9, 5, 3, 12, 8, 2, 0, 19207, 23145, 32250, 31908, 23145); -> Duplicate entry '13' for key 'PRIMARY' insert into `games` VALUES (14, 103, 196, 194, 3212, "2011-4-2", 1305, 0, 1, 0, 9, 5, 3, 9, 5, 1, 0, 25022, 27861, 25903, 30778, 32695); -> Duplicate entry '14' for key 'PRIMARY' insert into `games` VALUES (15, 103, 193, 187, 3409, "2011-4-2", 1305, 0, 1, 0, 9, 7, 3, 14, 8, 0, 1, 32098, 22880, 0, 32098, 23276); -> Duplicate entry '15' for key 'PRIMARY' insert into `games` VALUES (16, 103, 189, 192, 3441, "2011-4-2", 1335, 0, 1, 0, 9, 18, 6, 18, 9, 0, 3, 24427, 26037, 0, 24427, 26037); -> Duplicate entry '16' for key 'PRIMARY' insert into `games` VALUES (17, 103, 190, 188, 3315, "2011-4-2", 1835, 0, 1, 0, 9, 1, 9, 4, 10, 1, 1, 26863, 26173, 0, 26173, 26863); -> Duplicate entry '17' for key 'PRIMARY' insert into `games` VALUES (18, 103, 197, 195, 3319, "2011-4-2", 1900, 0, 1, 0, 9, 2, 4, 6, 9, 1, 1, 25073, 32637, 31310, 23548, 31233); -> Duplicate entry '18' for key 'PRIMARY' insert into `games` VALUES (19, 103, 191, 198, 3230, "2011-4-3", 1300, 0, 1, 0, 9, 2, 4, 4, 10, 0, 0, 32261, 19377, 28569, 23272, 32261); -> Duplicate entry '19' for key 'PRIMARY' insert into `games` VALUES (20, 103, 196, 194, 2982, "2011-4-3", 1305, 0, 1, 0, 9, 7, 1, 12, 7, 0, 0, 24700, 26128, 0, 24700, 26128); -> Duplicate entry '20' for key 'PRIMARY'
__________________
From the wise mind of Davey Eckstein "Now all you need is a signature. A quote or initial, perhaps." [ |
08-13-2011, 08:20 PM | #65 |
Minors (Single A)
Join Date: Apr 2010
Posts: 71
|
Trying to run our amateur draft with statslab 12, no issues until now. Have this message on draftboard (Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/osdkootp/public_html/StatsLab/draftReport.php on line 189) and get the player not draft eligible when manger tries to make the first overall pick? Contacted Fhmoss just on and logged right off
|
08-13-2011, 08:36 PM | #66 | ||
Minors (Single A)
Join Date: Apr 2010
Posts: 71
|
Quote:
Quote:
|
||
08-16-2011, 12:35 AM | #67 | ||||||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Hi all,
I've been on vacation with only intermittent internet access. Here are some responses. Quote:
Quote:
Quote:
Quote:
Quote:
Quote:
Does your games.mysql.sql file have a line at the top to DROP the table and then to CREATE the table? If not, check those options in the OOTP12 SQL configuration. They're new to OOTP12.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||||||
09-12-2011, 12:01 PM | #68 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Frank, do you happen to have any updates on development progress?
|
09-12-2011, 04:19 PM | #69 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Honestly, I haven't taken any time to work on it in about 3 weeks, and by "it", I mean StatsLab in general. Given things going on in my real world, I can't really give any sort of ETA at this point.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
09-13-2011, 05:43 PM | #70 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Understood. Thanks for the reply.
|
09-25-2011, 08:07 AM | #71 |
All Star Starter
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,269
|
Okay, I'm probably being dense, but I cannot figure this out.
I followed the directions exactly the same way I did for 11. pre-patch 2 for StatsLab. Everything looks okay visually on the StatsLab site. However, for whatever reason, when I go to set up the first development tables, I am getting time out errors before I can accomplish anything -- even if I limit the request to, say, A league pitching ratings... Related to this, I had far more trouble with time out errors when loading SQL files -- for the first time ever, I had to split them, and they are exactly the same size as they were back in OOTP 11, so this makes no sense to me. However, I notice documentation for a patch 2 in with the StatsLab directions, and so I am guessing that the patch is where things in StatsLab might be adjusted to OOTP 12. However, I see no patch 2 in the zip file download. Nor do I see a conversion2-2.php file. So I am stuck. Either I have done the correct installation but time out errors are preventing me from using the development tracker OR there is an important patch that I am not finding.
__________________
Commish of Dog Days Baseball Commish Pennant Chase Baseball League (PCBL) Commish and Blue Jays GM Extra Innings Baseball Last edited by beorn; 09-25-2011 at 08:16 AM. |
11-14-2011, 09:17 AM | #72 |
Major Leagues
Join Date: Jun 2006
Posts: 311
|
I'm guessing this will be an easy fi and I entered somethign wrong, but when I go to the exports page for my league, it says
ERROR: No League File Found at: "http://www.mtblcentral.com/league_files/MTBL12.tar.gz" but that's exactly where the league file is located, if you grab just the url portion, it'll download our league file. any ideas what I did wrong? |
11-14-2011, 02:38 PM | #73 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
What do your export tracker settings look like in the admin tab?
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
11-14-2011, 02:49 PM | #74 |
Major Leagues
Join Date: Jun 2006
Posts: 311
|
|
11-15-2011, 10:41 PM | #75 |
All Star Starter
Join Date: Dec 2005
Posts: 1,674
|
Frank,
I know I say this everytime I run a post-season for my solo league, but once again, thank you for StatsLab and the Playoff summary. This used to take me long hours to produce manually and it's time I can enjoy doing things like teasing my brow, cleaning my wife and daughters hair from the sink drains and browsing historical team graphs. Thanks man!
__________________
My OOTP Gaming Channels:
|
12-06-2011, 01:15 PM | #76 | |
Minors (Double A)
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
|
Quote:
|
|
12-13-2011, 09:08 PM | #77 | |
Bat Boy
Join Date: Oct 2006
Posts: 15
|
StatsLab12 Career Metrics Problem
Quote:
Love StatsLab!!! - Bill |
|
12-26-2011, 05:33 PM | #78 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Can anyone who's updated v11 with v12 tell me if it overwrites all of your settings? I'd like to know before I update.
|
12-27-2011, 04:25 PM | #79 |
All Star Starter
Join Date: Oct 2011
Location: Maple, ON - Canada
Posts: 1,058
|
StatsLab V12
Thank you for creating this utility.
It took me a while to get it to work but, I'm set now. I am getting one error in the draft utility. If anyone can help it would be appreciated! Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web118/b1183/ipg.usfleaguesnet/ootpsl/draftWarroom.php on line 438 Thanks! Jason Last edited by USF; 12-31-2011 at 09:07 PM. |
12-27-2011, 07:45 PM | #80 | |
All Star Reserve
Join Date: Mar 2003
Posts: 667
|
Quote:
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.
__________________
The Fluffy Kitty Ninjas Show - Home of the eMLB Universe! www.twitch.tv/FKNCommishLB The Man Behind eMLB - https://atl-02.statsplus.net/emlb/re..._150_home.html Proud OOTP Affiliate Streamer Proud Twitch Partner (Partnered 3/15/22) |
|
Bookmarks |
|
|