Français informations lecteur UID

[Cobra]

bonjour , j'ai un petit problème avec " Envoi de la requête au serveur pour obtenir des informations lecteur UID" suite a la connexion aux server ? ça vient dout ? de la basse de donnée ?

aussi je voudrais savoir ci on peut supprime ça ?

pour information j'ai Altis life 5.0 et extDB3

 

[Maxence]

Hello! Est-ce que tu peux partager tes logs serveur et extDB ?

 

[Cobra]

regarde le log ???

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.033
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

Message: This version was modified and include some improvement
Message: The lib was recompiled using new version of TBBMalloc, Boost and MariaDB connector
Message: The worker threads limitation was removed
Message: Steez: 30/10/2020


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


[21:23:21:985065 +01:00] [Thread 1088] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[21:23:21:985137 +01:00] [Thread 1088] extDB3: SQL: Initialized: NULL = ""
[21:23:21:985182 +01:00] [Thread 1088] extDB3: Locked
[21:23:22:032248 +01:00] [Thread 6444] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.deleteDeadVehicles does not exist
[21:23:22:032271 +01:00] [Thread 1192] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.deleteOldHouses does not exist
[21:23:22:032238 +01:00] [Thread 9296] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.resetLifeVehicles does not exist
[21:23:22:032239 +01:00] [Thread 2556] extDB3: SQL: Error MariaDBQueryException: PROCEDURE altislife.deleteOldGangs does not exist
[21:23:22:032327 +01:00] [Thread 1192] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldHouses
[21:23:22:032392 +01:00] [Thread 6444] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteDeadVehicles
[21:23:22:032438 +01:00] [Thread 9296] extDB3: SQL: Error MariaDBQueryException: Input: CALL resetLifeVehicles
[21:23:22:032453 +01:00] [Thread 2556] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldGangs

 

[MrAnciens]

Hello, j'espère que tu vas bien

Je vois que dans t'es logs db tu as un souci avec les procedure ...
Essaie d'executer dans ta db les procedure d'altis-life framework (BASE)

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`;

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

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

DELIMITER ;

Dit moi si maintenant ça fonctionne

 

[Cobra]

Hello! Est-ce que tu peux partager tes logs serveur et extDB ?

Hello! Est-ce que tu peux partager tes logs serveur et extDB ?

Hello, j'espère que tu vas bien

Je vois que dans t'es logs db tu as un souci avec les procedure ...
Essaie d'executer dans ta db les procedure d'altis-life framework (BASE)

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`;

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

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

DELIMITER ;

Dit moi si maintenant ça fonctionne

bonjour , oui je vais bien , avent tout merci de ta réponse . en faite j'ai du changer de version de MariaDB vue sais la couse du problème la nouvel version bug de trop donc j'ai mis une version plus récente et ça passe .

la version MariaDB 12 ne peut pas lire la basse de donné suis utf8mb4
elle me disais de supprime toute les procédure ??? mais MariaDB 10 ça passe , mais ci tu à la version MariaDB 12 chez toi dit mois comme ta fait ??

merci a toi

 

[Davidovitch]

Hello

C'est ""normal"", la requête du Framework est assez vielle donc peut foirer en fonction de ta version de mariadb.

Tu es actuellement sur du MariaDB10 ? Pourquoi changer ?