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$$