https://bugs.kde.org/show_bug.cgi?id=394839
Bug ID: 394839
Summary: pimitemtable.remoteid Column Too Small For Exchange
Calendar Via davmail
Product: Akonadi
Version: 5.7.2
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: DAV Resource
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I was unable to configure an Exchange calendar via the davmail proxy because
the item ID was longer than the column length for the pimitemtable.remoteid
column (255).
The error resulted in log messages like this:
DATABASE ERROR:
Error code: "1406"
DB error: "Data too long for column 'remoteId' at row 1"
Error text: "Data too long for column 'remoteId' at row 1 QMYSQL3: Unable
to execute statement"
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)"
I turned on general_log in mysql to catch the error.
The fix was:
alter table pimitemtable modify column remoteId varchar(1024);
(I imagine that 1024 is larger than what is strictly needed, but it costs
nothing to specify it.)
The problem data looks like this:
http://localhost:1080/users/[email protected]/calendar/AAMkADE0ZTY4YjY0LTM3ZmUtNGQ3Yy1hMzdjLTdlNTZlYjgzMTNkZgBGAAAAAABv2lgKJBYZRoOfK2MzkdgNBwCAS5PvJdbcTKxWQLEnWOAHAAAAAAENAACAS5PvJdbcTKxWQLEnWOAHAAAaQl7dAAA%3D.EML#040000008200E00074C5B7101A82E00800000000A059FC7E8054D20100000000000000001000000067BF664FED94F14D8772488D96A9E4E92017-01-17T19:30:00+00:00
My pimitemtable now has this:
MariaDB [akonadi]> select length(remoteid) from pimitemtable where
length(remoteid) > 255;
+------------------+
| length(remoteid) |
+------------------+
| 361 |
| 361 |
| 361 |
| 361 |
| 361 |
| 361 |
| 361 |
| 363 |
| 363 |
+------------------+
9 rows in set (0.01 sec)
MariaDB [akonadi]>
And the calendar is finally working.
--
You are receiving this mail because:
You are the assignee for the bug.
