HM2 HHs all disappeared

[skoolbuly]

Hi,

My HM2 was working fine, just until now when I tried to open it. Something about having issues with PostgreSQL and click next to resolve the problem. I followed the prompts and now I dont have any graphs/HHs.

[fozzy71]

Please try to vacuum/analyze and reindex your database.

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. 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.

If you continue to have problems 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.

All original hands that are auto-imported get moved to an archive for performance reasons. Your \HM2Archive is in C:\HM2Archive by default, but you may have put it anywhere. The archive should be organized by \Month\DayOfMonth e.g C:\HM2Archive\2009\07\31 or if it was auto-imported with v7283+ it would be in C:\HM2Archive\SiteName\YYYY\MM\DD.

When sending any files please zip them (right-click > send to > compressed folder) before attaching them to an email. If the attachment is larger than 10MB please upload them to a file hosting site like dropbox, then 'copy public link' and paste the download link directly into the support ticket via the 'Contact Support' and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.