AUTO IMPORT FULL TILT PLEASE HELP

[buddylistme]

I have the auto import section open in my pt3 and I am currently importing full tilt hands. The hands import correctly but as of right now where it says "import statistics" it says Hands: 31 Errors: 0 Duplicates: 15400 (and counting)

Is this normal to have so many duplicates? Also, the hud is displaying the wrong stats on players at the tables. I have trying clicking reset with no success.

P.S. as I am writing this I just received a pt3 pop up message that reads:

Error: Access violation at 0xA2B00040 (tried to read from 0xA2B00040), program terminated.

PLEASE HELP!

[buddylistme]

Edit:

Also, this is what comes up when I start the auto import:

2008/09/16 00:11:06: Auto-Import beginning
2008/09/16 00:11:06: Full Tilt: Starting auto-import.
2008/09/16 00:11:06: Full Tilt: Found 95 files to monitor.
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS1131.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS119B.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS1298.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS12BC.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS1509.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS1519.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS1E5D.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS222D.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS241E.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS27F3.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS2A0C.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS2C9F.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS2F7C.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS3CA8.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS4516.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS461B.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS4670.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS4870.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS541F.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS58E1.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS5A37.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS5A45.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS5D28.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS61DB.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS64C6.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS6C62.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS8093.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS81C9.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS8726.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS8ED6.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS8F51.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS921.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS9E4A.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSACA3.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSAD67.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSAF52.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSB946.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSBA61.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSBC1A.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSBEBD.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSCF69.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSDEDC.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSE18B.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSE938.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSE9E7.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSF001.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSF650.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSF785.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSF952.tmp
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Anasazi - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Brush - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Cogswell - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Grand Hills - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Greenbrook - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Hauck - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Hyde (deep) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Low Bridge - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Nolan - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Roaring Lion - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Rosco - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Sierra Brook - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Sunny Springs - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080908 Village Center - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 Anasazi - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 Cogswell - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 otbdave - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 Singing View - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 Spanish Wells - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 Sun Reef - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 Sweetzer - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080909 Yeager - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Cabana - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Cobble Cove - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Hayne (deep) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Low Bridge - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Regena Rose - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Round Castle - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Seashore - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080910 Sunny Springs - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080911 Angelou (edu) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080911 Cabana - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080911 Garnett - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080911 Hauck - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080911 Hyde (deep) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080911 Montpeliar - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080911 Village Center - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Anasazi - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Apollinaire (edu) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Brush - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Dove River - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Gustin (deep) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Harris (deep) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Inez (deep) - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Jasper Bluff - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:11:06: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\Buddylistme\FT20080915 Sunny Springs - $0.50-$1 - No Limit Hold'em.txt
2008/09/16 00:12:01: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHS68A1.tmp
2008/09/16 00:12:28: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSD115.tmp
2008/09/16 00:12:32: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSDAA7.tmp
2008/09/16 00:12:39: Full Tilt: Loading hand history file: C:\Program Files\Full Tilt Poker\HandHistory\LHSF662.tmp
2008/09/16 00:12:48: Full Tilt: Hand Imported (#8094094445)
2008/09/16 00:13:04: Full Tilt: Warning: Encountered cancelled hand history. (Hand #8020013976)
2008/09/16 00:13:07: Full Tilt: Warning: Encountered cancelled hand history. (Hand #8020767137)
2008/09/16 00:13:13: Full Tilt: Hand Imported (#8094098268)
2008/09/16 00:13:15: Full Tilt: Hand Imported (#8094099018)
2008/09/16 00:13:19: Full Tilt: Hand Imported (#8094097279)
2008/09/16 00:13:20: Full Tilt: Warning: Encountered cancelled hand history. (Hand #8016051663)
2008/09/16 00:13:22: Full Tilt: Hand Imported (#8094097545)
2008/09/16 00:13:39: Full Tilt: Hand Imported (#8094102295)
2008/09/16 00:13:46: Full Tilt: Warning: Encountered cancelled hand history. (Hand #7994813620)
2008/09/16 00:14:03: Full Tilt: Hand Imported (#8094101679)
2008/09/16 00:14:25: Full Tilt: Hand Imported (#8094104670)
2008/09/16 00:14:25: Full Tilt: Hand Imported (#8094102921)
2008/09/16 00:14:27: Full Tilt: Warning: Encountered cancelled hand history. (Hand #8016162874)
2008/09/16 00:14:36: Full Tilt: Hand Imported (#8094102365)
2008/09/16 00:14:36: Full Tilt: Hand Imported (#8094107194)
2008/09/16 00:15:24: Full Tilt: Hand Imported (#8094110671)
2008/09/16 00:15:29: Full Tilt: Hand Imported (#8094110589)
2008/09/16 00:15:38: Full Tilt: Hand Imported (#8094109408)
2008/09/16 00:15:48: Full Tilt: Hand Imported (#8094109588)

[buddylistme]

WTF Im going crazy now Im getting this in my autoimport section:

2008/09/16 00:19:47: Full Tilt: Unable to import hand (#8012210663). Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: value "84211552" is out of range for type smallint CONTEXT: COPY holdem_hand_summary, line 1, column id_limit: "84211552" )

PLEASE HELP!

[WhiteRider]

The original issue with the duplicates means that the processed hands weren't moved after they were imported previously. You can either let auto import complete (catch up with the duplicates) and then stop it, or you can move the old HH files manually.

Are you getting the second error for every hand, or one specific hand?