Project

General

Profile

Task #2672

askbot: Search resulut in a "Internal server error" on Ask LibreOffice Japanese Page

Added by Jun Nogata about 2 years ago. Updated 9 months ago.

Status:
Feedback
Priority:
Normal
Assignee:
Category:
Askbot
Target version:
-
Start date:
Due date:
% Done:

0%

Tags:
URL:

Description

Hi
I can not search on Ask LibreOffice Japanese Page.

  1. Open https://ask.libreoffice.org/ja/questions/
  2. Input search any keywords(English or Japanese) in search window.
  3. "Internal server error" is displayed.
Internal server error

system error log is recorded, error will be fixed as soon as possible
please report the error to the site administrators

Is this related?

History

#1

Updated by Florian Effenberger about 2 years ago

  • Assignee set to Evgeny Fadeev
#2

Updated by Jun Nogata 9 months ago

Hello.

It's been over a year since I reported. Would you be willing to respond?

#3

Updated by Florian Effenberger 9 months ago

Apologies for this indeed - Evgeny, can you have a look? Thanks!

#4

Updated by Evgeny Fadeev 9 months ago

Hi guys, this will require some dev work as postgresql does not support Japanese search well.
Florian and I discussed this and I made an estimate and never heard back regarding the decision.

I would need to implement this via elasticsearch.

#5

Updated by Florian Effenberger 9 months ago

Evgeny, I will follow-up privately on that item with you, so we can
discuss the options we have

#6

Updated by Guilhem Moulin 9 months ago

  • Status changed from New to Feedback

postgresql does not support Japanese search well.

I wonder if that statement is still true for PostgreSQL 11 and textsearch_ja 42 (upgraded the box and backend on Oct 31 last year). Dunno if the Japanese search works as expected, but at least after CREATE EXTENSION textsearch_ja I'm no longer able to reproduce the “Internal server error“ when hitting the search button:

https://ask.libreoffice.org/ja/questions/scope:all/sort:activity-desc/page:1/query:test/
https://ask.libreoffice.org/ja/questions/scope:all/sort:activity-desc/page:1/query:%E3%82%AF%E3%83%A9%E3%83%83%E3%82%B7%E3%83%A5/

Does the Japanese search now work as expected, Jun Nogata?

#7

Updated by Evgeny Fadeev 9 months ago

Ah thanks! Last time I've tried the textsearch_ja it was not compatible with the database.

Also available in: Atom PDF