[Akonadi] [Bug 394839] New: pimitemtable.remoteid Column Too Small For Exchange Calendar Via davmail
Garry Williams
bugzilla_noreply at kde.org
Tue May 29 22:02:46 BST 2018
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: kdepim-bugs at kde.org
Reporter: gtwilliams at gmail.com
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/garry_williams2@comcast.com/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.
More information about the Kdepim-bugs
mailing list