Since our 3.1.0 update today, our Search is no longer working. Our sysadmin team identified a problem and provided us with this log stating this is an application error. Does anyone else experience this problem and what may the clues be for us to be able to resolve the problem ourselves? I see sea…

any chance that you use the private replies plugin ? [image] Discourse Private Replies plugin Hi Richard, it seems there is an issue with the search patch (rebuilt with latest) [image] def execute(readonly_mode: @readonly_mode) seems to solve it though

We see the search doesn’t work for Topics/Posts, but works for Categories/Tags and Users.

Are you using an external instance of PostgreSQL? If so what is the version?

Yes, we are using the external PostgreSQL. The version is 14.6-1

Our search is completely broken when running against PostgreSQL 14, which is why we are still shipping PostgreSQL 13 for everyone following our standard install . We will eventually fix it since we will upgrade to PostgreSQL 15 (or 16) someday, but it may take a while.

Thank you. We’re investigating how that may have happened IF we have previously had other PostgreSQL version. Will get back to you once we identify the issue.

[image] kinetiksoft: IF Whether you previously had 14 isn’t really material, Discourse isn’t compatible with PostgreSQL 14. That’s your issue.

I’ve checked the discourse/docs/INSTALL.md at main · discourse/discourse · GitHub documentation instead, as Cloud documentation doesn’t have server requirements at all. We see “Postgres 13+” requirement here . May I be wrong by suggesting to your team to add a notice that Discourse supports 13.X ver…

We have it installed, it is disabled in Admin settings We also tried and reproduced the issue in Safe Mode . Should it matter anyway?

Unclear, but that was the issue in my case (same symptoms - although with PostgreSQL13) I’m sure Richard will patch it up shortly, in the mean time a fork and a simple edit is a solution.

[image] Falco: Our search is completely broken when running against PostgreSQL 14 Oh. Bummer. I’ve got one site that I mostly accidentally upgraded to PG14 a while back, and figured it would be fine. I just did a few searches and they weren’t obviously terribly broken. And the site is mostly…

La recherche ne fonctionne plus après la mise à jour 3.1.0.beta1

Soutien

Benjamin_D (Benjamin Decotte) Janvier 13, 2023, 2:30 11

Y a-t-il une chance que vous utilisiez le plugin de réponses privées ?

Sujet		Réponses	Vues
Update from 2.8.4 to 3.1.1 Self-hosting unsupported-install	5	353	Octobre 18, 2023
Update problem : Broken Forum Self-hosting server-resources	27	2602	Juin 11, 2022
Internal error on search and after upgrade Support	2	422	Août 17, 2020
Today error when upgrade from 2.5.1 to 2.5.2, discourse-assign Self-hosting	5	904	Novembre 6, 2020
Error upgrading from 3.0.1 to 3.1.0 Self-hosting	14	774	Mars 28, 2023

La recherche ne fonctionne plus après la mise à jour 3.1.0.beta1

Sujets connexes