DbalException An exception occurred while executing a query: SQLSTATE[22001]: String data value too long for type character varying(255)

[Nothing2024]

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

---

Steps to reproduce

1. Share a link to others
2. Enter a wrong password following the shared link.

Expected behaviour

The failing attempt should have been logged to oc_bruteforce_attempts.

Actual behaviour

DbalException in the log. Failed to add record to oc_bruteforce_attempts

[index] Error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 7 ERROR:  value too long for type character varying(255)
	GET /s/SomeRandomString&data=05%7C02%[email protected]%7Cb8e7d5ae03d1492e7ddd08dcdc73886a%7Cdd3be02229ab444490efbbee7374acee%7C1%7C0%7C638627636026167027%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0=%7C0%7C%7C%7C&sdata=Q5bXmOfXehZ+j1LwJJM0++dS1XKzy8yLhe7MmCKjWao=&reserved=0
	from 172.167.1xx.xxx by -- at Sep 24, 2024, 4:34:17 PM

No record was added to oc_bruteforce_attempts table.

Server configuration

Web server: Apache/Nginx Apache (docker)

Database: PostgreSQL

PHP version: 8.2.23 (docker)

Nextcloud version: (see Nextcloud admin page) 29.0.6 (docker image nextcloud:29.0)

List of activated apps

Enabled:
  - activity: 2.21.1
  - bruteforcesettings: 2.9.0