CAMOS question vs. MySQL

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?

markleeds wrote on Saturday, November 22, 2008:

Thanks.  I’ll take a look this weekend and see what happened.