Page 1 of 1

PT Stud Database error (since todays pokerstars update)

PostPosted: Tue Aug 04, 2009 10:33 am
by theeye
*********************************
PTS Version: 1.05.06
Error Date: 08/04/2009 16:23
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key value violates unique constraint "game_level_idx_02";
Error while executing the query

No changes made to database.

INSERT INTO game_level ( game_level_id, game_level_desc, game_level_big_bet, pl_nl, game_type_id ) VALUES ( 14, '$0.50/$1.00 USD ($0.05)/$0.05 Hi', 0.05, 0, 1 )
DataObject: d_dd_game_level
Syntax In Error: INSERT INTO game_level ( game_level_id, game_level_desc, game_level_big_bet, pl_nl, game_type_id ) VALUES ( 14, '$0.50/$1.00 USD ($0.05)/$0.05 Hi', 0.05, 0, 1 )
*********************************

Any solutions?

Re: PT Stud Database error (since todays pokerstars update)

PostPosted: Tue Aug 04, 2009 2:17 pm
by ptrack mike
It looks like PokerStars decided to add "USD" to their game level descriptions. I am working on a patch.

Re: PT Stud Database error (since todays pokerstars update)

PostPosted: Tue Aug 04, 2009 2:24 pm
by theeye
k thx

Re: PT Stud Database error (since todays pokerstars update)

PostPosted: Tue Aug 04, 2009 4:31 pm
by ptrack mike
Please see here for the patch and instructions for fixing the bad level(s) that may have been created:
viewtopic.php?f=39&t=21690