Hello Guys!
I am playing PLO 8 with 1.11.05d, and I have found some interesting logs. I don't remember which tab I was browsing when this was logged. The SQLErrors.log message is the following:
The Error: ERROR: 22P02: invalid input syntax for integer: "omaha o8"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion, GT.PokerGame,PH.holecard1int,PH.holecard2int,PH.ho lecard3int,PH.holecard4int,PKH.FlopCard1int,PKH.fl opcard2int,PKH.flopcard3int,PKH.TurnCardint,PKH.Ri verCardint,PH.flopplayerActionType_ID,PH.turnplaye rActionType_ID,PH.riverplayerActionType_ID,PH.NetA mountWon,GT.BigBlind,PH.PositionType_ID,PH.preflop action_id,PH.didpfr,PH.didvpip,(case when PH.StreetWentAllIn > 0 then (Select SklanskyBucks from AllInSituations where ph.playerhand_id = allinsituations.playerhand_id) else 0 end) as SklanskyBucks,(case when PH.StreetWentAllIn > 0 then (Select EquityPct from AllInSituations where ph.playerhand_id = allinsituations.playerhand_id) else 0 end) as EquityPct,getwinningplayerjoincashver2(ph.pokerhan d_id) as winningplayerjoin from playerhandscashkeycolumns_hero ph join players pl on (pl.player_id = ph.player_id) join pokerhands_hero pkh on pkh.pokerhand_id = ph.pokerhand_id join gametypes gt on gt.gametype_id = ph.gametype_id left join allinsituations_hero ev on ph.playerhand_id = ev.playerhand_id where (ph.player_id = 10770) and (ph.gametype_id = 1 or ph.gametype_id = 2 or ph.gametype_id = 3 or ph.gametype_id = 4 or ph.gametype_id = 15 or ph.gametype_id = 17 or ph.gametype_id = 18 or ph.gametype_id = 19 or ph.gametype_id = 22 or ph.gametype_id = 26 or ph.gametype_id = 27 or ph.gametype_id = 28 or ph.gametype_id = 29 or ph.gametype_id = 51 or ph.gametype_id = 85 or ph.gametype_id = 86 or ph.gametype_id = 88 or ph.gametype_id = 107 or ph.gametype_id = 115 or ph.gametype_id = 116 or ph.gametype_id = 125 or ph.gametype_id = 136 or ph.gametype_id = 162 or ph.gametype_id = 163 or ph.gametype_id = 164 or ph.gametype_id = 165 or ph.gametype_id = 166 or ph.gametype_id = 167 or ph.gametype_id = 168 or ph.gametype_id = 169 or ph.gametype_id = 170 or ph.gametype_id = 171) and ph.handtimestamp between to_timestamp('01/01/2010 00:00:00','mm/dd/yyyy hh24:mi:ss') and to_timestamp('01/01/2011 00:00:00','mm/dd/yyyy hh24:mi:ss') and GT.GameTypeDescription = '2010 12' and GT.BigBlind = 'omaha o8' and PH.HandTimeStamp between to_timestamp('12/01/2010 00:00:00','MM/DD/YYYY HH24:MI:SS') and to_timestamp('01/01/2011 00:00:00','MM/DD/YYYY HH24:MI:SS') order by PH.HandTimeStamp desc limit 100
Regards,
KZ