extDB3 Vlt. Error

HelperLee

Hey NN Community,

Ich kriege diese Errors in meinen Logs:

Code

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.026
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 18/05/15


extDB3: Found extdb3-conf.ini
extDB3: Detected 4 Cores, Setting up 4 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[09:42:53:592817 +01:00] [Thread 7236] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[09:42:53:593146 +01:00] [Thread 7236] extDB3: SQL: Initialized: NULL = ""
[09:42:53:593205 +01:00] [Thread 7236] extDB3: Locked
[09:42:53:668282 +01:00] [Thread 6416] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist
[09:42:53:668290 +01:00] [Thread 2480] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist
[09:42:53:668356 +01:00] [Thread 6416] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteDeadVehicles
[09:42:53:668373 +01:00] [Thread 2480] extDB3: SQL: Error MariaDBQueryException: Input: CALL resetLifeVehicles
[09:42:53:668542 +01:00] [Thread 6212] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist
[09:42:53:668549 +01:00] [Thread 5752] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist
[09:42:53:668567 +01:00] [Thread 6212] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldGangs
[09:42:53:668593 +01:00] [Thread 5752] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldHouses

Alles anzeigen

Ich weis echt nicht was er mit MariaDB will weil ich ja MySQL habe ?

Hoffe ihr könnt mir helfen.

moeck

Moin,

bitte öffne deine Altis.sql Datei und ändere dort bitte folgenden String arma3'@'localhost. Statt arma3 musst Du dort deinen DB User eintragen. Anschliessend die DB löschen und das Script neu einspielen! Damit hat sich der Fehler erledigt ;-).

Gruß,

moeck

HelperLee

Werde ich gleich nach der Schule ausprobieren Danke !

moeck

Falls Du die DB nicht neumachen möchtest, bitte den folgenden Code ändern und ausführen in NaviCat, phpmyadmin, ...

USER einfach durch deinen DB User ersetzen.

SQL

DELIMITER $$
--
-- Procedures
-- Edit USER to match a user in MySQL
-- For external databases: Edit localhost to match USERserver IP
--

CREATE DEFINER=`USER`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
 UPDATE `vehicles` SET `active`= 0;
END$$

CREATE DEFINER=`USER`@`localhost` PROCEDURE `deleteDeadVehicles`()
BEGIN
 DELETE FROM `vehicles` WHERE `alive` = 0;
END$$

CREATE DEFINER=`USER`@`localhost` PROCEDURE `deleteOldHouses`()
BEGIN
 DELETE FROM `houses` WHERE `owned` = 0;
END$$

CREATE DEFINER=`USER`@`localhost` PROCEDURE `deleteOldGangs`()
BEGIN
 DELETE FROM `gangs` WHERE `active` = 0;
END$$

CREATE DEFINER=`USER`@`localhost` PROCEDURE `deleteOldContainers`()
BEGIN
 DELETE FROM `containers` WHERE `owned` = 0;
END$$

CREATE DEFINER=`USER`@`localhost` PROCEDURE `deleteOldWanted`()
BEGIN
 DELETE FROM `wanted` WHERE `active` = 0;
END$$

DELIMITER ;

Alles anzeigen

Gruß,

moeck

extDB3 Vlt. Error

Ähnliche Themen

[Tutorial] Permanenter Personalausweis/Dienstausweis - (V1+V2)

Sammelfragen zu Problemen

Fahrzeuge nicht in der garage