Package: movabletype-opensource Version: 4.2.3-1+lenny1 Severity: important Tags: ipv6
Hi! 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) 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. Best regards, Bernd -- Bernd Zeimetz Debian GNU/Linux Developer http://bzed.de http://www.debian.org GPG Fingerprints: 06C8 C9A2 EAAD E37E 5B2C BE93 067A AD04 C93B FF79 ECA1 E3F2 8E11 2432 D485 DD95 EB36 171A 6FF9 435F -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20100217172021.21172.55048.report...@think.mg.bzed.de
