[ php-blog-Bugs-1713602 ] xmlrpc plugin issues invalid query to postgres

Bugs item #1713602, was opened at 2007-05-05 19:01
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1713602&group_id=75065

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Plugins
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: John Goerzen (jgoerzen)
Assigned to: Nobody/Anonymous (nobody)
Summary: xmlrpc plugin issues invalid query to postgres

Initial Comment:
Hi,

I have been trying to make the xmlrpc plugin work.  I have tracked down the problem to the insert it is sending to PostgreSQL.  I turned on statement logging in postgresql and captured this from my log (pardon the linewrapping):

LOG:  statement: INSERT INTO serendipity_entries (title,body,extended,isdraft,al
low_comments,moderate_comments,timestamp,exflag,comments,last_modified,author,au
thorid) values ('Flickr', 'This is a test post from <a href="http://www.flickr.c
om/r/testpost"><img alt="flickr" src="http://www.flickr.com/images/flickr_logo_b
log.gif" width="41" height="18" border="0" align="absmiddle" /></a>, a fancy pho
to sharing thing.', '', 'false', '', '', '1178405575', '0', '0', '1178405575', '
', '1')
ERROR:  invalid input syntax for type boolean: ""


This is s9y 1.1.2, serendipity_event_xmlrpc.php 1.24, serendipity_xmlrpc.inc.php 1.15.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1713602&group_id=75065

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/