View Full Version : Error in hands that went past Flop

03-04-2011, 02:42 PM
Hi, ive been using HEM plo/holdem for almost 2 years now, and for what seems out of the blue suddenly it has stopped importing any hands that went past the flop.

So all hands preflop and that end at flop via check fold or bet fold are being imported but nothing else. Even getting all-in preflop is not being imported.

Anything that goes past a flop seems to not import

This was happening with just my main game of PLO on Ongame so i switched to NLHE on ftp to check whos end the problem is on, and its still happening there to.

So something is up with my HEM or SQL

I updated to 1.11.06 didnt fix it, and the new SQL.


03-04-2011, 07:57 PM
Update to http://www.holdemmanager.com/Downloads/Hm_1.11.06b%20Internal-1.exe

Which SQL version are you using?

03-04-2011, 09:49 PM
hey just insalled the link you showed me, renamed my HH files so they could try re importing. Came out as 3089 import errors 0 files imported 0 duplicate hands.

SQL version is 9.0.3-1 and i just reinstalled that also to make sure. Iam running windows XP. (32bit) i believe since i have 4gb of ram but only 3gb is active/recognized currently)

Windows XP Home Edition 2002 Service Pack 3

did a 40 hand session to see if its fixed, it said it imported all 40 hands no errors, but its not showing up at all in my DB now.

Filters set to nothing except .10/.25RUSH the stake i was playing, all hands, all dates. Nothing shows up except the sesison from earlier today that was erroneous. (sp)

03-05-2011, 12:36 PM
I dont know if this changes anything but i just re started my computer, and aside from my normal user list there was an additional account 'postgres'

I have no idea why there is a username on my computer for postgres.

Does this help?

03-05-2011, 01:46 PM
just played another 1000 hands, since upgrading to the link you showed me for HEM not a single hand is showing up in the import.

Just 1084 errors.

03-05-2011, 03:34 PM
New postgres user is normal.
Just login to your regular account (NOT to postgres)

Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe

Which Firewall, and Anti-Virus are you using?

Add exceptions to the windows firewall, even if it is off. For postgres.exe and port 5432.

Open up a handhistory:
is the formatting in English?? It's a REAL-MONEY hand? Can you attach one of the hands?

03-05-2011, 04:23 PM
okay i have added that port to exceptions and the postgres that is located in the program files/postgres/bin/postgres (Application file) when i searched my comp for a postgres.exe this is what came up.

1 for 9.0 and 1 for 8.3 (guessing thats my old SQL)

I am using AVG antivirus free edition, and have Malware anti malware + sn00p free privacy shield.

They are real money hands, attached is the first 3 from my recent session.

Full Tilt Poker Game #28750772008: Table Apollo - $0.10/$0.25 - No Limit Hold'em - 11:50:27 ET - 2011/03/05
Seat 1: GOodM3n ($26.34)
Seat 2: AngryNina ($27.69)
Seat 3: bigirwin ($25)
Seat 4: xxx ($25)
Seat 5: hh0885 ($6.09)
Seat 6: Whozznext ($52.13)
Seat 7: Robby07770 ($47.12)
Seat 8: evilgaba ($30.42)
Seat 9: sukdeznutz ($8.95)
bigirwin posts the small blind of $0.10
xxx posts the big blind of $0.25
The button is in seat #2
*** HOLE CARDS ***
Dealt to xxx [Ac 3c]
hh0885 calls $0.25
Whozznext folds
Robby07770 has 8 seconds left to act
Robby07770 has timed out
Robby07770 folds
evilgaba folds
sukdeznutz folds
GOodM3n calls $0.25
AngryNina folds
bigirwin folds
xxx checks
*** FLOP *** [9h 6c 2s]
xxx checks
hh0885 checks
GOodM3n bets $0.50
xxx folds
hh0885 folds
Uncalled bet of $0.50 returned to GOodM3n
GOodM3n mucks
GOodM3n wins the pot ($0.81)
*** SUMMARY ***
Total pot $0.85 | Rake $0.04
Board: [9h 6c 2s]
Seat 1: GOodM3n collected ($0.81), mucked
Seat 2: AngryNina (button) didn't bet (folded)
Seat 3: bigirwin (small blind) folded before the Flop
Seat 4: xxx (big blind) folded on the Flop
Seat 5: hh0885 folded on the Flop
Seat 6: Whozznext didn't bet (folded)
Seat 7: Robby07770 didn't bet (folded)
Seat 8: evilgaba didn't bet (folded)
Seat 9: sukdeznutz didn't bet (folded)

