Re: [Dolibarr-dev] erreur cvs

[Régis Houssin]

oui effectivement, apparement la fonction substr dans une requete mysql est
apparu à partir de la version 4.1 de mysql et tu utilises la 4.0

il faudrait trouver un substitut de cette commande

Régis



On Fri, 10 Aug 2007 17:22:30 +0200, address@hidden wrote:
> 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
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/dolibarr-dev
-- 
Cordialement
Houssin Régis