Bonjour, Je vous ennuie encore avec les pb de mise à jour. Ci-joint les messages :
Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = concat('A0',box_order) where length(box_order) = 1 and substr(box_order,-1) in ('1','3','5','7','9'); 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 '(box_order,-1) in ('1','3','5','7','9')' at line 1 Request 657 sql='update llx_boxes set box_order = concat('B0',box_order) where length(box_order) = 1 and substr(box_order,-1) in ('0','2','4','6','8');' Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = concat('B0',box_order) where length(box_order) = 1 and substr(box_order,-1) in ('0','2','4','6','8'); 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 '(box_order,-1) in ('0','2','4','6','8')' at line 1 Request 658 sql='update llx_boxes set box_order = concat('A',box_order) where length(box_order) = 2 and substr(box_order,-1) in ('1','3','5','7','9');' Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = concat('A',box_order) where length(box_order) = 2 and substr(box_order,-1) in ('1','3','5','7','9'); 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 '(box_order,-1) in ('1','3','5','7','9')' at line 1 Request 659 sql='update llx_boxes set box_order = concat('B',box_order) where length(box_order) = 2 and substr(box_order,-1) in ('0','2','4','6','8');' Erreur DB_ERROR_SYNTAX: update llx_boxes set box_order = concat('B',box_order) where length(box_order) = 2 and substr(box_order,-1) in ('0','2','4','6','8'); 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 '(box_order,-1) in ('0','2','4','6','8')' at line 1
Exécution du script Ci-joint ma config : MySQL 4.0.24_Debian-10sarge2 Cordialement, Mathias _______________________________________________ Dolibarr-dev mailing list [email protected] http://lists.nongnu.org/mailman/listinfo/dolibarr-dev
