OOTP Developments Forums - View Single Post

Rencro · 06-26-2005, 10:19 PM

I had this problem after my 4th season. Also could not get into html to look for null char. So I tracked it down(SLOWLY) via the ltrans file. After deleting the bogus year import out of my db, i removed ALL transactions from the ltrans file. Import WORKED. Ok so now I tried again, this time removing only the trades form the ltrans file. Again, import worked. Note: i always delete this year in question from the db when trying new imports. So I put my ltrans file back to normal, ran the import expecting a fail, which it did.
So now I went into my leagues access db made by Cato, and looked in the "Trades" table. The last trade processed into the table was on 6-10-07. So now I removed all transactions from 6-10-7 in ltrans. Import worked. Removed all trades from 6-10-07, worked. Removed all non-trades from 6-10-07, worked.

???? Now I was scratching my head. Anyways, finally tracked it down to one transaction on said date. here is my ltrans file for the date in question:

6 Tuesday 6/10/2007 :
1 Trade between Minnesota and Kansas City :
1 Kansas City gets :
1 P Rick Aguilera
1 Minnesota gets :
1 P Paul Daluz
1 Minnesota: P Paul Daluz was assigned to the active roster.
1 Kansas City: P Rick Aguilera was assigned to the active roster.
1 Trade between Washington and Chicago (A) :
1 Chicago (A) gets :
1 2B Morimichi Takagi
1 Washington gets :
1 RF Magglio Ordonez
1 P Carlos Maldonado
1 Washington: 1B Buck Leonard was sent down from the active roster to AAA .
1 Washington: RF Magglio Ordonez was assigned to the active roster.
1 Washington: 3B Frank White was promoted from AAA to the active roster.
1 Chicago (A): 3B Richie Hebner was promoted from AAA to the active roster.
1 Chicago (A): 2B Rogers Hornsby was sent down from the active roster to AAA .
1 Chicago (A): 2B Morimichi Takagi was assigned to the active roster.
1 Trade between Minnesota and Detroit :
1 Detroit gets :
1 LF Al Oliver
1 Minnesota gets :
1 1B Samuel Nieves
1 Minnesota: LF Shane Mack was promoted from AAA to the active roster.
1 Detroit: CF Mickey Stanley was sent down from the active roster to AAA .
1 Detroit: LF Al Oliver was assigned to the active roster.
1 Chicago (N): Put 1B Mark Grace on the 15 Day DL.
1 Chicago (N): LF Bill Buckner was promoted from AAA to the active roster.
~

The transaction in question was Chicago (A) Rogers Hornsby sent down yadda yadda. Tried deleting this transaction only leaving rest of ltrans alone, import worked. Tried retyping this transaction by hand, still bad. Changed the team from Chicago (A) to Chicago (N), still bad. Moved just this transaction to the next day, 6-11-07, import worked.

Dont know the "why", just the process I went through.

Also the actual html is in the ltans file, just dont know how to turn off html in this post.

Question: Does Cato need the call up/send down transactions at all?

06-26-2005, 10:19 PM	#7
Rencro Bat Boy Join Date: Jun 2005 Posts: 5	I had this problem after my 4th season. Also could not get into html to look for null char. So I tracked it down(SLOWLY) via the ltrans file. After deleting the bogus year import out of my db, i removed ALL transactions from the ltrans file. Import WORKED. Ok so now I tried again, this time removing only the trades form the ltrans file. Again, import worked. Note: i always delete this year in question from the db when trying new imports. So I put my ltrans file back to normal, ran the import expecting a fail, which it did. So now I went into my leagues access db made by Cato, and looked in the "Trades" table. The last trade processed into the table was on 6-10-07. So now I removed all transactions from 6-10-7 in ltrans. Import worked. Removed all trades from 6-10-07, worked. Removed all non-trades from 6-10-07, worked. ???? Now I was scratching my head. Anyways, finally tracked it down to one transaction on said date. here is my ltrans file for the date in question: 6 Tuesday 6/10/2007 : 1 Trade between Minnesota and Kansas City : 1 Kansas City gets : 1 P Rick Aguilera 1 Minnesota gets : 1 P Paul Daluz 1 Minnesota: P Paul Daluz was assigned to the active roster. 1 Kansas City: P Rick Aguilera was assigned to the active roster. 1 Trade between Washington and Chicago (A) : 1 Chicago (A) gets : 1 2B Morimichi Takagi 1 Washington gets : 1 RF Magglio Ordonez 1 P Carlos Maldonado 1 Washington: 1B Buck Leonard was sent down from the active roster to AAA . 1 Washington: RF Magglio Ordonez was assigned to the active roster. 1 Washington: 3B Frank White was promoted from AAA to the active roster. 1 Chicago (A): 3B Richie Hebner was promoted from AAA to the active roster. 1 Chicago (A): 2B Rogers Hornsby was sent down from the active roster to AAA . 1 Chicago (A): 2B Morimichi Takagi was assigned to the active roster. 1 Trade between Minnesota and Detroit : 1 Detroit gets : 1 LF Al Oliver 1 Minnesota gets : 1 1B Samuel Nieves 1 Minnesota: LF Shane Mack was promoted from AAA to the active roster. 1 Detroit: CF Mickey Stanley was sent down from the active roster to AAA . 1 Detroit: LF Al Oliver was assigned to the active roster. 1 Chicago (N): Put 1B Mark Grace on the 15 Day DL. 1 Chicago (N): LF Bill Buckner was promoted from AAA to the active roster. ~ The transaction in question was Chicago (A) Rogers Hornsby sent down yadda yadda. Tried deleting this transaction only leaving rest of ltrans alone, import worked. Tried retyping this transaction by hand, still bad. Changed the team from Chicago (A) to Chicago (N), still bad. Moved just this transaction to the next day, 6-11-07, import worked. Dont know the "why", just the process I went through. Also the actual html is in the ltans file, just dont know how to turn off html in this post. Question: Does Cato need the call up/send down transactions at all?