Referral sources SQL error

[dealbyethan.com]

Hi,

I have recently found out that I have a sql error in the referral sources page in my admin. Does anyone know how this happened?

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's web site' order by ci.customers_info_id DESC' at line 1
in:
[select ci.customers_info_id, ci.customers_info_date_account_created from zen_customers_info ci, zen_sources_other so where so.customers_id = ci.customers_info_id and so.sources_other_name = 'Spy's web site' order by ci.customers_info_id DESC]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Please help. Thanks in advance :)

[DrByte]

You've added a single-quote mark in one of your referral sources: "Spy's web site".
Clearly that mod doesn't properly protect against that.
So, you have 2 options:
- don't use single-quotes (this is the fastest and simplest)
- rewrite the code to support single-quotes

[dealbyethan.com]

Thank you DrByte. I deleted the single quote in phpmyadmin and the error went away.