Full Tilt Poker Game #28750785471: Table Apollo - $0.10/$0.25 - No Limit Hold'em - 11:51:01 ET - 2011/03/05
Seat 1: xxx ($25)
Seat 2: YouPayMyRS4 ($48.38)
Seat 3: evilgaba ($30.32)
Seat 4: micknich ($8)
Seat 5: Torres5355 ($41.08)
Seat 6: Fiskaflesket ($27.84)
Seat 7: farfar444 ($26.84)
Seat 8: glaekenpj ($27.50)
Seat 9: Spartan1983 ($37.98)
xxx posts the small blind of $0.10
YouPayMyRS4 posts the big blind of $0.25
The button is in seat #9
*** HOLE CARDS ***
Dealt to xxx [7h Qd]
evilgaba folds
micknich has 8 seconds left to act
micknich folds
Torres5355 folds
Fiskaflesket folds
farfar444 folds
glaekenpj folds
Spartan1983 calls $0.25
xxx folds
YouPayMyRS4 checks
*** FLOP *** [5h 5d 3d]
YouPayMyRS4 bets $0.50
Spartan1983 folds
Uncalled bet of $0.50 returned to YouPayMyRS4
YouPayMyRS4 mucks
YouPayMyRS4 wins the pot ($0.57)
*** SUMMARY ***
Total pot $0.60 | Rake $0.03
Board: [5h 5d 3d]
Seat 1: xxx (small blind) folded before the Flop
Seat 2: YouPayMyRS4 (big blind) collected ($0.57), mucked
Seat 3: evilgaba didn't bet (folded)
Seat 4: micknich didn't bet (folded)
Seat 5: Torres5355 didn't bet (folded)
Seat 6: Fiskaflesket didn't bet (folded)
Seat 7: farfar444 didn't bet (folded)
Seat 8: glaekenpj didn't bet (folded)
Seat 9: Spartan1983 (button) folded on the Flop

Full Tilt Poker Game #28750789813: Table Apollo - $0.10/$0.25 - No Limit Hold'em - 11:51:12 ET - 2011/03/05
Seat 1: Mighty Yargo ($31.45)
Seat 2: vikal86 ($21.80)
Seat 3: Mattolaus ($26.64)
Seat 4: ropeDoper ($23.75)
Seat 5: GOodM3n ($26.90)
Seat 6: FishBamberg ($24.23)
Seat 7: xxx ($25)
Seat 8: hawa2i ($10)
Seat 9: DAbubbley ($44.28)
DAbubbley posts the small blind of $0.10
Mighty Yargo posts the big blind of $0.25
The button is in seat #8
*** HOLE CARDS ***
Dealt to xxx [9s 4d]
vikal86 folds
Mattolaus raises to $0.85
ropeDoper folds
GOodM3n folds
FishBamberg folds
xxx folds
hawa2i folds
DAbubbley folds
Mighty Yargo folds
Uncalled bet of $0.60 returned to Mattolaus
Mattolaus mucks
Mattolaus wins the pot ($0.60)
*** SUMMARY ***
Total pot $0.60 | Rake $0
Seat 1: Mighty Yargo (big blind) folded before the Flop
Seat 2: vikal86 didn't bet (folded)
Seat 3: Mattolaus collected ($0.60), mucked
Seat 4: ropeDoper didn't bet (folded)
Seat 5: GOodM3n didn't bet (folded)
Seat 6: FishBamberg didn't bet (folded)
Seat 7: xxx didn't bet (folded)
Seat 8: hawa2i (button) didn't bet (folded)
Seat 9: DAbubbley (small blind) folded before the Flop

Hero has been changed to xxx

After updating HEM again, and allowing those exceptions. Its still 1800 errors upon import.

I havent tried playing a fresh session since doing this. I will try that right now also.

03-05-2011, 04:32 PM
just played a quick 10 minute session, about 200 hands, 14 imported. rest were errors.

I dont get whats going on. This randomly just started happening. As i said ive been a HEM user for over 2 years and played full time pro for over a year of that.

Iam ready to freak the fk out this has been 6 weeks now with no HUD,HH reviews or EV stats.

03-05-2011, 04:40 PM
I dont know if this is anything but everytime i go into the HH root folder, i have 8-12 TMP files all 1kb each.

examples: LHS4b.tmp LHS4E.tmp

can you just PM me and we can do a teamviewer session or something? Has to be the easiest way to solve this

03-05-2011, 05:04 PM
pm sent