GNOME Bugzilla – Bug 552403
SQL errors upon mail sending: no such table Outbox
Last modified: 2009-01-29 16:46:38 UTC
this report has been filed here: https://bugs.edge.launchpad.net/ubuntu/+source/evolution/+bug/269508 "When sending a mail, the outbox gets marked with an "(1)" indicating there is one new message in it. When the mails gets sent, this indicator disappears. But when I run evolution from the console, I see some SQL errors appear right on the moment that "(1)" disappears. The errors i'm speaking about: Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE junk = 1 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE deleted = 1 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE read = 0 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE junk = 0 AND deleted = 0 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE junk = 1 AND deleted = 0 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE junk = 1 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE deleted = 1 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE read = 0 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE junk = 0 AND deleted = 0 [no such table: Outbox] Error in SQL SELECT statement: SELECT COUNT (*) FROM 'Outbox' WHERE junk = 1 AND deleted = 0 [no such table: Outbox]" "It's a fresh install, but I did import mails and settings through the backup plugin (exported and imported it through the item in menu File). But I did not re-use the .evolution folder + gnome-settings." "This doesn't seem to be a migration/corruption problem after all, as creating a fresh test user and sending a mail results in exactly the same error" error log from a fresh user while setting up evolution with the wizard utility: http://launchpadlibrarian.net/17626515/evolution_initial.log Thanks,
For the sake of clarity, this bug gets triggered on two different occasions: 1) when sending a mail (existing profile as well as fresh user); 2) when running the initial wizard, which configures a new user.
Which exact version is this about?
Used software: * evolution, evolution common, evolution data server et al are version 2.23.91-0ubuntu1; * libraries (libebackend, libedataserver, ...) are version 2.23.92-0ubuntu1.
Guys, I have made it verbose for debugging purpose. Atleast I dont want to disable till 2.24.1. I hope to see more issues when 2.24.0 gets out. These would help me fix issues.
Created attachment 120025 [details] Evolution Debug Log
Hello I'm having this issue too on Evolution 2.24.0 It was an upgrade from an older version where the issue started happening but I'm now doing the following: close evolution evolution --force-shutdown killall gconfd-2 rm -rf .evolution .gconf/apps/evolution Then I start evolution again and it starts the first-run wizard. I go through this and fill out all the details fine. Then when the actual mail window opens it shows the correct mail count for the inbox total but doesn't show any mails in the main window. Running evolution as E2K_DEBUG=5 evolution >& evo.log shows the errors as SQL select errors. I've attached the log produced. The app doesn't crash, it just doesn't show my mail. Please let me know if you need me to try anything. Thanks
To be exact, these warning are just verbose, and no harm. I want them to be verbose, so that, on fatal, I could grab these. I hope its fine. Please re-open if you have more points. Thanks.