Hallo, team! I encountered another strange error. I'm referring to this survey:
https://app.sgizmo.com/surveybuilder/survey_response_view.php?id=21386
That survey is set up to send an e-mail on the thank you page. The e-mail goes to one of our local administrators who has a user account. On Tuesday, August 24th, she received an e-mail that looked like a response. Here's the beginning of that e-mail (which is relevant later):
PAGE 2 QUESTIONS:
2-a. Name of intern
XXX Cherian
2-b. Name of agency
XXX
2-c. Agency Address
XXX
2-d. Agency Preceptor
XXX Vaughan
(Certain fields X'd out to protect the innocent)
She then logged into the Giz to take a look at the full response. But when she looked at the overview page, the response was not there. So she wrote to me asking what was up.
So I logged in and looked at the survey responses. Sure enough, I didn't see any response that matched. So I did a quick search for “Cherian” in the responses.
The search yielded 1 result, but “Cherian” wasn't actually in the record anywhere. In fact, it seemed to be totally blank. I clicked on the response to get a closer look.
Now here is where things get very strange. The first thing I saw was the the URL for the response looked like this:
survey_response_view.php?id=21386&rid=
That's not a typo. There was no string after the rid= variable. Getting into the details of the response yielded showed a totally blank survey and, at the bottom, under the “Action Log: Email to Administrators”, I saw the following error message:
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 'and
iQuestionSKU = 68' at line 1
Any ideas?