Still having problems with PT and iPoker after k patch

[Holthe]

I installed the "patch21701k" patch and everytthing was find untill I got this message:

"DBCode: 7 error Text: SQLSTATE = 22001"
ERROR: value too long for type character varying (2)
Error while execution the query

Installed the "patch21702" patch - great success - but not for long :-(

Now PT can't import the HH's and I have tried to roll back to the k patch which still gives me the error code shown above!

The errors I get are like these:

invalid hole cards listed for game #950915141.

Unexpected action found (Baron23: Raise (NF) $8.00) for game #950921227.

of_GetHandPreFlop (2) - unknown action for game #950921131 (rix29: Bet $16.00)

Error getting the player betting (flop) information (margaret90: Check) for game #950921215.

I can't make any sense of what to do. Is there any chance for you to make a sticky post on the forum with a guide to PT and iPoker.

[Holthe]

Ok this is strange!

I purged all errors and now it's working again and PT is importing the HH's correctly!

I was experiencing some strange graphic errors and relatively many disconnections during this session so I'm beginning to suspect iPoker for making changes

[ptrack pat]

That error is caused by iPoker listing more than 2 hole cards in the hand history file (not possible for Hold'em) and it gives these error for people with PostgreSQL databases. I fixed the problem in the 2.17.02 patch...you can get it from this link (MAKE SURE YOU DOWNLOAD THE PATCH INSTALL, the second link on this page, and NOT the full version:
http://www.pokertracker3.com/products/PTH/download.php

[Holthe]

The problem wasn't gone for a long time. I was and am running with the patch21702 patch.

This is from datamining. But the errors I got this night from normal play looked alike.



Here is one of the errors - just delete the post if it's not allowed to post this long and annoying error codes ;-) - I have tons of them and can ship it your way if you want:

<?xml version="1.0" encoding="utf-8"?><session sessioncode="080403142">
<general>
<mode>real</mode>
<gametype>Holdem NL 1/2</gametype>
<tablename>Melrose</tablename>
<duration>N/A</duration>
<gamecount>N/A</gamecount>
<startdate>2008-04-24 15:55:00</startdate>
<currency>USD</currency>
<nickname>GetOutRussian</nickname>
<bets>N/A</bets>
<wins>N/A</wins>
<chipsin>N/A</chipsin>
<chipsout>N/A</chipsout>
<ipoints>N/A</ipoints>
</general>
<game gamecode="951332230">
<general>
<startdate>2008-04-24 15:58:00</startdate>
<players>
<player seat="6" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="5" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="4" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="tornillo3" chips="$10000000" dealer="0" win="$25.20" bet="$20" /><player seat="2" name="cakal1" chips="$10000000" dealer="0" win="$0" bet="$8" /><player seat="1" name="Nianla3" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="cakal1" type="1" sum="$1"/>
<action no="2" player="tornillo3" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="SSankarAA" type="0" sum="$ 0"/>
<action no="4" player="MadEggs" type="0" sum="$ 0"/>
<action no="5" player="Dinhjo" type="0" sum="$ 0"/>
<action no="6" player="Nianla3" type="0" sum="$ 0"/>
<action no="7" player="cakal1" type="3" sum="$1"/>
<action no="8" player="tornillo3" type="23" sum="$8"/>
<action no="9" player="cakal1" type="3" sum="$6"/>
</round>
<round no="2">
<cards type="Flop" player="">c10 c5 h6</cards>
<action no="10" player="cakal1" type="4" sum="$ 0"/>
<action no="11" player="tornillo3" type="5" sum="$10"/>
<action no="12" player="cakal1" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951333453">
<general>
<startdate>2008-04-24 15:58:00</startdate>
<players>
<player seat="3" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="2" name="tornillo3" chips="$10000000" dealer="0" win="$72.45" bet="$40" /><player seat="1" name="cakal1" chips="$10000000" dealer="1" win="$0" bet="$33.45" />
</players>
</general>
<round no="0">
<action no="1" player="cakal1" type="23" sum="$4"/>
<action no="2" player="tornillo3" type="23" sum="$40"/>
<action no="3" player="SSankarAA" type="0" sum="$ 0"/>
<action no="4" player="cakal1" type="6" sum="$29.45"/>
</round>
<round no="2">
<cards type="Flop" player="">dK c10 hQ</cards>
</round>
<round no="3">
<cards type="Turn" player="">h8</cards>
</round>
<round no="4">
<cards type="River" player="">c9</cards>
</round>
</game>
<game gamecode="951335154">
<general>
<startdate>2008-04-24 15:58:00</startdate>
<players>
<player seat="5" name="Nianla3" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="4" name="Dinhjo" chips="$10000000" dealer="0" win="$9" bet="$6" /><player seat="3" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="tornillo3" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="SSankarAA" type="1" sum="$1"/>
<action no="2" player="MadEggs" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="Dinhjo" type="23" sum="$6"/>
<action no="4" player="Nianla3" type="0" sum="$ 0"/>
<action no="5" player="tornillo3" type="0" sum="$ 0"/>
<action no="6" player="SSankarAA" type="0" sum="$ 0"/>
<action no="7" player="MadEggs" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951335935">
<general>
<startdate>2008-04-24 15:58:00</startdate>
<players>
<player seat="6" name="tornillo3" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="5" name="cakal1" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="4" name="Nianla3" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="MadEggs" chips="$10000000" dealer="0" win="$9" bet="$8" /><player seat="1" name="SSankarAA" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="MadEggs" type="1" sum="$1"/>
<action no="2" player="Dinhjo" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="Nianla3" type="0" sum="$ 0"/>
<action no="4" player="cakal1" type="0" sum="$ 0"/>
<action no="5" player="tornillo3" type="0" sum="$ 0"/>
<action no="6" player="SSankarAA" type="0" sum="$ 0"/>
<action no="7" player="MadEggs" type="23" sum="$7"/>
<action no="8" player="Dinhjo" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951337422">
<general>
<startdate>2008-04-24 16:01:00</startdate>
<players>
<player seat="6" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="5" name="tornillo3" chips="$10000000" dealer="0" win="$32.05" bet="$22" /><player seat="4" name="cakal1" chips="$10000000" dealer="0" win="$0" bet="$8" /><player seat="3" name="Nianla3" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="MadEggs" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="Dinhjo" type="1" sum="$1"/>
<action no="2" player="Nianla3" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="cakal1" type="3" sum="$2"/>
<action no="4" player="tornillo3" type="23" sum="$8"/>
<action no="5" player="SSankarAA" type="0" sum="$ 0"/>
<action no="6" player="MadEggs" type="0" sum="$ 0"/>
<action no="7" player="Dinhjo" type="0" sum="$ 0"/>
<action no="8" player="Nianla3" type="0" sum="$ 0"/>
<action no="9" player="cakal1" type="3" sum="$6"/>
</round>
<round no="2">
<cards type="Flop" player="">s9 c5 dQ</cards>
<action no="10" player="cakal1" type="4" sum="$ 0"/>
<action no="11" player="tornillo3" type="5" sum="$14"/>
<action no="12" player="cakal1" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951338628">
<general>
<startdate>2008-04-24 16:01:00</startdate>
<players>
<player seat="6" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="5" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="4" name="tornillo3" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="cakal1" chips="$10000000" dealer="0" win="$3" bet="$2" /><player seat="2" name="Nianla3" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="Dinhjo" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="Nianla3" type="1" sum="$1"/>
<action no="2" player="cakal1" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="tornillo3" type="0" sum="$ 0"/>
<action no="4" player="SSankarAA" type="0" sum="$ 0"/>
<action no="5" player="MadEggs" type="0" sum="$ 0"/>
<action no="6" player="Dinhjo" type="0" sum="$ 0"/>
<action no="7" player="Nianla3" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951339049">
<general>
<startdate>2008-04-24 16:01:00</startdate>
<players>
<player seat="5" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="4" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="cakal1" chips="$10000000" dealer="0" win="$5.80" bet="$4" /><player seat="1" name="Nianla3" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="cakal1" type="1" sum="$1"/>
<action no="2" player="SSankarAA" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="MadEggs" type="0" sum="$ 0"/>
<action no="4" player="Dinhjo" type="0" sum="$ 0"/>
<action no="5" player="Nianla3" type="0" sum="$ 0"/>
<action no="6" player="cakal1" type="3" sum="$1"/>
<action no="7" player="SSankarAA" type="4" sum="$ 0"/>
</round>
<round no="2">
<cards type="Flop" player="">h5 dA h9</cards>
<action no="8" player="cakal1" type="5" sum="$2"/>
<action no="9" player="SSankarAA" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951339773">
<general>
<startdate>2008-04-24 16:01:00</startdate>
<players>
<player seat="5" name="Nianla3" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="4" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="MadEggs" chips="$10000000" dealer="0" win="$8.75" bet="$6" /><player seat="2" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="cakal1" chips="$10000000" dealer="1" win="$0" bet="$2" />
</players>
</general>
<round no="0">
<action no="1" player="SSankarAA" type="1" sum="$1"/>
<action no="2" player="MadEggs" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="Dinhjo" type="0" sum="$ 0"/>
<action no="4" player="Nianla3" type="0" sum="$ 0"/>
<action no="5" player="cakal1" type="3" sum="$2"/>
<action no="6" player="SSankarAA" type="0" sum="$ 0"/>
<action no="7" player="MadEggs" type="4" sum="$ 0"/>
</round>
<round no="2">
<cards type="Flop" player="">sK c6 sJ</cards>
<action no="8" player="MadEggs" type="4" sum="$ 0"/>
<action no="9" player="cakal1" type="4" sum="$ 0"/>
</round>
<round no="3">
<cards type="Turn" player="">cA</cards>
<action no="10" player="MadEggs" type="5" sum="$4"/>
<action no="11" player="cakal1" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951340602">
<general>
<startdate>2008-04-24 16:01:00</startdate>
<players>
<player seat="5" name="cakal1" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="4" name="Nianla3" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="SSankarAA" chips="$10000000" dealer="1" win="$11" bet="$8" />
</players>
</general>
<round no="0">
<action no="1" player="MadEggs" type="1" sum="$1"/>
<action no="2" player="Dinhjo" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="Nianla3" type="0" sum="$ 0"/>
<action no="4" player="cakal1" type="0" sum="$ 0"/>
<action no="5" player="SSankarAA" type="23" sum="$8"/>
<action no="6" player="MadEggs" type="0" sum="$ 0"/>
<action no="7" player="Dinhjo" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951341306">
<general>
<startdate>2008-04-24 16:01:00</startdate>
<players>
<player seat="4" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="cakal1" chips="$10000000" dealer="0" win="$3" bet="$2" /><player seat="2" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="MadEggs" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="Dinhjo" type="1" sum="$1"/>
<action no="2" player="cakal1" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="SSankarAA" type="0" sum="$ 0"/>
<action no="4" player="MadEggs" type="0" sum="$ 0"/>
<action no="5" player="Dinhjo" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951341642">
<general>
<startdate>2008-04-24 16:04:00</startdate>
<players>
<player seat="4" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="cakal1" chips="$10000000" dealer="0" win="$0" bet="$6" /><player seat="1" name="Dinhjo" chips="$10000000" dealer="1" win="$23.30" bet="$16" />
</players>
</general>
<round no="0">
<action no="1" player="cakal1" type="1" sum="$1"/>
<action no="2" player="SSankarAA" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="MadEggs" type="0" sum="$ 0"/>
<action no="4" player="Dinhjo" type="23" sum="$6"/>
<action no="5" player="cakal1" type="3" sum="$5"/>
<action no="6" player="SSankarAA" type="0" sum="$ 0"/>
</round>
<round no="2">
<cards type="Flop" player="">d8 s4 cJ</cards>
<action no="7" player="cakal1" type="4" sum="$ 0"/>
<action no="8" player="Dinhjo" type="5" sum="$10"/>
<action no="9" player="cakal1" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951342317">
<general>
<startdate>2008-04-24 16:04:00</startdate>
<players>
<player seat="4" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="SSankarAA" chips="$10000000" dealer="0" win="$10" bet="$9" /><player seat="1" name="cakal1" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="SSankarAA" type="1" sum="$1"/>
<action no="2" player="MadEggs" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="Dinhjo" type="0" sum="$ 0"/>
<action no="4" player="cakal1" type="0" sum="$ 0"/>
<action no="5" player="SSankarAA" type="23" sum="$8"/>
<action no="6" player="MadEggs" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951342787">
<general>
<startdate>2008-04-24 16:04:00</startdate>
<players>
<player seat="5" name="cakal1" chips="$10000000" dealer="0" win="$0" bet="$27.8" /><player seat="4" name="piranharama1" chips="$10000000" dealer="0" win="$55.70" bet="$29.8" /><player seat="3" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="SSankarAA" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="MadEggs" type="1" sum="$1"/>
<action no="2" player="Dinhjo" type="2" sum="$2"/>
<action no="3" player="piranharama1" type="2" sum="$2"/>
</round>
<round no="1">
<cards type="Pocket" player="cakal1">h8 h9</cards>
<cards type="Pocket" player="piranharama1">hJ cA</cards>
<action no="4" player="cakal1" type="3" sum="$2"/>
<action no="5" player="piranharama1" type="23" sum="$24"/>
<action no="6" player="SSankarAA" type="0" sum="$ 0"/>
<action no="7" player="MadEggs" type="0" sum="$ 0"/>
<action no="8" player="Dinhjo" type="0" sum="$ 0"/>
<action no="9" player="cakal1" type="6" sum="$25.80"/>
<action no="10" player="piranharama1" type="3" sum="$3.80"/>
</round>
<round no="2">
<cards type="Flop" player="">hQ sA s5</cards>
</round>
<round no="3">
<cards type="Turn" player="">d5</cards>
</round>
<round no="4">
<cards type="River" player="">c6</cards>
</round>
</game>
<game gamecode="951343882">
<general>
<startdate>2008-04-24 16:04:00</startdate>
<players>
<player seat="4" name="SSankarAA" chips="$10000000" dealer="0" win="$11" bet="$8" /><player seat="3" name="piranharama1" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="Dinhjo" chips="$10000000" dealer="0" win="$0" bet="$1" /><player seat="1" name="MadEggs" chips="$10000000" dealer="1" win="$0" bet="$0" />
</players>
</general>
<round no="0">
<action no="1" player="Dinhjo" type="1" sum="$1"/>
<action no="2" player="piranharama1" type="2" sum="$2"/>
</round>
<round no="1">
<action no="3" player="SSankarAA" type="23" sum="$8"/>
<action no="4" player="MadEggs" type="0" sum="$ 0"/>
<action no="5" player="Dinhjo" type="0" sum="$ 0"/>
<action no="6" player="piranharama1" type="0" sum="$ 0"/>
</round>
</game>
<game gamecode="951344469">
<general>
<startdate>2008-04-24 16:04:00</startdate>
<players>
<player seat="4" name="MadEggs" chips="$10000000" dealer="0" win="$0" bet="$0" /><player seat="3" name="SSankarAA" chips="$10000000" dealer="0" win="$0" bet="$2" /><player seat="2" name="piranharama1" chips="$10000000" dealer="0" win="$0" bet="$28" /><player seat="1" name="Dinhjo" chips="$10000000" dealer="1" win="$56" bet="$28" />
</players>
</general>
<round no="0">
<action no="1" player="piranharama1" type="1" sum="$1"/>
<action no="2" player="SSankarAA" type="2" sum="$2"/>
</round>
<round no="1">
<cards type="Pocket" player="piranharama1">cQ s10</cards>
<cards type="Pocket" player="Dinhjo">hA sQ</cards>
<action no="3" player="MadEggs" type="0" sum="$ 0"/>
<action no="4" player="Dinhjo" type="23" sum="$6"/>
<action no="5" player="piranharama1" type="3" sum="$5"/>
<action no="6" player="SSankarAA" type="0" sum="$ 0"/>
</round>
<round no="2">
<cards type="Flop" player="">c8 d5 c6</cards>
<action no="7" player="piranharama1" type="4" sum="$ 0"/>
<action no="8" player="Dinhjo" type="5" sum="$10"/>
<action no="9" player="piranharama1" type="3" sum="$10"/>
</round>
<round no="3">
<cards type="Turn" player="">d8</cards>
<action no="10" player="piranharama1" type="4" sum="$ 0"/>
<action no="11" player="Dinhjo" type="4" sum="$ 0"/>
</round>
<round no="4">
<cards type="River" player="">c3</cards>
<action no="12" player="piranharama1" type="5" sum="$12"/>
<action no="13" player="Dinhjo" type="3" sum="$12"/>
</round>
</game>
</session>

[ptrack pat]

You said in your first post here that you were using the K patch, not 2.17.02. Does your version number say 2.17.02 in the title bar? If it does then email me the XML file that you are getting the errors with.

[Holthe]

I don't have your email and PM's doesn't allow the xml extension!

I am running the 2.17.02 version

[ptrack pat]

Use the support system to send the file

http://www.pokertracker3.com/support/?cat_id=4