jeff_ross wrote on Thursday, April 24, 2008:
We got this yesterday and it continues to display in the notes field.
Fault: Code: 5 Reason ‘Didn’t receive 200 OK from remote server. (HTTP/1.1
405 Method Not Allowed)’
I don’t see anything in the access or error logs for apache, though. How can I clear it from the notes pane? I don’t think it is actually in the notes–at least I can’t find it in the pnotes table.
Possibly related (although I’m not sure of the sequence of events because I wasn’t there) was a db error
insert failed: INSERT INTO form_physical_exam (forms_id, line_id, wnl, abn, diagnosis, comments) VALUES ( ‘207’, ‘TRTRET’, ‘1’, ‘0’, ", ‘1 month patient to call in B/P’s over the next few weeks.’) (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’s over the next few weeks.’ ) ’ at line 1)
To my eye (which is way more used to PostgreSQL than mysql this is a simple escaping problem. When I browse through the sql functions though, I don’t see any call to the adodb escaping functions.
I’m sure they must be somewhere, though, or this error would be popping up every time someone used an apostrophe in a comment.
Thanks,
Jeff