Reports Tab Doesn't Show Tournaments

[LucHarding]

I can't get the reports tab to show all of my tournaments, despite having cleared all filters. It's as if the older tournaments are automatically archived or something. Sometimes only today's tournaments are showed, while right now HM hasn't found any tournaments at all.

Could it have anything to do with the lack of space on my hard disk? I can't think of anything else, as I haven't changed anything important recently in HM or PostgreSQL. :confused:

[Patvs]

Can you see the tournaments if you set the date filter to ALL HANDS? (date range = all dates)

Do they show up if you reimport them into a new empty database?

[LucHarding]

Do they show up if you reimport them into a new empty database?

This worked, thanks. :) Do you recommend proceeding with this new database?

[fozzy71]

This worked, thanks. :) Do you recommend proceeding with this new database?

Yes, the old database was probably corrupted. You can try to fix the old database but it is just as easy to stick with the new database, delete the old database, and make sure you regularly backup the new database. If your old database had player/hand notes you may want to try fixing it or you can just backup those from the old database and restore them to the new database.

Please try to vacuum/analyze and reindex your old database - http://hm2faq.holdemmanager.com/questions/5/Database+Manager+%28Ribbon%29#maintenance


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 - http://hm2faq.holdemmanager.com/questions/3091/How+to+create+a+new+database+and+import+previously +played+hands


If the new database seems to work properly, it sounds like your database might be corrupt. 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.


Here is a FAQ explaining how to backup your database and all settings in one easy step - http://hm2faq.holdemmanager.com/questions/1471/How+does+Backup+and+Restore+Database%2C+Settings+a nd+HUD+configs+work%3F

[LucHarding]

Thank you for your advice.

[fozzy71]

You are very welcome. Good luck at the tables. If you have any further questions or problems do not hesitate to ask us.