On Mon, Mar 01, 2010 at 12:01:37AM +0000, Dominic Hargreaves wrote: > On Wed, Feb 17, 2010 at 06:20:21PM +0100, Bernd Zeimetz wrote: > > > I'm using MT with an ipv6-aware lighttpd here, which results in ipv4 > > addresses from people posting comments are shown as > > '::ffff:172.26.14.40'. MT passes the IP address to the database in this > > form and tries to insert it into a character varying(16) field, which > > will obviously fail: > > > > > > > > 2010-02-17 18:04:51 CET DETAIL: Parameter: $1 = '222', $2 = 'Bernd > > Zeimetz', $3 = '1', $4 = NULL, $5 = NULL, $6 = '2010-02-17 18:04:51', $7 > > = 't...@example.com', $8 = '2', $9 = '::ffff:172.26.14.40', $10 = NULL, > > $11 = NULL, $12 = '1', $13 = '2000-01-01 00:00:00', $14 = NULL, $15 = > > '2010-02-17 18:04:51', $16 = NULL, $17 = 'New test post.', $18 = > > 'http://bzed.de', $19 = '0' > > 2010-02-17 18:04:51 CET FEHLER: Wert zu lang für Typ character > > varying(16) > > 2010-02-17 18:04:51 CET ANWEISUNG: INSERT INTO mt_comment > > (comment_id, comment_author, comment_blog_id, > > comment_commenter_id, comment_created_by, comment_created_on, > > comment_email, comment_entry_id, comment_ip, comment_junk_log, > > comment_junk_score, comment_junk_status, comment_last_moved_on, > > comment_modified_by, comment_modified_on, comment_parent_id, > > comment_text, comment_url, comment_visible) > > VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, > > $12, $13, $14, $15, $16, $17, $18, $19) > > I believe that this was fixed by Six Apart a while ago; I didn't > realise that the lenny package suffered from this problem :( > > It should be reasonably simple to backport this fix to stable; > I'll look into it and see what I can do.
Can you give the test packages (4.2.3-1+lenny2~test.2) from http://people.debian.org/~dom/mt-test/ a spin and let me know whether they fix the problem you're seeing? Thanks, Dominic. -- Dominic Hargreaves | http://www.larted.org.uk/~dom/ PGP key 5178E2A5 from the.earth.li (keyserver,web,email) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
