CFL League replaced by patch in MainData.mdb

[MjH]

Previously, I had created my own CFL league. Upon installing the new patch, my CFL league could no longer be found in the 'League Game' page. Scrolling through the leagues on the screen showed that there were four leagues - Maximum League, Maximum Indoor League, Maximum US League, and then 'blank'. I took a look at the Leagues table in the MainData.mdb, and found that my old CFL league entry had been replaced. Fortunately, I had taken a backup before installing the patch, so I could go back to the old file and compare. The data in my old database was:

Code: Select all

ID      League Name               SmallName
 ------  ------------------------  ---------
 192463  Canadian Football League  CFL

The data in the new database was:

Code: Select all

ID      League Name               SmallName
 ------  ------------------------  ---------
 231945	CFL Sample League         CFL

I was able to see my old league again by updating the ID in the new database with the ID from the old database (i.e. change 231945 to 192463). David, did the patch replace the entire MainData.mdb file, or did you run a script to update the existing database? Also, is there anything else in the MainData.mdb that was changed that might cause problems for my old league, or should I just delete the old league and re-create it, just to be safe?

Thanks...

[David Winter]

Ahh okay.. I see what's happening. When I was testing league creation I created a "CFL Sample League". It has the same CFL abbreviation as yours.
 
What should happen is when the game finds a new league it doesn't already have, it should import it. The problem here is my old sample league is causing the game to think your league is already installed.
 
To correct this, you can delete the row from the database and restart the game. It should then import your league.
 
I need to remember to take that row out of the database for the next release.
 
Thanks
David

[David Winter]

David, did the patch replace the entire MainData.mdb file, or did you run a script to update the existing database? Also, is there anything else in the MainData.mdb that was changed that might cause problems for my old league, or should I just delete the old league and re-create it, just to be safe?

 
The game installs a completely new maindata.mdb file and it also runs a script (hard coded) on existing league databases to ensure they're up to R3 specs.
 
But as I said above, all you have to do in your case, is delete the offending row. I'll delete it on my end as well so it doesn't happen next patch.

[MjH]

ORIGINAL: David Winter

But as I said above, all you have to do in your case, is delete the offending row. I'll delete it on my end as well so it doesn't happen next patch.

Good enough. I'll do that. Hopefully I'll be able to get in a game or two this weekend, but maybe not. The Huskies and the 'Riders have playoff games, and we're having a family birthday get-together on Sunday....... [:)]

[David Winter]

ORIGINAL: MjH

Good enough. I'll do that. Hopefully I'll be able to get in a game or two this weekend, but maybe not. The Huskies and the 'Riders have playoff games, and we're having a family birthday get-together on Sunday....... [:)]

Yeah.. Ill apologise in advance for not working on the game on Sunday during the semi-finals. I guess you heard by now that the Stumps have decided not to allow Gainer the Gopher into their stadium.. pansies.. [:)]

Of course if the 'Riders do make it past them, I have tickets to the Western Final here in Vancouver. If people don't hear from me after that game, it's probably because I've had a heart attack (whatever the outcome) ! [8D]