error for database (cash PLO + sng HU)

[legioneroff]

in torney-reports all rights

in cash-reports error:

The Error: ERROR: 42P01: missing FROM-clause entry for table "td"

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,ev.sklanskybucks,ev .equitypct from playerhandscashkeycolumns ph join pokerhands pkh on pkh.pokerhand_id = ph.pokerhand_id join gametypes gt on gt.gametype_id = ph.gametype_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 2) and td.buyin between 000 and 600 and td.tourneysize between 2 and 2 order by ph.handtimestamp desc limit 100

[legioneroff]

http://forums.holdemmanager.com/mana...h-reports.html
(clear your filters in the tourney reports tab))

[Patvs]

Open a tourney report and go to filter -> clear.
After this it should work again.