Reports tab doesn't show all hands (all filters cleared)

[Nice Hand Sir!]

I play on pacific poker 3000 hands and in the reports tab it doesn't show all hands.

I tried several times creating a new database (4 times) and each time it shows a different number of hands in my reports tab (350, 653, 852, etc)

What can I do?

[fozzy71]

i) Please try to vacuum/analyze and reindex your database.


ii) If you continue to have problems, try the following:


Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB.


If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.


Here is a FAQ explaining how to backup your database and all settings in one easy step.


iii) If none of that helps please zip and email the problem hand histories, with a link to this thread and your forum name, to us using the 'Contact Support' link.


Make sure you also include screenshots of your reports and a detailed description by tournament number, session, hole cards, stat, etc. of some of the errors we need to test.