Postgres Benutzerkonto gelöscht

    • Apostel111
      Apostel111
      Bronze
      Dabei seit: 15.05.2007 Beiträge: 16
      Hi,

      wollte heute den Ele mal neu installieren, da er paar probs hatte. Wollte dann auch glei sql neu draufspielen und hab in der deinstallationsanleitung überlesen dass das eigene konto nicht gelöscht werden darf.

      So nun bekomme ich jedesmal wenn ich den Ele starte dann versucht er sich mit meinen alten Datenbank zu verbinden (also user und pw kombo, welche ich ja gelöscht hatte) und das endet dann in "failed to establish a connection 127.00.00

      any ideas?
  • 8 Antworten
    • Snoke
      Snoke
      Bronze
      Dabei seit: 14.04.2007 Beiträge: 2.436
      könnte sein dass es am server oderso liegt ich hab jedenfalls seit heute das gleiche problem
    • Apostel111
      Apostel111
      Bronze
      Dabei seit: 15.05.2007 Beiträge: 16
      Hab den Ele nun zum laufen gebracht, aber hab dafür nun folgende Probleme: ;)

      Der ELe funktioniert soweit, d. h. er importiert meine gespielten Hände und wertet diese auch aus. Ich kann also im Überblickfenster meinen Graphen sehen und auch die Hände sind drinne.

      Allerdings sehe ich im Analysefenster nichts. Es werden keine Daten angezeigt und es steht da: Es sind keine Daten vorhanden, Filtereinstellungen prüfen.
      Hatte noch keinen Filter eingestellt, aber trotzdem mal auf Filter löschen gegangen, hat aber leider nichts gebracht..

      Irgendjemand ne Ahnung wieso?

      Und zweites Problem: Mein HUD funzt auch nicht. Es werden nur die Standardwerte fortlaufend angezeigt. Also seat 1 alle werte auf 10, seat 2 auf 20 usw..
      Ausserdem keine Hero Stats verfügbar.

      Wenn dazu noch jemand was wüsste, dann wär mein Tag gerettet :)

      Thx!
    • galam
      galam
      Bronze
      Dabei seit: 06.03.2005 Beiträge: 11.136
      Hm komische Geschichte, hast du auch mal zwischen Limit und No-Limit gewechselt? Sind in der Handübersicht Hände drin? Steht was im Logfile?

      Gruß Sebastian
    • Apostel111
      Apostel111
      Bronze
      Dabei seit: 15.05.2007 Beiträge: 16
      Hi Sebastian,

      hatte bis dato nur nl gespielt, auch wenn ich mal im Ele hin und her switche passiert nichts. In der Handübersicht sind Hände drinne und der Überblick-tab funktioniert auch ohne probs. Wirklich strange...

      Ich paste mal die Logfile, hoffe Du kannst mir helfen, fühle mich iwie "beschnitten" ohne stats^^

      OS: Microsoft Windows NT 5.1.2600 Service Pack 3
      .NET Runtime: 2.0.50727.1433
      RAM: 2GB
      Processors: 2
      CPU: x86 Family 6 Model 15 Stepping 6: 0/32/2, 2128

      Software version: 0.67

      (10) Log: 11:47:04.70 -- Logfile set: C:\Dokumente und Einstellungen\Thorsten\Lokale Einstellungen\Anwendungsdaten\PokerStrategy\Elephant\log.txt
      (10) Log: 11:47:04.71 -- Logfile cleared: C:\Dokumente und Einstellungen\Thorsten\Lokale Einstellungen\Anwendungsdaten\PokerStrategy\Elephant\log.txt
      (10) Log: 12:25:22.62 -- SELECT t.limit_type, SUM(gp.amount_won), SUM(CASE WHEN t.big_blind>0 THEN gp.amount_won/t.big_blind ELSE 0 END)::float, COUNT(DISTINCT(g.game_ID)), MAX( t.small_bet), t.big_bet FROM gametype t, game g, gameplayer gp, sorted_cards sc WHERE t.game_type_ID=g.game_type_ID AND g.game_ID=gp.game_ID AND gp.player_ID IN(14) AND gp.position_short<>'Unknown' AND g.dateonly>='2009-01-01' AND g.dateonly<='2009-12-31' AND g.num_players>='7' AND g.limit_type IN('NL','PL') AND g.tournament_ID='0' AND g.dateandtime>='01/01/2009 12:00:00 AM' AND g.dateandtime<='12/31/2009 12:00:00 AM' AND (gp.num_actions>0 OR gp.winner) AND gp.combined=sc.combined AND sc.active='true' AND NOT(t.currency='CHP') GROUP BY t.big_bet, t.limit_type ORDER BY t.limit_type, t.big_bet DESC
      (10) Log: 12:25:22.87 -- , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      (10) , line 0: Npgsql.NpgsqlException:
      date/time field value out of range: "12/31/2009 12:00:00 AM"
      Severity: ERROR
      Code: 22008
      Hint: Perhaps you need a different "datestyle" setting.
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader()
      at PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
    • Apostel111
      Apostel111
      Bronze
      Dabei seit: 15.05.2007 Beiträge: 16
      Vielleicht noch als ergänzung: Wenn der Ele Hände einliest (auto-import nach jeder Hand) dann klappt das immer einwandfrei, nur stuft er sämtliche neue eingelesenen Hände sofort als Duplikate ein, was unmöglich ist da ich die Hand ja erst ein paar sec. vorher gespielt hab..
    • Apostel111
      Apostel111
      Bronze
      Dabei seit: 15.05.2007 Beiträge: 16
      push

      ?( ?(
    • Wolf0815
      Wolf0815
      Bronze
      Dabei seit: 05.11.2008 Beiträge: 7
      wenn ich mir die Fehlermeldung so anschaue, hab ich den Verdacht, dass der elephant bei dir ein falsches Datumsformat verwendet:

      dein versuchter Eintrag:
      "12/31/2009 12:00:00 AM"

      bei mir in der DB stehen aber Einträge mit
      '2008-12-30 22:32:12'

      Meine vermutung wäre jetzt, dass du entweder beim elephant oder bei Windows das Datumsformat von englisch/amerikanisch auf deutsch setzen musst.

      Geh mal in Windows ins Control Panel (Systemsteuerung?) und öffne "Regional and Language Options" (Länderspezifische Einstellung?) und schau ob da Deutsch eingestellt ist.

      Ich benutze ein englisches Windows (daher weiss ich auch nicht genau wie die Tools auf Deutsch heissen) und hab mit dieser Datums-Einstellung kein Problem den Elephant zu benutzen.

      hoffe mal das hilft dir weiter
    • Apostel111
      Apostel111
      Bronze
      Dabei seit: 15.05.2007 Beiträge: 16
      Das dachte ich auch anfangs, allerdings ist es im Elephant möglich meine einzelnen Sessions nach Datum anzeigen zu lassen. Also ich erhalte für beispielsweise den 8.01.09 alle Hände dieses Tages korrekt angezeigt, also muss dass Problem wohl woanders liegen...