• Hilfe mit datenbank

      servus Leute, ich weiß nicht was ich tun soll bei der meldung,

      14:53:13:447000 +02:00] [Thread 5812] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2

      [14:53:13:447000 +02:00] [Thread 5812] extDB3: SQL: Initialized: NULL = ""

      [14:53:13:447000 +02:00] [Thread 5812] extDB3: Locked

      [14:53:13:452000 +02:00] [Thread 6536] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.resetLifeVehicles does not exist

      [14:53:13:452000 +02:00] [Thread 6484] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.deleteDeadVehicles does not exist

      [14:53:13:452000 +02:00] [Thread 6484] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteDeadVehicles

      [14:53:13:452000 +02:00] [Thread 6536] extDB3: SQL: Error MariaDBQueryException: Input: CALL resetLifeVehicles

      [14:53:13:452000 +02:00] [Thread 5304] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.deleteOldHouses does not exist

      [14:53:13:452000 +02:00] [Thread 5096] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.deleteOldGangs does not exist

      [14:53:13:452000 +02:00] [Thread 5304] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldHouses

      [14:53:13:452000 +02:00] [Thread 5096] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldGangs




      ich habe noch mal datenbank aufgespielt weiterhin der fehler

      wie füge ich die wieder ein ?

      -- Drop procedures to ensure no conflicts

      --

      DROP PROCEDURE IF EXISTS `resetLifeVehicles`;

      DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;

      DROP PROCEDURE IF EXISTS `deleteOldHouses`;

      DROP PROCEDURE IF EXISTS `deleteOldGangs`;

      DROP PROCEDURE IF EXISTS `deleteOldContainers`;

      DROP PROCEDURE IF EXISTS `deleteOldWanted`;

      is das nicht das was mit ausgeführt wird

      https://github.com/AsYetUntitled/…r/altislife.sql

      Wir haben es genau so gelöst

      Zitat von Krypton91

      und wie hast du es genau gelöst? wäre interessant für die leute die auch mal so ein Problem haben

      danke fürs melden, hab ich voll vergessen , danke schön

      Lösung

      SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

      SET time_zone = "+00:00";

      --

      -- Compatible with newer MySQL versions. (After MySQL-5.5)

      -- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.

      --


      /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

      /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

      /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

      /*!40101 SET NAMES utf8mb4 */;


      USE `altislife`;

      -- Name ändern falls deine DB anders heißt

      --

      -- Drop procedures to ensure no conflicts

      --

      DROP PROCEDURE IF EXISTS `resetLifeVehicles`;

      DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;

      DROP PROCEDURE IF EXISTS `deleteOldHouses`;

      DROP PROCEDURE IF EXISTS `deleteOldGangs`;

      DROP PROCEDURE IF EXISTS `deleteOldContainers`;

      DROP PROCEDURE IF EXISTS `deleteOldWanted`;

      --

      -- Procedures

      -- CURRENT_USER function returns the name of the current user in the SQL Server database.

      --

      DELIMITER $$

      CREATE DEFINER=CURRENT_USER PROCEDURE `resetLifeVehicles`()

      BEGIN

      UPDATE `vehicles` SET `active`= 0;

      END$$

      CREATE DEFINER=CURRENT_USER PROCEDURE `deleteDeadVehicles`()

      BEGIN

      DELETE FROM `vehicles` WHERE `alive` = 0;

      END$$

      CREATE DEFINER=CURRENT_USER PROCEDURE `deleteOldHouses`()

      BEGIN

      DELETE FROM `houses` WHERE `owned` = 0;

      END$$

      CREATE DEFINER=CURRENT_USER PROCEDURE `deleteOldGangs`()

      BEGIN

      DELETE FROM `gangs` WHERE `active` = 0;

      END$$

      CREATE DEFINER=CURRENT_USER PROCEDURE `deleteOldContainers`()

      BEGIN

      DELETE FROM `containers` WHERE `owned` = 0;

      END$$

      CREATE DEFINER=CURRENT_USER PROCEDURE `deleteOldWanted`()

      BEGIN

      DELETE FROM `wanted` WHERE `active` = 0;

      END$$