[ php-blog-Bugs-3055500 ] serendipity_event_suggest - insert into eintries won't work

Bugs item #3055500, was opened at 2010-08-29 17:21
Message generated for change (Tracker Item Submitted) made by leyrer
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=3055500&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: Martin Leyrer (leyrer)
Assigned to: Nobody/Anonymous (nobody)
Summary: serendipity_event_suggest - insert into eintries won't work

Initial Comment:
"Moving" a suggested story into the entries table after e-mail validation fails in a postgresql database with the message 
ERROR:  invalid input syntax for type boolean: ""

This is due to the value of 'moderate_comments' in the INSERT statement. To fix this problem, line #248 in file "serendipity_event_suggest.php" has to be changed from
'moderate_comments' => false,
to
'moderate_comments' => '0',

-- at least for postgresql databases.


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

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

------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users 
worldwide. Take advantage of special opportunities to increase revenue and 
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d