Page 1 of 1

Error message...

PostPosted: Tue Oct 06, 2009 12:39 pm
by uclafsc
I'm still getting access violations periodically, and I think it might be the pokerstars files that are triggering it.

Today I got an error message that stated the following (it said to include the hand history file that triggered it, but I have no idea which one it might be):

*********************************
PT Version: 2.17.04g
Error Date: 10/06/2009 09:02
Database Error: -3500
Error Text: Select error: SQLSTATE = 37000
[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.
DataObject: d_dd_game_level
Syntax In Error: PBSELECD( VERSION(400) DISTINCT ()TABLE(NAME="game_level" ) COLUMN(NAME="game_level.game_level_id") COLUMN(NAME="game_level.game_level_desc") COLUMN(NAME="game_level.game_level_big_bet") COLUMN(NAME="game_level.pl_nl"))
*********************************

*********************************
PT Version: 2.17.04g
Error Date: 10/06/2009 09:03
Database Error: -1605
Error Text: SQLSTATE = 23000
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that con

No changes made to database.

INSERT INTO game_level ( game_level_id, game_level_desc, game_level_big_bet, pl_nl ) VALUES ( 1, 'NL ($0.50) (6 max)', 0.5, 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 ) VALUES ( 1, 'NL ($0.50) (6 max)', 0.5, 1 )
*********************************

Re: Error message...

PostPosted: Tue Oct 06, 2009 5:51 pm
by ptrack pat
It must mean the database is corrupted. Use the Utilities > Repair A Poker Database option. If it still happens, create a new database or convert to PostgreSQL.