If the question or the answer has an apostrophe in it such as question: "My cat's name" then the apostrophe is escaped when inserting into the DB.
However, the \ to escape is not removed when the value is pulled back into the edit form. If the user edits their information and doesn't remove the \ from the question: "My cat\'s name" they would then see this in the DB: "My cat\\\'s name"
The apostrophe should be dealt with correctly coming out of the DB as well as going in. Is this an issue in PSA or in Metabase?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think it may have more to do with the magic_quotes_gpc settings. I've run PSA with the Metabase package on this site for a while now and haven't come across these types of problems. I've used it on a variety of servers that all had different settings for magic_quotes as well.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If the question or the answer has an apostrophe in it such as question: "My cat's name" then the apostrophe is escaped when inserting into the DB.
However, the \ to escape is not removed when the value is pulled back into the edit form. If the user edits their information and doesn't remove the \ from the question: "My cat\'s name" they would then see this in the DB: "My cat\\\'s name"
The apostrophe should be dealt with correctly coming out of the DB as well as going in. Is this an issue in PSA or in Metabase?
I think it may have more to do with the magic_quotes_gpc settings. I've run PSA with the Metabase package on this site for a while now and haven't come across these types of problems. I've used it on a variety of servers that all had different settings for magic_quotes as well.