Session is not shown

[Gelkand]

Hi!

Yesterday i played and imported two files from pokerstars, no problems, but while the hands with the correct times are shown, the corresponing session with the date 2008/02/27 are not shown and a query after sessions with this state, leads to an error (duplicate unique key constraints violated).

The corresponding log entry shows this:


[codeh8x]2008/02/27 23:47:31.171: [00005936][PostgresConnection] Successfully connected to: My PT3 Beta DB [26734848]
2008/02/27 23:47:34.468: [00004608][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 htss.id_player FROM holdem_hand_player_statistics hhps, holdem_table_session_summary htss WHERE 1=1 AND (htss.id_session = hhps.id_session AND htss.id_player = hhps.id_player) AND ( ( htss.date_start >= '2008/02/26 23:00:00' AND htss.date_start <= '2008/02/27 22:59:59') OR ( htss.date_end >= '2008/02/26 23:00:00' AND htss.date_end <= '2008/02/27 22:59:59') ) AND ( htss.id_site in (100)) AND ( hhps.id_limit in (28,1,3)) ) ORDER BY player_name_search asc
2008/02/27 23:47:34.546: [00004608][Query] Query execution time: 41.15746554 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 htss.id_player FROM holdem_hand_player_statistics hhps, holdem_table_session_summary htss WHERE 1=1 AND (htss.id_session = hhps.id_session AND htss.id_player = hhps.id_player) AND ( ( htss.date_start >= '2008/02/26 23:00:00' AND htss.date_start <= '2008/02/27 22:59:59') OR ( htss.date_end >= '2008/02/26 23:00:00' AND htss.date_end <= '2008/02/27 22:59:59') ) AND ( htss.id_site in (100)) AND ( hhps.id_limit in (28,1,3)) ) ORDER BY player_name_search asc
2008/02/27 23:47:34.671: [00002344][QueryReportCtrl] Query load time: 0 ms
2008/02/27 23:47:53.687: [- Main -][ConnectionManager] Setting: filters:holdem-cash = DT_SINCE:2008/02/01 LIMITS: 28 1 3 SITES: 100 [PokerTracker 3 Beta Database 1]
2008/02/27 23:47:53.734: [- Main -][PostgresConnection (Error)] Unable to execute query: INSERT INTO settings VALUES('filters:holdem-cash', 'DT_SINCE:2008/02/01 LIMITS: ...; Reason: Fatal Error (ERROR: duplicate key value violates unique constraint "settings_primary_key" )
2008/02/27 23:47:53.890: [00002476][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 htss.id_player FROM holdem_hand_player_statistics hhps, holdem_table_session_summary htss WHERE 1=1 AND (htss.id_session = hhps.id_session AND htss.id_player = hhps.id_player) AND ( htss.date_start >= '2008/01/31 23:00:00' OR htss.date_end >= '2008/01/31 23:00') AND ( htss.id_site in (100)) AND ( hhps.id_limit in (28,1,3)) ) ORDER BY player_name_search asc
2008/02/27 23:48:10.671: [00002476][Query] Query execution time: 16751.06947950 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 htss.id_player FROM holdem_hand_player_statistics hhps, holdem_table_session_summary htss WHERE 1=1 AND (htss.id_session = hhps.id_session AND htss.id_player = hhps.id_player) AND ( htss.date_start >= '2008/01/31 23:00:00' OR htss.date_end >= '2008/01/31 23:00') AND ( htss.id_site in (100)) AND ( hhps.id_limit in (28,1,3)) ) ORDER BY player_name_search asc
2008/02/27 23:48:10.828: [00002860][[/codeh8x]

Greetings, Gelkand

[Josh]

Try disabling the other non-date filters and see if that causes the session to appear.