Hallo,
nach dem Upgrade auf v2.13.0 konnte ich plötzlich keine Dateien mehr löschen. Der Löschvorgang scheiterte aufgrund von rot angezeigten Fehlermeldungen.
Wenn Ihr das gleiche Problem habt - hier die Lösung:
cd /path/to/paperless
Details zum Problem und zur Lösung findet Ihr hier:
opened 06:05PM - 25 Oct 24 UTC
closed 06:11PM - 25 Oct 24 UTC
bug
backend
### Description
Receive this error when trying to delete items after upgrading … to latest release
[2024-10-25 13:03:05,066] [WARNING] [paperless.api] An error occurred performing bulk edit: (1406, "Data too long for column 'transaction_id' at row 1")
### Steps to reproduce
select document -> move to trash, error occurs. from both the checkbox screen or within the document
### Webserver logs
```bash
[2024-10-25 13:03:05,066] [WARNING] [paperless.api] An error occurred performing bulk edit: (1406, "Data too long for column 'transaction_id' at row 1")
```
### Browser logs
_No response_
### Paperless-ngx version
2.13.0
### Host OS
Debian
### Installation method
Docker - official image
### System status
```json
{
"pngx_version": "2.13.0",
"server_os": "Linux-6.8.12-1-pve-x86_64-with-glibc2.36",
"install_type": "docker",
"storage": {
"total": 40802189312,
"available": 9618456576
},
"database": {
"type": "mysql",
"url": "paperless",
"status": "OK",
"error": null,
"migration_status": {
"latest_migration": "paperless_mail.0027_mailaccount_expiration_mailaccount_account_type_and_more",
"unapplied_migrations": []
}
},
"tasks": {
"redis_url": "redis://broker:6379",
"redis_status": "OK",
"redis_error": null,
"celery_status": "OK",
"index_status": "OK",
"index_last_modified": "2024-10-25T13:02:34.545103-05:00",
"index_error": null,
"classifier_status": "OK",
"classifier_last_trained": "2024-10-25T17:05:09.165998Z",
"classifier_error": null
}
}
```
### Browser
Chrome
### Configuration changes
_No response_
### Please confirm the following
- [X] I believe this issue is a bug that affects all users of Paperless-ngx, not something specific to my installation.
- [X] This issue is not about the OCR or archive creation of a specific file(s). Otherwise, please see above regarding OCR tools.
- [X] I have already searched for relevant existing issues and discussions before opening this report.
- [X] I have updated the title field above with a concise description.
https://docs.paperless-ngx.com/troubleshooting/#convert-uuid-field
Viele Grüße
Tony