New Zenner
- Join Date:
- Oct 2007
- Posts:
- 52
- Plugin Contributions:
- 0
How Did You Hear About Us? Apostrophe in Other
I have other referrals set up and that is what my customers mostly use so I can track magazines, tv etc. Whenever anyone enters a word with an apostrophe in it like Scruffy's, I get the following error code and I have to go into the database and remove the apostrophe so that the module will show the rest of the referrals for that page. Has anyone been able to fix this bug?
> 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' order by ci.customers_info_id DESC' at line 1
in:
[select ci.customers_info_id, ci.customers_info_date_account_created from customers_info ci, sources_other so where so.customers_id = ci.customers_info_id and so.sources_other_name = 'Scruffy's' 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.