Re: [Dbmail-dev] SQLException after upgrade to current git

Yeah - thats not the right flag. use -d for no data. Thats what I get for using my memory instead of my man! -Jon Uwe Kiewel wrote: > Jonathan Feally schrieb: > >> Check your mysqldump -t dbmail against the create_tables.sql to find any >> differences that need correction. You could also sen

Re: [Dbmail-dev] SQLException after upgrade to current git

Paul J Stevens schrieb: > Eh, I think Jon meant -d. _That_ makes sense. Thanks, Uwe > > > > Uwe Kiewel wrote: >> Jonathan Feally schrieb: >>> Check your mysqldump -t dbmail against the create_tables.sql to find any >>> differences that need correction. You could also sent that outpu

Re: [Dbmail-dev] SQLException after upgrade to current git

Eh, I think Jon meant -d. Uwe Kiewel wrote: > Jonathan Feally schrieb: >> Check your mysqldump -t dbmail against the create_tables.sql to find any >> differences that need correction. You could also sent that output to me >> offlist so I can try to figure out where it went wrong. > > from th

Re: [Dbmail-dev] SQLException after upgrade to current git

Jonathan Feally schrieb: > Check your mysqldump -t dbmail against the create_tables.sql to find any > differences that need correction. You could also sent that output to me > offlist so I can try to figure out where it went wrong. from the mysqldump man page: --no-create-info, -t

Re: [Dbmail-dev] SQLException after upgrade to current git

Check your mysqldump -t dbmail against the create_tables.sql to find any differences that need correction. You could also sent that output to me offlist so I can try to figure out where it went wrong. Also, you are moving from which 2.2.x to 2.3-git (post 2.3.5)?? -Jon Uwe Kiewel wrote: > Alek

Re: [Dbmail-dev] SQLException after upgrade to current git

Aleksander Kamenik wrote: > Uwe Kiewel wrote: >> Paul J Stevens wrote: >>> Uwe, >>> >>> you need to apply all the relevant migration scripts in sql/XXsql/... >>> *and* run dbmail-util -by >> I have trouble to apply the update scripts. MySQL says "cannot create >> table errno 150". > > That sounds

Re: [Dbmail-dev] SQLException after upgrade to current git

Uwe Kiewel wrote: > Paul J Stevens wrote: >> Uwe, >> >> you need to apply all the relevant migration scripts in sql/XXsql/... >> *and* run dbmail-util -by > > I have trouble to apply the update scripts. MySQL says "cannot create > table errno 150". > > For the dbmail_partlists table I did the cre

Re: [Dbmail-dev] SQLException after upgrade to current git

Uwe Kiewel wrote: > Paul J Stevens wrote: >> Uwe, >> >> you need to apply all the relevant migration scripts in sql/XXsql/... >> *and* run dbmail-util -by > > I have trouble to apply the update scripts. MySQL says "cannot create > table errno 150". That sounds too familiar: SET FOREIGN_KEY_CHECK

Re: [Dbmail-dev] SQLException after upgrade to current git

Paul J Stevens wrote: > Uwe, > > you need to apply all the relevant migration scripts in sql/XXsql/... > *and* run dbmail-util -by I have trouble to apply the update scripts. MySQL says "cannot create table errno 150". For the dbmail_partlists table I did the creation step by step and found out,

Re: [Dbmail-dev] SQLException after upgrade to current git

Uwe, you need to apply all the relevant migration scripts in sql/XXsql/... *and* run dbmail-util -by The latest migration nuked the dbmail_headervalue table which needs to be re-filled. Uwe Kiewel wrote: > Hi, > > I took a backup of my dbmail-2.2 db and migrated it to the latest git. > I can o

[Dbmail-dev] SQLException after upgrade to current git

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I took a backup of my dbmail-2.2 db and migrated it to the latest git. I can open and read the emails but thunderbird does not show Sender, Subject, Date. The logfile sayes: Apr 15 21:32:47 dedi0031 dbmail/imap4d[19498]: [0x80abdb8] Error:[db] d