| Summary: | RemoteID is too small MYSQL error | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | ad1rie3 |
| Component: | DAV Resource | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | ad1rie3, bugs.kde.org, horstjoe |
| Priority: | NOR | ||
| Version: | 5.9.1 | ||
| Target Milestone: | --- | ||
| Platform: | Fedora RPMs | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
*** This bug has been marked as a duplicate of bug 394839 *** *** Bug 408042 has been marked as a duplicate of this bug. *** |
SUMMARY When i synchronise my calendar with nextcloud, the remoteID field can greather than 255, in result of mysqlSQL error and crash .... g.kde.pim.akonadiserver: Error during insertion into table "PimItemTable" "Data too long for column 'remoteId' at row 1 QMYSQL3: Unable to execute statement" g.kde.pim.akonadiserver: Query: "INSERT INTO PimItemTable (rev, remoteId, remoteRevision, gid, collectionId, mimeTypeId, datetime, atime, dirty, size) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9)" g.kde.pim.akonadiserver: Values: QMap((":0", QVariant(int, 0))(":1", QVariant(QString, "https://nextcloud.brain-networks.net/remote.php/dav/calendars/Adrien.Faveraux/personal_shared_by_Anselme.Josset/040000008200E00074C5B7101A82E0080000000C070CA1EA9B1D40100000000000000001000000004865F8D8ECEAA47B9D3185D6F97F452.ics#040000008200E00074C5B7101A82E00800000000C070CA1EA9B1D40100000000000000001000000004865F8D8ECEAA47B9D3185D6F97F4522019-03-25T14:00:00+01:00"))(":2", QVaria .... g.kde.pim.akonadiserver: Error text: "Data too long for column 'remoteId' at row 1 QMYSQL3: Unable to execute statement" g.kde.pim.akonadiserver: DB error: "Data too long for column 'remoteId' at row 1" g.kde.pim.akonadiserver: Error code: "1406" g.kde.pim.akonadiserver: DATABASE ERROR: i have to edit the struct of mysql database of akonadi to set the limit more huge. mysql --socket=/tmp/akonadi-quartz.LHhNzx/mysql.socket MariaDB [akonadi]> ALTER TABLE `PimItemTable` CHANGE `remoteId` `remoteId` VARBINARY(512) NULL; Can you set the limit more user friendly by default ? STEPS TO REPRODUCE 1. Have an huge remoteID in ICS filename 2. 3. OBSERVED RESULT Crash EXPECTED RESULT Work :) SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: Fedora 29 (available in About System) KDE Plasma Version: 5.14.5 KDE Frameworks Version: 5.55 Qt Version: 5.11.3 ADDITIONAL INFORMATION