SQL error in Referral Sources addon

[eaddesigns]

its the "How did you hear about us" from the downloads.
I was unable to find anything with the same error

[kobra]

Did you just install it recently(read the last mod installed)?

Did you make a backup of your DB before you did this so that you might have a fall back position?

[eaddesigns]

i have had this installed from the start. I do have a back up i just wasnt sure what has caused this .

[kobra]

i have had this installed from the start

So is this a new development? or has this always been this way?

If new, what else has changed?
Server, phpver, mysql ver, upgrade of Zen Cart?

[eaddesigns]

I havent changed anything.
I have been using this mod for about a year.

[kobra]

Is this error new?

Has your host changed anything?

[DrByte]

This appears to be a bug in the addon, whereby it's not built to properly handle accepting of apostrophes when someone keys in a response to the "other" field. It's likely that you've not had the problem earlier because perhaps nobody has tried using apostrophes earlier?
To fix, you'll have to alter the code to properly handle apostrophes.

[eaddesigns]

this is a new error and my host has not changed anything.


How would i go about altering the code to properly handle apostrophes