deck
deck copied to clipboard
Long card description --> Indexing fails
Describe the bug After creating a card with a long description an error occurs in the log. After creating this card, no changes (title, description) to this card can be made. Every change attempt fails and produces an error in the log.
To Reproduce Steps to reproduce the behavior:
- Go to Deck
- Create a card
- Write a long description (in my case: ~3.900 letters)
- See error
Expected behavior Should work.
Server details
Database: PostgreSQL 14.10
PHP version: 8.1.25
Nextcloud version: 26.0.8 / 26.0.9
Logs
Nextcloud log (data/nextcloud.log)
[deck] Error: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[54000]: Program limit exceeded: 7 ERROR: index row size 2800 exceeds btree version 4 maximum 2704 for index "idx_last_editor"
DETAIL: Index row references tuple (16,58) in relation "oc_deck_cards".
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.