Hi Nils,

Done.


Bug 2069 Submitted
Bug 2069 has been added to the database

Email sent to: [EMAIL PROTECTED]

Thanks for your reply.



Le mardi 17 juillet 2007 à 14:34 +0200, Nils Breunese (Lemonbit) a
écrit :

> Laurent Minost wrote:
> 
> > Just done a debug test with mysql request log activated, we can see  
> > that there is a malformed syntax on the SQL Query sent by OTRS  
> > 2.2.1 when changing CustomerID of Customer Company :
> >
> > UPDATE customer_company SET  customer_id = 'Google',  name =  
> > 'Google',  street = '3 allée machin',  zip = '75020',  city =  
> > 'Paris',  country = 'United States',  url = 'http:// 
> > www.google.fr',  comments = 'Commentaire',  valid_id = 1,   
> > change_time = current_timestamp,  change_by = 1  WHERE LOWER 
> > (customer_id) = LOWER('Google')
> >
> > Value of customer_id in clause WHERE should NOT be the NEW one but  
> > the OLD customer ID.
> 
> Please file a bug report at http://bugs.otrs.org/
> 
> Nils Breunese.
> _______________________________________________
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
> Support or consulting for your OTRS system?
> => http://www.otrs.com/
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/

Reply via email to