[DONE] Problem mit dem Spielerfilter

    • Stralle
      Stralle
      Silber
      Dabei seit: 01.10.2009 Beiträge: 48
      PokerStrategy.com Elephant Version: 0.81
      [Problem bestand auch schon bei den anderen Versionen]

      Betriebssystem:
      (x) XP
      ( ) Vista
      ( ) Windows 7

      Auf welchen Pokerraum bezieht sich das Problem:
      ( ) PartyPoker
      (x) PokerStars
      ( ) FullTilt
      ( ) iPoker Netzwerk (Mansion, Titan, etc.)
      ( ) andere: _________

      Problem in FAQ gesucht: (Siehe: hier)
      (x) Ja
      ( ) Nein

      Screenshot vorhanden:
      ( ) Ja
      ( ) Nein

      Fehlermeldungen im Logfile vorhanden:
      (Wo finde ich die Log-Datei auf meinem Computer? Siehe: hier)
      (x) Ja
      ( ) Nein

      Bei Datenbankproblemen:
      PostgreSQL separat installiert:
      ( ) Ja
      (x) Nein, der Elephant hat Postgres mit installiert

      Datenbankproblem-Guide gelesen? (Siehe: hier)
      (x) Ja
      ( ) Nein

      Genaue Problembeschreibung:

      Moin moin,

      da ich den elephant für 2 verschiedene Seiten nutze, interessiert mich natürlich nicht nur der Gesamtgewinn/Verlust, sondern auch der für die einzelnen Portale. Wenn ich den Filter für mein Nick bei FTP setzte klappt es. Jedoch nicht bei PokerStars. Bei der Filtereinstellung gehe ich auf Filter --> Spieler und Portale --> dann gebe ich den Nick ein und auf suchen. Er zeigt mir dann 2 Nicks an "mein Nick" und, komischerweise, "mein Nick" (button).

      Weder bei dem ersten noch bei dem zweiten bekomme ich die erhofften Statistiken. Sowohl beim Überblick, bei den Händen also auch bei der Analyse sehe ich die normale Maske mit der Information: "Es liegen keine Daten vor. Bitte beachten Sie die Filtereinstellungen."
      Es sind aber keine weiteren Filtereinstellungen gesetzt.

      So sieht das Problem aus. Ich hoffe ihr habt eine Lösung.
      Vielen Dank schon mal dafür

      Ich häng auch gleich mal die LOG Datei an...is aber nen bissn länger.

      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 22P05: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Severity: ERROR
      - Code: 22P05
      - BaseMessage: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\mb\wchar.c
      - Line: 1575
      - Routine: report_untranslatable_char
      - ErrorSql: SELECT player_ID FROM player WHERE convert(player_name::bytea,'UTF8','WIN1252')::text = convert_to('let-start-it','UTF8')::text AND site_ID IN(3)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:13:03,875 - 1102671 [1] ERROR PBNLogger: Exception caught in System.String PokerStrategyElephant.Database.MainQuery.GetPlayerList(System.String, Int32, PokerStrategyElephant.DatabaseFilter, Boolean)
      -------------------- System.NullReferenceException --------------------
      - Message: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.String GetPlayerList(System.String, Int32, PokerStrategyElephant.DatabaseFilter, Boolean)
      - HelpLink: <null>
      - Source: Elephant
      - InnerException: <null><none>
      - StackTrace:
      bei PokerStrategyElephant.Database.MainQuery.GetPlayerList(String playerName, Int32 realPlayerId, DatabaseFilter filter, Boolean useStrippedNames)
      2010-06-02 19:13:03,875 - 1102671 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:13:03,953 - 1102750 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:13:04,031 - 1102828 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:13:04,109 - 1102906 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:13:04,187 - 1102984 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:13:04,265 - 1103062 [1] ERROR PBNLogger: MainQuery.GetGameLevelLinesFromCache exception caught!
      -------------------- System.NullReferenceException --------------------
      - Message: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean GetGameLevelLinesFromCache(System.String, PokerStrategyElephant.DatabaseFilter, System.Collections.Generic.List`1[PokerStrategyElephant.GameLevelLine] ByRef, Int32)
      - HelpLink: <null>
      - Source: Elephant
      - InnerException: <null><none>
      - StackTrace:
      bei PokerStrategyElephant.Database.MainQuery.GetGameLevelLinesFromCache(String playerName, DatabaseFilter filter, List`1& lines, Int32 realPlayerId)
      2010-06-02 19:15:17,015 - 1235812 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 22P05: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Severity: ERROR
      - Code: 22P05
      - BaseMessage: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\mb\wchar.c
      - Line: 1575
      - Routine: report_untranslatable_char
      - ErrorSql: SELECT player_ID FROM player WHERE convert(player_name::bytea,'UTF8','WIN1252')::text = convert_to('let-start-it','UTF8')::text AND site_ID IN(3)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:17,187 - 1235984 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 22P05: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Severity: ERROR
      - Code: 22P05
      - BaseMessage: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\mb\wchar.c
      - Line: 1575
      - Routine: report_untranslatable_char
      - ErrorSql: SELECT player_ID FROM player WHERE convert(player_name::bytea,'UTF8','WIN1252')::text = convert_to('let-start-it','UTF8')::text AND site_ID IN(3)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:17,390 - 1236187 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 22P05: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Severity: ERROR
      - Code: 22P05
      - BaseMessage: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\mb\wchar.c
      - Line: 1575
      - Routine: report_untranslatable_char
      - ErrorSql: SELECT player_ID FROM player WHERE convert(player_name::bytea,'UTF8','WIN1252')::text = convert_to('let-start-it','UTF8')::text AND site_ID IN(3)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:17,546 - 1236343 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 22P05: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Severity: ERROR
      - Code: 22P05
      - BaseMessage: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\mb\wchar.c
      - Line: 1575
      - Routine: report_untranslatable_char
      - ErrorSql: SELECT player_ID FROM player WHERE convert(player_name::bytea,'UTF8','WIN1252')::text = convert_to('let-start-it','UTF8')::text AND site_ID IN(3)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:17,750 - 1236546 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 22P05: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Severity: ERROR
      - Code: 22P05
      - BaseMessage: character 0xc281 of encoding "UTF8" has no equivalent in "WIN1252"
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\mb\wchar.c
      - Line: 1575
      - Routine: report_untranslatable_char
      - ErrorSql: SELECT player_ID FROM player WHERE convert(player_name::bytea,'UTF8','WIN1252')::text = convert_to('let-start-it','UTF8')::text AND site_ID IN(3)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending)
      bei Npgsql.ForwardsOnlyDataReader.Read()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:17,890 - 1236687 [1] ERROR PBNLogger: Exception caught in System.String PokerStrategyElephant.Database.MainQuery.GetPlayerList(System.String, Int32, PokerStrategyElephant.DatabaseFilter, Boolean)
      -------------------- System.NullReferenceException --------------------
      - Message: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.String GetPlayerList(System.String, Int32, PokerStrategyElephant.DatabaseFilter, Boolean)
      - HelpLink: <null>
      - Source: Elephant
      - InnerException: <null><none>
      - StackTrace:
      bei PokerStrategyElephant.Database.MainQuery.GetPlayerList(String playerName, Int32 realPlayerId, DatabaseFilter filter, Boolean useStrippedNames)
      2010-06-02 19:15:17,890 - 1236687 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:17,968 - 1236765 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:18,046 - 1236843 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:18,125 - 1236921 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:18,203 - 1237000 [1] ERROR PBNLogger:
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42601: syntax error at or near "t"
      - Severity: ERROR
      - Code: 42601
      - BaseMessage: syntax error at or near "t"
      - Detail:
      - Hint:
      - Position: 911
      - Where:
      - File: scan.l
      - Line: 807
      - Routine: base_yyerror
      - ErrorSql: SELECT MAX(t.small_bet), t.big_bet, MAX(t.limit_type), SUM(pc.num_games)::integer, SUM(pc.seen_flop), SUM(pc.fa_pf_bet), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_raise ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN subject_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='SB' THEN folded_to_steal ELSE 0 END), SUM(CASE WHEN pc.position='BB' THEN folded_to_steal ELSE 0 END), SUM(pc.af_br_total), SUM(pc.af_ca_total), SUM(pc.seen_showdown), SUM(pc.winner), SUM(pc.rake_part), SUM(pc.amount_won), MAX(t.small_blind), MAX(t.big_blind), SUM(pc.won_sd), SUM(CASE WHEN pc.position='CO' OR pc.position='BU' THEN pc.first_in_poss ELSE 0 END), SUM(pc.won_flop), SUM(pc.vpip), SUM(pc.fa_pf_call + pc.fa_pf_bet + pc.fa_pf_fold) FROM gametype t, playercache pc WHERE t.game_type_ID=pc.game_type_ID AND t.currency='USD' AND pc.AND t.limit_type IN('NL','PL') GROUP BY t.limit_type, t.big_bet ORDER BY t.limit_type, t.big_bet DESC
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      bei Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      bei Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      bei Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      bei Npgsql.ForwardsOnlyDataReader.NextResult()
      bei Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      bei Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      bei Npgsql.NpgsqlCommand.ExecuteReader()
      bei PBN.Database.PostgreSQL.ExecuteQuery(String in_sQuery)
      2010-06-02 19:15:18,281 - 1237078 [1] ERROR PBNLogger: MainQuery.GetGameLevelLinesFromCache exception caught!
      -------------------- System.NullReferenceException --------------------
      - Message: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean GetGameLevelLinesFromCache(System.String, PokerStrategyElephant.DatabaseFilter, System.Collections.Generic.List`1[PokerStrategyElephant.GameLevelLine] ByRef, Int32)
      - HelpLink: <null>
      - Source: Elephant
      - InnerException: <null><none>
      - StackTrace:
      bei PokerStrategyElephant.Database.MainQuery.GetGameLevelLinesFromCache(String playerName, DatabaseFilter filter, List`1& lines, Int32 realPlayerId)
      2010-06-02 19:15:26,859 - 1245656 [6] ERROR PBNLogger: Exception caught in System.String PokerStrategyElephant.RSSUpdateThread.GetRSSFeed(System.String, Boolean)
      -------------------- System.Xml.XmlException --------------------
      - Message: Das Stammelement ist nicht vorhanden.
      - LineNumber: 0
      - LinePosition: 0
      - SourceUri:
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void Throw(System.Exception)
      - HelpLink: <null>
      - Source: System.Xml
      - InnerException: <null><none>
      - StackTrace:
      bei System.Xml.XmlTextReaderImpl.Throw(Exception e)
      bei System.Xml.XmlTextReaderImpl.ThrowWithoutLineInfo(String res)
      bei System.Xml.XmlTextReaderImpl.ParseDocumentContent()
      bei System.Xml.XmlTextReaderImpl.Read()
      bei System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
      bei System.Xml.XmlDocument.Load(XmlReader reader)
      bei System.Xml.XmlDocument.LoadXml(String xml)
      bei PokerStrategyElephant.RSSUpdateThread.GetRSSFeed(String rssURL, Boolean showShortBlog
  • 9 Antworten