Rebuilding all customers configuration files:
Think I found it via this thread....
http://isp-control.net/forum/thread-1156...l#pid87024
problem:
select * from `mail_users` where not exists (select `subdomain_id` from `subdomain` where `subdomain`.`subdomain_id` = `mail_users`.`sub_id`) and `sub_id` != 0
I have several emails that are orphaned... because I disabled email for the domains... (don't use it)
domain ID affected 3,30,26
3 from each... all the other tables from that check come clean... just trying to figure out how to remove these records...
found that using
delete from mail_users mailid=offending numbers worked fine...
used domain_id and deleted too many I think.. whoops...