I now have a similar problem with SnGs: On the winnings tab PT3 states I played 4 SnGs in January 1970. I then switched to the tournaments tab and sorted by date. Couldn't find tournaments with such a date. So I fetched the records directly from DB using SQL. I noted down the Tourney # of the malicious records and again tried to find these on the tournaments tab. The tourneys were actually there, but with correct dates (which is funny, cause the db record says 1970 - obviously PT3 stores dates in more than one field...). The only thing that all the tourneys had in common is: They're all from PartyGaming and PT3 stored a $0 total-buyin for them, which is wrong - they all had normal buyins.
In case anyone has that problem too, here's what I did to fix it manually
(use at own risk, this may corrupt your db) :
* start pgAdmin III
* connect to your DB server (right-click, connect)
* click on the SQL-query button in the toolbox
* enter: SELECT * FROM tourney_holdem_summary WHERE date_start < '1971-01-01 00:00:00'
* press F5
* you now see all tourney records with invalid date, note down the values from column tourney_no (not id_tourney!)
* go back to pt3, switch to the tournaments tab and find the affected tourneys using the tourney # you just noted.
* for each tourney note the correct start and end dates (i assume it will display the correct date for you in pt3 since it did that for me too)
* also note the correct amount of buyin / rake for each tourney (if you can't remember select a hand from the tourney and look it up in the hand history)
* go back to pgAdmin III
* click on the SQL-query button again to open a new SQL query window
* for each record in the first SQL window enter the following: UPDATE tourney_holdem_summary SET date_start = DATESTART, date_end = DATEEND, amt_buyin = BUYIN, amt_rake = RAKE WHERE id_tourney = TOURNEYID
Instead of DATESTART/DATEEND you write the start/end dates in format 'yyyy-mm-dd hh:mm:ss'
Be sure to enclose each date with single quotes.
Instead of BUYIN you write the amount of buyin (without rake)
Instead of RAKE you write the rake paid
Instead of TOURNEYID you write the record id for the tournament you want to modify. You find the record id in the column id_tourney of the first SQL window.
* doublecheck everything, especially the WHERE clause
* pray
* press F5
Write and execute separate UPDATE statements for each record you want to modify. Don't try to modify them all in one run. (possible, but error-prone)
