database error

Any support related posts should go here.

database error

Postby lemonhead77 » Tue Sep 09, 2008 12:03 pm

Im getting a window popping up saying that a database error has occurred. It goes on to say "DBCode:-1022error text :sqlstate=s1000 {microsoft}{odbc microsoft access driver} disk or network error

No changes to database

insert into player winningsdate,played Etc.

I used the utilities /repair database tool already but this has not worked
lemonhead77
 
Posts: 50
Joined: Wed Feb 20, 2008 6:10 am

Re: database error

Postby ptrack pat » Tue Sep 09, 2008 2:08 pm

It means the database file is corrupted. If the repair doesn't work then you would need to revert to a backup provided you have been doing this. When did you backup this database last before the errors started?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: database error

Postby lemonhead77 » Tue Sep 09, 2008 2:13 pm

i havent been backing up this database,does this mean that the hand history folder is corrupted? should i be deleting this now, how do i go about setting up a new folder?
lemonhead77
 
Posts: 50
Joined: Wed Feb 20, 2008 6:10 am

Re: database error

Postby ptrack pat » Tue Sep 09, 2008 2:21 pm

It doesn't have anything to do with the hand histories, it's the database file.

Open the File > Maintain Database Names window.
Double-click on the name field for the entry that is giving this error.
What is the file name and size of the file that shows in the window that opens.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: database error

Postby lemonhead77 » Tue Sep 09, 2008 2:40 pm

file name is c:\program files\poker tracker v2\ptrack.mdb File size: 1,096,520KB
lemonhead77
 
Posts: 50
Joined: Wed Feb 20, 2008 6:10 am

Re: database error

Postby lemonhead77 » Tue Sep 09, 2008 3:29 pm

????/ what do i do with this file pat??
lemonhead77
 
Posts: 50
Joined: Wed Feb 20, 2008 6:10 am

Re: database error

Postby ptrack pat » Tue Sep 09, 2008 4:22 pm

Look for a file called ptrack_backup.mdb in the c:\program files\poker tracker v2 folder. If you find it, what is the date/time on it?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: database error

Postby lemonhead77 » Tue Sep 09, 2008 5:31 pm

The date /time on this file is 09/08/2008 8:32PM
lemonhead77
 
Posts: 50
Joined: Wed Feb 20, 2008 6:10 am

Re: database error

Postby ptrack pat » Tue Sep 09, 2008 7:02 pm

With PT closed, rename the ptrack.mdb file to ptrack_bad.mdb and then rename the backup file to ptrack.mdb and see if you can import again.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: database error

Postby lemonhead77 » Wed Sep 10, 2008 5:36 am

Ok i renamed both these files and rebooted the PC. Now when i open PT and immediate window pops up "repair database" Database c:\program files\poker tracker v2\ptrack.mdb needs to be repaired.

What should i do now??
lemonhead77
 
Posts: 50
Joined: Wed Feb 20, 2008 6:10 am

Next

Return to PTH Support

Who is online

Users browsing this forum: No registered users and 2 guests