Bug 337581

Summary:	Gmail Resource will not display in kmail
Product:	[Frameworks and Libraries] Akonadi	Reporter:	Blackpaw <lindsay.mathieson>
Component:	Gmail resource	Assignee:	Daniel Vrátil <dvratil>
Status:	RESOLVED UNMAINTAINED
Severity:	normal	CC:	kdepim-bugs, lindsay.mathieson
Priority:	NOR
Version:	GIT (master)
Target Milestone:	---
Platform:	Other
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:
Attachments:	signature.asc signature.asc

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