PokerTracker

Hello when i run autoimport i i get 1119 errors and 450 duplicates, it always slows it down. How do i fix? thanks

Please review this tutorial which explains how to correct this.

Thanks, however Im getting an error after running the assistant it reads

PokerStars Unable to import hand. Reason: Unable to execute query: COPY cash_hand_player_combinations FROM STDIN;; Reason: Fatal Error (ERROR: index "ohpc:idx2-id_player" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY cash_hand_player_combinations, line 1: "6182121 2 117 f t f f f f f f f 0 5 0 f f f f f 0 f f 0 0 0 f 0 f f 0 f f f f f f f f f 0 0 0 f f f ..." )

Go to Database -> Database Management and run Housekeeping -> Reindex and that will likely fix things for you.

Also getting this error when i added ipoker
iPoker Unable to import hand. Reason: Unable to execute query: COPY cash_hand_player_combinations FROM STDIN;; Reason: Fatal Error (ERROR: index "ohpc:idx2-id_player" contains unexpected zero page at block 0 HINT: Please REINDEX it. CONTEXT: COPY cash_hand_player_combinations, line 1: "6182126 2 117 f f t f f f f f f 2 1 1 f f f f f 0 f f 0 0 0 f 0 f f 0 f f f f f f f f f 0 0 0 f f f ..." )

Sorry didnt see you already replied, will tyr thanks

Unable to execute query: REINDEX DATABASE "PT4 DB";; Reason: Fatal Error (ERROR: could not create unique index "cash_hand_histories_primary_key" DETAIL: Table contains duplicated values. )

After running rebuild cache i got the above error

That implies your database is significantly corrupted. Your best bet will be to create a new database via Database -> Database Management -> New and reimporting your hand histories via Get Hands From Disk -- set it to import from the folder listed in Configure -> Sites & Import Options -> Preferences as the processed folder and it should get all of your hands then. It may take a while though.

I made a new db. an imported of a million hands before stopping it because it was taking too long. I am getting 2k duplicate hands after doing the partial import, and have tried reinexing it without any help.

What kinds of speeds were you seeing in the reimport?