Here's the kicker:
Just for fun, I took the same otrs installation, created a mysql database, changed a few config files to point otrs to the mysql database (instead of postgres) and magically all my problems I've been emailing this thread about disappeared!
The apostrophe issue can't be duplicated. The case sensitive search issue is fixed also now.
I made a few more changes and we have now switched to using mysql permanently.
Thanks for everyone's help here.
Carl Sheline
School of Dentistry
Loma Linda University
-----Original Message-----
From: otrs-bounces@otrs.org on behalf of Bryan Fullerton
Sent: Tue 7/5/2005 2:19 PM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] Using apostrophes in the subject causing problems
On 6/30/05, Jeremy Blain
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
This is the same as a bug I filed in May. http://bugs.otrs.org/show_bug.cgi?id=732 It also seems to be the same as this bug. http://bugs.otrs.org/show_bug.cgi?id=788 For what it's worth I haven't seen this bug recently, but I also haven't seen any email recently with apostrophes in the subject. Bryan _______________________________________________ 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 oder Consulting für Ihr OTRS System? =http://www.otrs.de/