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