duplicate records for EVERY pick 2007 +

[paladisiac]

Stan,

There are duplicate records in FFPPICK for drafts 2007 through 2009. There is a duplicate record for EVERY pick in every round in every year from 2007 through 2009.

Look for yourself:

select * from ffppick
where lid = '000666'
and efsyear >= 2007
order by efsyear, efsround, efspick

Notice that 2010 is ok. Tom Lorenz's guess is that when the picks for 2010 were inserted, that you inserted picks for 2007-2009 as well.

Please remove the “dummy” records and keep the good records. Thank you.



* rockey

[paladisiac]

Stan, you mention in a customer thread that you can't fix this until all the rookie drafts have completed. Do you mind if i have a go at it? At least for the leagues i'm in that have completed their drafts? (1000,666,12) i can create a program that will eliminate them this way:

01) if a pick's in trade, leave it; remove duplicate
02) if cur oid doesn't match orig oid, leave it (pick was traded); remove duplicate
03) if pick has a pid (for 2007), leave it; remove duplicate
04) otherwise, there are two identical records sitting there. Fix it this way:
a) set all records PID to RRN
b) delete lowest RRN where lid, efsyear, efsround, efspick match

[sid]

I think your plan will work as long as the draft is finished.... go for it. BUT, back it up.

[paladisiac]

I think your plan will work as long as the draft is finished.... go for it. BUT, back it up.

is there a table or database "backup" command?

[paladisiac]

I think your plan will work as long as the draft is finished.... go for it. BUT, back it up.

yes, this will work as long as the draft is finished. I ASSUME that you are fixing the bug where duplicate pick records are being inserted for years 2007, 2008 and 2009. If that bug is fixed, other leagues won't experience this problem going forward.

[sid]

I can enforce it after we get the duplicates out. Until then, we have to live with it. Around Sept 1st I will run the fix.