After changing language: Error listing search results, check logs for more detail.

[Schnusiman]

Hi all,

the days I played with the ui-language and switched from de to en (us) and after a day back to de again.
Since then, I get an error red bar, when I use the sorting for the "created" date: "Error while loading documents: Error listing search results, check logs for more detail."
It has to do with the language settings as I can sort the last 7 days bot not further more in the past.
Yes, I did add documents while I was in en-mode.

When I look in the Browser console network tab, you will, that last 3 month does not work and last 7 days does.

The log file from the shows only:

postgres does not say anything

Any ideas how to fix this?

After some more tests: If I enter the date in the "from" field, I get all documents without any error
http://192.168.200.52:9020/api/documents/?page=1&page_size=50&ordering=-added&truncate_content=true&correspondent__id__in=27&created__date__gt=2015-02-01

using the "last monthe or "last 3 month", it does not work:
http://192.168.200.52:9020/api/documents/?page=1&page_size=50&ordering=-added&truncate_content=true&correspondent__id__in=27&query=created:%5B-1%20month%20to%20now%5D

http://192.168.200.52:9020/api/documents/?page=1&page_size=50&ordering=-added&truncate_content=true&correspondent__id__in=27&query=created:%5B-3%20month%20to%20now%5D

As I can narrow the documents whee it fails by the correspondend, I lokked in the DB:

Any more ideas?

[shamoon]

Not sure if it really has to do with language switch but yea, in general Im not aware of any issues here.

Those queries (-1 month to now) come from one of our dependencies, whoosh and they use the document index (as opposed to date gt which just hits the db). Perhaps you can try reindexing? https://docs.paperless-ngx.com/administration/#index

[Schnusiman]

Good morning,

thanks a lot for your help, The reindexing did the trick.
It happend on two instances and both work now again.

Thanks again.

[github-actions[bot]]

This discussion has been automatically locked since there has not been any recent activity after it was closed. Please open a new discussion for related concerns.