PDA

View Full Version : BUG: Wrong SQL Error when Group By in the Reports Tab is active



4A888
06-16-2009, 11:09 AM
Hi i wrote this to support@holdemmanager.net some days ago but got no feedback. Since i used to get feedback to my mails at the same day i wrote it in the past i just want to make sure this wasn't overlooked.

I think i found a bug in Holdem Manager.

Version: 1.09.05, 1.09.6a and probably some Versions before

When I click group by player in the Reports tab, no cards are retrieved. (lower part of the window). Stats are retrieved just fine. Postgresql states the following:
ERROR: invalid input syntax for integer: "$1/2 NL"
In the sql syntax you put ... and GT.BigBlind = '1/2 NL'. That seems to be wrong.

It's similar for group by month.
ERROR: invalid input syntax for integer: "holdem"
And in the SQL statement it says: ... and GT.BigBlind = 'holdem'

When neither group by month or group by player is clicked everything works just fine.

Hope that helps you to fix this. I'd really like to use this feature and be able to see played hands.

Keep up the good work.

morny
06-16-2009, 01:50 PM
Escalated to Roy, hell respond asap

4A888
06-25-2009, 05:27 PM
Any news on this one? Probably quite an easy fix.

fozzy71
06-25-2009, 05:34 PM
Let me forward this to the developer again. I apologize for the delay in a proper reply.

Rvg72
06-25-2009, 07:52 PM
It will be working for the group by player in 1.09 beta 10. It's actually a fairly complex thing to get around but I got it working although not yet for the group by month option.

4A888
06-26-2009, 06:18 AM
Great. Thx.