Intrepid Ibex: Cannot empty Evolution Trash : [no such table: Templates]

[Mark Mandel]

Binary package hint: evolution

On Intrepid Ibex, Alpha 5 (up to date)

* Exported my mail from Evolution.
* Installed Ibex
* Imported my mail from the backup file.
* Managed some mail.
* Right click on the 'Trash' folder and click 'Empty Trash'
* Nothing Happens / Evolution Crashes.

If I run it in console the error I get is:

(evolution:28732): camel-WARNING **: Error storing '~/.evolution/mail/local/Inbox (mbox)': Summary and folder mismatch, even after a sync
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Templates' WHERE deleted = 1 [no such table: Templates]
Saving 1353/2761 dirty records of Inbox

[Sebastien Bacher (seb128)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. However, your crash report is either missing or challenging to deal with as a '.crash' file. Please follow these instructions to have apport report a new bug about your crash that can be dealt with by the automatic retracer.

 If you are running the Ubuntu Stable Release you might need to enable apport in /etc/default/apport and restart.

 If you are using Ubuntu with the Gnome desktop environment - launch nautilus and navigate to your /var/crash directory and double click on the crash report you wish to submit.

 If you are using Kubuntu or Xubuntu you can file the crash using /usr/share/apport/apport-qt --crash-file=/var/crash/_my_crash_report.crash in a terminal - where _my_crash_report.crash is the crash you would like to report.
 I'm closing this bug report since the process outlined above will automatically open a new bug report which can then dealt with more efficiently. Thanks in advance for your cooperation and understanding.

[lilbudda (cory-meisch-gmail)]

Getting similar error message:

evolution-shell-Message: Killing old version of evolution-data-server...
** (evolution:31934): DEBUG: mailto URL command: evolution %s
** (evolution:31934): DEBUG: mailto URL program: evolution
store_db_path /home/cmeisch/.evolution/mail/local/folders.db
folders table successfully created
store_db_path /<email address hidden>@exchange.pcthome.com/folders.db
folders table successfully created
store_db_path /<email address hidden>/folders.db
folders table successfully created

(evolution:31934): libecal-WARNING **: e-cal.c:318: Unexpected response

(evolution:31934): libecal-WARNING **: e-cal.c:318: Unexpected response
Changing the queries (contains? "summary" "")

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: Drafts

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: Queue

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: Sent

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: Trash

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: [Gmail]

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: [Gmail]/Spam

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: [Gmail]/Trash

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: [Imap]

(evolution:31934): camel-imap-provider-WARNING **: Unable to load summary no such table: gmskin:slate,1,1,1,1,1,1,1,1,0

e-data-server-ui-Message: Unable to find password(s) in keyring (Keyring reports: No matching results)
e-data-server-ui-Message: Key file does not have group 'Passwords-Mail'

(evolution:31934): camel-exchange-provider-WARNING **: Unable to load Exchage summary for folder personal/RSS Feeds: no such table: personal/RSS Feeds

Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/RSS Feeds' [no such table: personal/RSS Feeds]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/RSS Feeds' WHERE junk = 1 [no such table: personal/RSS Feeds]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/RSS Feeds' WHERE deleted = 1 [no such table: personal/RSS Feeds]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/RSS Feeds' WHERE read = 0 [no such table: personal/RSS Feeds]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/RSS Feeds' WHERE junk = 0 AND deleted = 0 [no such table: personal/RSS Feeds]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/RSS Feeds' WHERE junk = 1 AND deleted = 0 [no such table: personal/RSS Feeds]
Triggering summary_reloaded on INBOX 0xa758ea8
Saving 1/6230 dirty records of INBOX
store_db_path /home/cmeisch/.evolution/mail/vfolder/folders.db
folders table successfully created
removing cache for INBOX 6230 0xaf597118
done .. now 1

(evolution:31934): Gtk-CRITICAL **: gtk_widget_get_clipboard: assertion `gtk_widget_has_screen (widget)' failed
Saving 1/600 dirty records of personal/Inbox

(evoluti...

[Sebastien Bacher (seb128)]

do you still get the issue using the current version? could you open the bug on bugzilla.gnome.org too where the people writting the software will read it?

[oss_test_launchpad (oss-test-launchpad)]

Confirmed for Ubuntu 8.10 as of today with Evolution 2.24.0. On the first attempt, Evolution started emptying the Trash folder but then said "Error while expunging folder". On the second attempt, Evolution crashed (closed without any comment).

[Wilbur Harvey (wilbur-harvey-spirentcom)]

I am getting the same basic error, but so far, my evolution hasn't crashed.
It has, however, seemed to loose a lot of my email messages during the last month.
Older messages seem to be there.

I have the latest Interepid with all updates as of this morning.

wharvey@hnlwnh:~/Desktop$ evolution --version
GNOME evolution 2.24.0

evolution-shell-Message: Killing old version of evolution-data-server...
** (evolution:1753): DEBUG: mailto URL command: evolution %s
** (evolution:1753): DEBUG: mailto URL program: evolution
store_db_path /home/wharvey/.evolution/mail/local/folders.db
folders table successfully created
store_db_path /home/wharvey/.evolution/mail/exchange/wharvey@10.12.0.19/folders.db
folders table successfully created
store_db_path /home/wharvey/.evolution/mail/vfolder/folders.db
folders table successfully created

(evolution:1753): camel-exchange-provider-WARNING **: Unable to load Exchage summary for folder personal/System Cleanup: no such table: personal/System Cleanup

Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/System Cleanup' [no such table: personal/System Cleanup]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/System Cleanup' WHERE junk = 1 [no such table: personal/System Cleanup]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/System Cleanup' WHERE deleted = 1 [no such table: personal/System Cleanup]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/System Cleanup' WHERE read = 0 [no such table: personal/System Cleanup]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/System Cleanup' WHERE junk = 0 AND deleted = 0 [no such table: personal/System Cleanup]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'personal/System Cleanup' WHERE junk = 1 AND deleted = 0 [no such table: personal/System Cleanup]
Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Templates' WHERE deleted = 1 [no such table: Templates]
wharvey@hnlwnh:~/Desktop$

[salubrium (mcampbell-mosqhoy)]

Here's something that can help... I am not responsible if you trash your email, so do the following at your own risk. I do not know if there's supposed to be more to the schema of the Templates table. I just guessed it until it complained no longer.

$ sqlite3 /home/<username>/.evolution/mail/local/folders.db

now you are at the sqlite command prompt:

We create the table with a single field which happens to be the primary key also.

sqlite> CREATE TABLE 'Templates' ( deleted TEXT PRIMARY KEY);

that fixes the first problem with the missing table and field. The second problem was that my Junk and Trash folder had messages that I had to get rid of as there seemed to be a problem with the index in that it couldn't find the messages there. You may not have to do this part.

sqlite> delete * from ".#evolution/Trash";
sqlite> delete * from ".#evolution/Junk";
sqlite> .quit

I can now delete emails from my inbox of my pop3 accounts.

[Sebastien Bacher (seb128)]

the issue is similar to bug #281093

[Sebastien Bacher (seb128)]

do you still get the bug in the current intrepid version?

[Ivan Brasil Fuzzer (ivanbrasil)]

In last update e error not ocurred.

[Antoine Pairet (b-ly)]

After doing the trick of salubrium, I don't experience the problem anymore. I'm able to to empty trash without crash nor warnings.
Is the bug solved and should this report be marked as "Fix Released"?

[salubrium (mcampbell-mosqhoy)]

I also haven't had any issues since I applied my above suggestions, sorry.

[Sebastien Bacher (seb128)]

closing the bug since that works correctly now, you can reopen if you still get the issue though

[Daniel Dumitrache (dandu)]

I had the exact same problem with Evolution 2.24.1.1 (Intrepid) and managed to fix it with salubrium's "CREATE TABLE" (the other queries returned an error). Maybe the bug should be reopened, it was a clean installation and I only imported some mails.

[Daniel Dumitrache (dandu)]

googled some more, found various references about this bug, no solution worked. I also had an IMAP account, after I disabled it Evolution didn't crash any more, but gave me this error message: "Error storing '~/.evolution/mail/local/Templates (mbox)': Summary and folder mismatch, even after a sync [... ]" (the error said the same thing about Drafts and Sent too).

The fix (for me at least):
- $ evolution --force-shutdown
- backup and remove all the files for those folders from .evolution/mail/local/
- start evolution, everything is ok now (with IMAP enabled also)
- import the mails in those folders from the backup

I don't know what triggered the bug.

The backtrace of the crash (while having the IMAP account enabled) is rather useless:
[ ... ]
(no debugging symbols found)
Core was generated by `evolution'.
Program terminated with signal 11, Segmentation fault.
[New process 18100]
[New process 18028]
[New process 18101]
[New process 18083]
#0 0xb4a2098b in ?? () from /usr/lib/evolution-data-server-1.2/camel-providers/libcamelimap.so
(gdb) quit

[Daniel Dumitrache (dandu)]

got a somehow full trace:
#0 0xb4ac898b in ?? () from /usr/lib/evolution-data-server-1.2/camel-providers/libcamelimap.so
#1 0xb4ac9c31 in ?? () from /usr/lib/evolution-data-server-1.2/camel-providers/libcamelimap.so
#2 0xb4aca6fd in ?? () from /usr/lib/evolution-data-server-1.2/camel-providers/libcamelimap.so
#3 0xb7da1976 in camel_folder_sync () from /usr/lib/libcamel-provider-1.2.so.14
#4 0xb7dc6de2 in ?? () from /usr/lib/libcamel-provider-1.2.so.14
#5 0xb7dc0cad in ?? () from /usr/lib/libcamel-provider-1.2.so.14
#6 0xb7da16cf in camel_folder_expunge () from /usr/lib/libcamel-provider-1.2.so.14
#7 0xb5ef8dd2 in ?? () from /usr/lib/evolution/2.24/components/libevolution-mail.so
#8 0xb5ef5da9 in ?? () from /usr/lib/evolution/2.24/components/libevolution-mail.so
#9 0xb6ac56c6 in ?? () from /usr/lib/libglib-2.0.so.0
#10 0xb6ac402f in ?? () from /usr/lib/libglib-2.0.so.0
#11 0xb797850f in start_thread () from /lib/tls/i686/cmov/libpthread.so.0
#12 0xb69e27ee in clone () from /lib/tls/i686/cmov/libc.so.6

[wlx (wangliangxu)]

Confirmed in evolution 2.24.1.1, but can be solved with salubrium's solution.

[wlx (wangliangxu)]

It should be cleared with salubrium's solution that the Templates table should not be created, you should create a template email in evolution, and then just use sqlite3 to empty the Trash/Junk table.