Page 1 of 2

ipoker, betfair configure with PT4

PostPosted: Sun Jun 14, 2015 9:11 am
by No-Rebuy
Hi, so ive just recently downloaded the betfair poker client, im having trouble setting it up though, ive looked at your service were it shows how to do such things but it wouldnt work.
could you please guide me through on how to set up such a thing, thanks

Re: ipoker, betfair configure with PT4

PostPosted: Sun Jun 14, 2015 1:29 pm
by Flag_Hippo
To get things setup with Betfair you would want to refer to our iPoker guide here. If you are still unable to get things working then please restart PokerTracker 4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with your log file. You can find that file by clicking "File --> Show User Data Folder" in the main PokerTracker 4 window - the file we need is the text file called PokerTracker4 that is in that folder.

Re: ipoker, betfair configure with PT4

PostPosted: Fri Jun 19, 2015 12:09 pm
by No-Rebuy
ive tried following the instructions that were provided under the ipoker setup, it didnt track any of my hands.
ive followed you on trying to submit my log file but i cant find it anywere, when i type in pokertracker4 into my search engine the following tabs are produced; community,config,data,logs,processed,temp.

im not sure which ones im supose to produce or even how as ive tried to work the logging enabled part of the fix.

would delecting and go back to pt4 were i would download it and try and do things from scratch.

thanks

Re: ipoker, betfair configure with PT4

PostPosted: Fri Jun 19, 2015 1:25 pm
by kraada
You don't need to do any searching to find the log file. Just open PT4 with the Logging Enabled link from your Start menu, and in PT4 click File -> Show User Data Folder. The log we want is in the folder that appears and it's called PokerTracker4 - it's not in any of the subfolders.

Re: ipoker, betfair configure with PT4

PostPosted: Tue Jun 23, 2015 11:42 am
by No-Rebuy
hey, so this is the info your looking for, i couldnt attach it in a file as it came up, "extension log is not allowed"




