Page 1 of 1

EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 11:20 am
by kinghippo423
Hello Everyone,

I've just downloaded PT3 Beta today and I fully ready to explore this new version of PokerTracker. Some little usefull informations:

- I play on EverestPoker
- I wasn't using PostgreSQL with my PT2 (Microsoft Access)
- Using Windows Vista (yes Run as Administrator etc)

For a test, I went to my PT2 BD BackUp Hand-Histories files and I copied 3 files to my EverestPoker\history folder. After that, I clicked my Auto Import File and see if it was working, and yes the hands was importing correctly. But when I clicked on the Hold'em tab, the shit hit the fan.

Everywhere there was QUERY ERRORS (Divided by Zero) in every section in every tab. Everywhere but the PlayerStatistics in the General tab to my suprise. After that, I tried importing hands while playing and then again the import didn't seam to work also but I thought it was maybe related to my 1st problem so I stopped there.

Can you tell me why I was those QUERY ERRORS?
And why my Player statistics section is working? Everything in this section must reference so much thing?

Thanks in advance,

kinghippo423

P.S. Some screenshots for the visual:

http://www.casimages.com/img.php?i=0805 ... 289130.jpg
http://www.casimages.com/img.php?i=0805 ... 289104.jpg

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 3:07 pm
by WhiteRider
I wonder if it is to do with the format of the level. It shows
,50$ NL
..where I'd expect it to be
$0.50 NL
Is your poker client set to write hand histories in English?

I think there are issues related to this which have been fixed for the next release, which you should be able to get tomorrow.

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 3:09 pm
by kinghippo423
WhiteRider wrote:I wonder if it is to do with the format of the level. It shows
,50$ NL
..where I'd expect it to be
$0.50 NL
Is your poker client set to write hand histories in English?

I think there are issues related to this which have been fixed for the next release, which you should be able to get tomorrow.


When you say client you mean EverestPoker client right? If it is, yeah my are in French (see my bad English here haha) so it's maybe the cause.

I'll keep in touch I can't wait to use PT3.

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 3:20 pm
by WhiteRider
You need to configure the poker client to write hand histories in English.

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 4:50 pm
by kinghippo423
This is the inside of one hand-history file during my session test today. This file is from my EverestPoker\history folder :

