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. > Even worse, MT does not show that an error has happened while posting > the comment, instead the 'Thank you for commenting.' template is being > shown. That's also the reason why I file this bug as important - it was > not possible to see this error in the debug log of MT, I had to enable > statement logging in postgres to see the error and the reason for it. I've cloned this as a separate bug. -- 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