2015/06/23 16:39:40.200 [00000]: [- Main -][System] PokerTracker v4.13.4
2015/06/23 16:39:40.200 [00000]: [- Main -][SystemInfo] OS: Windows 7 (build 7601, Service Pack 1), 64-bit edition
2015/06/23 16:39:40.200 [00000]: [- Main -][SystemInfo] Windows Version: 6.1 build 7601 (platform 2) Service Pack 1
2015/06/23 16:39:40.200 [00000]: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2015/06/23 16:39:40.200 [00000]: [- Main -][SystemInfo] Total Logical Processing Units: 2
2015/06/23 16:39:40.200 [00000]: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 2 (L1: 2, L2: 1, L3: 0)
2015/06/23 16:39:40.201 [00000]: [- Main -][SystemInfo] Processor 1: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/23 16:39:40.201 [00000]: [- Main -][SystemInfo] Processor 2: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/23 16:39:40.201 [00000]: [- Main -][SystemInfo] C:\ Disk Space: 305,143 mb total; 64,683 mb used; 240,460 mb free
2015/06/23 16:39:40.215 [00014]: [- Main -][SystemInfo] Physical Memory: 4,083 mb (1,692 mb available) Virtual Memory: 2,047 mb (2,047 mb available) Page File: 8,165 mb (3,256 mb available)
2015/06/23 16:39:40.216 [00000]: [- Main -][System Info] Video[0]: NVIDIA Quadro NVS 160M (\\.\DISPLAY1)
2015/06/23 16:39:40.217 [00001]: [- Main -][SystemInfo] Display[0]: Position: 0x0, Size: 1920x1040
2015/06/23 16:39:40.250 [00033]: [- Main -][SystemInfo] Anti Virus: [Not Installed]
2015/06/23 16:39:40.251 [00000]: [- Main -][SystemInfo] Adobe Flash: 17.0.0.188 Plugin: 17.0.0.188 AIR: Error: Adobe AIR not installed
2015/06/23 16:39:40.252 [00002]: [- Main -][SystemInfo] Configuration: [General]\nRunCount=106\nBuildDate=2015/06/15\nRegistrationCode=*** REG CODE REMOVED ***\nFirstRun=N\nLogging=Y\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=hammies08\nDB1.Name=PokerTracker 4 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT4 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=PT4_2014_10_06_195153\nDB2.Type=postgres\nDB2.Postgres.Database=PT4_2014_10_06_195153\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=hammies08\nDB2.Default=Y\nDB3.Name=PT4_2015_06_23_155954\nDB3.Type=postgres\nDB3.Postgres.Database=PT4_2015_06_23_155954\nDB3.Postgres.Server=localhost\nDB3.Postgres.Port=5432\nDB3.Postgres.User=postgres\nDB3.Postgres.Password=hammies08\n[Import]\nAutoStart.900=N\nAutoStart.2300=N\nAutoStart.300=Y\nAutoStart.700=N\nAutoStart.400=Y\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=Y\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.1200=N\nAutoStart.2200=N\nAutoStart.2400=N\nMoveProcessedFiles=Y\nMoveProcessedFilesDirectory=C:\Users\user\AppData\Local\PokerTracker 4\Processed\iPoker\2015\06-19\iPoker\2015\06-19\nMoveProcessedFilesBySite=Y\nMoveProcessedFilesByDate=Y\nImportObservedHands=Y\nAutoTreatAs=Y\nPromptOnCloseDuringAutoImport=N\nOverwriteTournamentSummary=N\nTournamentDetectPostSummary=N\nAutoTourneyDetect=Y\nEquity:HeroDeadCards=Y\nEquity:PreflopEnumeration=Hero\nHidden.900=N\nAutoStart.2600=N\nHidden.2600=N\nAutoStart.1400=N\nHidden.1400=N\nAutoStart.1300=N\nHidden.1300=N\nAutoStart.800=N\nHidden.800=N\nAutoStart.2500=N\nHidden.2500=N\nAutoStart.500=N\nHidden.500=N\nHidden.2300=N\nHidden.300=N\nAutoStart.1000=N\nHidden.1000=N\nHidden.700=N\nHidden.400=N\nHidden.2100=N\nHidden.1100=N\nHidden.600=N\nHidden.200=N\nHidden.100=N\nHidden.1200=N\nHidden.2200=N\nHidden.2400=N\nEmail:Pop:Port=110\nEmail:Pop:Password=^E:\nEmail:Pop:UseSSL=N\n[Site.iPoker]\nFastHud=Y\nHandHistoryDirectories=C:\Poker\Betfair.com Poker\History;C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u;\nSkinName=Default\nSkinTimeZone=GMT\nAutoCenter=Y\n[Site.OnGame]\nPreferred.10=7\nAlwaysOnTop=Y\nHandHistoryDirectories=C:\Users\user\P5JavaClientSettings\handhistory;\n[TournamentDetect]\nCheckBoxProtectType=N\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nUnknownFinishRefundBuyin=N\nUnknownFinishICMAward=N\nNetAdjAllPlayers=Y\nNetAdjActivePlayerDecisions=N\nDefaultTables=0\nDefaultMinsPerRound=10\nDefaultRebuyMinutes=60\nNetAdjMTT=N\n[Players]\nActiveSiteID=300\nActiveName=No-rebuy-4-u\nPrevious.1.SiteID=100\nPrevious.1.Name=SoMany1Times\nPrevious.2.SiteID=300\nPrevious.2.Name=No-rebuy-4-u\nPrevious.3.SiteID=600\nPrevious.3.Name=SoMany1Times\n[Site.PokerStars]\nZoomHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.9=5\n[Site.FullTilt]\nHandHistoryDirectory=C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u\nRushHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.2=2\n[HudGui]\nNotesWindowX=450\nNotesWindowY=325\n[Hud]\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nLowOpacityTranslucency=90\nNotesMaxLines=10\nUseNoteColorOutline=Y\nUseTranslucency=Y\nVectorScaling=Y\nTableSelect=Y\nMinHands=1\nCurrentLimit=N\nCurrentBetType=Y\nSessionStats=Y\nShowEquityPercentages=Y\nLastXHands=0\nLastXWeeks=0\nPlayerRanges=-\nTourneyStackFilter.0=-1\nTourneyStackFilter.1=-1\nTourneyStackFilter.2=-1\nTourneyStackFilter.3=-1\nTourneyStackFilter.4=-1\nTourneyStackFilter.5=-1\nDatabases=PokerTracker 4 Database\nPT4_2014_10_06_195153\n
2015/06/23 16:39:40.253 [00000]: [- Main -][Community] Sub Process: C:\Program Files (x86)\PokerTracker 4\PokerTrackerWeb4.exe
2015/06/23 16:39:40.253 [00000]: [- Main -][Community] Cache Dir: C:\Users\user\AppData\Local\PokerTracker 4\Community\Cache
2015/06/23 16:39:40.253 [00000]: [- Main -][Community] Log File: C:\Users\user\AppData\Local\PokerTracker 4\PokerTrackerWeb4.log
2015/06/23 16:39:40.253 [00000]: [- Main -][Community] Resources Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium
2015/06/23 16:39:40.253 [00000]: [- Main -][Community] Locales Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium\locales
2015/06/23 16:39:40.270 [00016]: [- Main -][PostgresService] Install: postgresql-9.3 (32bit)
2015/06/23 16:39:40.273 [00002]: [- Main -][System] diffInDaysNow = 2364
2015/06/23 16:39:40.274 [00001]: [- Main -][Registration] counter1 = 0xba70d93c
2015/06/23 16:39:40.274 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/23 16:39:40.274 [00000]: [- Main -][Registration] counter1 = 0xba70d93c
2015/06/23 16:39:40.275 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/23 16:39:40.275 [00000]: [- Main -][System] Getting String: 1059-4E4B-5E3C-9DA2-46FF-C5F1-7700-24F8
2015/06/23 16:39:40.303 [00029]: [- Main -][System] Attempting to connect to: https://ptlicense.com/regcheck.php
2015/06/23 16:39:42.110 [01806]: [- Main -][Registration] License written to C:\Users\user\AppData\Local\PokerTracker 4\Config/PokerTracker.lic
2015/06/23 16:39:42.113 [00003]: [- Main -][System] Currencies v1.04 is up to date.
2015/06/23 16:39:42.162 [00050]: [- Main -][System] TournamentDetect v3.92 is up to date.
2015/06/23 16:39:42.167 [00004]: [- Main -][System] FullTilt v1.34 is up to date.
2015/06/23 16:39:42.167 [00001]: [- Main -][System] Party v1.18 is up to date.
2015/06/23 16:39:42.168 [00000]: [- Main -][System] iPoker v2.12 is up to date.
2015/06/23 16:39:42.168 [00000]: [- Main -][System] Pacific v1.11 is up to date.
2015/06/23 16:39:42.168 [00001]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/autoUpdate ... leList.ini
2015/06/23 16:39:42.846 [00677]: [- Main -][System] Checking MD5 checksums...
2015/06/23 16:39:42.847 [00000]: [- Main -][System] MD5 checksum complete
2015/06/23 16:39:42.856 [00010]: [- Main -][System] Holdem: Small Omaha: NO
2015/06/23 16:39:42.857 [00000]: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2015/06/23 16:39:42.879 [00022]: [00001208][ThreadPool(Idle)] Thread [0x00001208]: Begin
2015/06/23 16:39:42.880 [00000]: [00001208][ThreadPool] Thread [02FBEE58]: Created
2015/06/23 16:39:42.880 [00001]: [00001994][ThreadPool(Idle)] Thread [0x00001994]: Begin
2015/06/23 16:39:42.881 [00000]: [00001994][ThreadPool] Thread [02FBEE00]: Created
2015/06/23 16:39:42.898 [00018]: [- Main -][WindowSplash] Checking installation
2015/06/23 16:39:42.907 [00008]: [- Main -][PostgresService] Attempting to start service...
2015/06/23 16:39:42.946 [00038]: [- Main -][PostgresService (ERROR)] Failed to start service
2015/06/23 16:39:42.952 [00005]: [00001AA4][ThreadPool(Idle)] Thread [0x00001AA4]: Begin
2015/06/23 16:39:42.952 [00000]: [00001AA4][ThreadPool] Thread [02FBF590]: Created
2015/06/23 16:39:42.953 [00000]: [00001AB8][ThreadPool(Idle)] Thread [0x00001AB8]: Begin
2015/06/23 16:39:42.953 [00000]: [00001AB8][ThreadPool] Thread [02FBECF8]: Created
2015/06/23 16:39:42.983 [00030]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:43.216 [00233]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:43.217 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:43.356 [00140]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:44.362 [01005]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:44.450 [00088]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:44.450 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:44.505 [00054]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:45.509 [01004]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:45.548 [00038]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:45.548 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:45.600 [00052]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:46.620 [01020]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:47.134 [00513]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:47.134 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:47.201 [00067]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:48.208 [01007]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:48.262 [00054]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:48.263 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:48.334 [00071]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:49.338 [01003]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:49.388 [00049]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
2015/06/23 16:39:49.388 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:49.439 [00051]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:50.466 [01027]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:50.765 [00298]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
2015/06/23 16:39:50.765 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:50.830 [00065]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:51.845 [01014]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:51.890 [00045]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:51.890 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:51.930 [00039]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:52.954 [01024]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:53.087 [00133]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:53.088 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:53.202 [00114]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.
2015/06/23 16:39:54.211 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:54.300 [00089]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:54.301 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:54.374 [00073]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:55.380 [01006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:55.437 [00057]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:55.438 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/23 16:39:55.499 [00062]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/23 16:39:55.502 [00002]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/23 16:39:55.587 [00086]: [- Main -][PostgresConnection] [0x0018f328] Successfully connected to: postgres [0949fe50] (PostgreSQL version 90305)
2015/06/23 16:39:55.588 [00000]: [- Main -][PostgresConnection] [0x0018f328] Disconnecting from database: postgres
2015/06/23 16:39:55.601 [00013]: [000010E4][WindowSplash::Worker::Entry] Beginning thread.
2015/06/23 16:39:55.601 [00000]: [000010E4][WindowSplash::Worker] Thread [0x000010E4]: Begin
2015/06/23 16:39:55.628 [00027]: [000010E4][StatManager] Loading stats and reports...
2015/06/23 16:39:55.796 [00168]: [000010E4][StatManager] Stats and reports loaded. Load: 168ms, Custom: 0.2409ms, Dupe: -
2015/06/23 16:39:55.796 [00000]: [000010E4][FilterManager] Loading filters...
2015/06/23 16:39:56.062 [00267]: [000010E4][FilterManager] Filters loaded.
2015/06/23 16:39:56.068 [00000]: [000010E4][LayoutManager] Loading layouts...
2015/06/23 16:39:56.158 [00090]: [000010E4][LayoutManager] Adding Table Select Layout
2015/06/23 16:39:56.164 [00001]: [000010E4][StatManager] Loading stats and reports...
2015/06/23 16:39:56.272 [00107]: [000010E4][StatManager] Stats and reports loaded. Load: 107ms, Custom: 0.1408ms, Dupe: -
2015/06/23 16:39:56.272 [00000]: [000010E4][LayoutManager] Layouts loaded.
2015/06/23 16:39:56.287 [00015]: [000010E4][TagManager] Loaded 23 tag icons in 14ms
2015/06/23 16:39:56.287 [00000]: [000010E4][StatManager] Loading stats and reports...
2015/06/23 16:39:56.379 [00092]: [000010E4][StatManager] Stats and reports loaded. Load: 92ms, Custom: 0.1796ms, Dupe: -
2015/06/23 16:39:56.557 [00178]: [000010E4][NotesManager] AutoNotes loaded.
2015/06/23 16:39:56.585 [00028]: [000010E4][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/23 16:39:56.590 [00004]: [000010E4][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/23 16:39:56.598 [00008]: [000010E4][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/23 16:39:56.605 [00007]: [000010E4][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/23 16:39:56.608 [00003]: [000010E4][NotesManager] Initialized: 321ms
2015/06/23 16:39:56.609 [00001]: [000010E4][Player] 0 buddies found
2015/06/23 16:39:56.609 [00000]: [000010E4][WindowSplash::Worker::Entry] Ending thread.
2015/06/23 16:39:56.610 [00001]: [- Main -][WindowSplash] Initializing Main Window
2015/06/23 16:39:56.611 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/23 16:39:56.689 [00078]: [- Main -][PostgresConnection] [0x0c250570] Successfully connected to: PT4_2014_10_06_195153 [0c27e2b8] (PostgreSQL version 90305)
2015/06/23 16:39:56.760 [00071]: [- Main -][ConnectionManager] Database Version: 400019
2015/06/23 16:39:56.945 [00184]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/23 16:39:57.257 [00312]: [- Main -][PostgresConnection] [0x0c250320] Successfully connected to: PT4_2014_10_06_195153 [0be29968] (PostgreSQL version 90305)
2015/06/23 16:39:57.260 [00002]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/23 16:39:57.618 [00358]: [- Main -][PostgresConnection] [0x0c250448] Successfully connected to: PT4_2014_10_06_195153 [0bca04b0] (PostgreSQL version 90305)
2015/06/23 16:39:57.620 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/23 16:39:57.714 [00094]: [- Main -][PostgresConnection] [0x0c250698] Successfully connected to: PT4_2014_10_06_195153 [0b656620] (PostgreSQL version 90305)
2015/06/23 16:39:57.896 [00182]: [- Main -][CurrencyManager] Database Global Currency: USD
2015/06/23 16:39:57.918 [00022]: [- Main -][LayoutManager] Caching profile data.
2015/06/23 16:40:00.381 [02464]: [- Main -][LayoutManager] Caching profile data complete: 2.46s
2015/06/23 16:40:01.005 [00623]: [- Main -][StatManager] cacheVerifyIndexes: Cache indexes up to date.
2015/06/23 16:40:01.255 [00250]: [- Main -][WindowMain] Database: PT4_2014_10_06_195153 Size: 1635 MB
2015/06/23 16:41:14.107 [72853]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"

Re: ipoker, betfair configure with PT4

PostPosted: Tue Jun 23, 2015 2:45 pm
by kraada
That's the right file, but it doesn't show you doing anything beyond starting PT4 and opening the log. Please click Get Hands While Playing and attempt to play some then attach that file to a support ticket. Once you follow that link you will be able to attach the log there.

Re: ipoker, betfair configure with PT4

PostPosted: Sat Jun 27, 2015 11:37 am
by No-Rebuy
so ive recently played a few hands, but still not sure how to attach the log file. hope you can do the same with the log file paste.

i can only fit 60000 words so have the full log file in the following 2 pastes. thanks

2015/06/27 16:19:14.939 [00001]: [- Main -][System] PokerTracker v4.13.4
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] OS: Windows 7 (build 7601, Service Pack 1), 64-bit edition
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Windows Version: 6.1 build 7601 (platform 2) Service Pack 1
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Total Logical Processing Units: 2
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 2 (L1: 2, L2: 1, L3: 0)
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 1: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 2: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.943 [00000]: [- Main -][SystemInfo] C:\ Disk Space: 305,143 mb total; 64,628 mb used; 240,515 mb free
2015/06/27 16:19:15.095 [00151]: [- Main -][SystemInfo] Physical Memory: 4,083 mb (2,319 mb available) Virtual Memory: 2,047 mb (2,047 mb available) Page File: 8,165 mb (4,542 mb available)
2015/06/27 16:19:15.104 [00008]: [- Main -][System Info] Video[0]: NVIDIA Quadro NVS 160M (\\.\DISPLAY1)
2015/06/27 16:19:15.106 [00001]: [- Main -][SystemInfo] Display[0]: Position: 0x0, Size: 1280x760
2015/06/27 16:19:15.181 [00074]: [- Main -][SystemInfo] Anti Virus: [Not Installed]
2015/06/27 16:19:20.226 [05044]: [- Main -][SystemInfo] Adobe Flash: 17.0.0.190 Plugin: 17.0.0.190 AIR: Error: Adobe AIR not installed
2015/06/27 16:19:20.228 [00002]: [- Main -][SystemInfo] Configuration: [General]\nRunCount=107\nBuildDate=2015/06/15\nRegistrationCode=*** REG CODE REMOVED ***\nFirstRun=N\nLogging=Y\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=hammies08\nDB1.Name=PokerTracker 4 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT4 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=PT4_2014_10_06_195153\nDB2.Type=postgres\nDB2.Postgres.Database=PT4_2014_10_06_195153\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=hammies08\nDB2.Default=Y\nDB3.Name=PT4_2015_06_23_155954\nDB3.Type=postgres\nDB3.Postgres.Database=PT4_2015_06_23_155954\nDB3.Postgres.Server=localhost\nDB3.Postgres.Port=5432\nDB3.Postgres.User=postgres\nDB3.Postgres.Password=hammies08\n[Import]\nAutoStart.900=N\nAutoStart.2300=N\nAutoStart.300=Y\nAutoStart.700=N\nAutoStart.400=Y\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=Y\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.1200=N\nAutoStart.2200=N\nAutoStart.2400=N\nMoveProcessedFiles=Y\nMoveProcessedFilesDirectory=C:\Users\user\AppData\Local\PokerTracker 4\Processed\iPoker\2015\06-19\iPoker\2015\06-19\nMoveProcessedFilesBySite=Y\nMoveProcessedFilesByDate=Y\nImportObservedHands=Y\nAutoTreatAs=Y\nPromptOnCloseDuringAutoImport=N\nOverwriteTournamentSummary=N\nTournamentDetectPostSummary=N\nAutoTourneyDetect=Y\nEquity:HeroDeadCards=Y\nEquity:PreflopEnumeration=Hero\nHidden.900=N\nAutoStart.2600=N\nHidden.2600=N\nAutoStart.1400=N\nHidden.1400=N\nAutoStart.1300=N\nHidden.1300=N\nAutoStart.800=N\nHidden.800=N\nAutoStart.2500=N\nHidden.2500=N\nAutoStart.500=N\nHidden.500=N\nHidden.2300=N\nHidden.300=N\nAutoStart.1000=N\nHidden.1000=N\nHidden.700=N\nHidden.400=N\nHidden.2100=N\nHidden.1100=N\nHidden.600=N\nHidden.200=N\nHidden.100=N\nHidden.1200=N\nHidden.2200=N\nHidden.2400=N\nEmail:Pop:Port=110\nEmail:Pop:Password=^E:\nEmail:Pop:UseSSL=N\n[Site.iPoker]\nFastHud=Y\nHandHistoryDirectories=C:\Poker\Betfair.com Poker\History;C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u;\nSkinName=Default\nSkinTimeZone=GMT\nAutoCenter=Y\n[Site.OnGame]\nPreferred.10=7\nAlwaysOnTop=Y\nHandHistoryDirectories=C:\Users\user\P5JavaClientSettings\handhistory;\n[TournamentDetect]\nCheckBoxProtectType=N\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nUnknownFinishRefundBuyin=N\nUnknownFinishICMAward=N\nNetAdjAllPlayers=Y\nNetAdjActivePlayerDecisions=N\nDefaultTables=0\nDefaultMinsPerRound=10\nDefaultRebuyMinutes=60\nNetAdjMTT=N\n[Players]\nActiveSiteID=300\nActiveName=No-rebuy-4-u\nPrevious.1.SiteID=100\nPrevious.1.Name=SoMany1Times\nPrevious.2.SiteID=300\nPrevious.2.Name=No-rebuy-4-u\nPrevious.3.SiteID=600\nPrevious.3.Name=SoMany1Times\n[Site.PokerStars]\nZoomHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.9=5\n[Site.FullTilt]\nHandHistoryDirectory=C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u\nRushHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.2=2\n[HudGui]\nNotesWindowX=450\nNotesWindowY=325\n[Hud]\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nLowOpacityTranslucency=90\nNotesMaxLines=10\nUseNoteColorOutline=Y\nUseTranslucency=Y\nVectorScaling=Y\nTableSelect=Y\nMinHands=1\nCurrentLimit=N\nCurrentBetType=Y\nSessionStats=Y\nShowEquityPercentages=Y\nLastXHands=0\nLastXWeeks=0\nPlayerRanges=-\nTourneyStackFilter.0=-1\nTourneyStackFilter.1=-1\nTourneyStackFilter.2=-1\nTourneyStackFilter.3=-1\nTourneyStackFilter.4=-1\nTourneyStackFilter.5=-1\nDatabases=PokerTracker 4 Database\nPT4_2014_10_06_195153\n
2015/06/27 16:19:20.445 [00217]: [- Main -][Community] Sub Process: C:\Program Files (x86)\PokerTracker 4\PokerTrackerWeb4.exe
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Cache Dir: C:\Users\user\AppData\Local\PokerTracker 4\Community\Cache
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Log File: C:\Users\user\AppData\Local\PokerTracker 4\PokerTrackerWeb4.log
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Resources Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium
2015/06/27 16:19:20.446 [00000]: [- Main -][Community] Locales Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium\locales
2015/06/27 16:19:44.178 [23733]: [- Main -][PostgresService] Install: postgresql-9.3 (32bit)
2015/06/27 16:19:44.353 [00175]: [- Main -][System] diffInDaysNow = 2368
2015/06/27 16:19:44.354 [00001]: [- Main -][Registration] counter1 = 0xba70d93c
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter1 = 0xba70d940
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00001]: [- Main -][System] Getting String: 1059-4E4B-5E3C-9DA2-46FF-C5F1-7700-24F8
2015/06/27 16:19:44.650 [00294]: [- Main -][System] Attempting to connect to: https://ptlicense.com/regcheck.php
2015/06/27 16:19:48.617 [03968]: [- Main -][Registration] License written to C:\Users\user\AppData\Local\PokerTracker 4\Config/PokerTracker.lic
2015/06/27 16:19:51.016 [02397]: [- Main -][WindowDialog] Opening Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.856 [04840]: [- Main -][WindowDialog] Closing Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.862 [00006]: [- Main -][System] Currencies v1.04 is up to date.
2015/06/27 16:19:55.948 [00086]: [- Main -][System] TournamentDetect v3.92 is up to date.
2015/06/27 16:19:55.949 [00001]: [- Main -][System] FullTilt v1.34 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] Party v1.18 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] iPoker v2.12 is up to date.
2015/06/27 16:19:55.951 [00001]: [- Main -][System] Pacific v1.11 is up to date.
2015/06/27 16:19:56.087 [00136]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/autoUpdate ... leList.ini
2015/06/27 16:19:58.915 [02828]: [- Main -][System] Checking MD5 checksums...
2015/06/27 16:19:58.915 [00000]: [- Main -][System] MD5 checksum complete
2015/06/27 16:19:58.924 [00009]: [- Main -][System] Holdem: Small Omaha: NO
2015/06/27 16:19:58.925 [00001]: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2015/06/27 16:19:58.936 [00011]: [0000129C][ThreadPool(Idle)] Thread [0x0000129C]: Begin
2015/06/27 16:19:58.936 [00000]: [0000129C][ThreadPool] Thread [02F192E0]: Created
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool(Idle)] Thread [0x00002434]: Begin
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool] Thread [02F18838]: Created
2015/06/27 16:19:58.962 [00025]: [00001484][ThreadPool(Idle)] Thread [0x00001484]: Begin
2015/06/27 16:19:58.962 [00000]: [00001484][ThreadPool] Thread [02F18940]: Created
2015/06/27 16:19:58.963 [00001]: [00002044][ThreadPool(Idle)] Thread [0x00002044]: Begin
2015/06/27 16:19:58.963 [00000]: [00002044][ThreadPool] Thread [02F18890]: Created
2015/06/27 16:19:59.211 [00248]: [- Main -][WindowSplash] Checking installation
2015/06/27 16:19:59.212 [00001]: [- Main -][PostgresService] Attempting to start service...
2015/06/27 16:19:59.221 [00009]: [- Main -][PostgresService (ERROR)] Failed to start service
2015/06/27 16:19:59.227 [00006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:00.620 [01392]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:00.621 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:00.774 [00153]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.785 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:01.889 [00104]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.890 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:02.018 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.027 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:03.101 [00074]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.102 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:03.163 [00061]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.169 [01006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:04.201 [00032]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.201 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:04.244 [00043]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.254 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:05.502 [00249]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.503 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:05.581 [00078]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.591 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:06.894 [00302]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.895 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:07.023 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.034 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:08.299 [00265]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.300 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:08.476 [00176]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.487 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:09.599 [00111]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.600 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:09.719 [00118]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.729 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:10.850 [00121]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.851 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:10.928 [00077]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:11.950 [01022]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:12.056 [00105]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:12.057 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:12.293 [00235]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.327 [01034]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:13.566 [00238]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.566 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:13.695 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.697 [00001]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:15.160 [01463]: [- Main -][PostgresConnection] [0x0018f328] Successfully connected to: postgres [02f4bb28] (PostgreSQL version 90305)
2015/06/27 16:20:15.160 [00000]: [- Main -][PostgresConnection] [0x0018f328] Disconnecting from database: postgres
2015/06/27 16:20:15.162 [00002]: [00002124][WindowSplash::Worker::Entry] Beginning thread.
2015/06/27 16:20:15.163 [00000]: [00002124][WindowSplash::Worker] Thread [0x00002124]: Begin
2015/06/27 16:20:15.280 [00116]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:15.958 [00677]: [00002124][StatManager] Stats and reports loaded. Load: 678ms, Custom: 101ms, Dupe: -
2015/06/27 16:20:15.958 [00000]: [00002124][FilterManager] Loading filters...
2015/06/27 16:20:17.197 [01239]: [00002124][FilterManager] Filters loaded.
2015/06/27 16:20:17.198 [00000]: [00002124][LayoutManager] Loading layouts...
2015/06/27 16:20:20.839 [03642]: [00002124][LayoutManager] Adding Table Select Layout
2015/06/27 16:20:20.841 [00002]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:21.120 [00278]: [00002124][StatManager] Stats and reports loaded. Load: 278ms, Custom: 0.1404ms, Dupe: -
2015/06/27 16:20:21.120 [00000]: [00002124][LayoutManager] Layouts loaded.
2015/06/27 16:20:22.211 [01092]: [00002124][TagManager] Loaded 23 tag icons in 1.09s
2015/06/27 16:20:22.212 [00000]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:22.384 [00172]: [00002124][StatManager] Stats and reports loaded. Load: 172ms, Custom: 0.1104ms, Dupe: -
2015/06/27 16:20:23.394 [01010]: [00002124][NotesManager] AutoNotes loaded.
2015/06/27 16:20:23.791 [00397]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.806 [00014]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.873 [00066]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.902 [00029]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.925 [00022]: [00002124][NotesManager] Initialized: 1.71s
2015/06/27 16:20:23.930 [00005]: [00002124][Player] 0 buddies found
2015/06/27 16:20:23.931 [00000]: [00002124][WindowSplash::Worker::Entry] Ending thread.
2015/06/27 16:20:23.931 [00000]: [- Main -][WindowSplash] Initializing Main Window
2015/06/27 16:20:23.936 [00004]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:24.393 [00456]: [- Main -][PostgresConnection] [0x0c1281e0] Successfully connected to: PT4_2014_10_06_195153 [0c011f80] (PostgreSQL version 90305)
2015/06/27 16:20:29.688 [05295]: [- Main -][ConnectionManager] Database Version: 400019
2015/06/27 16:20:32.181 [02492]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.411 [00229]: [- Main -][PostgresConnection] [0x0c127f90] Successfully connected to: PT4_2014_10_06_195153 [0b666330] (PostgreSQL version 90305)
2015/06/27 16:20:32.412 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.457 [00044]: [- Main -][PostgresConnection] [0x0c1280b8] Successfully connected to: PT4_2014_10_06_195153 [0afde9c8] (PostgreSQL version 90305)
2015/06/27 16:20:32.458 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.665 [00207]: [- Main -][PostgresConnection] [0x0c128308] Successfully connected to: PT4_2014_10_06_195153 [0aeaa280] (PostgreSQL version 90305)
2015/06/27 16:20:34.538 [01873]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/currencyRates.php
2015/06/27 16:20:36.280 [01742]: [- Main -][CurrencyManager] Added 10 new rates
2015/06/27 16:20:37.002 [00722]: [- Main -][CurrencyManager] Database Global Currency: USD
2015/06/27 16:20:37.058 [00056]: [- Main -][LayoutManager] Caching profile data.
2015/06/27 16:20:39.906 [02848]: [- Main -][LayoutManager] Caching profile data complete: 2.85s
2015/06/27 16:20:44.285 [04378]: [- Main -][StatManager] cacheVerifyIndexes: Cache indexes up to date.
2015/06/27 16:20:46.511 [02226]: [- Main -][WindowMain] Database: PT4_2014_10_06_195153 Size: 1635 MB
2015/06/27 16:22:29.241 [99999]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"
2015/06/27 16:24:46.599 [99999]: [- Main -][wpImport] Click: Get Hands While Playing
2015/06/27 16:24:46.603 [00003]: [- Main -][ImportAuto] startImporting()::begin
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] Starting ImportAuto Worker Thread
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00001]: [- Main -][TableManager] Starting Up...
2015/06/27 16:24:46.623 [00019]: [00001228][TableManager] Thread [0x00001228]: Begin
2015/06/27 16:24:46.624 [00000]: [00001228][TableManager::Entry] Beginning thread.
2015/06/27 16:24:46.639 [00015]: [00001CE8][ImportAutoWorker] Thread [0x00001CE8]: Begin
2015/06/27 16:24:46.641 [00001]: [00001CE8][ImportAuto::ImportAutoWorker::Entry] Beginning thread.
2015/06/27 16:24:48.521 [01878]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_rotate AS UPDATE live_cash_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.567 [00046]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_rotate AS UPDATE live_tourney_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.568 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_rotate AS UPDATE live_cash_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.570 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_rotate AS UPDATE live_tourney_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.571 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_update AS UPDATE live_cash_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_update AS UPDATE live_tourney_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_update AS UPDATE live_cash_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.573 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_update AS UPDATE live_tourney_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.574 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_insert AS INSERT INTO live_cash_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.644 [00071]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_insert AS INSERT INTO live_tourney_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.645 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_insert AS INSERT INTO live_cash_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.646 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_insert AS INSERT INTO live_tourney_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.647 [00001]: [00001B20][HudManager] Thread [0x00001B20]: Begin
2015/06/27 16:24:48.676 [00029]: [- Main -][TableManager] Started
2015/06/27 16:24:48.676 [00000]: [- Main -][TableManager] Startup: ref_count: 1
2015/06/27 16:24:48.728 [00052]: [00001228][TableManager] Hud reading from database: PokerTracker 4 Database
2015/06/27 16:24:48.729 [00000]: [00001228][TableManager] Hud reading from database: PT4_2014_10_06_195153
2015/06/27 16:24:48.729 [00001]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:48.765 [00035]: [000023A0][AutoNoteThread] Thread [0x000023A0]: Begin
2015/06/27 16:24:48.765 [00000]: [000023A0][AutoNoteThread] Beginning thread.
2015/06/27 16:24:48.766 [00000]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.387 [00622]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.387 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.388 [00001]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:49.388 [00000]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:49.390 [00001]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.961 [00572]: [- Main -][TourneyDetect] System Language: en_US
2015/06/27 16:24:49.962 [00000]: [- Main -][ImportAuto] startImporting()::end
2015/06/27 16:24:49.963 [00002]: [- Main -][wpImport] AutoImport: Start Importing: Full Tilt
2015/06/27 16:24:49.963 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:49.979 [00015]: [00000F50][TourneyDetectThread] Thread [0x00000F50]: Begin
2015/06/27 16:24:49.979 [00000]: [00000F50][TourneyDetectThread] Beginning thread.
2015/06/27 16:24:49.984 [00005]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.984 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.985 [00000]: [- Main -][ImportAuto] Starting AutoImporter: Full Tilt
2015/06/27 16:24:49.985 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:49.985 [00000]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:50.019 [00034]: [- Main -][ImportStatus] Full Tilt: Starting auto-import.
2015/06/27 16:24:50.073 [00054]: [- Main -][ImportStatus] Full Tilt: Monitoring tables for Rush Poker.
2015/06/27 16:24:50.074 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.075 [00000]: [- Main -][wpImport] AutoImport: Start Importing: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.075 [00001]: [- Main -][ImportAuto] Starting AutoImporter: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.076 [00000]: [- Main -][ImportStatus] iPoker: Starting auto-import.
2015/06/27 16:24:50.087 [00011]: [0000061C][FullTiltHandGrabber] Thread [0x0000061C]: Begin
2015/06/27 16:24:50.088 [00000]: [0000061C][FullTiltHandGrabber] Thread Start
2015/06/27 16:24:50.110 [00022]: [- Main -][DirectoryMonitor] Unable to monitor directory: C:\Poker\Betfair.com Poker\History
2015/06/27 16:24:50.112 [00002]: [- Main -][ImportStatus] iPoker: Monitoring tables for Speed Poker.
2015/06/27 16:24:50.112 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.113 [00000]: [- Main -][wpImport] AutoImport: Start Importing: OnGame
2015/06/27 16:24:50.113 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.114 [00000]: [- Main -][ImportAuto] Starting AutoImporter: OnGame
2015/06/27 16:24:50.114 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.114 [00001]: [- Main -][ImportStatus] OnGame: Starting auto-import.
2015/06/27 16:24:50.115 [00001]: [0000061C][FullTiltOptions] Using FullTiltPoker: C:\Users\user\AppData\Local\FullTiltPoker.eu
2015/06/27 16:24:50.132 [00017]: [- Main -][ImportStatus] OnGame: Monitoring tables for Strobe Poker.
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.133 [00001]: [- Main -][wpImport] AutoImport: Start Importing: PokerStars
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.134 [00001]: [- Main -][ImportAuto] Starting AutoImporter: PokerStars
2015/06/27 16:24:50.134 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.135 [00000]: [- Main -][ImportStatus] PokerStars: Starting auto-import.
2015/06/27 16:24:50.136 [00001]: [- Main -][PokerStarsOptions] Found INI File: C:\Users\user\AppData\Local\PokerStars\user.ini
2015/06/27 16:24:50.139 [00002]: [00001768][OnGameHandGrabber] Thread [0x00001768]: Begin
2015/06/27 16:24:50.139 [00000]: [00001768][OnGameHandGrabber] Thread Start
2015/06/27 16:24:50.146 [00008]: [0000061C][FullTiltHandGrabber] Table Style: Classic, Avatars: ON
2015/06/27 16:24:50.148 [00002]: [000024FC][iPokerHandGrabber] Thread [0x000024FC]: Begin
2015/06/27 16:24:50.148 [00000]: [000024FC][iPokerHandGrabber] Thread Start
2015/06/27 16:24:50.149 [00001]: [00001768][OnGameHandGrabber] Monitoring C:\Users\user\P5JavaClientSettings\handhistory\strobe-hand-starts.dat
2015/06/27 16:24:50.193 [00044]: [- Main -][ImportStatus] PokerStars: Monitoring tables for Zoom Poker.
2015/06/27 16:24:50.194 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.210 [00016]: [- Main -][wpImport] Done: Get Hands While Playing
2015/06/27 16:24:50.214 [00005]: [- Main -][HudLauncher] Launching: C:\Program Files (x86)\PokerTracker 4\PokerTrackerHud4.exe
2015/06/27 16:24:50.231 [00017]: [00001110][PokerStarsMemoryGrabber] Thread [0x00001110]: Begin
2015/06/27 16:24:50.231 [00000]: [00001110][PokerStarsMemoryGrabber] Starting memory hand grabber thread
2015/06/27 16:24:50.232 [00000]: [00001110][System] Getting String:
2015/06/27 16:24:50.243 [00011]: [00000440][PokerStarsHandGrabber] Thread [0x00000440]: Begin
2015/06/27 16:24:50.243 [00000]: [00000440][PokerStarsHandGrabber] Thread Start
2015/06/27 16:24:50.568 [00324]: [- Main -][ImportStatus] Full Tilt: Found 0 files to monitor.
2015/06/27 16:24:50.594 [00026]: [- Main -][ImportStatus] iPoker: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00032]: [- Main -][ImportStatus] OnGame: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00001]: [- Main -][ImportStatus] PokerStars: Found 0 files to monitor.
2015/06/27 16:24:51.197 [00569]: [000024FC][iPokerHandGrabber] Launching iPoker Communicator
2015/06/27 16:24:52.258 [01061]: [000024FC][iPokerHandGrabber] Opening the Comm Pipe
2015/06/27 16:24:52.258 [00000]: [000024FC][iPokerHandGrabber] Waiting for messages...
2015/06/27 16:24:53.837 [01579]: [00001B20][HudIpcClient] PONG: Launch: 5.19s
2015/06/27 16:24:56.883 [03046]: [000024FC][GrabberPipe] High mark is: 32
2015/06/27 16:24:56.884 [00001]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00566]: [000024FC][GrabberPipe] High mark is: 136
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] New Table: Speed Hold'em 3 [LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20] (€0.20 NL FAST (6 max))
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 1: Akingge
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 3: hovlaaaa
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 5: hevos5mih
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 6: PISTONS55
2015/06/27 16:24:57.452 [00000]: [000024FC][iPokerHandGrabber] Seat 8: LastClock
2015/06/27 16:24:57.468 [00016]: [00001228][TableManager] Table found: 'Speed Hold'em 3' ([PTIODEVICE] LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20)
2015/06/27 16:24:57.469 [00001]: [00001228][TableManager] Hero for table 'Speed Hold'em 3' is 'LastClock'
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Initial table refresh: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Refreshing table: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.566 [00097]: [00001228][ProfileManager] Hud Profiles loaded.
2015/06/27 16:24:57.566 [00000]: [00001228][ProfileManager] Profile: Cash - Default Priority: 0
2015/06/27 16:24:57.567 [00000]: [00001228][ProfileManager] Selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][TableManager] Auto selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][LayoutManager] Loading profile: iPoker - 6 max - Speed Cash | Cash - Default
2015/06/27 16:24:58.522 [00955]: [00001228][StatManager] Unable to use cache due to column: live_amt_stack (live_amt_stack)
2015/06/27 16:24:58.864 [00343]: [00001228][LayoutManager] Load Success: Cash - Default
2015/06/27 16:24:58.865 [00000]: [00001228][HudManager] Profile: Commands: 11284, Bytes: 766106
2015/06/27 16:24:58.865 [00000]: [00001228][LayoutManager] st: 3401 t: 1.30s p1: 929ms p3: 0.2119ms s: 406ms sc: 7ms st: 361ms sp: 3ms q: 366ms
2015/06/27 16:24:58.865 [00000]: [00001228][WindowUpdater] Setting profile: Cash - Default
2015/06/27 16:24:58.866 [00001]: [00001228][TableManager] Table refreshed.
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 8
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 5 (8), Preferred Seat: 3, Total Seats: 6, Offset: 4
2015/06/27 16:24:58.867 [00001]: [00001228][TableManager] Query [0]: SLOW, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.867 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20' 1 queries)
2015/06/27 16:24:58.895 [00028]: [00001228][TableManager] Query Begin [0]: Channel: SLOW Priority: 33140, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.895 [00000]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'akingge') OR (p.id_site=400 AND p.player_name_search=E'hovlaaaa') OR (p.id_site=400 AND p.player_name_search=E'hevos5mih') OR (p.id_site=400 AND p.player_name_search=E'pistons55')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Query execution time: 0.00623253 ms
2015/06/27 16:24:58.920 [00025]: [00001228][TableManager] Query Failure [0]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:25:16.332 [17412]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 1: harrycys
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 3: VKARTMANN10
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 5: RD709324
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 6: LastClock
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 8: hevos5mih
2015/06/27 16:25:16.333 [00000]: [000024FC][iPokerHandGrabber] Seat 10: ReeblStribe
2015/06/27 16:25:16.526 [00193]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 6
2015/06/27 16:25:16.526 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 4 (6), Preferred Seat: 3, Total Seats: 6, Offset: 5
2015/06/27 16:25:16.536 [00010]: [00001228][TableManager] Query [1]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:25:16.536 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:25:16.610 [00074]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:25:16.610 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE

Re: ipoker, betfair configure with PT4

PostPosted: Sat Jun 27, 2015 11:45 am
by No-Rebuy
so ive recently played a few hands, but still not sure how to attach the log file. hope you can do the same with the log file paste.

i can only fit 60000 words so have the full log file in the following 2 pastes. thanks

2015/06/27 16:19:14.939 [00001]: [- Main -][System] PokerTracker v4.13.4
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] OS: Windows 7 (build 7601, Service Pack 1), 64-bit edition
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Windows Version: 6.1 build 7601 (platform 2) Service Pack 1
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Total Logical Processing Units: 2
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 2 (L1: 2, L2: 1, L3: 0)
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 1: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 2: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.943 [00000]: [- Main -][SystemInfo] C:\ Disk Space: 305,143 mb total; 64,628 mb used; 240,515 mb free
2015/06/27 16:19:15.095 [00151]: [- Main -][SystemInfo] Physical Memory: 4,083 mb (2,319 mb available) Virtual Memory: 2,047 mb (2,047 mb available) Page File: 8,165 mb (4,542 mb available)
2015/06/27 16:19:15.104 [00008]: [- Main -][System Info] Video[0]: NVIDIA Quadro NVS 160M (\\.\DISPLAY1)
2015/06/27 16:19:15.106 [00001]: [- Main -][SystemInfo] Display[0]: Position: 0x0, Size: 1280x760
2015/06/27 16:19:15.181 [00074]: [- Main -][SystemInfo] Anti Virus: [Not Installed]
2015/06/27 16:19:20.226 [05044]: [- Main -][SystemInfo] Adobe Flash: 17.0.0.190 Plugin: 17.0.0.190 AIR: Error: Adobe AIR not installed
2015/06/27 16:19:20.228 [00002]: [- Main -][SystemInfo] Configuration: [General]\nRunCount=107\nBuildDate=2015/06/15\nRegistrationCode=*** REG CODE REMOVED ***\nFirstRun=N\nLogging=Y\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=hammies08\nDB1.Name=PokerTracker 4 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT4 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=PT4_2014_10_06_195153\nDB2.Type=postgres\nDB2.Postgres.Database=PT4_2014_10_06_195153\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=hammies08\nDB2.Default=Y\nDB3.Name=PT4_2015_06_23_155954\nDB3.Type=postgres\nDB3.Postgres.Database=PT4_2015_06_23_155954\nDB3.Postgres.Server=localhost\nDB3.Postgres.Port=5432\nDB3.Postgres.User=postgres\nDB3.Postgres.Password=hammies08\n[Import]\nAutoStart.900=N\nAutoStart.2300=N\nAutoStart.300=Y\nAutoStart.700=N\nAutoStart.400=Y\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=Y\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.1200=N\nAutoStart.2200=N\nAutoStart.2400=N\nMoveProcessedFiles=Y\nMoveProcessedFilesDirectory=C:\Users\user\AppData\Local\PokerTracker 4\Processed\iPoker\2015\06-19\iPoker\2015\06-19\nMoveProcessedFilesBySite=Y\nMoveProcessedFilesByDate=Y\nImportObservedHands=Y\nAutoTreatAs=Y\nPromptOnCloseDuringAutoImport=N\nOverwriteTournamentSummary=N\nTournamentDetectPostSummary=N\nAutoTourneyDetect=Y\nEquity:HeroDeadCards=Y\nEquity:PreflopEnumeration=Hero\nHidden.900=N\nAutoStart.2600=N\nHidden.2600=N\nAutoStart.1400=N\nHidden.1400=N\nAutoStart.1300=N\nHidden.1300=N\nAutoStart.800=N\nHidden.800=N\nAutoStart.2500=N\nHidden.2500=N\nAutoStart.500=N\nHidden.500=N\nHidden.2300=N\nHidden.300=N\nAutoStart.1000=N\nHidden.1000=N\nHidden.700=N\nHidden.400=N\nHidden.2100=N\nHidden.1100=N\nHidden.600=N\nHidden.200=N\nHidden.100=N\nHidden.1200=N\nHidden.2200=N\nHidden.2400=N\nEmail:Pop:Port=110\nEmail:Pop:Password=^E:\nEmail:Pop:UseSSL=N\n[Site.iPoker]\nFastHud=Y\nHandHistoryDirectories=C:\Poker\Betfair.com Poker\History;C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u;\nSkinName=Default\nSkinTimeZone=GMT\nAutoCenter=Y\n[Site.OnGame]\nPreferred.10=7\nAlwaysOnTop=Y\nHandHistoryDirectories=C:\Users\user\P5JavaClientSettings\handhistory;\n[TournamentDetect]\nCheckBoxProtectType=N\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nUnknownFinishRefundBuyin=N\nUnknownFinishICMAward=N\nNetAdjAllPlayers=Y\nNetAdjActivePlayerDecisions=N\nDefaultTables=0\nDefaultMinsPerRound=10\nDefaultRebuyMinutes=60\nNetAdjMTT=N\n[Players]\nActiveSiteID=300\nActiveName=No-rebuy-4-u\nPrevious.1.SiteID=100\nPrevious.1.Name=SoMany1Times\nPrevious.2.SiteID=300\nPrevious.2.Name=No-rebuy-4-u\nPrevious.3.SiteID=600\nPrevious.3.Name=SoMany1Times\n[Site.PokerStars]\nZoomHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.9=5\n[Site.FullTilt]\nHandHistoryDirectory=C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u\nRushHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.2=2\n[HudGui]\nNotesWindowX=450\nNotesWindowY=325\n[Hud]\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nLowOpacityTranslucency=90\nNotesMaxLines=10\nUseNoteColorOutline=Y\nUseTranslucency=Y\nVectorScaling=Y\nTableSelect=Y\nMinHands=1\nCurrentLimit=N\nCurrentBetType=Y\nSessionStats=Y\nShowEquityPercentages=Y\nLastXHands=0\nLastXWeeks=0\nPlayerRanges=-\nTourneyStackFilter.0=-1\nTourneyStackFilter.1=-1\nTourneyStackFilter.2=-1\nTourneyStackFilter.3=-1\nTourneyStackFilter.4=-1\nTourneyStackFilter.5=-1\nDatabases=PokerTracker 4 Database\nPT4_2014_10_06_195153\n
2015/06/27 16:19:20.445 [00217]: [- Main -][Community] Sub Process: C:\Program Files (x86)\PokerTracker 4\PokerTrackerWeb4.exe
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Cache Dir: C:\Users\user\AppData\Local\PokerTracker 4\Community\Cache
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Log File: C:\Users\user\AppData\Local\PokerTracker 4\PokerTrackerWeb4.log
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Resources Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium
2015/06/27 16:19:20.446 [00000]: [- Main -][Community] Locales Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium\locales
2015/06/27 16:19:44.178 [23733]: [- Main -][PostgresService] Install: postgresql-9.3 (32bit)
2015/06/27 16:19:44.353 [00175]: [- Main -][System] diffInDaysNow = 2368
2015/06/27 16:19:44.354 [00001]: [- Main -][Registration] counter1 = 0xba70d93c
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter1 = 0xba70d940
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00001]: [- Main -][System] Getting String: 1059-4E4B-5E3C-9DA2-46FF-C5F1-7700-24F8
2015/06/27 16:19:44.650 [00294]: [- Main -][System] Attempting to connect to: https://ptlicense.com/regcheck.php
2015/06/27 16:19:48.617 [03968]: [- Main -][Registration] License written to C:\Users\user\AppData\Local\PokerTracker 4\Config/PokerTracker.lic
2015/06/27 16:19:51.016 [02397]: [- Main -][WindowDialog] Opening Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.856 [04840]: [- Main -][WindowDialog] Closing Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.862 [00006]: [- Main -][System] Currencies v1.04 is up to date.
2015/06/27 16:19:55.948 [00086]: [- Main -][System] TournamentDetect v3.92 is up to date.
2015/06/27 16:19:55.949 [00001]: [- Main -][System] FullTilt v1.34 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] Party v1.18 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] iPoker v2.12 is up to date.
2015/06/27 16:19:55.951 [00001]: [- Main -][System] Pacific v1.11 is up to date.
2015/06/27 16:19:56.087 [00136]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/autoUpdate ... leList.ini
2015/06/27 16:19:58.915 [02828]: [- Main -][System] Checking MD5 checksums...
2015/06/27 16:19:58.915 [00000]: [- Main -][System] MD5 checksum complete
2015/06/27 16:19:58.924 [00009]: [- Main -][System] Holdem: Small Omaha: NO
2015/06/27 16:19:58.925 [00001]: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2015/06/27 16:19:58.936 [00011]: [0000129C][ThreadPool(Idle)] Thread [0x0000129C]: Begin
2015/06/27 16:19:58.936 [00000]: [0000129C][ThreadPool] Thread [02F192E0]: Created
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool(Idle)] Thread [0x00002434]: Begin
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool] Thread [02F18838]: Created
2015/06/27 16:19:58.962 [00025]: [00001484][ThreadPool(Idle)] Thread [0x00001484]: Begin
2015/06/27 16:19:58.962 [00000]: [00001484][ThreadPool] Thread [02F18940]: Created
2015/06/27 16:19:58.963 [00001]: [00002044][ThreadPool(Idle)] Thread [0x00002044]: Begin
2015/06/27 16:19:58.963 [00000]: [00002044][ThreadPool] Thread [02F18890]: Created
2015/06/27 16:19:59.211 [00248]: [- Main -][WindowSplash] Checking installation
2015/06/27 16:19:59.212 [00001]: [- Main -][PostgresService] Attempting to start service...
2015/06/27 16:19:59.221 [00009]: [- Main -][PostgresService (ERROR)] Failed to start service
2015/06/27 16:19:59.227 [00006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:00.620 [01392]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:00.621 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:00.774 [00153]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.785 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:01.889 [00104]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.890 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:02.018 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.027 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:03.101 [00074]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.102 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:03.163 [00061]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.169 [01006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:04.201 [00032]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.201 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:04.244 [00043]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.254 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:05.502 [00249]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.503 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:05.581 [00078]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.591 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:06.894 [00302]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.895 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:07.023 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.034 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:08.299 [00265]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.300 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:08.476 [00176]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.487 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:09.599 [00111]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.600 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:09.719 [00118]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.729 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:10.850 [00121]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.851 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:10.928 [00077]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:11.950 [01022]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:12.056 [00105]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:12.057 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:12.293 [00235]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.327 [01034]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:13.566 [00238]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.566 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:13.695 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.697 [00001]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:15.160 [01463]: [- Main -][PostgresConnection] [0x0018f328] Successfully connected to: postgres [02f4bb28] (PostgreSQL version 90305)
2015/06/27 16:20:15.160 [00000]: [- Main -][PostgresConnection] [0x0018f328] Disconnecting from database: postgres
2015/06/27 16:20:15.162 [00002]: [00002124][WindowSplash::Worker::Entry] Beginning thread.
2015/06/27 16:20:15.163 [00000]: [00002124][WindowSplash::Worker] Thread [0x00002124]: Begin
2015/06/27 16:20:15.280 [00116]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:15.958 [00677]: [00002124][StatManager] Stats and reports loaded. Load: 678ms, Custom: 101ms, Dupe: -
2015/06/27 16:20:15.958 [00000]: [00002124][FilterManager] Loading filters...
2015/06/27 16:20:17.197 [01239]: [00002124][FilterManager] Filters loaded.
2015/06/27 16:20:17.198 [00000]: [00002124][LayoutManager] Loading layouts...
2015/06/27 16:20:20.839 [03642]: [00002124][LayoutManager] Adding Table Select Layout
2015/06/27 16:20:20.841 [00002]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:21.120 [00278]: [00002124][StatManager] Stats and reports loaded. Load: 278ms, Custom: 0.1404ms, Dupe: -
2015/06/27 16:20:21.120 [00000]: [00002124][LayoutManager] Layouts loaded.
2015/06/27 16:20:22.211 [01092]: [00002124][TagManager] Loaded 23 tag icons in 1.09s
2015/06/27 16:20:22.212 [00000]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:22.384 [00172]: [00002124][StatManager] Stats and reports loaded. Load: 172ms, Custom: 0.1104ms, Dupe: -
2015/06/27 16:20:23.394 [01010]: [00002124][NotesManager] AutoNotes loaded.
2015/06/27 16:20:23.791 [00397]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.806 [00014]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.873 [00066]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.902 [00029]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.925 [00022]: [00002124][NotesManager] Initialized: 1.71s
2015/06/27 16:20:23.930 [00005]: [00002124][Player] 0 buddies found
2015/06/27 16:20:23.931 [00000]: [00002124][WindowSplash::Worker::Entry] Ending thread.
2015/06/27 16:20:23.931 [00000]: [- Main -][WindowSplash] Initializing Main Window
2015/06/27 16:20:23.936 [00004]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:24.393 [00456]: [- Main -][PostgresConnection] [0x0c1281e0] Successfully connected to: PT4_2014_10_06_195153 [0c011f80] (PostgreSQL version 90305)
2015/06/27 16:20:29.688 [05295]: [- Main -][ConnectionManager] Database Version: 400019
2015/06/27 16:20:32.181 [02492]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.411 [00229]: [- Main -][PostgresConnection] [0x0c127f90] Successfully connected to: PT4_2014_10_06_195153 [0b666330] (PostgreSQL version 90305)
2015/06/27 16:20:32.412 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.457 [00044]: [- Main -][PostgresConnection] [0x0c1280b8] Successfully connected to: PT4_2014_10_06_195153 [0afde9c8] (PostgreSQL version 90305)
2015/06/27 16:20:32.458 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.665 [00207]: [- Main -][PostgresConnection] [0x0c128308] Successfully connected to: PT4_2014_10_06_195153 [0aeaa280] (PostgreSQL version 90305)
2015/06/27 16:20:34.538 [01873]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/currencyRates.php
2015/06/27 16:20:36.280 [01742]: [- Main -][CurrencyManager] Added 10 new rates
2015/06/27 16:20:37.002 [00722]: [- Main -][CurrencyManager] Database Global Currency: USD
2015/06/27 16:20:37.058 [00056]: [- Main -][LayoutManager] Caching profile data.
2015/06/27 16:20:39.906 [02848]: [- Main -][LayoutManager] Caching profile data complete: 2.85s
2015/06/27 16:20:44.285 [04378]: [- Main -][StatManager] cacheVerifyIndexes: Cache indexes up to date.
2015/06/27 16:20:46.511 [02226]: [- Main -][WindowMain] Database: PT4_2014_10_06_195153 Size: 1635 MB
2015/06/27 16:22:29.241 [99999]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"
2015/06/27 16:24:46.599 [99999]: [- Main -][wpImport] Click: Get Hands While Playing
2015/06/27 16:24:46.603 [00003]: [- Main -][ImportAuto] startImporting()::begin
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] Starting ImportAuto Worker Thread
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00001]: [- Main -][TableManager] Starting Up...
2015/06/27 16:24:46.623 [00019]: [00001228][TableManager] Thread [0x00001228]: Begin
2015/06/27 16:24:46.624 [00000]: [00001228][TableManager::Entry] Beginning thread.
2015/06/27 16:24:46.639 [00015]: [00001CE8][ImportAutoWorker] Thread [0x00001CE8]: Begin
2015/06/27 16:24:46.641 [00001]: [00001CE8][ImportAuto::ImportAutoWorker::Entry] Beginning thread.
2015/06/27 16:24:48.521 [01878]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_rotate AS UPDATE live_cash_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.567 [00046]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_rotate AS UPDATE live_tourney_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.568 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_rotate AS UPDATE live_cash_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.570 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_rotate AS UPDATE live_tourney_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.571 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_update AS UPDATE live_cash_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_update AS UPDATE live_tourney_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_update AS UPDATE live_cash_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.573 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_update AS UPDATE live_tourney_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.574 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_insert AS INSERT INTO live_cash_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.644 [00071]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_insert AS INSERT INTO live_tourney_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.645 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_insert AS INSERT INTO live_cash_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.646 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_insert AS INSERT INTO live_tourney_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.647 [00001]: [00001B20][HudManager] Thread [0x00001B20]: Begin
2015/06/27 16:24:48.676 [00029]: [- Main -][TableManager] Started
2015/06/27 16:24:48.676 [00000]: [- Main -][TableManager] Startup: ref_count: 1
2015/06/27 16:24:48.728 [00052]: [00001228][TableManager] Hud reading from database: PokerTracker 4 Database
2015/06/27 16:24:48.729 [00000]: [00001228][TableManager] Hud reading from database: PT4_2014_10_06_195153
2015/06/27 16:24:48.729 [00001]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:48.765 [00035]: [000023A0][AutoNoteThread] Thread [0x000023A0]: Begin
2015/06/27 16:24:48.765 [00000]: [000023A0][AutoNoteThread] Beginning thread.
2015/06/27 16:24:48.766 [00000]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.387 [00622]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.387 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.388 [00001]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:49.388 [00000]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:49.390 [00001]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.961 [00572]: [- Main -][TourneyDetect] System Language: en_US
2015/06/27 16:24:49.962 [00000]: [- Main -][ImportAuto] startImporting()::end
2015/06/27 16:24:49.963 [00002]: [- Main -][wpImport] AutoImport: Start Importing: Full Tilt
2015/06/27 16:24:49.963 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:49.979 [00015]: [00000F50][TourneyDetectThread] Thread [0x00000F50]: Begin
2015/06/27 16:24:49.979 [00000]: [00000F50][TourneyDetectThread] Beginning thread.
2015/06/27 16:24:49.984 [00005]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.984 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.985 [00000]: [- Main -][ImportAuto] Starting AutoImporter: Full Tilt
2015/06/27 16:24:49.985 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:49.985 [00000]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:50.019 [00034]: [- Main -][ImportStatus] Full Tilt: Starting auto-import.
2015/06/27 16:24:50.073 [00054]: [- Main -][ImportStatus] Full Tilt: Monitoring tables for Rush Poker.
2015/06/27 16:24:50.074 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.075 [00000]: [- Main -][wpImport] AutoImport: Start Importing: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.075 [00001]: [- Main -][ImportAuto] Starting AutoImporter: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.076 [00000]: [- Main -][ImportStatus] iPoker: Starting auto-import.
2015/06/27 16:24:50.087 [00011]: [0000061C][FullTiltHandGrabber] Thread [0x0000061C]: Begin
2015/06/27 16:24:50.088 [00000]: [0000061C][FullTiltHandGrabber] Thread Start
2015/06/27 16:24:50.110 [00022]: [- Main -][DirectoryMonitor] Unable to monitor directory: C:\Poker\Betfair.com Poker\History
2015/06/27 16:24:50.112 [00002]: [- Main -][ImportStatus] iPoker: Monitoring tables for Speed Poker.
2015/06/27 16:24:50.112 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.113 [00000]: [- Main -][wpImport] AutoImport: Start Importing: OnGame
2015/06/27 16:24:50.113 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.114 [00000]: [- Main -][ImportAuto] Starting AutoImporter: OnGame
2015/06/27 16:24:50.114 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.114 [00001]: [- Main -][ImportStatus] OnGame: Starting auto-import.
2015/06/27 16:24:50.115 [00001]: [0000061C][FullTiltOptions] Using FullTiltPoker: C:\Users\user\AppData\Local\FullTiltPoker.eu
2015/06/27 16:24:50.132 [00017]: [- Main -][ImportStatus] OnGame: Monitoring tables for Strobe Poker.
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.133 [00001]: [- Main -][wpImport] AutoImport: Start Importing: PokerStars
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.134 [00001]: [- Main -][ImportAuto] Starting AutoImporter: PokerStars
2015/06/27 16:24:50.134 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.135 [00000]: [- Main -][ImportStatus] PokerStars: Starting auto-import.
2015/06/27 16:24:50.136 [00001]: [- Main -][PokerStarsOptions] Found INI File: C:\Users\user\AppData\Local\PokerStars\user.ini
2015/06/27 16:24:50.139 [00002]: [00001768][OnGameHandGrabber] Thread [0x00001768]: Begin
2015/06/27 16:24:50.139 [00000]: [00001768][OnGameHandGrabber] Thread Start
2015/06/27 16:24:50.146 [00008]: [0000061C][FullTiltHandGrabber] Table Style: Classic, Avatars: ON
2015/06/27 16:24:50.148 [00002]: [000024FC][iPokerHandGrabber] Thread [0x000024FC]: Begin
2015/06/27 16:24:50.148 [00000]: [000024FC][iPokerHandGrabber] Thread Start
2015/06/27 16:24:50.149 [00001]: [00001768][OnGameHandGrabber] Monitoring C:\Users\user\P5JavaClientSettings\handhistory\strobe-hand-starts.dat
2015/06/27 16:24:50.193 [00044]: [- Main -][ImportStatus] PokerStars: Monitoring tables for Zoom Poker.
2015/06/27 16:24:50.194 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.210 [00016]: [- Main -][wpImport] Done: Get Hands While Playing
2015/06/27 16:24:50.214 [00005]: [- Main -][HudLauncher] Launching: C:\Program Files (x86)\PokerTracker 4\PokerTrackerHud4.exe
2015/06/27 16:24:50.231 [00017]: [00001110][PokerStarsMemoryGrabber] Thread [0x00001110]: Begin
2015/06/27 16:24:50.231 [00000]: [00001110][PokerStarsMemoryGrabber] Starting memory hand grabber thread
2015/06/27 16:24:50.232 [00000]: [00001110][System] Getting String:
2015/06/27 16:24:50.243 [00011]: [00000440][PokerStarsHandGrabber] Thread [0x00000440]: Begin
2015/06/27 16:24:50.243 [00000]: [00000440][PokerStarsHandGrabber] Thread Start
2015/06/27 16:24:50.568 [00324]: [- Main -][ImportStatus] Full Tilt: Found 0 files to monitor.
2015/06/27 16:24:50.594 [00026]: [- Main -][ImportStatus] iPoker: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00032]: [- Main -][ImportStatus] OnGame: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00001]: [- Main -][ImportStatus] PokerStars: Found 0 files to monitor.
2015/06/27 16:24:51.197 [00569]: [000024FC][iPokerHandGrabber] Launching iPoker Communicator
2015/06/27 16:24:52.258 [01061]: [000024FC][iPokerHandGrabber] Opening the Comm Pipe
2015/06/27 16:24:52.258 [00000]: [000024FC][iPokerHandGrabber] Waiting for messages...
2015/06/27 16:24:53.837 [01579]: [00001B20][HudIpcClient] PONG: Launch: 5.19s
2015/06/27 16:24:56.883 [03046]: [000024FC][GrabberPipe] High mark is: 32
2015/06/27 16:24:56.884 [00001]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00566]: [000024FC][GrabberPipe] High mark is: 136
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] New Table: Speed Hold'em 3 [LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20] (€0.20 NL FAST (6 max))
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 1: Akingge
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 3: hovlaaaa
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 5: hevos5mih
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 6: PISTONS55
2015/06/27 16:24:57.452 [00000]: [000024FC][iPokerHandGrabber] Seat 8: LastClock
2015/06/27 16:24:57.468 [00016]: [00001228][TableManager] Table found: 'Speed Hold'em 3' ([PTIODEVICE] LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20)
2015/06/27 16:24:57.469 [00001]: [00001228][TableManager] Hero for table 'Speed Hold'em 3' is 'LastClock'
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Initial table refresh: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Refreshing table: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.566 [00097]: [00001228][ProfileManager] Hud Profiles loaded.
2015/06/27 16:24:57.566 [00000]: [00001228][ProfileManager] Profile: Cash - Default Priority: 0
2015/06/27 16:24:57.567 [00000]: [00001228][ProfileManager] Selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][TableManager] Auto selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][LayoutManager] Loading profile: iPoker - 6 max - Speed Cash | Cash - Default
2015/06/27 16:24:58.522 [00955]: [00001228][StatManager] Unable to use cache due to column: live_amt_stack (live_amt_stack)
2015/06/27 16:24:58.864 [00343]: [00001228][LayoutManager] Load Success: Cash - Default
2015/06/27 16:24:58.865 [00000]: [00001228][HudManager] Profile: Commands: 11284, Bytes: 766106
2015/06/27 16:24:58.865 [00000]: [00001228][LayoutManager] st: 3401 t: 1.30s p1: 929ms p3: 0.2119ms s: 406ms sc: 7ms st: 361ms sp: 3ms q: 366ms
2015/06/27 16:24:58.865 [00000]: [00001228][WindowUpdater] Setting profile: Cash - Default
2015/06/27 16:24:58.866 [00001]: [00001228][TableManager] Table refreshed.
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 8
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 5 (8), Preferred Seat: 3, Total Seats: 6, Offset: 4
2015/06/27 16:24:58.867 [00001]: [00001228][TableManager] Query [0]: SLOW, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.867 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20' 1 queries)
2015/06/27 16:24:58.895 [00028]: [00001228][TableManager] Query Begin [0]: Channel: SLOW Priority: 33140, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.895 [00000]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'akingge') OR (p.id_site=400 AND p.player_name_search=E'hovlaaaa') OR (p.id_site=400 AND p.player_name_search=E'hevos5mih') OR (p.id_site=400 AND p.player_name_search=E'pistons55')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Query execution time: 0.00623253 ms
2015/06/27 16:24:58.920 [00025]: [00001228][TableManager] Query Failure [0]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:25:16.332 [17412]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 1: harrycys
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 3: VKARTMANN10
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 5: RD709324
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 6: LastClock
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 8: hevos5mih
2015/06/27 16:25:16.333 [00000]: [000024FC][iPokerHandGrabber] Seat 10: ReeblStribe
2015/06/27 16:25:16.526 [00193]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 6
2015/06/27 16:25:16.526 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 4 (6), Preferred Seat: 3, Total Seats: 6, Offset: 5
2015/06/27 16:25:16.536 [00010]: [00001228][TableManager] Query [1]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:25:16.536 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:25:16.610 [00074]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:25:16.610 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call",