<SESSION time="1210773846" tableName="Riga-26" id="409.40.139" type="ring" money="$" screenName="knghippo423" game="hold-em" gametype="no-limit"/>
<HAND time="1210774382" id="3236415044" index="7" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="209"/>
<SEAT position="1" name="kizas" balance="853"/>
<SEAT position="2" name="knghippo423" balance="1000"/>
<SEAT position="3" name="verball" balance="512"/>
<SEAT position="4" name="IvoHR" balance="385"/>
<SEAT position="5" name="Elmsborg" balance="413"/>
<SEAT position="6" name="Jebuni" balance="760"/>
<SEAT position="7" name="@9@9@" balance="149"/>
<SEAT position="8" name="Tomnemtom" balance="326"/>
<SEAT position="9" name="Rulehen88" balance="175"/>
<DEALER position="0"/>
<BLIND position="1" amount="5" penalty="0"/>
<BLIND position="2" amount="10" penalty="0"/>
<HOLE position="1">--</HOLE>
<HOLE position="2">Ad</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">9c</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<FOLD position="3"/>
<BET position="4" amount="10"/>
<FOLD position="5"/>
<FOLD position="6"/>
<FOLD position="7"/>
<BET position="8" amount="10"/>
<FOLD position="9"/>
<FOLD position="0"/>
<FOLD position="1"/>
<BET position="2" amount="0"/>
<SWEEP rake="1">34</SWEEP>
<COMMUNITY>Kh, Jd, 10s</COMMUNITY>
<BET position="2" amount="0"/>
<BET position="4" amount="0"/>
<BET position="8" amount="0"/>
<SWEEP rake="1">34</SWEEP>
<COMMUNITY>Kd</COMMUNITY>
<BET position="2" amount="0"/>
<BET position="4" amount="0"/>
<BET position="8" amount="0"/>
<SWEEP rake="1">34</SWEEP>
<COMMUNITY>4c</COMMUNITY>
<BET position="2" amount="0"/>
<BET position="4" amount="0"/>
<BET position="8" amount="0"/>
<SWEEP rake="1">34</SWEEP>
<SHOW position="2">Ad, 9c</SHOW>
<SHOW position="4">3c, Ac</SHOW>
<SHOW position="8">8c, 7d</SHOW>
<WIN position="2" amount="17" pot="0", potAmount="34"/>
<WIN position="4" amount="17" pot="0", potAmount="34"/>
</HAND>
<HAND time="1210774462" id="3236419731" index="8" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="209"/>
<SEAT position="1" name="kizas" balance="848"/>
<SEAT position="2" name="knghippo423" balance="1007"/>
<SEAT position="4" name="IvoHR" balance="392"/>
<SEAT position="5" name="Elmsborg" balance="413"/>
<SEAT position="6" name="Jebuni" balance="760"/>
<SEAT position="7" name="@9@9@" balance="149"/>
<SEAT position="8" name="Tomnemtom" balance="316"/>
<SEAT position="9" name="Rulehen88" balance="175"/>
<DEALER position="1"/>
<BLIND position="2" amount="5" penalty="0"/>
<BLIND position="4" amount="10" penalty="0"/>
<HOLE position="2">Jd</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">Qs</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<FOLD position="5"/>
<BET position="6" amount="10"/>
<BET position="7" amount="10"/>
<BET position="8" amount="10"/>
<FOLD position="9"/>
<FOLD position="0"/>
<FOLD position="1"/>
<BET position="2" amount="5"/>
<BET position="4" amount="0"/>
<SWEEP rake="2">48</SWEEP>
<COMMUNITY>2c, 7c, 2d</COMMUNITY>
<BET position="2" amount="0"/>
<BET position="4" amount="0"/>
<BET position="6" amount="0"/>
<BET position="7" amount="10"/>
<FOLD position="8"/>
<FOLD position="2"/>
<FOLD position="4"/>
<BET position="6" amount="10"/>
<SWEEP rake="3">67</SWEEP>
<COMMUNITY>2s</COMMUNITY>
<BET position="6" amount="0"/>
<BET position="7" amount="0"/>
<SWEEP rake="3">67</SWEEP>
<COMMUNITY>6h</COMMUNITY>
<BET position="6" amount="0"/>
<BET position="7" amount="0"/>
<SWEEP rake="3">67</SWEEP>
<SHOW position="6">Ah, 10s</SHOW>
<SHOW position="7">Qc, 5c</SHOW>
<WIN position="6" amount="67" pot="0", potAmount="67"/>
</HAND>
<HAND time="1210774528" id="3236423612" index="9" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="209"/>
<SEAT position="1" name="kizas" balance="848"/>
<SEAT position="2" name="knghippo423" balance="997"/>
<SEAT position="3" name="verball" balance="512"/>
<SEAT position="4" name="IvoHR" balance="382"/>
<SEAT position="5" name="Elmsborg" balance="413"/>
<SEAT position="6" name="Jebuni" balance="807"/>
<SEAT position="7" name="@9@9@" balance="129"/>
<SEAT position="8" name="Tomnemtom" balance="306"/>
<SEAT position="9" name="Rulehen88" balance="175"/>
<DEALER position="2"/>
<BLIND position="4" amount="5" penalty="0"/>
<XBLIND position="5"/>
<XBLIND position="6"/>
<BLIND position="7" amount="10" penalty="0"/>
<HOLE position="4">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">Ac</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">6h</HOLE>
<CHAT time="1210774541" name="Jebuni">:chat4:</CHAT>
<BET position="8" amount="10"/>
<FOLD position="9"/>
<FOLD position="0"/>
<FOLD position="1"/>
<FOLD position="2"/>
<BET position="4" amount="5"/>
<BET position="7" amount="0"/>
<SWEEP rake="1">29</SWEEP>
<COMMUNITY>Qs, As, 3h</COMMUNITY>
<BET position="4" amount="0"/>
<BET position="7" amount="10"/>
<BET position="8" amount="60"/>
<FOLD position="4"/>
<BET position="7" amount="50"/>
<SWEEP rake="7">143</SWEEP>
<COMMUNITY>Kc</COMMUNITY>
<BET position="7" amount="59" allin="1"/>
<BET position="8" amount="59"/>
<SWEEP rake="13">255</SWEEP>
<SHOW position="7">Ad, 2c</SHOW>
<SHOW position="8">Qc, 3c</SHOW>
<COMMUNITY>10s</COMMUNITY>
<SHOW position="7">Ad, 2c</SHOW>
<SHOW position="8">Qc, 3c</SHOW>
<WIN position="8" amount="255" pot="0", potAmount="255"/>
</HAND>
<HAND time="1210774616" id="3236428747" index="10" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="209"/>
<SEAT position="1" name="kizas" balance="848"/>
<SEAT position="2" name="knghippo423" balance="997"/>
<SEAT position="3" name="verball" balance="512"/>
<SEAT position="4" name="IvoHR" balance="372"/>
<SEAT position="7" name="@9@9@" balance="100"/>
<SEAT position="8" name="Tomnemtom" balance="432"/>
<SEAT position="9" name="Rulehen88" balance="175"/>
<DEALER position="4"/>
<BLIND position="7" amount="5" penalty="0"/>
<BLIND position="8" amount="10" penalty="0"/>
<BLIND position="3" amount="10" penalty="5"/>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">8d</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">7c</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<FOLD position="9"/>
<FOLD position="0"/>
<BET position="1" amount="50"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<BET position="7" amount="95" allin="1"/>
<BET position="8" amount="90"/>
<BET position="1" amount="365"/>
<BET position="8" amount="315"/>
<SWEEP rake="47">294, 604</SWEEP>
<COMMUNITY>Jd, 10d, 6c</COMMUNITY>
<BET position="8" amount="17" allin="1"/>
<BET position="1" amount="17"/>
<SWEEP rake="48">295, 636</SWEEP>
<SHOW position="7">9d, 9c</SHOW>
<SHOW position="8">6h, 6d</SHOW>
<SHOW position="1">Ah, Ks</SHOW>
<COMMUNITY>2h, 5h</COMMUNITY>
<SHOW position="8">6h, 6d</SHOW>
<SHOW position="1">Ah, Ks</SHOW>
<SHOW position="7">9d, 9c</SHOW>
<WIN position="8" amount="295" pot="1", potAmount="295"/>
<WIN position="8" amount="636" pot="2", potAmount="636"/>
</HAND>
<HAND time="1210774698" id="3236433529" index="11" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="209"/>
<SEAT position="1" name="kizas" balance="416"/>
<SEAT position="2" name="knghippo423" balance="997"/>
<SEAT position="3" name="verball" balance="497"/>
<SEAT position="4" name="IvoHR" balance="372"/>
<SEAT position="5" name="-RK-" balance="300"/>
<SEAT position="6" name="supervosgien" balance="100"/>
<SEAT position="7" name="@9@9@" balance="100"/>
<SEAT position="8" name="Tomnemtom" balance="931"/>
<SEAT position="9" name="Rulehen88" balance="175"/>
<DEALER position="7"/>
<BLIND position="8" amount="5" penalty="0"/>
<BLIND position="9" amount="10" penalty="0"/>
<BLIND position="5" amount="10" penalty="0"/>
<BLIND position="6" amount="10" penalty="0"/>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">Kc</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">9d</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<FOLD position="0"/>
<FOLD position="1"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<BET position="5" amount="0"/>
<BET position="6" amount="0"/>
<BET position="7" amount="10"/>
<BET position="8" amount="55"/>
<BET position="9" amount="165" allin="1"/>
<FOLD position="5"/>
<FOLD position="6"/>
<FOLD position="7"/>
<BET position="8" amount="115"/>
<SWEEP rake="19">361</SWEEP>
<SHOW position="8">Ah, Ac</SHOW>
<SHOW position="9">Ad, Ks</SHOW>
<COMMUNITY>Js, Jh, 5d, 3h, Kd</COMMUNITY>
<SHOW position="9">Ad, Ks</SHOW>
<SHOW position="8">Ah, Ac</SHOW>
<WIN position="8" amount="361" pot="0", potAmount="361"/>
</HAND>
<HAND time="1210774742" id="3236436065" index="12" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="209"/>
<SEAT position="1" name="kizas" balance="416"/>
<SEAT position="2" name="knghippo423" balance="997"/>
<SEAT position="3" name="verball" balance="497"/>
<SEAT position="4" name="IvoHR" balance="372"/>
<SEAT position="5" name="-RK-" balance="290"/>
<SEAT position="6" name="supervosgien" balance="90"/>
<SEAT position="7" name="@9@9@" balance="90"/>
<SEAT position="8" name="Tomnemtom" balance="1117"/>
<SEAT position="9" name="Rulehen88" balance="200"/>
<DEALER position="8"/>
<BLIND position="9" amount="5" penalty="0"/>
<BLIND position="0" amount="10" penalty="0"/>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">6d</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">Jc</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<FOLD position="1"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<BET position="5" amount="10"/>
<FOLD position="6"/>
<BET position="7" amount="10"/>
<BET position="8" amount="20"/>
<FOLD position="9"/>
<FOLD position="0"/>
<BET position="5" amount="10"/>
<BET position="7" amount="80" allin="1"/>
<BET position="8" amount="70"/>
<FOLD position="5"/>
<SWEEP rake="10">205</SWEEP>
<SHOW position="7">Kc, As</SHOW>
<SHOW position="8">Ac, 8c</SHOW>
<COMMUNITY>10s, 2h, 7s, 4c, 6h</COMMUNITY>
<SHOW position="7">Kc, As</SHOW>
<SHOW position="8">Ac, 8c</SHOW>
<WIN position="7" amount="205" pot="0", potAmount="205"/>
</HAND>
<HAND time="1210774801" id="3236439481" index="13" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="199"/>
<SEAT position="1" name="kizas" balance="416"/>
<SEAT position="2" name="knghippo423" balance="997"/>
<SEAT position="3" name="verball" balance="497"/>
<SEAT position="4" name="IvoHR" balance="372"/>
<SEAT position="5" name="-RK-" balance="270"/>
<SEAT position="6" name="supervosgien" balance="90"/>
<SEAT position="7" name="@9@9@" balance="205"/>
<SEAT position="8" name="Tomnemtom" balance="1027"/>
<SEAT position="9" name="Rulehen88" balance="195"/>
<DEALER position="9"/>
<BLIND position="0" amount="5" penalty="0"/>
<XBLIND position="1"/>
<BLIND position="2" amount="10" penalty="0"/>
<HOLE position="0">--</HOLE>
<HOLE position="2">7h</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="2">5d</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<FOLD position="3"/>
<FOLD position="4"/>
<BET position="5" amount="10"/>
<BET position="6" amount="45"/>
<FOLD position="7"/>
<BET position="8" amount="45"/>
<FOLD position="9"/>
<BET position="0" amount="40"/>
<FOLD position="2"/>
<FOLD position="5"/>
<SWEEP rake="7">148</SWEEP>
<COMMUNITY>8d, Qd, 3h</COMMUNITY>
<BET position="0" amount="0"/>
<BET position="6" amount="45" allin="1"/>
<BET position="8" amount="90"/>
<FOLD position="0"/>
<PUSH position="8" amount="45"/>
<SWEEP rake="12">233</SWEEP>
<SHOW position="6">Ah, Qs</SHOW>
<SHOW position="8">Jh, Qh</SHOW>
<COMMUNITY>10d, 9s</COMMUNITY>
<SHOW position="8">Jh, Qh</SHOW>
<SHOW position="6">Ah, Qs</SHOW>
<WIN position="8" amount="233" pot="0", potAmount="233"/>
</HAND>
<HAND time="1210774863" id="3236443101" index="14" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="154"/>
<SEAT position="2" name="knghippo423" balance="987"/>
<SEAT position="3" name="verball" balance="497"/>
<SEAT position="4" name="IvoHR" balance="372"/>
<SEAT position="5" name="-RK-" balance="260"/>
<SEAT position="6" name="supervosgien" balance="100"/>
<SEAT position="7" name="@9@9@" balance="205"/>
<SEAT position="8" name="Tomnemtom" balance="1170"/>
<SEAT position="9" name="Rulehen88" balance="195"/>
<DEALER position="0"/>
<BLIND position="2" amount="5" penalty="0"/>
<BLIND position="3" amount="10" penalty="0"/>
<HOLE position="2">8d</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="2">Qd</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<FOLD position="4"/>
<BET position="5" amount="10"/>
<FOLD position="6"/>
<FOLD position="7"/>
<BET position="8" amount="10"/>
<FOLD position="9"/>
<FOLD position="0"/>
<FOLD position="2"/>
<BET position="3" amount="0"/>
<SWEEP rake="1">34</SWEEP>
<COMMUNITY>5c, 5d, 7d</COMMUNITY>
<BET position="3" amount="0"/>
<BET position="5" amount="0"/>
<BET position="8" amount="10"/>
<BET position="3" amount="10"/>
<FOLD position="5"/>
<SWEEP rake="2">53</SWEEP>
<COMMUNITY>6h</COMMUNITY>
<BET position="3" amount="0"/>
<BET position="8" amount="10"/>
<BET position="3" amount="20"/>
<FOLD position="8">As, 10c</FOLD>
<PUSH position="3" amount="10"/>
<SWEEP rake="3">72</SWEEP>
<XSHOW position="3"/>
<WIN position="3" amount="72" pot="0", potAmount="72"/>
</HAND>
<HAND time="1210774943" id="3236447799" index="15" blinds=",05$/,10$" stakes=",10$/,10$">
<SEAT position="0" name="OneTime666" balance="224"/>
<SEAT position="1" name="eric1406" balance="140"/>
<SEAT position="2" name="knghippo423" balance="982"/>
<SEAT position="3" name="verball" balance="539"/>
<SEAT position="4" name="IvoHR" balance="372"/>
<SEAT position="5" name="-RK-" balance="250"/>
<SEAT position="6" name="supervosgien" balance="100"/>
<SEAT position="7" name="@9@9@" balance="205"/>
<SEAT position="8" name="Tomnemtom" balance="1140"/>
<SEAT position="9" name="Rulehen88" balance="195"/>
<DEALER position="2"/>
<BLIND position="3" amount="5" penalty="0"/>
<BLIND position="4" amount="10" penalty="0"/>
<BLIND position="1" amount="10" penalty="0"/>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">9d</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">--</HOLE>
<HOLE position="2">5h</HOLE>
<BET position="5" amount="20"/>
<FOLD position="6"/>
<FOLD position="7"/>
<BET position="8" amount="20"/>
<FOLD position="9"/>
<FOLD position="0"/>
<BET position="1" amount="10"/>
<FOLD position="2"/>
<FOLD position="3"/>
<BET position="4" amount="10"/>
<SWEEP rake="4">81</SWEEP>
<COMMUNITY>7c, 3c, Jc</COMMUNITY>
<BET position="4" amount="0"/>
<BET position="5" amount="85"/>
<FOLD position="8"/>
<BET position="1" amount="85"/>
<FOLD position="4"/>
<SWEEP rake="12">243</SWEEP>
<COMMUNITY>6h</COMMUNITY>
<BET position="5" amount="10"/>
<BET position="1" amount="35" allin="1"/>
<BET position="5" amount="25"/>
<SWEEP rake="16">309</SWEEP>
<SHOW position="5">Ad, Ah</SHOW>
<SHOW position="1">Qc, Jd</SHOW>
<COMMUNITY>Ks</COMMUNITY>
<SHOW position="1">Qc, Jd</SHOW>
<SHOW position="5">Ad, Ah</SHOW>
<WIN position="5" amount="309" pot="0", potAmount="309"/>
</HAND>

