User tracking mod

[mc12345678]

Well, I resolved my original issue by using the fix provided via the Zen Lightbox thread. Now I am dealing with something else and perhaps it doesn't have anything to do with User Tracking but since it's the mod revealing the problem I am starting here. Here is the error message:
Here is the link http://www.clevershoppers.com/index....ducts_id=79860 to the product in question. You will notice in the title (Theo (Teaching Children God's Word) God's Love DVD 2011) there are two apostrophes. I believe the ' in the title is what's causing the problem. It would appear User Tracking is not properly escaping the single quote (') in the title before trying to post it to the database. Zen Cart seems to handle this just fine on the site but not sure how to deal with this issue.

So the field that is currently causing the problem is the page description (which I thought would be different than the page title, but I can look further into that). You are correct that UT doesn't (yet) filter the data to remove the converted ' (made into \' ) prior to posting to the UT table database. Typically I have seen that only the last_page_url or refferer_page_url would throw that type of error because of attempts by malicious visitors to inject SQL code. It looks like the review/change will need to include the characters of other fields as well, to include some form of substitution of the last character in the string as applicable.