Database Error 1r+1a

[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)

[WhiteRider]

Where exactly do you see this error?

[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.

[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.

[hartmannr]

The message box indicates a PA HUD error.
I have submitted a support ticket.

[WhiteRider]

Thanks.