Quote Originally Posted by mc12345678 View Post
Yeah, took a second tofigure out, but look at the last character of your page description field that is just before the host ip address. Looks like this: 'Discovery and Exploration##-##Educational Insights You\', well, the \ just before the single parenthesis is an escape code sequence, telling SQL to treat the ' as a character in the string rather than the end of a string. So the next ' becomes the end, the OFFICE_IP_TO_HOST_ADDRESS is becomes a misplaced statement and then finally the last ' is treated as the opening to a new string that is not properly finalized which causes the error you are seeing. I think that if you were to visit thatpage yourself, you would cause the same issue, it just happens that someone/something got there first.

Btw, that is an example also of what I was saying of identifying a malformed SQL statement, doing something about it, and letting the operator know it happened and hopefully in a way that would be unique to UT.

Basically the page description for that product should not end with a backwards slash. Not sure why it would, to begin with...
Thank you so much for looking into this. I think the problem is with the Zen Lightbox on our site. If you look at this page: http://www.clevershoppers.com//index...ducts_id=13478 you will notice the garbage on top of the product image. If I turn off Zen Lightbox the problem is not there. As you suggested I went to the actual product page: http://www.clevershoppers.com/index....ducts_id=13478 and I did not see any problem with the description when I view it normally as well as looking at the source. I will try to solve the Zen Lightbox issue first and then see if I see more errors in the log.