This is the inside of one hand-history from my PokerTracker 3\Processed folder:

<SESSION time="1207467001" tableName="Berlin-19" id="346.42.1531" type="ring" money="$" screenName="knghippo423" game="hold-em" gametype="no-limit"/>
<HAND time="1207467308" id="3070300244" index="4" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="1947"/>
<SEAT position="1" name="knghippo423" balance="5000"/>
<SEAT position="2" name="casse303" balance="1390"/>
<SEAT position="3" name="fgte" balance="2815"/>
<SEAT position="4" name="Estanque" balance="3405"/>
<SEAT position="5" name="umisya" balance="6470"/>
<SEAT position="6" name="AndreP77" balance="4025"/>
<SEAT position="7" name="CruiSa" balance="5000"/>
<SEAT position="8" name="schmitt07" balance="1150"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="9"/>
<BLIND position="0" amount="25" penalty="0"/>
<BLIND position="1" amount="50" penalty="0"/>
<BLIND position="7" amount="50" penalty="0"/>
<HOLE position="0">--</HOLE>
<HOLE position="1">8s</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">3d</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<FOLD position="5"/>
<FOLD position="6"/>
<BET position="7" amount="0"/>
<FOLD position="8"/>
<FOLD position="9"/>
<FOLD position="0"/>
<BET position="1" amount="0"/>
<SWEEP rake="5">120</SWEEP>
<COMMUNITY>10s, 9s, 3c</COMMUNITY>
<BET position="1" amount="0"/>
<BET position="7" amount="0"/>
<SWEEP rake="5">120</SWEEP>
<COMMUNITY>Ah</COMMUNITY>
<BET position="1" amount="0"/>
<BET position="7" amount="0"/>
<SWEEP rake="5">120</SWEEP>
<COMMUNITY>10d</COMMUNITY>
<BET position="1" amount="50"/>
<FOLD position="7"/>
<PUSH position="1" amount="50"/>
<SWEEP rake="5">120</SWEEP>
<XSHOW position="1"/>
<WIN position="1" amount="120" pot="0", potAmount="120"/>
</HAND>
<HAND time="1207467376" id="3070301871" index="5" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="1922"/>
<SEAT position="1" name="knghippo423" balance="5070"/>
<SEAT position="2" name="casse303" balance="1390"/>
<SEAT position="3" name="fgte" balance="2815"/>
<SEAT position="4" name="Estanque" balance="3405"/>
<SEAT position="5" name="umisya" balance="6470"/>
<SEAT position="6" name="AndreP77" balance="4025"/>
<SEAT position="7" name="CruiSa" balance="4950"/>
<SEAT position="8" name="schmitt07" balance="1150"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="0"/>
<BLIND position="1" amount="25" penalty="0"/>
<BLIND position="2" amount="50" penalty="0"/>
<HOLE position="1">8c</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">Qh</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<BET position="3" amount="175"/>
<FOLD position="4"/>
<BET position="5" amount="175"/>
<FOLD position="6"/>
<FOLD position="7"/>
<FOLD position="8"/>
<FOLD position="9"/>
<FOLD position="0"/>
<FOLD position="1"/>
<FOLD position="2"/>
<SWEEP rake="20">405</SWEEP>
<COMMUNITY>Jc, 9c, 7h</COMMUNITY>
<BET position="3" amount="425"/>
<FOLD position="5"/>
<PUSH position="3" amount="425"/>
<SWEEP rake="20">405</SWEEP>
<XSHOW position="3"/>
<WIN position="3" amount="405" pot="0", potAmount="405"/>
</HAND>
<HAND time="1207467432" id="3070303235" index="6" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="1922"/>
<SEAT position="1" name="knghippo423" balance="5045"/>
<SEAT position="2" name="casse303" balance="1340"/>
<SEAT position="3" name="fgte" balance="3045"/>
<SEAT position="4" name="Estanque" balance="3405"/>
<SEAT position="5" name="umisya" balance="6295"/>
<SEAT position="6" name="AndreP77" balance="4025"/>
<SEAT position="7" name="CruiSa" balance="4950"/>
<SEAT position="8" name="schmitt07" balance="1150"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="1"/>
<BLIND position="2" amount="25" penalty="0"/>
<BLIND position="3" amount="50" penalty="0"/>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">7d</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">Qd</HOLE>
<FOLD position="4"/>
<FOLD position="5"/>
<BET position="6" amount="50"/>
<FOLD position="7"/>
<FOLD position="8"/>
<FOLD position="9"/>
<BET position="0" amount="225"/>
<FOLD position="1"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="6"/>
<PUSH position="0" amount="175"/>
<SWEEP rake="0">175</SWEEP>
<XSHOW position="0"/>
<WIN position="0" amount="175" pot="0", potAmount="175"/>
</HAND>
<HAND time="1207467508" id="3070305045" index="7" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="2047"/>
<SEAT position="1" name="knghippo423" balance="5045"/>
<SEAT position="2" name="casse303" balance="1315"/>
<SEAT position="3" name="fgte" balance="2995"/>
<SEAT position="4" name="Estanque" balance="3405"/>
<SEAT position="5" name="umisya" balance="6295"/>
<SEAT position="7" name="CruiSa" balance="4950"/>
<SEAT position="8" name="schmitt07" balance="1150"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="2"/>
<BLIND position="3" amount="25" penalty="0"/>
<BLIND position="4" amount="50" penalty="0"/>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">4s</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="7">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">3h</HOLE>
<HOLE position="2">--</HOLE>
<FOLD position="5"/>
<FOLD position="7"/>
<FOLD position="8"/>
<FOLD position="9"/>
<BET position="0" amount="50"/>
<FOLD position="1"/>
<FOLD position="2"/>
<BET position="3" amount="25"/>
<BET position="4" amount="0"/>
<SWEEP rake="5">145</SWEEP>
<COMMUNITY>Qc, As, Qd</COMMUNITY>
<BET position="3" amount="0"/>
<BET position="4" amount="0"/>
<BET position="0" amount="150"/>
<FOLD position="3"/>
<FOLD position="4"/>
<PUSH position="0" amount="150"/>
<SWEEP rake="5">145</SWEEP>
<XSHOW position="0"/>
<WIN position="0" amount="145" pot="0", potAmount="145"/>
</HAND>
<HAND time="1207467575" id="3070306626" index="8" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="2142"/>
<SEAT position="1" name="knghippo423" balance="5045"/>
<SEAT position="2" name="casse303" balance="1315"/>
<SEAT position="3" name="fgte" balance="2945"/>
<SEAT position="4" name="Estanque" balance="3355"/>
<SEAT position="5" name="umisya" balance="6295"/>
<SEAT position="6" name="AndreP77" balance="3975"/>
<SEAT position="8" name="schmitt07" balance="1150"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="3"/>
<BLIND position="4" amount="25" penalty="0"/>
<BLIND position="5" amount="50" penalty="0"/>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">5s</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">Kd</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<FOLD position="6"/>
<FOLD position="8"/>
<FOLD position="9"/>
<FOLD position="0"/>
<FOLD position="1"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<PUSH position="5" amount="25"/>
<SWEEP rake="0">50</SWEEP>
<XSHOW position="5"/>
<WIN position="5" amount="50" pot="0", potAmount="50"/>
</HAND>
<HAND time="1207467613" id="3070307554" index="9" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="2142"/>
<SEAT position="1" name="knghippo423" balance="5045"/>
<SEAT position="2" name="casse303" balance="1315"/>
<SEAT position="3" name="fgte" balance="2945"/>
<SEAT position="4" name="Estanque" balance="3330"/>
<SEAT position="5" name="umisya" balance="6320"/>
<SEAT position="6" name="AndreP77" balance="3975"/>
<SEAT position="8" name="schmitt07" balance="1150"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="4"/>
<BLIND position="5" amount="25" penalty="0"/>
<BLIND position="6" amount="50" penalty="0"/>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">Ah</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">As</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<FOLD position="8"/>
<FOLD position="9"/>
<FOLD position="0"/>
<BET position="1" amount="200"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<FOLD position="5"/>
<FOLD position="6"/>
<PUSH position="1" amount="150"/>
<SWEEP rake="0">125</SWEEP>
<XSHOW position="1"/>
<WIN position="1" amount="125" pot="0", potAmount="125"/>
</HAND>
<HAND time="1207467641" id="3070308227" index="10" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="2142"/>
<SEAT position="1" name="knghippo423" balance="5120"/>
<SEAT position="2" name="casse303" balance="1315"/>
<SEAT position="3" name="fgte" balance="2945"/>
<SEAT position="4" name="Estanque" balance="3330"/>
<SEAT position="5" name="umisya" balance="6295"/>
<SEAT position="6" name="AndreP77" balance="3925"/>
<SEAT position="8" name="schmitt07" balance="1150"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="5"/>
<BLIND position="6" amount="25" penalty="0"/>
<BLIND position="8" amount="50" penalty="0"/>
<HOLE position="6">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">2h</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">8s</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<FOLD position="9"/>
<FOLD position="0"/>
<FOLD position="1"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<BET position="5" amount="175"/>
<FOLD position="6"/>
<FOLD position="8"/>
<PUSH position="5" amount="125"/>
<SWEEP rake="0">125</SWEEP>
<XSHOW position="5"/>
<WIN position="5" amount="125" pot="0", potAmount="125"/>
</HAND>
<HAND time="1207467677" id="3070309109" index="11" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="2142"/>
<SEAT position="1" name="knghippo423" balance="5120"/>
<SEAT position="2" name="casse303" balance="1315"/>
<SEAT position="3" name="fgte" balance="2945"/>
<SEAT position="4" name="Estanque" balance="3330"/>
<SEAT position="5" name="umisya" balance="6370"/>
<SEAT position="6" name="AndreP77" balance="3900"/>
<SEAT position="8" name="schmitt07" balance="1100"/>
<SEAT position="9" name="Dalerion" balance="4950"/>
<DEALER position="6"/>
<BLIND position="8" amount="25" penalty="0"/>
<BLIND position="9" amount="50" penalty="0"/>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">Jd</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<HOLE position="8">--</HOLE>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
<HOLE position="1">Kc</HOLE>
<HOLE position="2">--</HOLE>
<HOLE position="3">--</HOLE>
<HOLE position="4">--</HOLE>
<HOLE position="5">--</HOLE>
<HOLE position="6">--</HOLE>
<FOLD position="0"/>
<FOLD position="1"/>
<FOLD position="2"/>
<FOLD position="3"/>
<FOLD position="4"/>
<FOLD position="5"/>
<BET position="6" amount="175"/>
<FOLD position="8"/>
<FOLD position="9"/>
<PUSH position="6" amount="125"/>
<SWEEP rake="0">125</SWEEP>
<XSHOW position="6"/>
<WIN position="6" amount="125" pot="0", potAmount="125"/>
</HAND>
<HAND time="1207467737" id="3070310540" index="12" blinds=",25$/,50$" stakes=",50$/,50$">
<SEAT position="0" name="JERE4551" balance="2142"/>
<SEAT position="1" name="knghippo423" balance="5120"/>
<SEAT position="2" name="casse303" balance="1315"/>
<SEAT position="3" name="fgte" balance="2945"/>
<SEAT position="4" name="Estanque" balance="3330"/>
<SEAT position="5" name="umisya" balance="6370"/>
<SEAT position="6" name="AndreP77" balance="3975"/>
<SEAT position="8" name="schmitt07" balance="1075"/>
<SEAT position="9" name="Dalerion" balance="4900"/>
<DEALER position="8"/>
<BLIND position="9" amount="25" penalty="0"/>
<BLIND position="0" amount="50" penalty="0"/>
<HOLE position="9">--</HOLE>
<HOLE position="0">--</HOLE>
</SESSION>

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 5:12 pm
by WhiteRider
Yes, I imported those hands, and I also see the query error. Please submit the file to the Support system.

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 5:24 pm
by kinghippo423
WhiteRider wrote:Yes, I imported those hands, and I also see the query error. Please submit the file to the Support system.

It's on this forum or it's by email?

Sorry for this easy question probably :(

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 5:26 pm
by WhiteRider
Click the link, then click PokerTracker, etc.

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 5:54 pm
by kinghippo423
Wow the colors of the link were alomst impossible to see...

Re: EverestPoker Hand-History Problems w/ PSQL

PostPosted: Wed May 14, 2008 7:28 pm
by APerfect10
This issue has been resolved for the commercial release tomorrow (Thursday). :)

Best regards,

Derek