Page 1 of 1
hands disappearing

Posted:
Fri Apr 04, 2008 8:37 pm
by 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!
Re: hands disappearing

Posted:
Fri Apr 04, 2008 8:51 pm
by 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?
Re: hands disappearing

Posted:
Sat Apr 05, 2008 3:11 am
by 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!
Re: hands disappearing

Posted:
Sat Apr 05, 2008 3:40 am
by 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.
Re: hands disappearing

Posted:
Sat Apr 05, 2008 10:41 am
by 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.