PT3 Crashes

[wokkie]

I've installed the latest beta version and everytime I've start PT it crashes. Ive removed and installed PT several times, but it doesn;t solve the problem.
Can someone help me with this problem?

I use Vista

[Josh]

Copy and paste the contents of the PokerTracker.log file here.

[wokkie]

I hope this is it? I have no viruses and I've cleaned the cache and all little errors, but the problem is still there

2008/04/27 16:07:16.822: [- Main -][System] PokerTracker v3.00 beta 9
2008/04/27 16:07:16.982: [- Main -][System] Attempting to to: http://www.ptrackupdate.com/check.php
2008/04/27 16:07:17.010: [00005756][ConnectorThread] Connecting...
2008/04/27 16:07:17.529: [00005756][ConnectorThread] Sending request...
2008/04/27 16:07:18.092: [00005756][ConnectorThread] Reading response...
2008/04/27 16:07:18.114: [00005756][ConnectorThread] Read complete.
2008/04/27 16:07:18.138: [00005756][ConnectorThread] Returning.
2008/04/27 16:07:18.161: [- Main -][System] Data read.
2008/04/27 16:07:18.178: [00003060][QueryManager] Loading stats
2008/04/27 16:07:20.318: [00003060][QueryManager] Stats loaded.
2008/04/27 16:07:20.335: [00003060][QueryManager] Loading queries
2008/04/27 16:07:20.352: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Aliases.xml.pte
2008/04/27 16:07:20.377: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2008/04/27 16:07:20.442: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2008/04/27 16:07:20.486: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Notes.xml.pte
2008/04/27 16:07:20.506: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Players.xml.pte
2008/04/27 16:07:20.539: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2008/04/27 16:07:20.591: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2008/04/27 16:07:20.644: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2008/04/27 16:07:20.687: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2008/04/27 16:07:20.714: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2008/04/27 16:07:20.758: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2008/04/27 16:07:20.890: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2008/04/27 16:07:20.996: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2008/04/27 16:07:21.055: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2008/04/27 16:07:21.079: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2008/04/27 16:07:21.109: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2008/04/27 16:07:21.143: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2008/04/27 16:07:21.174: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2008/04/27 16:07:21.323: [00003060][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2008/04/27 16:07:21.421: [00003060][QueryManager] Queries loaded.
2008/04/27 16:07:22.618: [00003060][StatManager] Stats and reports loaded.
2008/04/27 16:07:22.685: [00003060][FilterManager] Loading filters...
2008/04/27 16:07:23.766: [00003060][FilterManager] Filters loaded.
2008/04/27 16:07:23.801: [00003060][LayoutManager] Loading layouts...
2008/04/27 16:07:23.818: [00003060][LayoutManager] Layouts loaded.
2008/04/27 16:07:24.972: [00003060][StatManager] Stats and reports loaded.
2008/04/27 16:07:25.012: [00003060][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/04/27 16:07:25.134: [00003060][PostgresConnection] Successfully connected to: PT3 Beta DB1 [29724008]
2008/04/27 16:07:25.173: [00003060][PostgresConnection (Error)] Unable to execute query: SELECT * FROM tourney_holdem_blinds ORDER BY amt_bb asc, blinds_name;; Reason: Fatal Error (ERROR: could not open relation 1663/16438/16935: No such file or directory )
2008/04/27 16:07:25.202: [00003060][ConnectionManager] Unable to load blinds. Reason: Unable to execute query: SELECT * FROM tourney_holdem_blinds ORDER BY amt_bb asc, blinds_name;; Reason: Fatal Error (ERROR: could not open relation 1663/16438/16935: No such file or directory )
2008/04/27 16:07:25.243: [00003060][ConnectionManager] Database Version: 300025
2008/04/27 16:07:25.377: [00003060][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/04/27 16:07:25.513: [00003060][PostgresConnection] Successfully connected to: PT3 Beta DB1 [29724528]
2008/04/27 16:07:25.546: [00003060][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/04/27 16:07:25.649: [00003060][PostgresConnection] Successfully connected to: PT3 Beta DB1 [29725048]
2008/04/27 16:07:25.679: [00003060][PostgresConnection] Connecting to database: PT3 Beta DB1
2008/04/27 16:07:25.788: [00003060][PostgresConnection] Successfully connected to: PT3 Beta DB1 [29725568]
2008/04/27 16:07:26.042: [- Main -][PokerStarsOptions] Special Path: C:\Users\Remko\AppData\Local\PokerStars
2008/04/27 16:07:26.080: [- Main -][PokerStarsOptions] Special Path: C:\Users\Remko\AppData\Local\PokerStars
2008/04/27 16:07:26.104: [- Main -][PokerStarsOptions] Special Path: C:\Users\Remko\AppData\Local\PokerStars
2008/04/27 16:07:26.126: [- Main -][PokerStarsOptions] Special Path: C:\Users\Remko\AppData\Local\PokerStars
2008/04/27 16:07:26.153: [- Main -][PokerStarsOptions] Special Path: C:\Users\Remko\AppData\Local\PokerStars
2008/04/27 16:07:26.293: [00004384][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:26.414: [00004384][Query] Query execution time: 23.59866966 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:28.239: [00004252][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:28.326: [00004252][PostgresConnection (Error)] Unable to execute query: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc ; Reason: Fatal Error (ERROR: could not open relation 1663/16438/16829: No such file or directory )
2008/04/27 16:07:28.352: [00004252][Query] Query execution time: 30.58733722 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:29.745: [00003596][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:29.778: [00003768][Query] Executing SQL: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:29.811: [00003596][Query] Query execution time: 21.38840272 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in ( SELECT DISTINCT holdem_table_session_summary.id_player FROM holdem_table_session_summary WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:29.827: [00003768][PostgresConnection (Error)] Unable to execute query: SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc ; Reason: Fatal Error (ERROR: could not open relation 1663/16438/16829: No such file or directory )
2008/04/27 16:07:29.844: [00003768][Query] Query execution time: 32.47053746 ms : SELECT id_player, id_site, player_name, val_icon FROM player WHERE id_player > 0 AND id_player_alias = 0 AND id_player in (SELECT DISTINCT id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 ) ORDER BY player_name_search asc
2008/04/27 16:07:30.155: [00004400][QueryReportCtrl] Query load time: 202 ms

[wokkie]

Someone can help me?

This is what I see. It's Dutch language. Is says: "Pokertracker doesn't work anymore. The program will be closed"



I cleaned up mij computer. I've installed PT a several times, also rebooted my PC several times. Im using Vista

[Josh]

Fatal Error (ERROR: could not open relation 1663/16438/16935: No such file or directory )

This makes me think it's a problem with your database. I'll make sure Derek sees this, as he's more of a PostgreSQL expert than I am.

[APerfect10]

Did you change PostgreSQL versions? Did you manually touch your PostgreSQL data/base directory?

Some of your database files are corrupted...

Best regards,

Derek