penguin8r wrote on Friday, November 21, 2008:
There seems to be a problem with CAMOS on newer versions of MySQL. Or rather, there’s a problem with the newer versions of MySQL that affects CAMOS in a negative way. If you try to submit text in a CAMOS form that contains an apostrophe, then you get an SQL insert error. apparently something isn’t escaping the ’ in text & it’s trying to interpret it as part of the command instead of part of the text. I was checking this on 2 separate systems, both are version 2.9.0, one works fine with MySQL version 5.0.45, the other system is running MySQL version 5.0.51, & it keeps throwing up the errors. Is there any quick way to fix this in the CAMOS code or do I just need to avoid newer versions of MySQL for now?