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/