Support Forums

We encourage an open exchange of information. Ask your questions or make suggestions. We are here to help, but we also encourage all of you to help one another.
Click on the Subscribe Flag to be notified by email of replies to your post.
Current User: Guest Login Register
Please consider registering

Blank response and strange mysql error?

Add a New Topic Reply to Post
UserPost

5:09
August 27, 2008


steinhardt.webmaster

Member

posts 21

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?

7:52
August 27, 2008


Mario

Moderator

Boulder, CO

posts 607

I'd have to bump this up to our lead developer. It's not unimaginable that there was a hiccup, but I'll have to dig a bit deeper.

11:33
August 28, 2008


Chad

Moderator

posts 754

Hi Steinhardt,

Would you mind sending us the full version of the email to support[at]sgizmo.com?  Also any further information like the exact date and time your admin received the email would be really helpful.

Thanks,

Chad

12:26
August 28, 2008


steinhardt.webmaster

Member

posts 21

Done!  The full e-mail was just forwarded to you guys with a timestamp.  Thanks for checking into this!

10:17
August 29, 2008


Christian Vanek

Moderator

Cambridge, MA

posts 788

Hi just an update!

This is definitely one of the most puzzling questions I have received.   I have narrowed down the search and should have the response restored by the end of the day.

Cheers,

-Christian

11:27
August 29, 2008


Chad

Moderator

posts 754

Hi,

The response is back.  We reprocessed the response and it's visible in your account now.

We think this might have been due to a brief server outage, when our provider took the system down to replace some memory, without properly scheduling with us.

The responsible parties have been flogged and we've been assured this will not happen again.

Hope this helps,

Chad

Add a New Topic Reply to Post


Reply to Topic: Blank response and strange mysql error?

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 2 + 8        (Required)

Topic Reply:


 
© Simple:Press Forum - Version 3.1.4 (Build 357)