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?

[图片] 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. [图片] CamilleRoux: Do you know if the next stable version will be release soon? We cut a “stable” version approximately every 6 m…

审核帖子时出现“500内部服务器错误”

支持安装

Roman (Roman Rizzi) 2020 年10 月 1 日 21:37 8

谢谢，这真的很有帮助！

你之前是否跟踪过 beta 分支，然后切换到了 stable？private_message 列是在 v2.6.0.beta2 中新增的，但该提交并未包含在 v2.5.2 +2 中。这是该提交的链接：

话题		回复	浏览量
500 Error when editing an existing post Bug	10	1828	2022 年11 月 17 日
User can't post: 500 internal server error Support	12	1408	2018 年4 月 18 日
On edit: Internal Server Error due to plugin Support	3	1435	2019 年1 月 4 日
Approve post in closed topic leads to internal server error Bug	6	1474	2016 年6 月 24 日
Users reporting lots of 502 errors when attempting to post due to "max consecutive replies" check Bug	37	2986	2019 年1 月 18 日

审核帖子时出现“500内部服务器错误”

相关话题