Yes Paul but, I'm sure this all mailboxes are subscrived, because of what I told you. I'm inserting the value in dbmail_users+dbmail_aliases+dbmail_mailboxes And this is for POP3 users (I belive they don't use the IMAP) I should insert the corresponding value in dbmail_subscription right?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens Sent: segunda-feira, 11 de Fevereiro de 2008 7:22 To: DBMail mailinglist Subject: Re: [Dbmail] DBMail 2.3.2 released Jorge Bastos wrote: > Hum paul, > I putted by brain thinking and sinse I must have the same number of records > in dbmail_mailboxes and dbmail_subscription, I did: That is *not* true. For every record in subscription there must be record(s) in dbmail_users and dbmail_mailboxes, but not the other way around. > > --- > replace into dbmail_subscription SELECT owner_idnr,mailbox_idnr FROM > dbmail_mailboxes order by owner_idnr,mailbox_idnr; > --- That means you have now subscribed all your users to all their mailboxes, even the ones they unsubscribed from. Let me reiterate: if you create a mailbox, and later unsubscribe from that same mailbox, you will still have a record in dbmail_mailboxes for that particular mailbox. But there is no longer a record in dbmail_subscription for that mailbox and that user. Still, good to hear you are up and running. -- ________________________________________________________________ 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
