Hi,

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.

Laurent


Le mardi 17 juillet 2007 à 09:53 +0200, Laurent Minost a écrit :
Hi everyone,

Anyone here tried or suceed to reproduce this problem on his installation of OTRS please ?

I would be glad to get an answer so I can open a bug on OTRS Bugzilla if it's really necessary. ( Nothing at the moment on existing bugs is linked with this problem)

Thanks.

Laurent


Le lundi 16 juillet 2007 à 16:00 +0200, Laurent Minost a écrit : 
Hi,

Could anyone here confirm me that under OTRS 2.2.1 installed using MySQL
as a backend database, if we modify CustomerID on an already existing
Customer Company from Customer Company Management panel then submit :
got a successful Updated reply but no modifications is done ?


Thanks for you answer.


Laurent