[Akonadi] [Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Denis Kurz changed: What|Removed |Added Status|NEEDSINFO |RESOLVED Resolution|WAITINGFORINFO |UNMAINTAINED --- Comment #17 from Denis Kurz --- Just as announced in my last comment, I close this bug. If you encounter it again in a recent version (at least 5.0 aka 15.08), please open a new one unless it already exists. Thank you for all your input. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Denis Kurz changed: What|Removed |Added Resolution|--- |WAITINGFORINFO Status|CONFIRMED |NEEDSINFO --- Comment #16 from Denis Kurz --- This bug has only been reported for versions older than KDEPIM 4.14 (at most akonadi-1.3). Can anyone tell if this bug still present? If noone confirms this bug for a recent version of akonadi (part of KDE Applications 15.08 or later), it gets closed in about three months. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #15 from Modestas Vainius --- I did not experience this when I migrated my kmail 1 accounts with kdepim(libs) 4.8.4 today. It has been fixed probably. -- You are receiving this mail because: You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Laurent RINEAU changed: What|Removed |Added CC||Laurent.Rineau__kde@normale ||sup.org -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Christophe Giboudeaux changed: What|Removed |Added Component|folders |Migration Version|1.99.0 |4.7 Product|kmail2 |Akonadi --- Comment #14 from Christophe Giboudeaux 2011-09-13 21:14:34 --- Thanks -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #13 from Arne K. Haaje 2011-09-13 18:03:28 --- Yes, it is the migration that fails. I've tested on two different machines, and if account is created from scratch, then the subfolders are populated. If the accounts are migrated, then the subfolders are empty -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #12 from Christophe Giboudeaux 2011-09-13 15:27:53 --- that *only* happens when migrating accounts, right ? -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Ferdinand Gassauer changed: What|Removed |Added CC||gassa...@kde.org --- Comment #11 from Ferdinand Gassauer 2011-08-03 08:52:50 --- same problem with mailstore: cyrus imap deleting and recreating fixes the ssue -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #10 from FiNeX 2011-07-27 21:22:57 --- Humm... I've deleted the account from Kmail and I've recreated a new one and now it shows all my emails... :-/ -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 FiNeX changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||fi...@finex.org Ever Confirmed|0 |1 --- Comment #9 from FiNeX 2011-07-27 20:57:24 --- I confirm the bug. I've migrated an IMAP account (dovecot) with about 5 email and hundred of subfolders and all looks empty :-( Unfortunatly I don't have time to play with scripts and configuration files. So I will downgrade to KMail 1 until KMail 2 is an alpha-quality version :-( bye :-) -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Markus Rennings changed: What|Removed |Added CC||b...@rennings.net --- Comment #8 from Markus Rennings 2011-07-08 20:40:02 --- Same here (Arch Linux, KMail 2.1.1), the IRC snippet helped -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #7 from Richard Homonnai 2011-06-28 09:13:31 --- Well, this fixed it for me. If anybody also uses SQlite, here's the query: update collectiontable set remoteid = '.' || substr(remoteid,2) where id >= 80 AND id <= 85 of course, replace 80 and 85 accordingly. I for myself just updated all rows and then fixed a few (3, I think) calendar entries by hand. Was much less effort than the 114 broken subdirs on four mail servers ;) The most safe approach might be: update collectiontable set remoteid = '.' || substr(remoteid,2) where remoteid NOT LIKE '/home/username/%' of course, assuming all your local calendars are on your home. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #6 from Modestas Vainius 2011-06-27 10:08:37 --- Richard, of course you can edit using SQLite tools. You might just need to adapt SQL syntax a bit. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #5 from Modestas Vainius 2011-06-27 10:07:11 --- AFAIK '.' is more common than '/' among IMAP servers. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #4 from Arne K. Haaje 2011-06-27 10:01:43 --- I deleted the account in Kmail2 (which as imported by the migrator), then recreated it manually. That fixed it for me. -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 --- Comment #3 from Richard Homonnai 2011-06-27 09:59:32 --- I am using Dovecot on one of my servers, the others have Courier-IMAP I think. Is this one also affected by this bug? Because on both of them I don't see any subfolder contents. Can I edit the db with normal SQLite tools if using SQLite? Or is there something to keep in mind? -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418
--- Comment #2 from Modestas Vainius 2011-06-27 09:52:23
---
In short the cause of this bug is that migrator assumes (or misdetects) that a
IMAP hierarchy separator. It assumes it to be '/' (GMail default) while dovecot
uses '.' by default. If you're using akonadi mysql backend (if not, you can
still adapt the instructions), read the IRC conversation below to fix this for
your setup. Please note that these instructions deal with consequences, not the
cause.
[Wednesday 15 June 2011] [01:07:42] do have imap folders like
INBOX/something ?
[Wednesday 15 June 2011] [01:07:55] or rather INBOX.something
[Wednesday 15 June 2011] [01:08:51] On my private accout all
folders are subfolders of INBOX
[Wednesday 15 June 2011] [01:09:19] and they open fine?
[Wednesday 15 June 2011] [01:09:24] yes
[Wednesday 15 June 2011] [01:09:35] MoDaX: wait
[Wednesday 15 June 2011] [01:09:38] no they don't
[Wednesday 15 June 2011] [01:09:41] heh
[Wednesday 15 June 2011] [01:09:44] :S
[Wednesday 15 June 2011] [01:10:39] Did I lose all my mails in
INBOX/sent ?
[Wednesday 15 June 2011] [01:11:10] otherperson: not yet
[Wednesday 15 June 2011] [01:11:19] promising words :D
[Wednesday 15 June 2011] [01:11:19] kmail2 does not show them
[Wednesday 15 June 2011] [01:11:57] MoDaX: strange is, that I
sent a test mail, and it (and only it) is visibile in IBOX/sent
[Wednesday 15 June 2011] [01:12:43] otherperson: akonadi cached it,
it's not on the imap server though
[Wednesday 15 June 2011] [01:12:54] ok
[Wednesday 15 June 2011] [01:13:01] you better delete it
[Wednesday 15 June 2011] [01:13:08] so how do I make
subfolders visibile
[Wednesday 15 June 2011] [01:13:12] ok
[Wednesday 15 June 2011] [01:13:27] otherperson: scroll back to my
backlog from yesterday
[Wednesday 15 June 2011] [01:13:53] I hope you use mysql as akonadi
backend, don't you?
[Wednesday 15 June 2011] [01:14:39] MoDaX: yes
[Wednesday 15 June 2011] [01:16:10] otherperson: this is going to be
a bit tricky. connect to mysql server
[Wednesday 15 June 2011] [01:16:12] mysql --socket
~/.local/share/akonadi/socket-`hostname`/mysql.socket
[Wednesday 15 June 2011] [01:16:47] there do 'use akonadi'
[Wednesday 15 June 2011] [01:17:14] database changed
[Wednesday 15 June 2011] [01:18:02] otherperson: select id,
remoteid, name, parentid from collectiontable;
[Wednesday 15 June 2011] [01:18:16] remember IDs of your imap
folders
[Wednesday 15 June 2011] [01:19:17] stop kmail2
[Wednesday 15 June 2011] [01:19:23] where to find the ID's
[Wednesday 15 June 2011] [01:19:29] IDs
[Wednesday 15 June 2011] [01:19:43] otherperson: select gave them to
you
[Wednesday 15 June 2011] [01:19:51] first column
[Wednesday 15 June 2011] [01:20:10] MoDaX: ahh, overread that
line
[Wednesday 15 June 2011] [01:20:12] ok
[Wednesday 15 June 2011] [01:20:30] kmail stoped
[Wednesday 15 June 2011] [01:21:25] your mailbox subfolders should
be sequential and fit into min <= id AND id <= max . find those min and max
from the output
[Wednesday 15 June 2011] [01:22:33] so there is a line:
7->imap:... and all in between until 27->/Trash
[Wednesday 15 June 2011] [01:22:51] is then 8-27 ?
[Wednesday 15 June 2011] [01:23:00] yeah
[Wednesday 15 June 2011] [01:23:13] what you need to do here is to
change the first symbol of remoteid column from '/' to '.'
[Wednesday 15 June 2011] [01:23:14] ok
[Wednesday 15 June 2011] [01:23:37] update collectiontable set
remoteid = concat('.', substr(remoteid from 2)) where id >= 80 AND id <= 85
[Wednesday 15 June 2011] [01:23:43] replace min and max
[Wednesday 15 June 2011] [01:25:47] then in another console restart
akonadi (akonadictl restart). mysql server will restart, reconnect to it and
recheck with select if remoteid where actually changed
[Wednesday 15 June 2011] [01:27:37] ok, went fine I guess
[Wednesday 15 June 2011] [01:27:42] start kmail2 ?
[Wednesday 15 June 2011] [01:28:08] really annoying bug
[Wednesday 15 June 2011] [01:28:24] imagine explaining this to
old users at a university
[Wednesday 15 June 2011] [01:28:29] yeah, start it
[Wednesday 15 June 2011] [01:28:46] folder icons should be back too
now
[Wednesday 15 June 2011] [01:28:53] MoDaX: Yippie
[Wednesday 15 June 2011] [01:29:00] thanks a lot
[Wednesday 15 June 2011] [01:29:55] but kmail2 might still eat your
mail. better disable automatic expurging in account settings. might help
[Wednesday 15 June 2011] [01:30:20] I think I have already "saved" 5
mails with this today
[Wednesday 15 June 2011] [01:30:33] they are both 'deleted' and
'unread' now :)
--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Kdepim
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Arne K. Haaje changed: What|Removed |Added CC||a...@drlinux.no --- Comment #1 from Arne K. Haaje 2011-06-27 09:08:00 --- I can confirm this with Kmail 2.1.0 on KDE 4.6.4. IMAP server in use is Dovecot 1.2.12 All subfolders appear empty. The containing folder appear to have a correct message count. Possibly important, the subfolders are not under the inbox (which is named INBOX). The containign folders are all on the same level as INBOX, like this; Afolder Bfolder Container1 - some messages Subfolder1 Subfolder2 Dfolder Efolder INBOX Ffolder ListcontainerFolder List1 List2 OneMoreFolder and so on. All folders on the first level are correct. The subfolders appear empty -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 275418] IMAP (sub-)subfolders empty in kmail2
https://bugs.kde.org/show_bug.cgi?id=275418 Modestas Vainius changed: What|Removed |Added CC||modes...@vainius.eu -- Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email --- You are receiving this mail because: --- You are the assignee for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
