Import and missing data problem

[tapped_out]

I recently reinstalled PT'er and used the two old data files to overwrite the new download files and restore my database. Everything seemed fine until today(although I didn't try to import anything since reinstalling) but all my data and stats were present and now it's all gone and pokertracker does not work at all :?


Here are the screen shots of the errors:

This is when I first open PT'er.
[urlk8l]http://img175.imageshack.us/img175/2683/firsterrorcd8.png[/urlk8l]

This is the first error that pops up when trying to import
[urlk8l]http://img175.imageshack.us/img175/9734/errorwhenuploadingiw8.png[/urlk8l]

Second error while importing
[urlk8l]http://img175.imageshack.us/img175/4053/errorwhenuploading2on0.png[/urlk8l]

When trying to open the error file
[urlk8l]http://img175.imageshack.us/img175/4053/errorwhenuploading2on0.png[/urlk8l]

[tapped_out]

Here is the txt file it was asking for


*********************************
PT Version: 2.17.01g
Error Date: 03/21/2008 22:33
Database Error: -1611
Error Text: Select error: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
DataObject: d_dd_game_level
Syntax In Error: SELECT DISTINCT game_level.game_level_id , game_level.game_level_desc , game_level.game_level_big_bet , game_level.pl_nl FROM game_level
*********************************

[ptrack mike]

Some on the images you posted show two instances of PT running at the same time. Were you doing imports on both instances? If so, that will cause these errors and you should avoid doing that.

Try using the Utilities > Repair A Poker Database option to fix the file. If that doesn't work, do you have any backups of the database?

[tapped_out]

I only had one instance of PT running.

I repaired it successfully and the import works fine and the data has been restored, but the limts I've played are all bunched into one level. There could be other bugs but that's what I notice right away.

Here is a SS of what the prefereces tab looks like. As you can see, a few of the levels are marked ################# and even a few of the ones that are checked(200nl) don't show up on the general tab.
[urlhih]http://img120.imageshack.us/img120/8800/ptssoflevels2qz4.png[/urlhih]

I have the data files saved on an external HD so I can try overwriting again if you think that might help.


Thanks

[ptrack pat]

You can delete these bad levels using the steps listed here
archives/PT2/viewtopic.php?t=18559&highlight=f12

If any of them won't delete because it tells you there are hands associated with them, you would have to purge those sessions using the first tab on the Utilities > Database Maintenance and Options window first and then reimport those hands after you get these bad levels deleted.