
Hi! I've now upgraded our customer's OTRS/Oracle installation to 1.3.2. This reduced the number of patches needed quite a bit, although we're not done testing it yet. I've attached the patches I needed (apart from the obviously site-specific ones, like stylesheets and 'use lib'). The updated schema file is also attached. Note that I've made CLOBs of the fields having the datatype TEXT in PostgreSQL. Since the "=" operator doesn't like CLOBs, the patch below changes "=" to "LIKE" in some string comparison statements. I think that should work just as well as "=" on all databases. The patches I've currently applied to my installation: The only other gotcha I can think of is that the session database shouldn't be called "session". The schema calls it "sessions", but this must be reflected in Kernel/Config.pm. Also, is this the right place to ask about the "commercial support" list on http://otrs.org/support/? The company I work for (Linpro AS, www.linpro.no) has customized and supported OTRS for several customers, and would appreciate being mentioned in this list. :) Regards, -- Kristoffer.