The Error: ERROR: 22P02: invalid input syntax for integer: "omaha o8"
Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    May 2009
    Posts
    67

    Default The Error: ERROR: 22P02: invalid input syntax for integer: "omaha o8"

    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

  2. #2
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Thanks ill write up a bug for this
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

Similar Threads

  1. Replies: 1
    Last Post: 03-25-2010, 10:01 PM
  2. Error: invalid page header in block 297 of relation "players"
    By mksteele99 in forum Manager General
    Replies: 4
    Last Post: 10-17-2009, 06:10 AM
  3. Replies: 3
    Last Post: 01-03-2009, 07:40 PM
  4. Replies: 3
    Last Post: 11-27-2008, 11:43 AM
  5. Replies: 7
    Last Post: 08-17-2008, 01:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •