GNOME Bugzilla – Bug 578910
Error while getting mail
Last modified: 2009-10-26 04:57:00 UTC
Every time I receive a mail from a certain mailing list that have a filter to move it to a folder I get an error with a message like: "Table foobar has 26 columns but 28 values were supplied" or something like that, I lost the error message. It looks like an sqlite error message. And the main problem is that the mail is lost!. It only happens with that mailing list.
Carlos, what was your version of Evolution you used? I remember fixing up a patch for this in 2.26.0. Can you confirm me your version ?
It's 2.27.3
Cool. If this is replicable, then export CAMEL_DEBUG=all <clear console> evolution. wait till the problem happens, and once it occurs, then copy the console log and paste me. Caution, it might be very verbose to expose your mails down here. Feel free to strip the contents. Thanks Carlos
Carlos, thanks a lot. I will debug this.
Seeing the logs it seems that your wasn't migrated during 2.26. I need to analyse why. But to confirm my statement. Can you open the folders.db relating to the account of (KaL/GSyC) and do .schema "KaL/GSyc" and paste me?
(In reply to comment #5) > Seeing the logs it seems that your wasn't migrated during 2.26. I need to > analyse why. But to confirm my statement. > it only happens with this certain a mailing list. > > Can you open the folders.db relating to the account of (KaL/GSyC) and do > .schema "KaL/GSyc" and paste me? > sqlite> .schema KaL/GSyC CREATE TABLE 'KaL/GSyC' ( uid TEXT PRIMARY KEY , flags INTEGER , msg_type INTEGER , read INTEGER , deleted INTEGER , replied INTEGER , important INTEGER , junk INTEGER , attachment INTEGER , msg_security INTEGER , size INTEGER , dsent NUMERIC , dreceived NUMERIC , subject TEXT , mail_from TEXT , mail_to TEXT , mail_cc TEXT , mlist TEXT , followup_flag TEXT , followup_completed_on TEXT , followup_due_by TEXT , part TEXT , labels TEXT , usertags TEXT , cinfo TEXT , bdata TEXT ); CREATE INDEX 'DELINDEX-KaL/GSyC' ON 'KaL/GSyC' (deleted); CREATE INDEX 'JUNKINDEX-KaL/GSyC' ON 'KaL/GSyC' (junk); CREATE INDEX 'READINDEX-KaL/GSyC' ON 'KaL/GSyC' (read); CREATE INDEX 'SINDEX-KaL/GSyC' ON 'KaL/GSyC' (uid, flags, size, dsent, dreceived, subject, mail_from, mail_to, mail_cc, mlist, part, labels, usertags, cinfo);
As I suspect this folder wasn't migrated to new schema. There was gap in Evo code where the migration was bad. I think it might have happened then. Lemme see, how to fix tihs. But thanks for your help
hmm, so I guess it might be fixed with and alter table or something like that. Anyway, I think evo should *never* lose e-mails, when something goes wrong it should send the e-mails to another folder , draft or whatever.
Created attachment 141137 [details] [review] This should fix it. So this patch takes care of any such problems by migrating those folders.
Fixed to git tip.
Created commit 12be604 in eds master (2.29.1+) Created commit b9deaf9 in eds gnome-2-28 (2.27.92+) a) removed a debug printf b) did test less aggressive c) extended the g_warning to know what folder it is working on
*** Bug 599592 has been marked as a duplicate of this bug. ***