'
> actionpack-7.1.4/lib/action_dispatch/routing/mapper.rb:60:in `serve'
> actionpack-7.1.4/lib/action_dispatch/journey/router.rb:51:in `block in serve'
> actionpack-7.1.4/lib/action_dispatch/journey/router.rb:131:in `block in find_routes'
> actionpack-7.1.4/lib/action_dispatch/journey/router.rb:124:in `each'
> actionpack-7.1.4/lib/action_dispatch/journey/router.rb:124:in `find_routes'
> actionpack-7.1.4/lib/action_dispatch/journey/router.rb:32:in `serve'
> actionpack-7.1.4/lib/action_dispatch/routing/route_set.rb:882:in `call'
> /var/www/discourse/lib/middleware/omniauth_bypass_middleware.rb:64:in `call'
> rack-2.2.9/lib/rack/tempfile_reaper.rb:15:in `call'
> rack-2.2.9/lib/rack/conditional_get.rb:40:in `call'
> rack-2.2.9/lib/rack/head.rb:12:in `call'
> actionpack-7.1.4/lib/action_dispatch/http/permissions_policy.rb:36:in `call'
> /var/www/discourse/lib/content_security_policy/middleware.rb:12:in `call'
> /var/www/discourse/lib/middleware/anonymous_cache.rb:393:in `call'
> /var/www/discourse/lib/middlewar
>
> ```
---
### Author:  [@sam](https://meta.discourse.org/u/sam)
#### Post date: [September 17, 2024, 4:32am UTC](https://meta.discourse.org/t/certain-message-cannot-be-sent-in-chat/326762/2 "2024-09-17T04:32:39Z")
> [@Firepup650](#):
>
> ```plaintext
> Failed to handle exception in exception app middleware : ActiveRecord::ValueTooLong : PG::StringDataRightTruncation: ERROR: value too long for type character varying(1000)
>
> ```
It is trying to insert into the chat table and the column is limited to 1000 chars.
Maybe try this in [data explorer](https://meta.discourse.org/t/32566?silent=true):
```plaintext
SELECT
column_name,
data_type,
character_maximum_length
FROM
information_schema.columns
WHERE
table_name = 'chat_messages'
AND column_name IN ('cooked', 'message')
```
Is there a max length defined somehow on your schema?
---
### Author:  [@j.jaffeux](https://meta.discourse.org/u/j.jaffeux)
#### Post date: [September 17, 2024, 9:45am UTC](https://meta.discourse.org/t/certain-message-cannot-be-sent-in-chat/326762/4 "2024-09-17T09:45:17Z")
The `value too long for type character varying(1000)` indicates to me that it’s related to excerpt. This is surprising because technically we limit excerpts at `150` chars, so this case should never happen, at first I thought it was a bug in our excerpt builder but looking at the excerpt code in chat I saw this:
```ruby
def build_excerpt
# just show the URL if the whole message is a URL, because we cannot excerpt oneboxes
return message if UrlHelper.relaxed_parse(message).is_a?(URI)
# upload-only messages are better represented as the filename
return uploads.first.original_filename if cooked.blank? && uploads.present?
# this may return blank for some complex things like quotes, that is acceptable
PrettyText.excerpt(cooked, EXCERPT_LENGTH, strip_links: true, keep_mentions: true)
end
```
Quick debugging has shown that we actually never reach `PrettyText.excerpt` and we stop at the first return. Apparently the `???` is making our code thinks this is a URL:
```plaintext
[1] pry(main)> UrlHelper.relaxed_parse("???\ntest").is_a?(URI)
=> true
```
---
### Author:  [@j.jaffeux](https://meta.discourse.org/u/j.jaffeux)
#### Post date: [September 18, 2024, 9:30am UTC](https://meta.discourse.org/t/certain-message-cannot-be-sent-in-chat/326762/8 "2024-09-18T09:30:33Z")
We have identified the fix, but will take some time to land in main.
---
### Author:  [@j.jaffeux](https://meta.discourse.org/u/j.jaffeux)
#### Post date: [October 23, 2024, 1:55pm UTC](https://meta.discourse.org/t/certain-message-cannot-be-sent-in-chat/326762/10 "2024-10-23T13:55:42Z")
The fix has been merged: [SECURITY: Correctly parse URLs in chat excerpts · discourse/discourse@1da97de · GitHub](https://github.com/discourse/discourse/commit/1da97de7f0b4e05f12080e14b9b10fa9956681ac)
---
### Author:  [@j.jaffeux](https://meta.discourse.org/u/j.jaffeux)
#### Post date: [October 26, 2024, 1:56pm UTC](https://meta.discourse.org/t/certain-message-cannot-be-sent-in-chat/326762/11 "2024-10-26T13:56:28Z")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.