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

Bugs item #3055500, was opened at 2010-08-29 15:21
Message generated for change (Comment added) made by garvinhicking
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: Closed
>Resolution: Accepted
>Priority: 1
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.


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

>Comment By: Garvin Hicking (garvinhicking)
Date: 2010-09-01 09:40

Message:
Thanks a lot, also fixed :-)

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

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

------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd