Elephant Overview crashing

    • bellavec
      bellavec
      Bronze
      Joined: 29.01.2008 Posts: 7,815
      Hey guys,
      a little problem with Elephant.. if i go to the section "overview" the graphs seem to be correct, but if i try and click on a single day, in the top left section "days", instead of the graph it appears "loading" and Elephant crashes, i must restart it to make it work again..

      had any of u some trouble like this? ideas/hints? thanks so much!
  • 12 replies
    • TribunCaesar
      TribunCaesar
      Bronze
      Joined: 29.04.2007 Posts: 13,264
      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
    • bellavec
      bellavec
      Bronze
      Joined: 29.01.2008 Posts: 7,815
      hey thanks tribun, didn't see you answer :D

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

      not a big deal anyways ;)
    • galam
      galam
      Bronze
      Joined: 06.03.2005 Posts: 11,136
      Mmh please look into the logfile after this happened and post whats in there.

      Greets Sebastian
    • bellavec
      bellavec
      Bronze
      Joined: 29.01.2008 Posts: 7,815
      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? :D
      thanks so much!
    • galam
      galam
      Bronze
      Joined: 06.03.2005 Posts: 11,136
      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
    • nexalp
      nexalp
      Bronze
      Joined: 18.03.2008 Posts: 774
      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

      code:
      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) 
    • bellavec
      bellavec
      Bronze
      Joined: 29.01.2008 Posts: 7,815
      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 :D :D
    • HoofdVogel
      HoofdVogel
      Bronze
      Joined: 11.01.2008 Posts: 3,193
      I detected 2 bugs in that logfile X( X(
    • galam
      galam
      Bronze
      Joined: 06.03.2005 Posts: 11,136
      Thats interesting where you just using the overview? Any timefilters active on before you switch to the overview?
    • bellavec
      bellavec
      Bronze
      Joined: 29.01.2008 Posts: 7,815
      No, i believe that filters were inactive..
    • nexalp
      nexalp
      Bronze
      Joined: 18.03.2008 Posts: 774
      it happened to me while i was selecting the stats of a single day, or single month
    • galam
      galam
      Bronze
      Joined: 06.03.2005 Posts: 11,136
      Please report if the error still occurs while using the newest 0.61 version of the elephant.

      Greets Sebastian