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

[WordPress Trac]

#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        |   Keywords:  has-patch
--------------------------+-----------------------------
 !WordPress sometimes pings back with long permalinks that exceed
 comment_author_url column length limit of 200, which  results in
 generating unusable broken links to the post.
 It easily reaches to the limit, especially if the permalink contains url-
 encoded multibyte title as postname. (e.g. 23 characters of UTF-8 Japanese
 become a 207 characters long url-encoded string. Incomplete url-encoded
 string may trigger 400 Bad Request too.)

 '''Solution:'''
 In pingback(), use shortlink instead of regular permalink if the URL is
 longer than 200 characters.
 It seems to work ok with wp.me shortlinks.

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