GNOME Bugzilla – Bug 719806
[IMAP+] Empty trash doesn't work with a real trash folder
Last modified: 2014-02-12 10:42:19 UTC
File-Empty trash doesn't empty the trash. Also I have 'Empty trash folders' set to On exit, once per day, but this doesn't work either. If I select all of the files in trash and delete them, that works. See attached log.
Created attachment 263448 [details] log file generated with CAMEL_DEBUG=all evolution >& evo2.log
Extracted from attached log: DB SQL operation [BEGIN] started Camel SQL Exec: BEGIN Camel SQL Exec: CREATE TABLE IF NOT EXISTS Deletes (id INTEGER primary key AUTOINCREMENT not null, uid TEXT, time TEXT, mailbox TEXT) Camel SQL Exec: INSERT OR REPLACE INTO Deletes (uid, mailbox, time) SELECT uid, '.#evolution/Junk', strftime("%s", 'now') FROM '.#evolution/Junk' Error in SQL EXEC statement: INSERT OR REPLACE INTO Deletes (uid, mailbox, time) SELECT uid, '.#evolution/Junk', strftime("%s", 'now') FROM '.#evolution/Junk' [no such table: .#evolution/Junk]. Camel SQL Exec: DELETE FROM folders WHERE folder_name = '.#evolution/Junk' Camel SQL Exec: DROP TABLE '.#evolution/Junk' Error in SQL EXEC statement: DROP TABLE '.#evolution/Junk' [no such table: .#evolution/Junk]. Camel SQL Exec: DROP TABLE '.#evolution/Junk_bodystructure' Error in SQL EXEC statement: DROP TABLE '.#evolution/Junk_bodystructure' [no such table: .#evolution/Junk_bodystructure]. Camel SQL Exec: COMMIT DB Operation ended. Time Taken : 0.000245 ########### DB SQL operation [BEGIN] started Camel SQL Exec: BEGIN Camel SQL Exec: CREATE TABLE IF NOT EXISTS Deletes (id INTEGER primary key AUTOINCREMENT not null, uid TEXT, time TEXT, mailbox TEXT) Camel SQL Exec: INSERT OR REPLACE INTO Deletes (uid, mailbox, time) SELECT uid, 'Untitled', strftime("%s", 'now') FROM 'Untitled' Error in SQL EXEC statement: INSERT OR REPLACE INTO Deletes (uid, mailbox, time) SELECT uid, 'Untitled', strftime("%s", 'now') FROM 'Untitled' [no such table: Untitled]. Camel SQL Exec: DELETE FROM folders WHERE folder_name = 'Untitled' Camel SQL Exec: DROP TABLE 'Untitled' Error in SQL EXEC statement: DROP TABLE 'Untitled' [no such table: Untitled]. Camel SQL Exec: DROP TABLE 'Untitled_bodystructure' Error in SQL EXEC statement: DROP TABLE 'Untitled_bodystructure' [no such table: Untitled_bodystructure]. Camel SQL Exec: COMMIT DB Operation ended. Time Taken : 0.000325 ########### DB SQL operation [BEGIN] started Camel SQL Exec: BEGIN Camel SQL Exec: CREATE TABLE IF NOT EXISTS Deletes (id INTEGER primary key AUTOINCREMENT not null, uid TEXT, time TEXT, mailbox TEXT) Camel SQL Exec: INSERT OR REPLACE INTO Deletes (uid, mailbox, time) SELECT uid, '.#evolution/Trash', strftime("%s", 'now') FROM '.#evolution/Trash' Error in SQL EXEC statement: INSERT OR REPLACE INTO Deletes (uid, mailbox, time) SELECT uid, '.#evolution/Trash', strftime("%s", 'now') FROM '.#evolution/Trash' [no such table: .#evolution/Trash]. Camel SQL Exec: DELETE FROM folders WHERE folder_name = '.#evolution/Trash' Camel SQL Exec: DROP TABLE '.#evolution/Trash' Error in SQL EXEC statement: DROP TABLE '.#evolution/Trash' [no such table: .#evolution/Trash]. Camel SQL Exec: DROP TABLE '.#evolution/Trash_bodystructure' Error in SQL EXEC statement: DROP TABLE '.#evolution/Trash_bodystructure' [no such table: .#evolution/Trash_bodystructure]. Camel SQL Exec: COMMIT DB Operation ended. Time Taken : 0.000345
Empty Trash works fine for virtual Trash folders. We haven't yet completed the illusion of file-manager-style Trash folders yet. Still have to explicitly mark messages for deletion, even if the messages are in an IMAP folder is named "Trash".
see: https://bugs.launchpad.net/ubuntu/+source/evolution/+bug/1265768
*** Bug 723376 has been marked as a duplicate of this bug. ***
I fixed this for 3.12.0: Created commit 112aae3 in eds master (3.11.90+) [1] [1] https://git.gnome.org/browse/evolution-data-server/commit/?id=112aae3