Project

General

Profile

Actions

Task #2672

closed

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

Added by Jun Nogata over 5 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
AskLibO
Target version:
-
Start date:
Due date:
% Done:

0%

Tags:

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?

Actions #1

Updated by Florian Effenberger over 5 years ago

  • Assignee set to Evgeny Fadeev
Actions #2

Updated by Jun Nogata almost 4 years ago

Hello.

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

Actions #3

Updated by Florian Effenberger almost 4 years ago

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

Actions #4

Updated by Evgeny Fadeev almost 4 years 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.

Actions #5

Updated by Florian Effenberger almost 4 years ago

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

Actions #6

Updated by Guilhem Moulin almost 4 years 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?

Actions #7

Updated by Evgeny Fadeev almost 4 years ago

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

Actions #8

Updated by Beluga Beluga over 2 years ago

  • Status changed from Feedback to Closed
Actions

Also available in: Atom PDF