Re: ipoker, betfair configure with PT4

PostPosted: Sat Jun 27, 2015 11:52 am
by No-Rebuy
can you please ignore the previous pastes of the log file, it was the wrong one, thanks. the following pastes are the log file, it will be shown in 2 consecutive posts.


2015/06/27 16:19:14.939 [00001]: [- Main -][System] PokerTracker v4.13.4
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] OS: Windows 7 (build 7601, Service Pack 1), 64-bit edition
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Windows Version: 6.1 build 7601 (platform 2) Service Pack 1
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Total Logical Processing Units: 2
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 2 (L1: 2, L2: 1, L3: 0)
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 1: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 2: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.943 [00000]: [- Main -][SystemInfo] C:\ Disk Space: 305,143 mb total; 64,628 mb used; 240,515 mb free
2015/06/27 16:19:15.095 [00151]: [- Main -][SystemInfo] Physical Memory: 4,083 mb (2,319 mb available) Virtual Memory: 2,047 mb (2,047 mb available) Page File: 8,165 mb (4,542 mb available)
2015/06/27 16:19:15.104 [00008]: [- Main -][System Info] Video[0]: NVIDIA Quadro NVS 160M (\\.\DISPLAY1)
2015/06/27 16:19:15.106 [00001]: [- Main -][SystemInfo] Display[0]: Position: 0x0, Size: 1280x760
2015/06/27 16:19:15.181 [00074]: [- Main -][SystemInfo] Anti Virus: [Not Installed]
2015/06/27 16:19:20.226 [05044]: [- Main -][SystemInfo] Adobe Flash: 17.0.0.190 Plugin: 17.0.0.190 AIR: Error: Adobe AIR not installed
2015/06/27 16:19:20.228 [00002]: [- Main -][SystemInfo] Configuration: [General]\nRunCount=107\nBuildDate=2015/06/15\nRegistrationCode=*** REG CODE REMOVED ***\nFirstRun=N\nLogging=Y\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=hammies08\nDB1.Name=PokerTracker 4 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT4 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=PT4_2014_10_06_195153\nDB2.Type=postgres\nDB2.Postgres.Database=PT4_2014_10_06_195153\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=hammies08\nDB2.Default=Y\nDB3.Name=PT4_2015_06_23_155954\nDB3.Type=postgres\nDB3.Postgres.Database=PT4_2015_06_23_155954\nDB3.Postgres.Server=localhost\nDB3.Postgres.Port=5432\nDB3.Postgres.User=postgres\nDB3.Postgres.Password=hammies08\n[Import]\nAutoStart.900=N\nAutoStart.2300=N\nAutoStart.300=Y\nAutoStart.700=N\nAutoStart.400=Y\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=Y\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.1200=N\nAutoStart.2200=N\nAutoStart.2400=N\nMoveProcessedFiles=Y\nMoveProcessedFilesDirectory=C:\Users\user\AppData\Local\PokerTracker 4\Processed\iPoker\2015\06-19\iPoker\2015\06-19\nMoveProcessedFilesBySite=Y\nMoveProcessedFilesByDate=Y\nImportObservedHands=Y\nAutoTreatAs=Y\nPromptOnCloseDuringAutoImport=N\nOverwriteTournamentSummary=N\nTournamentDetectPostSummary=N\nAutoTourneyDetect=Y\nEquity:HeroDeadCards=Y\nEquity:PreflopEnumeration=Hero\nHidden.900=N\nAutoStart.2600=N\nHidden.2600=N\nAutoStart.1400=N\nHidden.1400=N\nAutoStart.1300=N\nHidden.1300=N\nAutoStart.800=N\nHidden.800=N\nAutoStart.2500=N\nHidden.2500=N\nAutoStart.500=N\nHidden.500=N\nHidden.2300=N\nHidden.300=N\nAutoStart.1000=N\nHidden.1000=N\nHidden.700=N\nHidden.400=N\nHidden.2100=N\nHidden.1100=N\nHidden.600=N\nHidden.200=N\nHidden.100=N\nHidden.1200=N\nHidden.2200=N\nHidden.2400=N\nEmail:Pop:Port=110\nEmail:Pop:Password=^E:\nEmail:Pop:UseSSL=N\n[Site.iPoker]\nFastHud=Y\nHandHistoryDirectories=C:\Poker\Betfair.com Poker\History;C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u;\nSkinName=Default\nSkinTimeZone=GMT\nAutoCenter=Y\n[Site.OnGame]\nPreferred.10=7\nAlwaysOnTop=Y\nHandHistoryDirectories=C:\Users\user\P5JavaClientSettings\handhistory;\n[TournamentDetect]\nCheckBoxProtectType=N\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nUnknownFinishRefundBuyin=N\nUnknownFinishICMAward=N\nNetAdjAllPlayers=Y\nNetAdjActivePlayerDecisions=N\nDefaultTables=0\nDefaultMinsPerRound=10\nDefaultRebuyMinutes=60\nNetAdjMTT=N\n[Players]\nActiveSiteID=300\nActiveName=No-rebuy-4-u\nPrevious.1.SiteID=100\nPrevious.1.Name=SoMany1Times\nPrevious.2.SiteID=300\nPrevious.2.Name=No-rebuy-4-u\nPrevious.3.SiteID=600\nPrevious.3.Name=SoMany1Times\n[Site.PokerStars]\nZoomHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.9=5\n[Site.FullTilt]\nHandHistoryDirectory=C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u\nRushHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.2=2\n[HudGui]\nNotesWindowX=450\nNotesWindowY=325\n[Hud]\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nLowOpacityTranslucency=90\nNotesMaxLines=10\nUseNoteColorOutline=Y\nUseTranslucency=Y\nVectorScaling=Y\nTableSelect=Y\nMinHands=1\nCurrentLimit=N\nCurrentBetType=Y\nSessionStats=Y\nShowEquityPercentages=Y\nLastXHands=0\nLastXWeeks=0\nPlayerRanges=-\nTourneyStackFilter.0=-1\nTourneyStackFilter.1=-1\nTourneyStackFilter.2=-1\nTourneyStackFilter.3=-1\nTourneyStackFilter.4=-1\nTourneyStackFilter.5=-1\nDatabases=PokerTracker 4 Database\nPT4_2014_10_06_195153\n
2015/06/27 16:19:20.445 [00217]: [- Main -][Community] Sub Process: C:\Program Files (x86)\PokerTracker 4\PokerTrackerWeb4.exe
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Cache Dir: C:\Users\user\AppData\Local\PokerTracker 4\Community\Cache
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Log File: C:\Users\user\AppData\Local\PokerTracker 4\PokerTrackerWeb4.log
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Resources Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium
2015/06/27 16:19:20.446 [00000]: [- Main -][Community] Locales Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium\locales
2015/06/27 16:19:44.178 [23733]: [- Main -][PostgresService] Install: postgresql-9.3 (32bit)
2015/06/27 16:19:44.353 [00175]: [- Main -][System] diffInDaysNow = 2368
2015/06/27 16:19:44.354 [00001]: [- Main -][Registration] counter1 = 0xba70d93c
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter1 = 0xba70d940
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00001]: [- Main -][System] Getting String: 1059-4E4B-5E3C-9DA2-46FF-C5F1-7700-24F8
2015/06/27 16:19:44.650 [00294]: [- Main -][System] Attempting to connect to: https://ptlicense.com/regcheck.php
2015/06/27 16:19:48.617 [03968]: [- Main -][Registration] License written to C:\Users\user\AppData\Local\PokerTracker 4\Config/PokerTracker.lic
2015/06/27 16:19:51.016 [02397]: [- Main -][WindowDialog] Opening Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.856 [04840]: [- Main -][WindowDialog] Closing Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.862 [00006]: [- Main -][System] Currencies v1.04 is up to date.
2015/06/27 16:19:55.948 [00086]: [- Main -][System] TournamentDetect v3.92 is up to date.
2015/06/27 16:19:55.949 [00001]: [- Main -][System] FullTilt v1.34 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] Party v1.18 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] iPoker v2.12 is up to date.
2015/06/27 16:19:55.951 [00001]: [- Main -][System] Pacific v1.11 is up to date.
2015/06/27 16:19:56.087 [00136]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/autoUpdate ... leList.ini
2015/06/27 16:19:58.915 [02828]: [- Main -][System] Checking MD5 checksums...
2015/06/27 16:19:58.915 [00000]: [- Main -][System] MD5 checksum complete
2015/06/27 16:19:58.924 [00009]: [- Main -][System] Holdem: Small Omaha: NO
2015/06/27 16:19:58.925 [00001]: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2015/06/27 16:19:58.936 [00011]: [0000129C][ThreadPool(Idle)] Thread [0x0000129C]: Begin
2015/06/27 16:19:58.936 [00000]: [0000129C][ThreadPool] Thread [02F192E0]: Created
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool(Idle)] Thread [0x00002434]: Begin
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool] Thread [02F18838]: Created
2015/06/27 16:19:58.962 [00025]: [00001484][ThreadPool(Idle)] Thread [0x00001484]: Begin
2015/06/27 16:19:58.962 [00000]: [00001484][ThreadPool] Thread [02F18940]: Created
2015/06/27 16:19:58.963 [00001]: [00002044][ThreadPool(Idle)] Thread [0x00002044]: Begin
2015/06/27 16:19:58.963 [00000]: [00002044][ThreadPool] Thread [02F18890]: Created
2015/06/27 16:19:59.211 [00248]: [- Main -][WindowSplash] Checking installation
2015/06/27 16:19:59.212 [00001]: [- Main -][PostgresService] Attempting to start service...
2015/06/27 16:19:59.221 [00009]: [- Main -][PostgresService (ERROR)] Failed to start service
2015/06/27 16:19:59.227 [00006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:00.620 [01392]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:00.621 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:00.774 [00153]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.785 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:01.889 [00104]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.890 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:02.018 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.027 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:03.101 [00074]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.102 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:03.163 [00061]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.169 [01006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:04.201 [00032]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.201 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:04.244 [00043]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.254 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:05.502 [00249]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.503 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:05.581 [00078]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.591 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:06.894 [00302]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.895 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:07.023 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.034 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:08.299 [00265]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.300 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:08.476 [00176]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.487 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:09.599 [00111]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.600 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:09.719 [00118]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.729 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:10.850 [00121]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.851 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:10.928 [00077]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:11.950 [01022]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:12.056 [00105]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:12.057 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:12.293 [00235]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.327 [01034]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:13.566 [00238]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.566 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:13.695 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.697 [00001]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:15.160 [01463]: [- Main -][PostgresConnection] [0x0018f328] Successfully connected to: postgres [02f4bb28] (PostgreSQL version 90305)
2015/06/27 16:20:15.160 [00000]: [- Main -][PostgresConnection] [0x0018f328] Disconnecting from database: postgres
2015/06/27 16:20:15.162 [00002]: [00002124][WindowSplash::Worker::Entry] Beginning thread.
2015/06/27 16:20:15.163 [00000]: [00002124][WindowSplash::Worker] Thread [0x00002124]: Begin
2015/06/27 16:20:15.280 [00116]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:15.958 [00677]: [00002124][StatManager] Stats and reports loaded. Load: 678ms, Custom: 101ms, Dupe: -
2015/06/27 16:20:15.958 [00000]: [00002124][FilterManager] Loading filters...
2015/06/27 16:20:17.197 [01239]: [00002124][FilterManager] Filters loaded.
2015/06/27 16:20:17.198 [00000]: [00002124][LayoutManager] Loading layouts...
2015/06/27 16:20:20.839 [03642]: [00002124][LayoutManager] Adding Table Select Layout
2015/06/27 16:20:20.841 [00002]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:21.120 [00278]: [00002124][StatManager] Stats and reports loaded. Load: 278ms, Custom: 0.1404ms, Dupe: -
2015/06/27 16:20:21.120 [00000]: [00002124][LayoutManager] Layouts loaded.
2015/06/27 16:20:22.211 [01092]: [00002124][TagManager] Loaded 23 tag icons in 1.09s
2015/06/27 16:20:22.212 [00000]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:22.384 [00172]: [00002124][StatManager] Stats and reports loaded. Load: 172ms, Custom: 0.1104ms, Dupe: -
2015/06/27 16:20:23.394 [01010]: [00002124][NotesManager] AutoNotes loaded.
2015/06/27 16:20:23.791 [00397]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.806 [00014]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.873 [00066]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.902 [00029]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.925 [00022]: [00002124][NotesManager] Initialized: 1.71s
2015/06/27 16:20:23.930 [00005]: [00002124][Player] 0 buddies found
2015/06/27 16:20:23.931 [00000]: [00002124][WindowSplash::Worker::Entry] Ending thread.
2015/06/27 16:20:23.931 [00000]: [- Main -][WindowSplash] Initializing Main Window
2015/06/27 16:20:23.936 [00004]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:24.393 [00456]: [- Main -][PostgresConnection] [0x0c1281e0] Successfully connected to: PT4_2014_10_06_195153 [0c011f80] (PostgreSQL version 90305)
2015/06/27 16:20:29.688 [05295]: [- Main -][ConnectionManager] Database Version: 400019
2015/06/27 16:20:32.181 [02492]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.411 [00229]: [- Main -][PostgresConnection] [0x0c127f90] Successfully connected to: PT4_2014_10_06_195153 [0b666330] (PostgreSQL version 90305)
2015/06/27 16:20:32.412 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.457 [00044]: [- Main -][PostgresConnection] [0x0c1280b8] Successfully connected to: PT4_2014_10_06_195153 [0afde9c8] (PostgreSQL version 90305)
2015/06/27 16:20:32.458 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.665 [00207]: [- Main -][PostgresConnection] [0x0c128308] Successfully connected to: PT4_2014_10_06_195153 [0aeaa280] (PostgreSQL version 90305)
2015/06/27 16:20:34.538 [01873]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/currencyRates.php
2015/06/27 16:20:36.280 [01742]: [- Main -][CurrencyManager] Added 10 new rates
2015/06/27 16:20:37.002 [00722]: [- Main -][CurrencyManager] Database Global Currency: USD
2015/06/27 16:20:37.058 [00056]: [- Main -][LayoutManager] Caching profile data.
2015/06/27 16:20:39.906 [02848]: [- Main -][LayoutManager] Caching profile data complete: 2.85s
2015/06/27 16:20:44.285 [04378]: [- Main -][StatManager] cacheVerifyIndexes: Cache indexes up to date.
2015/06/27 16:20:46.511 [02226]: [- Main -][WindowMain] Database: PT4_2014_10_06_195153 Size: 1635 MB
2015/06/27 16:22:29.241 [99999]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"
2015/06/27 16:24:46.599 [99999]: [- Main -][wpImport] Click: Get Hands While Playing
2015/06/27 16:24:46.603 [00003]: [- Main -][ImportAuto] startImporting()::begin
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] Starting ImportAuto Worker Thread
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00001]: [- Main -][TableManager] Starting Up...
2015/06/27 16:24:46.623 [00019]: [00001228][TableManager] Thread [0x00001228]: Begin
2015/06/27 16:24:46.624 [00000]: [00001228][TableManager::Entry] Beginning thread.
2015/06/27 16:24:46.639 [00015]: [00001CE8][ImportAutoWorker] Thread [0x00001CE8]: Begin
2015/06/27 16:24:46.641 [00001]: [00001CE8][ImportAuto::ImportAutoWorker::Entry] Beginning thread.
2015/06/27 16:24:48.521 [01878]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_rotate AS UPDATE live_cash_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.567 [00046]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_rotate AS UPDATE live_tourney_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.568 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_rotate AS UPDATE live_cash_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.570 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_rotate AS UPDATE live_tourney_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.571 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_update AS UPDATE live_cash_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_update AS UPDATE live_tourney_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_update AS UPDATE live_cash_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.573 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_update AS UPDATE live_tourney_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.574 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_insert AS INSERT INTO live_cash_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.644 [00071]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_insert AS INSERT INTO live_tourney_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.645 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_insert AS INSERT INTO live_cash_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.646 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_insert AS INSERT INTO live_tourney_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.647 [00001]: [00001B20][HudManager] Thread [0x00001B20]: Begin
2015/06/27 16:24:48.676 [00029]: [- Main -][TableManager] Started
2015/06/27 16:24:48.676 [00000]: [- Main -][TableManager] Startup: ref_count: 1
2015/06/27 16:24:48.728 [00052]: [00001228][TableManager] Hud reading from database: PokerTracker 4 Database
2015/06/27 16:24:48.729 [00000]: [00001228][TableManager] Hud reading from database: PT4_2014_10_06_195153
2015/06/27 16:24:48.729 [00001]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:48.765 [00035]: [000023A0][AutoNoteThread] Thread [0x000023A0]: Begin
2015/06/27 16:24:48.765 [00000]: [000023A0][AutoNoteThread] Beginning thread.
2015/06/27 16:24:48.766 [00000]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.387 [00622]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.387 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.388 [00001]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:49.388 [00000]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:49.390 [00001]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.961 [00572]: [- Main -][TourneyDetect] System Language: en_US
2015/06/27 16:24:49.962 [00000]: [- Main -][ImportAuto] startImporting()::end
2015/06/27 16:24:49.963 [00002]: [- Main -][wpImport] AutoImport: Start Importing: Full Tilt
2015/06/27 16:24:49.963 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:49.979 [00015]: [00000F50][TourneyDetectThread] Thread [0x00000F50]: Begin
2015/06/27 16:24:49.979 [00000]: [00000F50][TourneyDetectThread] Beginning thread.
2015/06/27 16:24:49.984 [00005]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.984 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.985 [00000]: [- Main -][ImportAuto] Starting AutoImporter: Full Tilt
2015/06/27 16:24:49.985 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:49.985 [00000]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:50.019 [00034]: [- Main -][ImportStatus] Full Tilt: Starting auto-import.
2015/06/27 16:24:50.073 [00054]: [- Main -][ImportStatus] Full Tilt: Monitoring tables for Rush Poker.
2015/06/27 16:24:50.074 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.075 [00000]: [- Main -][wpImport] AutoImport: Start Importing: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.075 [00001]: [- Main -][ImportAuto] Starting AutoImporter: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.076 [00000]: [- Main -][ImportStatus] iPoker: Starting auto-import.
2015/06/27 16:24:50.087 [00011]: [0000061C][FullTiltHandGrabber] Thread [0x0000061C]: Begin
2015/06/27 16:24:50.088 [00000]: [0000061C][FullTiltHandGrabber] Thread Start
2015/06/27 16:24:50.110 [00022]: [- Main -][DirectoryMonitor] Unable to monitor directory: C:\Poker\Betfair.com Poker\History
2015/06/27 16:24:50.112 [00002]: [- Main -][ImportStatus] iPoker: Monitoring tables for Speed Poker.
2015/06/27 16:24:50.112 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.113 [00000]: [- Main -][wpImport] AutoImport: Start Importing: OnGame
2015/06/27 16:24:50.113 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.114 [00000]: [- Main -][ImportAuto] Starting AutoImporter: OnGame
2015/06/27 16:24:50.114 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.114 [00001]: [- Main -][ImportStatus] OnGame: Starting auto-import.
2015/06/27 16:24:50.115 [00001]: [0000061C][FullTiltOptions] Using FullTiltPoker: C:\Users\user\AppData\Local\FullTiltPoker.eu
2015/06/27 16:24:50.132 [00017]: [- Main -][ImportStatus] OnGame: Monitoring tables for Strobe Poker.
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.133 [00001]: [- Main -][wpImport] AutoImport: Start Importing: PokerStars
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.134 [00001]: [- Main -][ImportAuto] Starting AutoImporter: PokerStars
2015/06/27 16:24:50.134 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.135 [00000]: [- Main -][ImportStatus] PokerStars: Starting auto-import.
2015/06/27 16:24:50.136 [00001]: [- Main -][PokerStarsOptions] Found INI File: C:\Users\user\AppData\Local\PokerStars\user.ini
2015/06/27 16:24:50.139 [00002]: [00001768][OnGameHandGrabber] Thread [0x00001768]: Begin
2015/06/27 16:24:50.139 [00000]: [00001768][OnGameHandGrabber] Thread Start
2015/06/27 16:24:50.146 [00008]: [0000061C][FullTiltHandGrabber] Table Style: Classic, Avatars: ON
2015/06/27 16:24:50.148 [00002]: [000024FC][iPokerHandGrabber] Thread [0x000024FC]: Begin
2015/06/27 16:24:50.148 [00000]: [000024FC][iPokerHandGrabber] Thread Start
2015/06/27 16:24:50.149 [00001]: [00001768][OnGameHandGrabber] Monitoring C:\Users\user\P5JavaClientSettings\handhistory\strobe-hand-starts.dat
2015/06/27 16:24:50.193 [00044]: [- Main -][ImportStatus] PokerStars: Monitoring tables for Zoom Poker.
2015/06/27 16:24:50.194 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.210 [00016]: [- Main -][wpImport] Done: Get Hands While Playing
2015/06/27 16:24:50.214 [00005]: [- Main -][HudLauncher] Launching: C:\Program Files (x86)\PokerTracker 4\PokerTrackerHud4.exe
2015/06/27 16:24:50.231 [00017]: [00001110][PokerStarsMemoryGrabber] Thread [0x00001110]: Begin
2015/06/27 16:24:50.231 [00000]: [00001110][PokerStarsMemoryGrabber] Starting memory hand grabber thread
2015/06/27 16:24:50.232 [00000]: [00001110][System] Getting String:
2015/06/27 16:24:50.243 [00011]: [00000440][PokerStarsHandGrabber] Thread [0x00000440]: Begin
2015/06/27 16:24:50.243 [00000]: [00000440][PokerStarsHandGrabber] Thread Start
2015/06/27 16:24:50.568 [00324]: [- Main -][ImportStatus] Full Tilt: Found 0 files to monitor.
2015/06/27 16:24:50.594 [00026]: [- Main -][ImportStatus] iPoker: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00032]: [- Main -][ImportStatus] OnGame: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00001]: [- Main -][ImportStatus] PokerStars: Found 0 files to monitor.
2015/06/27 16:24:51.197 [00569]: [000024FC][iPokerHandGrabber] Launching iPoker Communicator
2015/06/27 16:24:52.258 [01061]: [000024FC][iPokerHandGrabber] Opening the Comm Pipe
2015/06/27 16:24:52.258 [00000]: [000024FC][iPokerHandGrabber] Waiting for messages...
2015/06/27 16:24:53.837 [01579]: [00001B20][HudIpcClient] PONG: Launch: 5.19s
2015/06/27 16:24:56.883 [03046]: [000024FC][GrabberPipe] High mark is: 32
2015/06/27 16:24:56.884 [00001]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00566]: [000024FC][GrabberPipe] High mark is: 136
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] New Table: Speed Hold'em 3 [LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20] (€0.20 NL FAST (6 max))
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 1: Akingge
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 3: hovlaaaa
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 5: hevos5mih
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 6: PISTONS55
2015/06/27 16:24:57.452 [00000]: [000024FC][iPokerHandGrabber] Seat 8: LastClock
2015/06/27 16:24:57.468 [00016]: [00001228][TableManager] Table found: 'Speed Hold'em 3' ([PTIODEVICE] LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20)
2015/06/27 16:24:57.469 [00001]: [00001228][TableManager] Hero for table 'Speed Hold'em 3' is 'LastClock'
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Initial table refresh: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Refreshing table: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.566 [00097]: [00001228][ProfileManager] Hud Profiles loaded.
2015/06/27 16:24:57.566 [00000]: [00001228][ProfileManager] Profile: Cash - Default Priority: 0
2015/06/27 16:24:57.567 [00000]: [00001228][ProfileManager] Selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][TableManager] Auto selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][LayoutManager] Loading profile: iPoker - 6 max - Speed Cash | Cash - Default
2015/06/27 16:24:58.522 [00955]: [00001228][StatManager] Unable to use cache due to column: live_amt_stack (live_amt_stack)
2015/06/27 16:24:58.864 [00343]: [00001228][LayoutManager] Load Success: Cash - Default
2015/06/27 16:24:58.865 [00000]: [00001228][HudManager] Profile: Commands: 11284, Bytes: 766106
2015/06/27 16:24:58.865 [00000]: [00001228][LayoutManager] st: 3401 t: 1.30s p1: 929ms p3: 0.2119ms s: 406ms sc: 7ms st: 361ms sp: 3ms q: 366ms
2015/06/27 16:24:58.865 [00000]: [00001228][WindowUpdater] Setting profile: Cash - Default
2015/06/27 16:24:58.866 [00001]: [00001228][TableManager] Table refreshed.
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 8
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 5 (8), Preferred Seat: 3, Total Seats: 6, Offset: 4
2015/06/27 16:24:58.867 [00001]: [00001228][TableManager] Query [0]: SLOW, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.867 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20' 1 queries)
2015/06/27 16:24:58.895 [00028]: [00001228][TableManager] Query Begin [0]: Channel: SLOW Priority: 33140, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.895 [00000]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'akingge') OR (p.id_site=400 AND p.player_name_search=E'hovlaaaa') OR (p.id_site=400 AND p.player_name_search=E'hevos5mih') OR (p.id_site=400 AND p.player_name_search=E'pistons55')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Query execution time: 0.00623253 ms
2015/06/27 16:24:58.920 [00025]: [00001228][TableManager] Query Failure [0]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:25:16.332 [17412]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 1: harrycys
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 3: VKARTMANN10
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 5: RD709324
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 6: LastClock
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 8: hevos5mih
2015/06/27 16:25:16.333 [00000]: [000024FC][iPokerHandGrabber] Seat 10: ReeblStribe
2015/06/27 16:25:16.526 [00193]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 6
2015/06/27 16:25:16.526 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 4 (6), Preferred Seat: 3, Total Seats: 6, Offset: 5
2015/06/27 16:25:16.536 [00010]: [00001228][TableManager] Query [1]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:25:16.536 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:25:16.610 [00074]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:25:16.610 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call",

