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
