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
_______________________________________________ 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/
