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.
PGP.sig
Description: Dit deel van het bericht is digitaal ondertekend
_______________________________________________ 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/
