OOTP Developments Forums - View Single Post

kbensel · 04-05-2004, 05:57 PM

Operation Shutdown said: "Finally figured this little bugger out. For some odd reason, the exporter really screwed up the gamenr column when it exported the schedule_game.csv file. No idea how or why that happened, maybe it had something to do with a manual schedule being created. Basically, there were a bunch of duplicate entries in there, and it seemed to start off with the number of the last previous regular season game. I would've found it sooner if I had thought more about what the actual message error was saying, I could have just went into the games table and found what the primary key was in that table (which is a combo of the date and gamenr combined) and then figured out from that what was causing the problem. Anyway, to fix it, I just opened the csv file in Excel and filled down 1, 2, etc until the last regular season game. I figured the somewhat weird way it numbered the playoffs and stuck that in as well."

I'm getting the same error that Operation Shutdown got (shown below), but I'm not sure it's for the same reason.

"Run-time error '-2147467259 (80004005)'

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

I am using a fresh install of History Website Creator v.5.3.3. When I click "Import Stats" it gets all the way through "Updating Fields..." and then chokes on "Copying... Pre-Sim Data." The league is actually in its 8th season but this is the first time we're using Cato's program.

I have looked at the schedule_game.csv file and it looks normal, with no duplicate entries. The All-Star game shows up as game # 5000, but other than that the games are numbered sequentially through the end of the season, and then you get the strange (but systematic) numbering of games for the postseason.

Any ideas?

Thanks,
Kevin

04-05-2004, 05:57 PM	#21
kbensel Minors (Single A) Join Date: Jul 2002 Posts: 68	Operation Shutdown said: "Finally figured this little bugger out. For some odd reason, the exporter really screwed up the gamenr column when it exported the schedule_game.csv file. No idea how or why that happened, maybe it had something to do with a manual schedule being created. Basically, there were a bunch of duplicate entries in there, and it seemed to start off with the number of the last previous regular season game. I would've found it sooner if I had thought more about what the actual message error was saying, I could have just went into the games table and found what the primary key was in that table (which is a combo of the date and gamenr combined) and then figured out from that what was causing the problem. Anyway, to fix it, I just opened the csv file in Excel and filled down 1, 2, etc until the last regular season game. I figured the somewhat weird way it numbered the playoffs and stuck that in as well." I'm getting the same error that Operation Shutdown got (shown below), but I'm not sure it's for the same reason. "Run-time error '-2147467259 (80004005)' The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." I am using a fresh install of History Website Creator v.5.3.3. When I click "Import Stats" it gets all the way through "Updating Fields..." and then chokes on "Copying... Pre-Sim Data." The league is actually in its 8th season but this is the first time we're using Cato's program. I have looked at the schedule_game.csv file and it looks normal, with no duplicate entries. The All-Star game shows up as game # 5000, but other than that the games are numbered sequentially through the end of the season, and then you get the strange (but systematic) numbering of games for the postseason. Any ideas? Thanks, Kevin