PDA

View Full Version : Unable to stats under report



jdm123
06-12-2010, 04:39 AM
I'm able to import, but can't see anything under reports. I have all filters off.

netsrak
06-12-2010, 05:56 AM
Please check your filter settings, date time, player name and gametype.

jdm123
06-12-2010, 01:32 PM
The power went out and everything on my computer turned off. When I turned it back on I was unable to get cash games reports to work
I have cheked filters and I believe I have it right.
Can there be anything else?

jdm123
06-12-2010, 05:33 PM
Are there any other filters than under Reports that I may have clicked?

morny
06-12-2010, 05:56 PM
can you create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database) and try reimporting the hands into the database and see if the problem persists

The 2 most common causes of this problems are 1) powering off your computer or having your computer lose power while the database is doing something and 2) an old drive with bad sectors on it. Basically what happens is a small portion of a file gets slightly corrupt and then when you reboot and windows goes into that checkdsk procedure it finds the bad section and, thinking it is doing a good thing, removes it. Postgres then loads the table and a portion of it is gone so it doesn’t like that and blocks access to the entire table. Normally when this happens it is on a completely useless file that you'll never even notice is now gone and quite often it will happen to an index in the DB which can easily be rebuilt but in your case it happened to one or more of the tables.

So, to protect against this

1) keep you hands histories in case you do need to reimport
2) use a power bar and avoid hard shutdowns (when you flick the power switch on the pc)
3) if your drive is old consider replacing it with a new one. They are cheap and much faster now than even a few years ago.

FWIW ive been using HM for probably 2 years, as part of internal testing we try out internal betas which would have more bugs than the versions we release, i regularly import hands people send that they cant get to import, i datamine 24 hours on a networked PC and i play poker regularly using HM and ive only gotten 1 corruption when my PC lost power during an import so it is extremely stable so if your having issues its most likely something on your PC