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

Hi Nils, Done. Bug 2069 Submitted Bug 2069 has been added to the database Email sent to: bb@otrs.com 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/