[Akonadi] [Bug 406106] New: RemoteID is too small MYSQL error

[bugzilla_noreply at kde.org]

https://bugs.kde.org/show_bug.cgi?id=406106

            Bug ID: 406106
           Summary: RemoteID is too small MYSQL error
           Product: Akonadi
           Version: 5.9.1
          Platform: Fedora RPMs
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: DAV Resource
          Assignee: kdepim-bugs at kde.org
          Reporter: ad1rie3 at hotmail.fr
  Target Milestone: ---

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

-- 
You are receiving this mail because:
You are the assignee for the bug.