Re: ipoker, betfair configure with PT4

PostPosted: Sat Jun 27, 2015 11:58 am
by No-Rebuy
(sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'harrycys') OR (p.id_site=400 AND p.player_name_search=E'vkartmann10') OR (p.id_site=400 AND p.player_name_search=E'rd709324') OR (p.id_site=400 AND p.player_name_search=E'hevos5mih') OR (p.id_site=400 AND p.player_name_search=E'reeblstribe')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:25:16.610 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Query execution time: 0.00659915 ms
2015/06/27 16:25:16.611 [00000]: [00001228][TableManager] Query Begin [1]: Channel: SLOW Priority: 33040, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:25:16.638 [00027]: [00001228][TableManager] Query Failure [1]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:25:24.616 [07977]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:25:24.616 [00000]: [000024FC][iPokerHandGrabber] Seat 1: jussika444
2015/06/27 16:25:24.616 [00000]: [000024FC][iPokerHandGrabber] Seat 3: Nordathes
2015/06/27 16:25:24.616 [00000]: [000024FC][iPokerHandGrabber] Seat 5: Blu3zK1D
2015/06/27 16:25:24.616 [00000]: [000024FC][iPokerHandGrabber] Seat 6: gukape
2015/06/27 16:25:24.616 [00000]: [000024FC][iPokerHandGrabber] Seat 8: MrBoyle91
2015/06/27 16:25:24.617 [00000]: [000024FC][iPokerHandGrabber] Seat 10: LastClock
2015/06/27 16:25:24.628 [00011]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 10
2015/06/27 16:25:24.628 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 6 (10), Preferred Seat: 3, Total Seats: 6, Offset: 3
2015/06/27 16:25:24.647 [00019]: [00001228][TableManager] Query [2]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:25:24.648 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:25:24.679 [00031]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:25:24.680 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'jussika444') OR (p.id_site=400 AND p.player_name_search=E'nordathes') OR (p.id_site=400 AND p.player_name_search=E'blu3zk1d') OR (p.id_site=400 AND p.player_name_search=E'gukape') OR (p.id_site=400 AND p.player_name_search=E'mrboyle91')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:25:24.680 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Query execution time: 0.00989872 ms
2015/06/27 16:25:24.680 [00000]: [00001228][TableManager] Query Begin [2]: Channel: SLOW Priority: 33040, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:25:24.705 [00024]: [00001228][TableManager] Query Failure [2]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:26:30.144 [65441]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:26:30.145 [00000]: [000024FC][iPokerHandGrabber] Seat 1: LastClock
2015/06/27 16:26:30.145 [00000]: [000024FC][iPokerHandGrabber] Seat 3: macgs56
2015/06/27 16:26:30.145 [00000]: [000024FC][iPokerHandGrabber] Seat 5: PISTONS55
2015/06/27 16:26:30.145 [00000]: [000024FC][iPokerHandGrabber] Seat 6: jussika444
2015/06/27 16:26:30.145 [00000]: [000024FC][iPokerHandGrabber] Seat 8: me8phisto
2015/06/27 16:26:30.165 [00019]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 1
2015/06/27 16:26:30.165 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 1 (1), Preferred Seat: 3, Total Seats: 6, Offset: 2
2015/06/27 16:26:30.242 [00078]: [00001228][TableManager] Query [3]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:26:30.243 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:26:30.274 [00031]: [00001228][TableManager] Query Begin [3]: Channel: SLOW Priority: 33040, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:26:30.295 [00021]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:26:30.295 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'macgs56') OR (p.id_site=400 AND p.player_name_search=E'pistons55') OR (p.id_site=400 AND p.player_name_search=E'jussika444') OR (p.id_site=400 AND p.player_name_search=E'me8phisto')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:26:30.296 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Query execution time: 0.01209843 ms
2015/06/27 16:26:30.303 [00008]: [00001228][TableManager] Query Failure [3]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:26:50.163 [19858]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:26:50.163 [00000]: [000024FC][iPokerHandGrabber] Seat 1: PISTONS55
2015/06/27 16:26:50.163 [00000]: [000024FC][iPokerHandGrabber] Seat 3: LastClock
2015/06/27 16:26:50.163 [00000]: [000024FC][iPokerHandGrabber] Seat 5: MrBoyle91
2015/06/27 16:26:50.163 [00000]: [000024FC][iPokerHandGrabber] Seat 8: ReeblStribe
2015/06/27 16:26:50.163 [00000]: [000024FC][iPokerHandGrabber] Seat 10: me8phisto
2015/06/27 16:26:50.179 [00015]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 3
2015/06/27 16:26:50.183 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 2 (3), Preferred Seat: 3, Total Seats: 6, Offset: 1
2015/06/27 16:26:50.209 [00026]: [00001228][TableManager] Query [4]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:26:50.209 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:26:50.270 [00060]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:26:50.270 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'me8phisto') OR (p.id_site=400 AND p.player_name_search=E'pistons55') OR (p.id_site=400 AND p.player_name_search=E'mrboyle91') OR (p.id_site=400 AND p.player_name_search=E'reeblstribe')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:26:50.270 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Query execution time: 0.00989872 ms
2015/06/27 16:26:50.271 [00000]: [00001228][TableManager] Query Begin [4]: Channel: SLOW Priority: 33040, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:26:50.297 [00027]: [00001228][TableManager] Query Failure [4]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:26:53.257 [02959]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:26:53.257 [00000]: [000024FC][iPokerHandGrabber] Seat 1: allmine121
2015/06/27 16:26:53.257 [00000]: [000024FC][iPokerHandGrabber] Seat 3: jussika444
2015/06/27 16:26:53.257 [00000]: [000024FC][iPokerHandGrabber] Seat 5: mouriska
2015/06/27 16:26:53.257 [00000]: [000024FC][iPokerHandGrabber] Seat 6: hovlaaaa
2015/06/27 16:26:53.258 [00000]: [000024FC][iPokerHandGrabber] Seat 8: LastClock
2015/06/27 16:26:53.258 [00000]: [000024FC][iPokerHandGrabber] Seat 10: hevos5mih
2015/06/27 16:26:53.261 [00003]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 8
2015/06/27 16:26:53.261 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 5 (8), Preferred Seat: 3, Total Seats: 6, Offset: 4
2015/06/27 16:26:53.280 [00018]: [00001228][TableManager] Query [5]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:26:53.281 [00001]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:26:53.353 [00073]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:26:53.353 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'allmine121') OR (p.id_site=400 AND p.player_name_search=E'jussika444') OR (p.id_site=400 AND p.player_name_search=E'mouriska') OR (p.id_site=400 AND p.player_name_search=E'hovlaaaa') OR (p.id_site=400 AND p.player_name_search=E'hevos5mih')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:26:53.353 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Query execution time: 0.00733238 ms
2015/06/27 16:26:53.354 [00000]: [00001228][TableManager] Query Begin [5]: Channel: SLOW Priority: 33040, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:26:53.403 [00050]: [00001228][TableManager] Query Failure [5]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:27:20.766 [27364]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:27:20.767 [00000]: [000024FC][iPokerHandGrabber] Seat 1: VKARTMANN10
2015/06/27 16:27:20.767 [00000]: [000024FC][iPokerHandGrabber] Seat 3: pradaabu81
2015/06/27 16:27:20.767 [00000]: [000024FC][iPokerHandGrabber] Seat 5: LastClock
2015/06/27 16:27:20.767 [00000]: [000024FC][iPokerHandGrabber] Seat 6: calculomal
2015/06/27 16:27:20.767 [00000]: [000024FC][iPokerHandGrabber] Seat 8: Uvko
2015/06/27 16:27:20.767 [00000]: [000024FC][iPokerHandGrabber] Seat 10: Seretis79
2015/06/27 16:27:20.773 [00006]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 5
2015/06/27 16:27:20.773 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 3 (5), Preferred Seat: 3, Total Seats: 6, NO ROTATION
2015/06/27 16:27:20.785 [00012]: [00001228][TableManager] Query [6]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:27:20.785 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:27:20.821 [00037]: [00001228][TableManager] Query Begin [6]: Channel: SLOW Priority: 33040, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:27:20.846 [00024]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:27:20.846 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'vkartmann10') OR (p.id_site=400 AND p.player_name_search=E'pradaabu81') OR (p.id_site=400 AND p.player_name_search=E'calculomal') OR (p.id_site=400 AND p.player_name_search=E'uvko') OR (p.id_site=400 AND p.player_name_search=E'seretis79')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:27:20.846 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Query execution time: 0.00733238 ms
2015/06/27 16:27:20.874 [00028]: [00001228][TableManager] Query Failure [6]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:27:25.309 [04435]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:27:25.309 [00000]: [000024FC][iPokerHandGrabber] Seat 1: pradaabu81
2015/06/27 16:27:25.310 [00000]: [000024FC][iPokerHandGrabber] Seat 3: VKARTMANN10
2015/06/27 16:27:25.310 [00000]: [000024FC][iPokerHandGrabber] Seat 5: PISTONS55
2015/06/27 16:27:25.310 [00000]: [000024FC][iPokerHandGrabber] Seat 6: funkyJane
2015/06/27 16:27:25.310 [00000]: [000024FC][iPokerHandGrabber] Seat 10: LastClock
2015/06/27 16:27:25.367 [00057]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 10
2015/06/27 16:27:25.367 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 6 (10), Preferred Seat: 3, Total Seats: 6, Offset: 3
2015/06/27 16:27:25.384 [00018]: [00001228][TableManager] Query [7]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:27:25.385 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:27:25.461 [00076]: [00001228][TableManager] Query Begin [7]: Channel: SLOW Priority: 33040, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:27:25.461 [00000]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:27:25.461 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'pradaabu81') OR (p.id_site=400 AND p.player_name_search=E'vkartmann10') OR (p.id_site=400 AND p.player_name_search=E'pistons55') OR (p.id_site=400 AND p.player_name_search=E'funkyjane')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:27:25.461 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Query execution time: 0.00843224 ms
2015/06/27 16:27:25.486 [00024]: [00001228][TableManager] Query Failure [7]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:28:07.665 [42180]: [00001228][TableManager] Window for table no longer valid: 'Speed Hold'em 3'
2015/06/27 16:28:07.757 [00092]: [00001228][TableManager] Removing table: Speed Hold'em 3 [Speed Hold'em 3]
2015/06/27 16:28:13.991 [06233]: [- Main -][wpImport] Click: Get Hands While Playing
2015/06/27 16:28:13.994 [00002]: [- Main -][wpImport] AutoImport: Stop Import
2015/06/27 16:28:13.994 [00000]: [- Main -][ImportAuto] stopImport()::begin
2015/06/27 16:28:13.994 [00000]: [- Main -][ImportAuto] stopThread()::begin
2015/06/27 16:28:13.995 [00000]: [- Main -][ImportAuto] Wait()
2015/06/27 16:28:13.997 [00002]: [00001CE8][ImportAuto] Stopping: Full Tilt
2015/06/27 16:28:14.017 [00021]: [- Main -][ImportStatus] Full Tilt: Stopping auto-import.
2015/06/27 16:28:14.293 [00275]: [0000061C][FullTiltHandGrabber] Thread End
2015/06/27 16:28:14.294 [00001]: [00001CE8][ImportAuto] Stopping: iPoker
2015/06/27 16:28:14.316 [00022]: [000024FC][iPokerHandGrabber] Closing the Comm Pipe
2015/06/27 16:28:14.316 [00000]: [000024FC][iPokerHandGrabber] Thread End
2015/06/27 16:28:14.326 [00009]: [00001CE8][ImportAuto] Stopping: OnGame
2015/06/27 16:28:14.353 [00026]: [- Main -][ImportStatus] iPoker: Stopping auto-import.
2015/06/27 16:28:14.394 [00041]: [- Main -][ImportStatus] OnGame: Stopping monitoring of Strobe poker.
2015/06/27 16:28:14.422 [00027]: [00001768][OnGameHandGrabber] Thread End
2015/06/27 16:28:14.423 [00000]: [00001CE8][ImportAuto] Stopping: PokerStars
2015/06/27 16:28:14.424 [00000]: [- Main -][ImportStatus] OnGame: Stopping auto-import.
2015/06/27 16:28:14.463 [00039]: [- Main -][ImportStatus] PokerStars: Stopping auto-import.
2015/06/27 16:28:14.489 [00025]: [00001110][PokerStarsMemoryGrabber] Thread Exit
2015/06/27 16:28:14.972 [00483]: [00000440][PokerStarsHandGrabber] Thread End
2015/06/27 16:28:14.973 [00001]: [00001CE8][ImportAuto::ImportAutoWorker::Entry] Ending thread.
2015/06/27 16:28:14.984 [00012]: [- Main -][ImportStatus] Auto-Import stopped.
2015/06/27 16:28:14.987 [00003]: [- Main -][ImportAuto] stopThread()::end
2015/06/27 16:28:15.738 [00750]: [000023A0][AutoNoteThread] Ending thread.
2015/06/27 16:28:15.738 [00001]: [00000F50][TourneyDetectThread] Ending thread.
2015/06/27 16:28:15.739 [00000]: [- Main -][TableManager] Shutting Down...
2015/06/27 16:28:15.739 [00001]: [- Main -][TableManager] Waiting for thread to stop...
2015/06/27 16:28:15.748 [00008]: [00001228][TableManager] Clearing tables
2015/06/27 16:28:15.748 [00000]: [00001228][TableManager] Clearing connections
2015/06/27 16:28:16.749 [00999]: [00001228][TableManager] Clearing tables
2015/06/27 16:28:16.749 [00000]: [00001228][TableManager] Thread exiting.
2015/06/27 16:28:16.749 [00001]: [- Main -][TableManager] Thread stopped
2015/06/27 16:28:18.020 [01271]: [- Main -][TableManager] Shutdown
2015/06/27 16:28:18.020 [00000]: [- Main -][TableManager] Shutdown: ref_count: 0
2015/06/27 16:28:18.020 [00000]: [- Main -][ImportAuto] notifyEnd
2015/06/27 16:28:18.037 [00017]: [- Main -][ImportAuto] stopImport()::end
2015/06/27 16:28:18.047 [00009]: [- Main -][wpImport] Done: Get Hands While Playing
2015/06/27 16:28:20.908 [02862]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"
2015/06/27 16:31:54.271 [99999]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"
2015/06/27 16:40:26.674 [99999]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"
2015/06/27 16:50:52.289 [99999]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"