URL-encoded comment_author_url gets broken by MySQL varchar 200 length limit
|Reported by:||tenpura||Owned by:|
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.)
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.
Change History (5)
- Component changed from Comments to I18N
- Summary changed from Long comment_author_url of the pingback gets broken by MySQL varchar 200 length limit to URL-encoded comment_author_url gets broken by MySQL varchar 200 length limit
- Version changed from 3.2 to 3.4