WordPress.org

Making WordPress.org

Opened 6 years ago

Closed 3 years ago

#276 closed defect (fixed)

"Search term" in bbPress admin doesn't work for Cyrillic words

Reported by: SergeyBiryukov Owned by:
Milestone: Priority: normal
Component: International Forums Keywords:
Cc:

Description (last modified by SergeyBiryukov)

If you search for "плагин", "тема", "файл" (or any other Cyrillic word commonly used on forums) in bbPress admin on ru.forums.wordpress.org, you'll just get "No posts found".

If the topic has some English words (a plugin name, etc.), you may eventually succeed by searching for them and wading through a lot of unrelated topics, but most of the time you're out of luck.

Combined with #121 and #347, it's virtually impossible to find any topic older than a few days, even if you're an administrator and happen to remember the exact keywords.

Attachments (1)

276.png (131.1 KB) - added by ocean90 4 years ago.

Download all attachments as: .zip

Change History (13)

#1 @SergeyBiryukov
6 years ago

  • Summary changed from "Searh term" in bbPress admin doesn't work for Cyrillic words to "Search term" in bbPress admin doesn't work for Cyrillic words

#2 @SergeyBiryukov
6 years ago

  • Description modified (diff)

#3 @SergeyBiryukov
5 years ago

  • Description modified (diff)

#4 @SergeyBiryukov
4 years ago

  • Description modified (diff)

#5 @SergeyBiryukov
4 years ago

Combined with #121 and #347, it's virtually impossible to find any topic older than a few days, even if you're an administrator and happen to remember the exact keywords.

Would it be possible to at least fix this one?

It does work on a clean bbPress 1.x install, so it's probably a latin1 DB issue, which makes me think it wouldn't be fixed with the upgrade to bbPress 2.x and needs to be fixed separately anyway.

#6 @SergeyBiryukov
4 years ago

Just spent another 10 minutes to find a topic that could be found in 10 seconds if the admin search worked.

This ticket was mentioned in Slack in #meta by ocean90. View the logs.


4 years ago

#8 @samuelsidler
4 years ago

Tracking bug for upgrading to bbPress 2.x is #1544.

@ocean90
4 years ago

#9 follow-up: @ocean90
4 years ago

  • Keywords reporter-feedback added

@SergeyBiryukov Just did a search for "плагин" and it's working for me, see 276.png. Do you use any filters?

#10 in reply to: ↑ 9 @SergeyBiryukov
4 years ago

Replying to ocean90:

@SergeyBiryukov Just did a search for "плагин" and it's working for me, see 276.png. Do you use any filters?

Try searching for posts instead of topics (sorry if that was not clear from my description).

#11 @ocean90
4 years ago

  • Keywords reporter-feedback removed

bbPress is doing a full-text search by using MATCH() ... AGAINST if the length of the search term is over 5 ("пл" is using LIKE, "пла" MATCH), see BB_Query->generate_post_text_sql(). This seems not to work with Cyrillic chars in a database with latin1 charset.

#12 @SergeyBiryukov
3 years ago

  • Resolution set to fixed
  • Status changed from new to closed

After the upgrade to bbPress 2.x in #1544, the admin search appears to work as expected.

Note: See TracTickets for help on using tickets.