Hello Carl, On Thu, Jun 30, 2005 at 01:52:34PM -0700, Sheline, Carl (LLU) wrote:
I'm using Postgresql instead of mysql. Would this error have occurred using mysql? It shouldn't matter because sql is sql right?
ACK.
OTRS devs: is mysql the preferred database for otrs?
Because we use MySQL in all our standard installations, OTRS might support MySQ the best. If errors occure with MySQL, we'll see them faster then other DB errors.
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Jeremy Blain Sent: Thursday, June 30, 2005 12:18 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Using apostrophes in the subject causing problems
This sounds like an sql escaping issue, where placeholders or proper quoting should be used for all the data, but isn't correct. (this is potentially a security issue too)
I've filed a bug report about it http://bugs.otrs.org/show_bug.cgi?id=809
Thanks a lot! Best regards, Christian -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!