KranthiKiranGude, a forum admin, reported encountering a 500 error when attempting to post specific topics, despite successfully posting others. The problematic post included a lengthy body discussing the value of learning programming for commerce students. IAmGav initially suspected character limits, but KranthiKiranGude confirmed all limits were set to maximum values. The issue worsened over time, severely affecting the forum. IAmGav tested the same content on another Discourse server successfully, suggesting the issue was server-specific. Falco advised checking the /logs page, which KranthiKiranGude could not access; Falco clarified that admin login is required. KranthiKiranGude questioned if the error stemmed from similar body content, referencing a Mozilla Discourse thread. IAmGav suggested checking posting settings. sam requested the error log, which KranthiKiranGude provided: ActiveRecord::ValueTooLong (PG::StringDataRightTruncation: ERROR: value too long for type character varying(1000)). sam identified the cause: the topic_excerpt_maxlength setting exceeded PostgreSQL’s 1000-character limit for excerpts. Reducing it to 999 resolved the issue. KranthiKiranGude confirmed the fix.
I get a 500 Error while trying to post a new Topic. I am the Admin and have posted and am able to post multiple other topics. But, only few set of topics are throwing me an error. Title:
Why should I learn computer programming even though I am a commerce student? How can computer programming help me? Post:
First of all in couple of years everything will be programmable so it will be useful thing to know. But you might not care about that since you will be only consumer - and that is fine to be clear.Even though you do not know every law in the book like professional lawyer you still know few of your basic rights so why not learn some basics of computer programming?As a commerce student I expect that you will be working with a bunch of numbers and if you have repetitive tasks having them automated can save you a bunch of time.Last but not least you should never turn down opportunity to learn s Continue ReadingFirst of all in couple of years everything will be programmable so it will be useful thing to know. But you might not care about that since you will be only consumer - and that is fine to be clear.Even though you do not know every law in the book like professional lawyer you still know few of your basic rights so why not learn some basics of computer programming?As a commerce student I expect that you will be working with a bunch of numbers and if you have repetitive tasks having them automated can save you a bunch of time.Last but not least you should never turn down opportunity to learn something new: be it playing instrument, new language or just good old programming.
Could someone help me understand what could possible go wrong here
I have kept the topic character limit to the maximum.
I have increase the max post length to 150000.
Max Topic Title Length to 255.
Title max word length to 2000000000
Any other possible reason.
The Number of 500 Errors have been increasing considerably. Not able to identify the exact reason. This is severely affecting my forum. Could you someone please help me here.
Is it true that this might be caused due to similar body content, as mentioned here,
If yes, how to disable this feature. I’m comfortable having a Check for duplicate titles. But, I don’t want Discourse to throw and error for similar body
ActiveRecord::ValueTooLong (PG::StringDataRightTruncation: ERROR: value too long for type character varying(1000) ) lib/post_creator.rb:496:in `update_topic_stats' lib/post_creator.rb:199:in `block i