v.054 Debug Fehler

    • Pris0n
      Pris0n
      Bronze
      Dabei seit: 15.07.2007 Beiträge: 8.603
      Hi,
      hab mir grad nie neue Version runtergeladen.
      Dann das erste was ich gemacht habe ist die alte Db zu löschen und ne neue Aufgemacht, um Fehler zu vermeiden...

      Hab dann allerdings keine Lust gehabt das ganze zu testen, sondern hab dann nur den Elephant geschlossen.

      Und schwups hatte ich folgende Fehlermeldung:


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

      Software version: 0.54

      (10) Log: 18:13:33.68 -- Logfile set: C:\Dokumente und Einstellungen\Tobias\Lokale Einstellungen\Anwendungsdaten\PokerStrategy\Elephant\log.txt
      (10) Log: 18:13:33.68 -- Logfile cleared: C:\Dokumente und Einstellungen\Tobias\Lokale Einstellungen\Anwendungsdaten\PokerStrategy\Elephant\log.txt
      (10) Log: 18:14:45.40 -- CREATE or REPLACE FUNCTION update_unreviewed_count_delete () RETURNS trigger AS $BODY$ DECLARE gplayer RECORD; BEGIN IF OLD.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=OLD.game_id AND site_id=OLD.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed -1 WHERE dateonly=''' || OLD.dateonly || ''' AND game_type_id=' || OLD.game_type_id || ' AND site_id=' || OLD.site_id || ' AND num_players=' || OLD.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; RETURN OLD; END; $BODY$ LANGUAGE 'plpgsql';
      (10) Log: 18:14:45.54 -- , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:45.64 -- CREATE or REPLACE FUNCTION update_unreviewed_count_insert () RETURNS trigger AS $BODY$ DECLARE gplayer RECORD; BEGIN IF NEW.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=NEW.game_id AND site_id=NEW.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed +1 WHERE dateonly=''' || NEW.dateonly || ''' AND game_type_id=' || NEW.game_type_id || ' AND site_id=' || NEW.site_id || ' AND num_players=' || NEW.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql';
      (10) Log: 18:14:45.64 -- , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:45.71 -- CREATE or REPLACE FUNCTION update_unreviewed_count_update () RETURNS trigger AS $BODY$ DECLARE gplayer RECORD; BEGIN IF NEW.marked<>OLD.marked THEN IF OLD.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=OLD.game_id AND site_id=OLD.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed -1 WHERE dateonly=''' || OLD.dateonly || ''' AND game_type_id=' || OLD.game_type_id || ' AND site_id=' || OLD.site_id || ' AND num_players=' || OLD.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; IF NEW.marked=999 THEN FOR gplayer IN SELECT * FROM gameplayer WHERE game_id=OLD.game_id AND site_id=OLD.site_id LOOP EXECUTE 'UPDATE playercache SET num_unreviewed = num_unreviewed +1 WHERE dateonly=''' || OLD.dateonly || ''' AND game_type_id=' || OLD.game_type_id || ' AND site_id=' || OLD.site_id || ' AND num_players=' || OLD.num_players || ' AND player_id=' || gplayer.player_id; END LOOP; END IF; END IF; RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql';
      (10) Log: 18:14:45.71 -- , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:45.79 -- CREATE or REPLACE FUNCTION insert_or_replace_playercache() RETURNS trigger AS $BODY$ BEGIN DELETE FROM playercache WHERE playercache.player_id = new.player_id AND playercache.site_id = new.site_id AND playercache.num_players = new.num_players AND playercache.game_type_id = new.game_type_id AND playercache.dateonly = new.dateonly; RETURN NEW; END; $BODY$ LANGUAGE 'plpgsql';
      (10) Log: 18:14:45.79 -- , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:45.87 -- ALTER FUNCTION update_unreviewed_count_delete() OWNER TO "Poker";
      (10) Log: 18:14:45.87 -- , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_delete() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_delete() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:45.95 -- ALTER FUNCTION update_unreviewed_count_insert() OWNER TO "Poker";
      (10) Log: 18:14:45.95 -- , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_insert() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_insert() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.03 -- ALTER FUNCTION update_unreviewed_count_update() OWNER TO "Poker";
      (10) Log: 18:14:46.03 -- , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_update() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_update() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.10 -- ALTER FUNCTION insert_or_replace_playercache() OWNER TO "Poker";
      (10) Log: 18:14:46.10 -- , line 0: Npgsql.NpgsqlException:
      function insert_or_replace_playercache() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function insert_or_replace_playercache() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.18 -- CREATE TRIGGER unreviewed_delete AFTER DELETE ON game FOR EACH ROW EXECUTE PROCEDURE update_unreviewed_count_delete();
      (10) Log: 18:14:46.18 -- , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_delete() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_delete() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.26 -- CREATE TRIGGER unreviewed_insert AFTER INSERT ON game FOR EACH ROW EXECUTE PROCEDURE update_unreviewed_count_insert();
      (10) Log: 18:14:46.26 -- , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_insert() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_insert() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.34 -- CREATE TRIGGER unreviewed_update AFTER UPDATE ON game FOR EACH ROW EXECUTE PROCEDURE update_unreviewed_count_update();
      (10) Log: 18:14:46.34 -- , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_update() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function update_unreviewed_count_update() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.42 -- CREATE TRIGGER insert_into_playercache BEFORE INSERT ON playercache FOR EACH ROW EXECUTE PROCEDURE insert_or_replace_playercache();
      (10) Log: 18:14:46.42 -- , line 0: Npgsql.NpgsqlException:
      function insert_or_replace_playercache() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function insert_or_replace_playercache() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.50 -- CREATE or REPLACE FUNCTION deflag_archive() RETURNS trigger AS $BODY$ BEGIN EXECUTE 'DELETE FROM triggstop'; IF NEW.actiontype='imported' THEN EXECUTE 'UPDATE archive SET imported=''true'' WHERE imported=''false'''; RETURN OLD; ELSE RETURN NEW; END IF; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE;
      (10) Log: 18:14:46.50 -- , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      language "plpgsql" does not exist
      Severity: ERROR
      Code: 42704
      Hint: Use CREATE LANGUAGE to load the language into the database.
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) Log: 18:14:46.68 -- CREATE TRIGGER deflag_archive BEFORE INSERT ON triggstop FOR EACH ROW EXECUTE PROCEDURE deflag_archive();
      (10) Log: 18:14:46.68 -- , line 0: Npgsql.NpgsqlException:
      function deflag_archive() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
      (10) , line 0: Npgsql.NpgsqlException:
      function deflag_archive() does not exist
      Severity: ERROR
      Code: 42883
      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.ExecuteNonQuery()
      bei PBN.Database.PostgreSQL.ExecuteNonQuery(String in_sQueryString)
  • 1 Antwort