PDA

View Full Version : disk check now having problem



scott40
11-13-2013, 11:54 AM
I don't know if it's related but I did a disk check and now I'm having a problem. My Hud is working and updating but my daily, monthly, and yearly stats aren't.

The auto update seems to be having a problem. After a hand it says

files imported 1 of 1
hands imported 1 of 1
duplicate hands: 65
errors 0


Every new hand adds one to the duplicate hands and it didn't used to do that. Is that the problem? Thanks for any help.

udbrky
11-13-2013, 04:43 PM
1) Please close HM

2) Please open PGAdminIII

It is in the Start -> Postgres folder.

3) Enter your postgres password. The default password is typically postgrespass.

4) Open the databases.

5) Highlight your database.

6) Right click, click maintenance.

7) Run the vacuum and analyze and reindex functions.

http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+

Please try again.

If it is not right, there is corrupted data.

Please create a new database.

1) Click the database name in the bottom right corner (2nd in)

2) Click the green + sign

3) Name it, click ok.

4) Import the hands from c:\hm2archive using the hand importing function on the ribbon, not the import from database in the database manager.

scott40
11-15-2013, 02:06 PM
Vacuum, analyze and reindex fixed the problem. Thanks!

udbrky
11-15-2013, 04:41 PM
Thank you for letting us know this is resolved.

Good luck at the tables,

Please let us know if we can help with anything else.