[Closed] Elephant Overview crashing

Hey bellavec,

unfortunately I have no clue why you have this problem. Let's see if galam can help when he is back from vacations.

Best regards,
TribunCaesar

hey thanks tribun, didn't see you answer ♦

somebody on our italian forum told me he has the same problem, this could be a bug to fix...

not a big deal anyways

Mmh please look into the logfile after this happened and post whats in there.

Greets Sebastian

Originally posted by galam
Mmh please look into the logfile after this happened and post whats in there.

Greets Sebastian

hi Sebastian, i'd be happy to post it, but i actually don't know what the logfile is..
could you please tell me what i've got to do, just like you were talking to your granny? ♦
thanks so much!

Thats pretty simple. After the Elephant crashes please restart it and then goto to mainmenu (elephant upper left corner) and switch to the help section. there you can find the logfile of the current and previous session. Please post the log of the previous session here.

Greets Sebastian

hi, since i have exactly the same problem as bellavec, i will post my last error report

i tried with a database of lot of hands and a database with very few, there's no difference

OS: Microsoft Windows NT 5.1.2600 Service Pack 3 .NET Runtime: 2.0.50727.1433 RAM: 2GB Processors: 2 CPU: x86 Family 15 Model 35 Stepping 2: 0/32/2, 2300  Software version: 0.60  (10) 18:38:41.09 -- Logfile cleared: C:\Documents and Settings\NexAlp\Local Settings\Application Data\PokerStrategy\Elephant\log.txt (10) 18:39:10.98 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:11.10 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:11.23 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:11.25 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:11.39 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:11.39 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:11.53 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:11.53 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:11.67 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:11.67 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:11.81 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:11.81 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:11.95 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:11.95 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:12.14 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:12.17 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:12.37 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:12.37 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:12.53 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:12.53 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:12.67 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:12.68 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:12.82 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:12.82 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:12.95 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:12.96 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:13.10 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:13.10 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:13.25 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:13.25 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:13.39 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:13.39 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:13.53 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:13.53 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:13.68 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:13.68 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:13.84 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:13.84 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:13.98 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:13.98 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:14.12 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:14.12 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:14.26 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:14.26 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:14.42 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:14.42 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:14.56 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:14.56 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:14.70 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly>='2008-10-01' AND g.dateonly<='2008-10-31' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-01 0.00.0' AND g.dateandtime<='2008-10-31 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:14.70 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-01 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:16.26 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly='2008-10-09' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-09 0.00.0' AND g.dateandtime<='2008-10-09 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:16.28 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-09 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) (10) 18:39:40.14 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won),  SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(3) AND NOT(t.currency='CHP') AND g.dateonly='2008-10-09' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0'  AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-09 0.00.0' AND g.dateandtime<='2008-10-09 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC  (10) 18:39:40.14 -- , line 0: Npgsql.NpgsqlException: (10) invalid input syntax for type timestamp: "2008-10-09 0.00.0" (10) Severity: ERROR (10) Code: 22007 (10)    at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() (10)    at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() (10)    at Npgsql.ForwardsOnlyDataReader.NextResult() (10)    at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) (10)    at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) (10)    at Npgsql.NpgsqlCommand.ExecuteReader() (10)    at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery) 

Hi Galam, i followed your guide and clicked "show last logfile"

here's the result:

OS: Microsoft Windows NT 6.0.6001 Service Pack 1
.NET Runtime: 2.0.50727.1434
RAM: 3GB
Processors: 2
CPU: x64 Family 6 Model 15 Stepping 13: 9/64/1, 2000

Software version: 0.60

(10) 18:53:17.62 -- Logfile cleared: C:\Users\Administrator\AppData\Local\PokerStrategy\Elephant\log.txt
(10) 02:39:23.25 -- SELECT COUNT(DISTINCT(g.game_ID)) AS total_hands, MAX(g.dateandtime) , '1', '1', SUM(gp.amount_won), SUM(CASE WHEN t.big_blind>0 THEN (gp.amount_won/t.big_blind) ELSE 0 END) AS bb_won FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE g.game_type_ID=t.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(19556,507,7) AND NOT(t.currency='CHP') AND g.dateonly='2008-10-06' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0' AND gp.combined=sc.combined AND sc.active='true' AND gp.position_short<>'Unknown' AND gp.num_actions>0 AND g.dateandtime>='2008-10-06 0.00.0' AND g.dateandtime<='2008-10-06 23.59.59' GROUP BY g.game_ID ORDER BY MAX(g.dateandtime) DESC
(10) 02:39:23.47 -- , line 0: Npgsql.NpgsqlException:
(10) invalid input syntax for type timestamp: "2008-10-06 0.00.0"
(10) Severity: ERROR
(10) Code: 22007
(10) at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
(10) at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
(10) at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
(10) at Npgsql.ForwardsOnlyDataReader.NextResult()
(10) at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
(10) at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
(10) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
(10) at Npgsql.NpgsqlCommand.ExecuteReader()
(10) at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)

hope it'll help ♦

I detected 2 bugs in that logfile X(

Thats interesting where you just using the overview? Any timefilters active on before you switch to the overview?

No, i believe that filters were inactive..

it happened to me while i was selecting the stats of a single day, or single month

Please report if the error still occurs while using the newest 0.61 version of the elephant.

Greets Sebastian