hands disappearing

[bg26892]

i have a postsql DB and it appears some of the hh's have disappeared for a certain date range.

no data shows up in the general info pag, game notes, position stats.

however, i do have session note info, as well as summary info that appears accurate.

please advise, thanks!

[ptrack pat]

How long ago did you convert to PostgreSQL?
Are you sure you don't have any sort of filters on the Preferences tab, like "# of players in hand" or anything like that?

[bg26892]

[quote="ptrack pat"oym]How long ago did you convert to PostgreSQL?
Are you sure you don't have any sort of filters on the Preferences tab, like "# of players in hand" or anything like that?[/quoteoym]

DB was converted roughly 10 months ago.
All filters have been removed.

It is very strange bc at the bottom of the misc stats section, the number of hands/winnings is correct for the past 18+ months...but I have lost some of the HH's.

Any other suggestions?

Thanks!

[bg26892]

I have also tried restoring a previous version of the same DB that I made roughly a week ago - still having the same problems.

[ptrack pat]

It sounds like the db is corrupted. These stats you are looking at, are they from before the time you converted to PostgreSQL? I've seen this kind of issue with Access databases but not with PostgreSQL. If it's from before the time you converted to PostgreSQL it's very likely the old Access db was corrupted before you converted it.