dbmail-export error

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 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?

What version of mysql are you on?

zamri wrote:
>;
>
> On Dec 29, 2007 10:49 AM, zamri < myzamrigmail.com">myzamrigmail.com

> <mailto: myzamrigmail.com"> myzamrigmail.com>> 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&#39;
>     in 'on clause';] [SELECT
&gt;     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.
&gt;
>     It was fine with 2.2.7. What should i do?
>

>     <http://muhdzamri.blogspot.com&gt;

>
> Anyone?
&gt;
>
>;
> --
> zamri
> Linux System Administrator
> Kolej ShahPutra Kuantan
&gt; Pahang Malaysia
&gt; Tel : 609.573.777.7 ext 119
> web : http://muhdzamri.blogspot.com
&gt;
>

> ------------------------------------------------------------------------
>;
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org">DBmaildbmail.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
DBmaildbmail.org">DBmaildbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail