Symptome : Au moment de valider la commande fournisseur / choix de l’entrepot, retour sur une page blanche.
Impossible de valider la commande.
Bonjour !
Je suis bloqué au niveau validation de commande fournisseur. J’ai vu un bug signalé a propos de la longueur des champs mais a priori réglé donc ou trouver la mention de l’erreur (activer un mode debug ?) pour plus d’info ?
La commande inclut 1 produit et 2 services (livraison), y a t il un problème possible a ce niveau, sur l’intitulé de la référence fournisseur ? (espaces, caracteres spéciaux, etc ?)
Je remonte le sujet car impossible de finaliser la moindre commande fournisseur avec toujours la même erreur et il m’est impossible d’interpréter cette erreur…
Une piste SVP ?
Pareil en 10.0.2 et 10.0.3 maj à l’instant
Voila le log de l’opération :
2019-11-02 11:00:24 ERR 196.121.133.103 DoliDBMysqli::close Closing a connection with an opened transaction depth=1
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error query: DROP PROCEDURE IF EXISTS societe_address_email;
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error message: DB_ERROR_1192 Can’t execute the given command because you have active locked tables or an active transaction
2019-11-02 11:01:09 ERR 196.121.133.103 Admin.lib::run_sql Request 4 Error DB_ERROR_1192 DROP PROCEDURE IF EXISTS societe_address_email;<br>Can’t execute the given command because you have active locked tables or an active transaction
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error query: DELIMITER //CREATE PROCEDURE societe_address_email()BEGINDECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error message: DB_ERROR_SYNTAX You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‹ DELIMITER //CREATE PROCEDURE societe_address_email()BEGINDECLARE CONTINUE HAND › at line 1
2019-11-02 11:01:09 ERR 196.121.133.103 Admin.lib::run_sql Request 5 Error DB_ERROR_SYNTAX DELIMITER //CREATE PROCEDURE societe_address_email()BEGINDECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‹ DELIMITER //CREATE PROCEDURE societe_address_email()BEGINDECLARE CONTINUE HAND › at line 1
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error query: ALTER TABLE llx_societe_address ADD COLUMN email varchar(128) NULL DEFAULT NULL;
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error message: DB_ERROR_COLUMN_ALREADY_EXISTS Duplicate column name ‹ email ›
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error query: ALTER TABLE llx_societe_address ADD COLUMN url varchar(255) NULL DEFAULT NULL;
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error message: DB_ERROR_COLUMN_ALREADY_EXISTS Duplicate column name ‹ url ›
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error query: END //DELIMITER ;
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error message: DB_ERROR_SYNTAX You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‹ END //DELIMITER › at line 1
2019-11-02 11:01:09 ERR 196.121.133.103 Admin.lib::run_sql Request 8 Error DB_ERROR_SYNTAX END //DELIMITER ;<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‹ END //DELIMITER › at line 1
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error query: CALL societe_address_email();
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error message: DB_ERROR_1305 PROCEDURE digistor_maeeve.societe_address_email does not exist
2019-11-02 11:01:09 ERR 196.121.133.103 Admin.lib::run_sql Request 9 Error DB_ERROR_1305 CALL societe_address_email();<br>PROCEDURE digistor_maeeve.societe_address_email does not exist
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error query: DROP PROCEDURE societe_address_email;
2019-11-02 11:01:09 ERR 196.121.133.103 DoliDBMysqli::query SQL Error message: DB_ERROR_1192 Can’t execute the given command because you have active locked tables or an active transaction
2019-11-02 11:01:09 ERR 196.121.133.103 Admin.lib::run_sql Request 10 Error DB_ERROR_1192 DROP PROCEDURE societe_address_email;<br>Can’t execute the given command because you have active locked tables or an active transaction