Opened 9 years ago
Closed 9 years ago
#1867 closed defect (bug) (fixed)
Some links are broken
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| Milestone: | Priority: | high | |
| Component: | International Forums | Keywords: | |
| Cc: |
Description
I notice that some links at โJapanese forum are broken.
It looks like related to topic title length.
For example,
- Topic Title: ๅใซใใดใชใงไธ้ๅฑคไธใฎใซใใดใชใฎใซในใฟใ ใใฃใผใซใใ่กจ็คบใใใ
- Wrong Link: โhttps://ja.wordpress.org/support/topic/%e5%90%84%e3%82%ab%e3%83%86%e3%82%b4%e3%83%aa%e3%83%9a%e3%83%bc%e3%82%b8%e3%81%a7%e4%b8%80%e9%9a%8e%e5%b1%a4%e4%b8%8b%e3%81%ae%e3%82%ab%e3%83%86%e3%82%b4%e3%83%aa%e3%81%ab%e7%99%bb%e9%8c%b2%e3%81%97%e/
Change History (7)
#2
follow-up:
โย 4
@
9 years ago
Is it possible to change the permalink settings to ID based rather than slug ones? I suspect that this is caused by MySQL column length limitation. WP core has the same problem.
#3
@
9 years ago
- Resolution set to fixed
- Status changed from new to closed
I've run a utf8-friendly fixer script on the post_names for each already-imported bbPress forum, and will adjust the import script going forward. The above invalid links are no longer used as topic links -- the topics are now correctly linked at:
โhttps://ru.wordpress.org/support/topic/%D0%BA%D0%B0%D0%BA-%D0%BE%D1%82%D0%BA%D0%BB%D1%8E%D1%87%D0%B8%D1%82%D1%8C-%D1%8D%D0%BA%D1%80%D0%B0%D0%BD%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5-%D0%BA%D0%B8%D1%80%D0%B8%D0%BB%D0%BB%D0%B8/
โhttps://ru.wordpress.org/support/topic/%D0%BD%D0%B0-%D0%BF%D0%BB%D0%B0%D1%82%D0%BD%D0%BE%D0%BC-%D1%88%D0%B0%D0%B1%D0%BB%D0%BE%D0%BD%D0%B5-%D0%BC%D0%BE%D0%B6%D0%BD%D0%BE-%D0%B4%D0%B5%D0%BB%D0%B0%D1%82%D1%8C-%D0%BC%D0%BD%D0%BE%D0%B3%D0%BE/
#4
in reply to:
โย 2
@
9 years ago
Replying to tenpura:
I suspect that this is caused by MySQL column length limitation. WP core has the same problem.
It's worth noting that โ#wp17771 only affects pingbacks, regular post slugs are truncated correctly since 3.6 (see โ#wp21013).
#5
follow-up:
โย 6
@
9 years ago
- Resolution fixed deleted
- Status changed from closed to reopened
This topic URL works, but cannot be urldecoded correctly due to an extra %d1 at the end, so browsers don't display it in human-readable form in the address bar, like other topics:
โhttps://ru.wordpress.org/support/topic/%d0%94%d0%b2%d1%83%d1%8f%d0%b7%d1%8b%d1%87%d0%bd%d1%8b%d0%b9-%d1%81%d0%b0%d0%b9%d1%82-%d0%b1%d0%b5%d0%b7-%d0%b8%d1%81%d0%bf%d0%be%d0%bb%d1%8c%d0%b7%d0%be%d0%b2%d0%b0%d0%bd%d0%b8%d1%8f-%d0%bc%d0%b0%d1/
Any way to double-check the fixer script?
#6
in reply to:
โย 5
@
9 years ago
- Owner set to jmdodd
- Status changed from reopened to assigned
I re-ran the script with an additional set of decode/encode/decode comparisons and it caught this instance but no others:
Updated post ID 216625 from %d0%94%d0%b2%d1%83%d1%8f%d0%b7%d1%8b%d1%87%d0%bd%d1%8b%d0%b9-%d1%81%d0%b0%d0%b9%d1%82-%d0%b1%d0%b5%d0%b7-%d0%b8%d1%81%d0%bf%d0%be%d0%bb%d1%8c%d0%b7%d0%be%d0%b2%d0%b0%d0%bd%d0%b8%d1%8f-%d0%bc%d0%b0%d1 to %d0%94%d0%b2%d1%83%d1%8f%d0%b7%d1%8b%d1%87%d0%bd%d1%8b%d0%b9-%d1%81%d0%b0%d0%b9%d1%82-%d0%b1%d0%b5%d0%b7-%d0%b8%d1%81%d0%bf%d0%be%d0%bb%d1%8c%d0%b7%d0%be%d0%b2%d0%b0%d0%bd%d0%b8%d1%8f-%d0%bc%d0%b0
I'll leave this open until I'm certain that I've fixed the importer.
Same on Russian forums.
Some topic slugs cannot be urldecoded correctly due to being cut in the middle of a UTF-8 sequence, but somehow still work:
Others are completely broken and produce a 400 Bad Request error:
@jmdodd: Is there a way to find and fix all the affected topics?