SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'label' at row 293

🍱 Features & apps passman
1

I posted this question to SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'label' at row 293 · Issue #711 · nextcloud/passman · GitHub If it gets resolved, I’ll close both and cross reference.

After updating passman from 2.3.7 to 2.3.10 I got an error "SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘label’ at row 293 " Disabling passman allowed the update to finish, but I cannot enable it and it triggers the same error.

Of the passman tables, only oc_passman_credentials has a “labels” column and it is already longtext utf8mb4_bin. Any thoughts?

Web server:
apache24-2.4.48

Database:
mariadb105-server-10.5.11

PHP version:
php74-7.4.23

Nextcloud Version:
22.1.1

OS:
FreeBSD 11.3-RELEASE-p8

2

OK, editing the labels in the database I found 3 that were too long for the current iteration of passman - 723 characters is too much. These were all (3) generated by milestonesys.com SSO system which puts multiple loong guid values in the URL.