 |
 Home | Webstore
|
|
Latest News:
OOTP 27 Buy Now
- FHM 12 Available
- OOTP Go! 27 Available
Out of the Park Baseball 27 Buy Now! |
|
|
||||
| ||||
10-01-2003, 10:54 PM
|
#1 |
|
Hall Of Famer
Join Date: Feb 2002
Location: Pittsburgh
Posts: 5,106
|
SQL Error with OOTP5 History Utility
Hi all.
For some reason in a league I'm running now, I always get the following SQL error when the app is importing histories after year 5. I've restarted the league 3 times now thinking maybe it was an out-of-the-ordinary glitch, but it's happening every single time I finish season 5: "Data provider or other service returned an E_FAIL status" Anyone have any ideas of whether there's something I can do to figure out why this is happening? Could be a blank history entry or something similar in the CSV's, or maybe something I should be looking at in the Database itself? Jason
__________________
"I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech |
|
|
10-01-2003, 10:56 PM
|
#2 |
|
Hall Of Famer
Join Date: Feb 2002
Location: Pittsburgh
Posts: 5,106
|
Also, if it helps (or if Cato or someone reads this) I can zip up my CSV, MDB, and HTML files for checking.
Jason
__________________
"I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech |
|
|
|
10-01-2003, 11:05 PM
|
#3 |
|
Hall Of Famer
Join Date: Feb 2002
Location: Pittsburgh
Posts: 5,106
|
Hm, ok, I found another thread on this, so I apologize for the duplication.
I'm going to import stats again and look at the database and try and see where the update is stopping. Maybe I can figure out which entry in a player's history is causing the problem. Jason
__________________
"I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech |
|
|
|
10-01-2003, 11:21 PM
|
#4 |
|
Hall Of Famer
Join Date: Feb 2002
Location: Pittsburgh
Posts: 5,106
|
Ok, not sure if this matters, but the history file it's choking on is incredibly large (actually 3k, the largest of any by far in my league).
I'm going to delete all batter/pitcher of the week/month awards out of the histories to see if the filesize is what's making it choke. Just to show you what I mean, here's the history in question: Code:
Drafted in 1st round, 8th overall pick, by Minnesota in 1900... Had first career hit on 4/2/1900, off Richard Piercy (TEX)... Hit first career homerun on 4/6/1900, off Matthew Goldblatt (KCR)... Was selected to the 1900 Allstar game... Injured on 7/15/1900 with a Inflamed Abdominal Muscle, out for one week... Hit for the cycle against Toronto on 8/27/1900... Won Gold Glove at Shortstop in 1900... Won Player of the Week award on 5/21/1901, hitting .520 with 3 HR, 11 RBI... Won Batter of the Month award on 6/1/1901, hitting .350 with 9 HR, 35 RBI... Was selected to the 1901 Allstar game... Injured on 7/13/1901 with a Hyper Extended Knee, out for one week... Won Player of the Week award on 5/7/1902, hitting .474 with 3 HR, 9 RBI... Drove in 7 runs against Baltimore on 5/11/1902... Won Player of the Week award on 6/18/1902, hitting .364 with 4 HR, 8 RBI... Was selected to the 1902 Allstar game... Sets a new season AL-Record for HR with 39 on 8/9/1902... Sets a new season AL-Record for RBI with 124 on 9/7/1902... Won Player of the Week award on 9/10/1902, hitting .500 with 2 HR, 4 RBI... Won Most Valuable Player in 1902, hitting .316 with 52 HR, 146 RBI... Signed as a free agent by St Louis on 2/6/1903 to a 7-year deal worth $13,285,300 per year... Won Player of the Week award on 5/7/1903, hitting .579 with 2 HR, 3 RBI... Won Batter of the Month award on 6/1/1903, hitting .372 with 10 HR, 20 RBI... Won Batter of the Month award on 7/1/1903, hitting .301 with 10 HR, 23 RBI... Won Player of the Week award on 7/2/1903, hitting .423 with 4 HR, 10 RBI... Was selected to the 1903 Allstar game... Won Player of the Week award on 7/16/1903, hitting .483 with 4 HR, 15 RBI... Won Player of the Week award on 8/13/1903, hitting .368 with 4 HR, 8 RBI... Was selected to the 1904 Allstar game... Hit 3 homeruns against San Diego, driving in 5 runs on 7/12/1904... Won Player of the Week award on 8/13/1904, hitting .474 with 4 HR, 8 RBI... Drove in 7 runs against San Diego on 8/21/1904... Sets a new season NL-Record for RBI with 129 on 9/14/1904... Sets a new season NL-Record for HR with 48 on 9/26/1904... Won Batter of the Month award on 10/1/1904, hitting .398 with 11 HR, 28 RBI... Won Player of the Week award on 10/1/1904, hitting .429 with 4 HR, 8 RBI... Won Most Valuable Player in 1904, hitting .308 with 52 HR, 150 RBI... Won Player of the Week award on 4/9/1905, hitting .542 with 4 HR, 15 RBI... Was selected to the 1905 Allstar game... Won Player of the Week award on 7/16/1905, hitting .379 with 4 HR, 10 RBI...
__________________
"I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech |
|
|
|
01-02-2004, 12:05 PM
|
#5 |
|
Minors (Double A)
Join Date: Sep 2003
Posts: 161
|
I am having this problem as well. Did you ever fix the problem?
Thanks, Scott
__________________
Scott Stewart World Baseball Hierarchy - Calgary Outlaws Beyond the Ivy - Chicago Cubs Stars and Strips Baseball League - Chicago White Soxs Action Pack Baseball League - Toronto Blue Jays |
|
|
| Bookmarks |
|
|
