Questions and discussion about PokerTracker 4 for Windows
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by IMightBluff » Thu Jan 12, 2017 6:24 pm
Currently having an big issue when attempting to "Get Hand While Playing" in Tournaments. Here is the Error message: Error: Unable to execute query: Fatal Error; Reason Error: (ERROR: index"toh-unique_hand_no"is not a btree) Please help, I attached a screen shot. The Hud windows are displaying but only 1 stat is coming up. I don't believe its an import issue as I tried runing my HM2 and it seems to be working fine.
- Attachments
-
- PT4 Error.PNG (7.51 KiB) Viewed 848 times
-
IMightBluff
-
- Posts: 9
- Joined: Sun Mar 02, 2014 2:54 am
by Flag_Hippo » Fri Jan 13, 2017 9:02 am
That indicates the database is damaged so you can try a reindex via the "Database > Database Management window" - to do that select the affected database, then click "Housekeeping > Reindex". After the housekeeping is complete you should click your database then "Rebuild Cache -> Full Cache Rebuild". Be prepared for this to take a considerable amount of time if you have a large database, so you'll want to run it when you're not using PokerTracker 4 for a while (such as overnight maybe). Make sure that your computer does not power itself off or go to sleep while it's running or you will need to run it again from the start.
-
Flag_Hippo
- Moderator
-
- Posts: 14514
- Joined: Tue Jan 31, 2012 7:50 am
by IMightBluff » Fri Jan 13, 2017 3:46 pm
Thank you for the response, I am showing a different error today when I started up.
- Attachments
-
- PT4error1.PNG (6.25 KiB) Viewed 840 times
-
IMightBluff
-
- Posts: 9
- Joined: Sun Mar 02, 2014 2:54 am
by WhiteRider » Sat Jan 14, 2017 4:46 am
That suggests an error with one or more of the files which makes up your database, and can be caused by a disk fault so you may want to run a disk check as well as trying the things suggested in
this guide.
-
WhiteRider
- Moderator
-
- Posts: 53987
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by IMightBluff » Sat Jan 14, 2017 2:29 pm
The rebuild worked, thank you very much. Any idea why this would happen or how to avoid this from repeating?
-
IMightBluff
-
- Posts: 9
- Joined: Sun Mar 02, 2014 2:54 am
by WhiteRider » Sat Jan 14, 2017 3:51 pm
If you don't have any bad sectors on your disk then it's possible it's caused by a power failure or something else causing PostgreSQL to end while it's updating one of the files in the database.
-
WhiteRider
- Moderator
-
- Posts: 53987
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
Return to PokerTracker 4
Users browsing this forum: FAST WebCrawler [Crawler], Google [Bot], mitchs10 and 110 guests