Page 1 of 1

Database Error 1r+1a

PostPosted: Sun Oct 19, 2008 5:48 pm
by hartmannr
There appears to be a problem with table names like:
$2 + $0.25 Rebuy (1r+1a) (65040597), Table 32 - 15-30 - No Limit Hold'em

The SELECT query below is using "1r+1a" instead of the tourney number.
This was a 1 rebuy 1 addon tournament (hence 1r+1a in the title).
It looks like the code grabbed the contents of the first parenthesis. :)

2008/10/18 21:14:16.974: [Database (Error)] SQL exception while trying to query player: Error executing "SELECT tg.tourney_id FROM tourney_game tg, tourney t WHERE t.tourney_id=tg.tourney_id AND tg.table_name='Table 36' AND t.tourney_number=1r+1a ORDER BY tg.date_played DESC": ERROR: syntax error at or near "r";
Error while executing the query (location: 1013)

Re: Database Error 1r+1a

PostPosted: Sun Oct 19, 2008 5:51 pm
by WhiteRider
Where exactly do you see this error?

Re: Database Error 1r+1a

PostPosted: Mon Oct 20, 2008 6:09 pm
by hartmannr
The error just pops up in a message box. I can send you an image if you want.
Here is the error from the log:
2008/10/18 21:14:16.974: [Database] [PTPGSQL1] SQL Statement: SELECT tg.tourney_id FROM tourney_game tg, tourney t WHERE t.tourney_id=tg.tourney_id AND tg.table_name='Table 36' AND t.tourney_number=1r+1a ORDER BY tg.date_played DESC
2008/10/18 21:14:16.974: [Database (Error)] SQL exception while trying to query player: Error executing "SELECT tg.tourney_id FROM tourney_game tg, tourney t WHERE t.tourney_id=tg.tourney_id AND tg.table_name='Table 36' AND t.tourney_number=1r+1a ORDER BY tg.date_played DESC": ERROR: syntax error at or near "r";
Error while executing the query (location: 1013)

This is clearly a bad SQL statement: "AND t.tourney_number=1r+1a"
I happen to be a database expert.

Re: Database Error 1r+1a

PostPosted: Mon Oct 20, 2008 6:12 pm
by WhiteRider
I mean, is it a PAHud error or a PT2 error?

Please create a ticket about this on the Support system and attach a screenshot and a hand history file from one of these tournaments so that we can investigate.
Thanks.

Re: Database Error 1r+1a

PostPosted: Mon Oct 20, 2008 6:27 pm
by hartmannr
The message box indicates a PA HUD error.
I have submitted a support ticket.

Re: Database Error 1r+1a

PostPosted: Tue Oct 21, 2008 4:32 am
by WhiteRider
Thanks.

highfalutin