On Dec 30, 2007 4:58 PM, Paul J Stevens <[EMAIL PROTECTED]> wrote: > > What version of mysql are you on? >
4.1.12 > > zamri wrote: > > > > > > On Dec 29, 2007 10:49 AM, zamri <[EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > Hi all, > > > > After upgrading to 2.2.8, I ran dbmail-export but got this error: > > > > dbmail-export -u john -m Spam -o john/Junk.mbox > > Exporting [1] mailboxes for [john] > > export mailbox Spam -> john/Junk.mbox > > Dec 29 10:38:55 webmail.broder dbmail-export[4712]: Error:[sql] > > dbmysql.c,db_query(+290): [Unknown column 'dbmail.p.physmessage_id' > > in 'on clause'] [SELECT > > is_header,messageblk,DATE_FORMAT(internal_date, '%Y-%m-%d %T') FROM > > dbmail_messageblks b JOIN dbmail_physmessage p ON b.physmessage_id = > > p.id <http://p.id> JOIN dbmail_messages m USING (physmessage_id) > > WHERE message_idnr IN > > > (545444,545901,547191,547192,547193,549590,555072,555074,555291,556696,556997,557706,557708,557709,557710,557921,558127,558617,558618,558619,560007,561858,561859,562483,565392,566146,566168,567159,568125,568126,568127,568128,568276,571074,571075,571076,571077,571080,572228,572229,573626,574433,574457,576370,576371,578232,578233,578234,580457,580463,584514,585318,587663,587672,596101,596102,596103,596104,596110,596111,596112,596113,596114,596115,596116,596155,596328,596329,596376,596797) > > ORDER BY messageblk_idnr ] > > Export failed > > error exporting mailbox Spam -> john/Junk.mbox > > Command failed. > > > > It was fine with 2.2.7. What should i do? > > > > <http://muhdzamri.blogspot.com> > > > > Anyone? > > > > > > > > -- > > zamri > > Linux System Administrator > > Kolej ShahPutra Kuantan > > Pahang Malaysia > > Tel : 609.573.777.7 ext 119 > > web : http://muhdzamri.blogspot.com > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > DBmail mailing list > > DBmail@dbmail.org > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > -- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- zamri Linux System Administrator Kolej ShahPutra Kuantan Pahang Malaysia Tel : 609.573.777.7 ext 119 web : http://muhdzamri.blogspot.com
_______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
