!!! Database Error !!! SQLDBCode: 11 ; SQLErrText: Select

[VonFuKT]

I´m playing on Prima and my PT don´t import hands anymore. Its says that the import is a success after force import but no hands. And also, it won´t let me compact my poker database, it just says that make sure HUD is not on even though it´s not on. Compacting hand history database was ok. And while i was auto importing this text came up

!!! Database Error !!! SQLDBCode: 11 ; SQLErrText: Select error: SQLSTATE = S1000
database disk image is malformed (11)

I´m using version 2.17.03d

[ptrack pat]

This error means the GameHistory.dat file that the Prima site is writing your hands to and the file Poker Tracker is reading has been corrupted.

Open the Prima auto-import window and click on the Configure Database Files button. Make a note of the folder name where this file exists.

Then close both PT and the Prima software. Go to that folder using Windows Explorer and rename the file GameHistory.dat to GameHistory_bad.dat.

Then open the Prima software and play a hand. A new GameHistory.dat file should be created for you. Then you should be able to start importing again.

In the future, it's a good idea to use the "Reset DB's" button on the Prima auto-import window on a regular basis. This keeps the GameHistory.dat file from getting huge and it also will make the imports faster as PT won't have to sort through a ton of old hand histories the first time the timer fires on the auto-import window.

[VonFuKT]

I have done this before in an earlier post,
viewtopic.php?f=26&t=13482

I´ve already renamed the database once as Gamehistory_bad.dat.

[ptrack pat]

Then you'll need to do it again, call it GameHistory_bad2.dat or something like that.

As for not compacting the database, with Poker Tracker closed, repair the database following the steps listed here:

http://www.pokertracker3.com/forums/arc ... ght=repair

[VonFuKT]

Ok, and the into my next stupid question: When I reset the DB, what does this mean exactly? Do I loose my played hands on Prima or what...

[ptrack pat]

It just removes the hands from the GameHistory.dat file, it doesn't touch your PT2 database. Click the help link at the top right corner of the auto-import window where it explains all this.