Jorge Bastos wrote: > > Howdy, > > I’d like to confirm that i don’t have any lost mailbox’s on the DB, > can you give me an sql query example to check this? > > Jorge, > I'm pretty sure that the dbmail-util -t already does that check. I have a patch I'm testing to help with db locking during that type of util run that also fixes those display errors.
This should show any mailboxes where the owner no longer exists SELECT mailbox_idnr FROM dbmail_mailboxes WHERE owner_id NOT IN (SELECT user_idnr FROM dbmail_users); -Jon -- Scanned for viruses and dangerous content by MailScanner _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
