[Dolibarr-dev] erreur cvs

[mwolff]

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