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


Reply via email to