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

[SourceForge.net]

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

[SourceForge.net]

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