[Webkit-unassigned] [Bug 9854] New: error interfacing with website's SQL

[bugzilla-daemon at opendarwin.org]

http://bugzilla.opendarwin.org/show_bug.cgi?id=9854

           Summary: error interfacing with website's SQL
           Product: WebKit
           Version: 420+ (nightly)
          Platform: Macintosh
               URL: http://notmuch.com/Quiz/
        OS/Version: Mac OS X 10.4
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: New Bugs
        AssignedTo: webkit-unassigned at opendarwin.org
        ReportedBy: emark2k at yahoo.com


* note: the URL above is to register to get to the quiz page for Public Radio
International's "Whad'Ya Know?" Online Quiz Questions .

To get to the page where the problem exists requires registration (an email and
a nickname only) then you will get to the quiz at
URL:  http://notmuch.com/Tools/quiz.pl?user_id=XXXXX       (the XXXX is your
unique user id - and unfortunately, there is only one question to answer per
day, so I set up multiple accounts to try with multiple browsers to interact on
same day...will make sense when you get there - really easy).

OK, the bug:  after answering a quiz question the page refreshes once and says
your answer is received (this works in Safari / Webkit).  Then, the site is
supposed to automatically refresh and go back to the quiz questions to show
your answer as correct and incorrect, and your stats for the week.  This is
when Safari/Webkit fail.  The error message is:

Submission Failed
Submission failed for the following reason(s):
You have an error in your SQL syntax near '"' at line 1
Query: SELECT username, username_formatted, id, email FROM users WHERE id =
XXXXX"
Hit the 'back' button and try your submission again, making changes if
necessary.


Firefox 1.5.0.4 and IE 5.23 both seem to navigate the site and return one to
the appropriate page.  My first response was to write the webmaster and the
response was  "it doesn't happen on my machine..."


-- 
Configure bugmail: http://bugzilla.opendarwin.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.