PDA

View Full Version : iPoker Import Fail.



blackjock
05-01-2010, 08:14 PM
Since the last update I have a problem importing iPoker HH.

I did a clean install after the first upgrade attempt crashed.
Now there are some hands missing and I cant import any hands in which I won the pot on or after the flop.

I have all the steals and all the folds preflop but nothing for flops at all.
It seems to have imported the correct number of hands but is missing data from all the flops I played.

My vpip pfr for these sessions is only showing 12 each when I am twice that easy. Must just be the steals registering.

Also there is W$SD of 0 as you would expect i guess.

Any one else with this problem ?
More importantly, anyone with a solution ?

a.k.a.Also
05-02-2010, 06:29 AM
If the number of hands imported is correct, this sounds like a filter problem.

Make sure all the filters are cleared on the Reports tab.

options > miscellaneous options > [x] auto apply all filter changes to all tabs

blackjock
05-02-2010, 10:24 AM
I am guessing its not a Filter problem as it says "no filters" next to the filter tab.

I also got this error message on starting HM just now.

The following error occured: ERROR:XX002: index " playerhandsflop_hero_pkey"
contains unexpected zero page at block 66.

I also played a sesion on BF which imported all hands fine.

a.k.a.Also
05-02-2010, 11:50 AM
Have you tried creating a new test database and just importing those problem hands?

It may be we will need you to forward some of the hand histories, but I would advise hanging fire for a while and I'll see if one of the database guys can have some input.

fozzy71
05-02-2010, 12:08 PM
I am guessing its not a Filter problem as it says "no filters" next to the filter tab.

I also got this error message on starting HM just now.

The following error occured: ERROR:XX002: index " playerhandsflop_hero_pkey"
contains unexpected zero page at block 66.

I also played a sesion on BF which imported all hands fine.

It sounds like your DB is damaged.

You can try to fix that index - FAQ - Hold'em Manager Poker Tracking Software :: Fix Indexes (http://faq.holdemmanager.com/questions/86/Fix+Indexes)

I would suggest you just create a new DB instead. If the new DB also has problems, I would then recommend you uninstall postgresql and reinstall a newer version.


*Try creating a new UTF DB - FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - FAQ - Hold'em Manager Poker Tracking Software :: Reinstalling on a new PC - Backup Tips (http://faq.holdemmanager.com/questions/372/Reinstalling+on+a+new+PC+-+Backup+Tips)


If you want to reinstall postgresql completely:

*Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe