PDA

View Full Version : Ongame hud problem



kraks
06-22-2009, 01:31 PM
Hi, yesterday i have installed hem 1.09 beta 8 and everything works great. Today my hud just stop working :( I see tables in table manager but i dont see any stats on table. What i should to do? I dont know its important but i have trial version. I'm just looking in logs and in SQLErrors i see something like that:

The Error: ERROR: 42704: index "compiledresults_month_idx1" does not exist

Occurred when running ExecuteNonQuery with this query: DROP INDEX compiledresults_month_idx1

The Error: ERROR: 22P02: invalid input syntax for integer: "holdem"

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 pokerhands_hero pkh on ph.pokerhand_id = pkh.pokerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 2) and (ph.gametype_id = 1 or ph.gametype_id = 2) and GT.GameTypeDescription = '2009 06' and GT.BigBlind = 'holdem' order by PH.HandTimeStamp desc limit 100

fozzy71
06-22-2009, 01:50 PM
It seems to be a common issue currently. Take a look thru the last page of the current beta thread. (http://208.109.95.123/forum/showthread.php?t=11641)