It's a debian specific patch included in the dbmail-2.0 packages. I didn't write the patch, but decided to include it in the 2.0 packages to provide some kind of filtering capability in 2.0.
Jorge Bastos wrote: > wow > > i don't have that table, dbmail_filters. > is that native in the svn version or it's an aditional patch Paul? > > Jorge > > > ----- Original Message ----- From: "Paul J Stevens" <[EMAIL PROTECTED]> > To: "DBMail mailinglist" <[email protected]> > Sent: Friday, June 09, 2006 9:29 AM > Subject: Re: [Dbmail] mysql error: Duplicate entry '4-0' for key 1 > > >> >> >> DK wrote: >>> Hello >>> >>> I get following msql error "#1062 - Duplicate entry '4-0' for key 1 " >>> when I try to run following INSERT statement. >>> >>> Suggesting that each user can have only one filter. >>> What am I doing wrong here? >>> >>> INSERT INTO `dbmail_filters` ( `user_id` , `filter_id` , >>> `filter_field` , `filter_value` , `mailbox` ) >>> VALUES ( >>> '4', '0', 'Subject', 'casino', 'INBOX/Spam' >>> ) >> >> Demi, >> >> This means that there is already a filter_id:0 for user_id:4. The >> filter_id values has to be unique for each user. >> >> >> -- >> ________________________________________________________________ >> Paul Stevens paul at nfg.nl >> NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 >> The Netherlands________________________________http://www.nfg.nl >> _______________________________________________ >> Dbmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > _______________________________________________ > Dbmail mailing list > [email protected] > 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
