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

Bugs item #1713602, was opened at 2007-05-05 23:01
Message generated for change (Comment added) made by garvinhicking
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: Closed
>Resolution: Fixed
>Priority: 1
Private: No
Submitted By: John Goerzen (jgoerzen)
>Assigned to: Garvin Hicking (garvinhicking)
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.

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

>Comment By: Garvin Hicking (garvinhicking)
Date: 2007-05-07 11:01

Message:
Logged In: YES 
user_id=473563
Originator: NO

Hi!

Thanks a lot! Just committed a fix for that in version 1.28 of the plugin!

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

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/