[ php-blog-Bugs-3055504 ] serendipity_event_suggest - adding a suggestion won't work

Bugs item #3055504, was opened at 2010-08-29 15:31
Message generated for change (Comment added) made by garvinhicking
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=3055504&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 - adding a suggestion won't work

Initial Comment:
Adding a suggestion into the table "suggestmail" in a postgresql database won't work:
ERROR:  value too long for type character varying(12)

You have to change the column 'ip' of the table "suggestmail" in line #53 of file "serendipity_event_suggest.php" from 
ip varchar(12),
to
ip varchar(16),

If the table already exisits in the Postgresql database, you will need to issue this statement:
ALTER TABLE serendipity_suggestmails ALTER COLUMN ip TYPE varchar(16);

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

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

Message:
Thanks a lot, fixed!

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=3055504&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