Hi, I’m using the 2.5.1 version of Discourse and get a “500 Internal Server Error” when approving a post in review. Here is the error in /logs: Message (7 copies reported) ActiveRecord::StatementInvalid (PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until e…

Thanks, that really helps! Did you were tracking the beta branch at some point and then switched to stable? The private_message column was added in v2.6.0.beta2, but the commit is not included in v2.5.2 +2. This is the commit: PERF: Add partial index for non-pm s…

We are experiencing the same issue in the same circumnstances as described by Camille. So we tried to edit the post first, and then tried again to approve it, but the problem persist. Any solution available? Thank you

I’m still having the same problem with the v2.5.2 +2 version. It seems to happen to the posts triggering the auto silence fast typers on first post option.

Hi @CamilleRoux ! I couldn’t reproduce this locally so maybe I’m missing something. Does this happen when you try to approve any queued post, or only for a particular one?

I’ve no other message in review… What can I do to give you more info? I just set approve new topics unless trust level the max and now I get a 500 error when I post a new topic. It seems to be quite the same error: ActiveRecord::StatementInvalid (PG::InFailedSqlTransaction: ERROR: current transac…

Can you enter the container and check the PostgreSQL logs for an error around the same timestamp?

Here is the error (for the error of the topic): 2020-10-01 18:37:18.894 UTC [25661] discourse@discourse ERROR: null value in column "private_message" violates not-null constraint 2020-10-01 18:37:18.894 UTC [25661] discourse@discourse DETAIL: Failing row contains (8803, 'a':25 'api':4A,17 'arriv'…

Arf… Yes I did that, my bad. Thank you very much! Do you know if the next stable version will be release soon?

[immagine] CamilleRoux: Yes I did that That is completely unsupported and will result in a broken Discourse. Revert back to the default tests-passed or beta ASAP. [immagine] CamilleRoux: Do you know if the next stable version will be release soon? We cut a “stable” version approximate…

"500 Internal Server Error" quando si approva un post in revisione

Supporto Installazione

Roman (Roman Rizzi) 1 Ottobre 2020, 9:37pm 8

Grazie, è davvero d’aiuto!

Hai seguito il ramo beta in un certo momento e poi sei passato a stable? La colonna private_message è stata aggiunta in v2.6.0.beta2, ma il commit non è incluso in v2.5.2 +2. Ecco il commit:

Argomento		Risposte	Visualizzazioni
500 Error when editing an existing post Bug	10	1828	Novembre 17, 2022
User can't post: 500 internal server error Support	12	1408	Aprile 18, 2018
On edit: Internal Server Error due to plugin Support	3	1435	Gennaio 4, 2019
Approve post in closed topic leads to internal server error Bug	6	1474	Giugno 24, 2016
Users reporting lots of 502 errors when attempting to post due to "max consecutive replies" check Bug	37	2986	Gennaio 18, 2019

"500 Internal Server Error" quando si approva un post in revisione

Argomenti correlati