Bug 337581 - Gmail Resource will not display in kmail
Summary: Gmail Resource will not display in kmail
Status: RESOLVED UNMAINTAINED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: Gmail resource (show other bugs)
Version: GIT (master)
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Daniel Vrátil
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-18 14:37 UTC by Blackpaw
Modified: 2016-03-22 00:38 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
signature.asc (197 bytes, application/pgp-signature)
2014-07-22 23:20 UTC, Blackpaw
Details
signature.asc (197 bytes, application/pgp-signature)
2014-07-22 23:21 UTC, Blackpaw
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Blackpaw 2014-07-18 14:37:44 UTC
Have added the gmail resource - very slick and easy these days. I used akonadiconsole to do so. 
  - "Download all messages" was Checked.

Status indicates it syncing and it was hammering my network, but the resource never appeared in the kontact/kmail display.

Deleted it. This left a kio_http process flogging my net connection, which I had to kill manually.

Have re-added it via kmail but the resource is still not visible in kmail
  - "Download all messages" is not Checked.

Second time roung I got a msg about the resource being broken, and the console showed:

DATABASE ERROR:
Error code: 1062
DB error:  "Duplicate entry '203-Drafts' for key 'CollectionTable_parentAndNameIndex'"
Error text: "Duplicate entry '203-Drafts' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
Query: "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, enabled, syncPref, displayPref, indexPref, cachePolicyInherit, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10)"
Error during insertion into table "CollectionTable" "Duplicate entry '203-Drafts' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement" 

But it seems to carry on syncing after this.
Comment 1 Daniel Vrátil 2014-07-21 08:23:06 UTC
Do you happen to have two folders "Drafts", one under [Gmail] folder, and in root folder?
Comment 2 Blackpaw 2014-07-22 12:37:07 UTC
(In reply to Daniel Vrátil from comment #1)
> Do you happen to have two folders "Drafts", one under [Gmail] folder, and in
> root folder?

In my Gmail Account? yes I do. Visible in WebMail and IMAP
Comment 3 Blackpaw 2014-07-22 12:40:39 UTC
(In reply to Daniel Vrátil from comment #1)
> Do you happen to have two folders "Drafts", one under [Gmail] folder, and in
> root folder?

I marked the root Drafts folder as do not show in IMAP via the web interface and the Account is now showing.

Interestingly it still shows the Drafts folder
Comment 4 Daniel Vrátil 2014-07-22 13:25:40 UTC
It's showing the other "Drafts" folder from [Gmail] folder - the Gmail resource intentionally flattens the hierarchy (by moving folders from [Gmail] folder to top-level).

I think the best fix is to merge content of these "duplicated" folders into the one visible "Drafts" folder (or for any other such folder).
Comment 5 Blackpaw 2014-07-22 23:20:07 UTC
Created attachment 87888 [details]
signature.asc

On Tue, 22 Jul 2014 01:25:40 PM you wrote:
> It's showing the other "Drafts" folder from [Gmail] folder - the Gmail
> resource intentionally flattens the hierarchy (by moving folders from
> [Gmail] folder to top-level).
> 
> I think the best fix is to merge content of these "duplicated" folders into
> the one visible "Drafts" folder (or for any other such folder).


Sounds like a plan to me.

Unfortunately I'm off to NZ for a few days, so will be unable to test to next 
week.


Cheers,
Comment 6 Blackpaw 2014-07-22 23:21:33 UTC
Created attachment 87889 [details]
signature.asc

On Tue, 22 Jul 2014 01:25:40 PM you wrote:
> It's showing the other "Drafts" folder from [Gmail] folder - the Gmail
> resource intentionally flattens the hierarchy (by moving folders from
> [Gmail] folder to top-level).
> 
> I think the best fix is to merge content of these "duplicated" folders into
> the one visible "Drafts" folder (or for any other such folder).


p.s None of the folders except the (ironically) the Spam folder appeared to be 
sync'ing, but I lacked the time to follow it up.
Comment 7 Blackpaw 2016-03-22 00:38:23 UTC
Obsolete now