database always broken

Posted:
Wed Jun 10, 2009 10:17 pm
by chadattak
I need to repair my database quite often these days, almost every time I fire up the timer for Stars, after a couple of hands, it stop working and I get an error message. So I go to repair the database, it is sucessfull, and then the same problem happen again when I play.
Is there any tips for that? I have like 500K hands in my PT2, is it too large?
Thanks for the help.
Re: database always broken

Posted:
Wed Jun 10, 2009 10:24 pm
by ptrack pat
See the FAQ, issue #2, it tells you what to do if the error keeps coming back...
viewtopic.php?f=30&t=1377
Re: database always broken

Posted:
Sat Jun 13, 2009 5:52 pm
by chadattak
thanks Pat, I now converted to postgreSQL but I have this error now
[ img ][ img ]thanks for helping me
Re: database always broken

Posted:
Sat Jun 13, 2009 8:47 pm
by ptrack pat
Open the Utilities > PostgreSQL Settings window. The ODBC Entry to Use field should be "PostgreSQL Unicode". If it's not, you need to change it to that and save.
Then, open the File > Maintain Database Names window, click the Add button, enter a description, check the "Dflt" box and in the last field choose "Select existing PostgreSQL database". On the window that opens select the PostgreSQL database again. Delete the OLD entry that was pointing to this same PostgreSQL db. Then click OK to save all changes. CLOSE AND REOPEN POKER TRACKER.