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

Bugs item #3055504, was opened at 2010-08-29 17:31
Message generated for change (Tracker Item Submitted) made by leyrer
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: Open
Resolution: None
Priority: 5
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);

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

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