Re: [Dolibarr-dev] erreur cvs

[Régis Houssin]

On Sun, 12 Aug 2007 15:40:59 -0500, Yannick Warnier <address@hidden>
wrote:
> Je pense que avant 4.1 SUBSTRING() existait, mais par contre il
> n'acceptait apparemment pas le second paramètre en négatif.
> 
>
http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_substring
>


j'ai renommé substr en substring
pourrais-tu refaire un essai de mise à jour stp ?

Régis


 
> Yannick
> 
> 
> Le dimanche 12 août 2007 à 21:43 +0200, Régis Houssin a écrit :
>> 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
> 
> 
> 
> _______________________________________________
> Dolibarr-dev mailing list
> address@hidden
> http://lists.nongnu.org/mailman/listinfo/dolibarr-dev
-- 
Cordialement
Houssin Régis