Database problem
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Jul 2018
    Posts
    1

    Default Database problem

    Hello everyone, I need help. Suddenly all my old hands disappeared from reports and if i try to re-import hands only the most recent ones came out in the reports. It seems like the database was reset. What's the reason for that? How can I recover them all?
    Thanks

  2. #2
    You're out! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    20,898

    Default

    Make sure the reports and filters are not corrupted.

    Close HM2
    Please delete everything in:

    Win Vista/7/8: C:\Users\username\AppData\Roaming\HoldemManager\Re ports and \Filters
    Windows XP: C:\documents and settings\username\application data\HoldemManager\Reports and \Filters

    Showing hidden files: Hold'Em Manager 2 FAQs - Poker Software :: How are Hidden Files Viewed in Windows?
    Restart HM2 and the issue should be resolved.

    Then, make sure the database is not corrupted.

    Please try to vacuum/analyze and reindex your database - Hold'Em Manager 2 FAQs - Poker Software :: Database Manager (Ribbon)

    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 - Hold'Em Manager 2 FAQs - Poker Software :: 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. 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 - Hold'Em Manager 2 FAQs - Poker Software :: How does Backup and Restore Database, Settings and HUD configs work?

    If you continue to have problems, please reproduce the problem and zip/attach your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing - Hold'Em Manager 2 FAQs - Poker Software :: How Do I Send a Log File to Holdem Manager Support?
    Regards udbrky (Chris)

Similar Threads

  1. PostgreSQL database Problem (windows 10 problem)
    By klever187 in forum Bug Reports
    Replies: 3
    Last Post: 08-20-2015, 11:51 PM
  2. Replies: 1
    Last Post: 07-03-2015, 12:52 AM
  3. Huge Database Problem 486GB - Note Caddy Problem?
    By KingDeva in forum General Support
    Replies: 0
    Last Post: 12-18-2014, 08:49 PM
  4. Database problem
    By eastside in forum Manager General
    Replies: 2
    Last Post: 01-09-2010, 11:37 PM
  5. HM problem, can't start database, also postSQL problem
    By euroglot in forum Manager General
    Replies: 7
    Last Post: 01-22-2009, 10:55 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •