[wp-trac] [WordPress Trac] #17771: Long comment_author_url of the pingback gets broken by MySQL varchar 200 length limit

WordPress Trac wp-trac at lists.automattic.com
Sun Jun 12 03:51:44 UTC 2011


#17771: Long comment_author_url of the pingback gets broken by MySQL varchar 200
length limit
--------------------------+------------------------------
 Reporter:  tenpura       |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Comments      |     Version:  3.2
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |
--------------------------+------------------------------

Comment (by dd32):

 This is something that would be better off stored in the comment meta data
 table IMO. Of course, that adds an extra query for displaying comments,
 but as metadata becomes used more, it'll be a query which is made anyway.

 The useragent currently overflows the MySQL field sometimes too.. There's
 a ticket for that somewhere I believe (can't find it right now)

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17771#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list