Current time: 11-01-2024, 10:36 AM Hello There, Guest! (LoginRegister)


Post Reply 
Update ispcp 1.0.6 to 1.0.7 problem with fastCGi - Debian Lenny
Author Message
viperiii Offline
Junior Member
*

Posts: 65
Joined: Feb 2008
Reputation: 0
Post: #8
RE: Update ispcp 1.0.6 to 1.0.7 problem with fastCGi - Debian Lenny
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...
(This post was last modified: 12-04-2010 02:07 AM by viperiii.)
12-04-2010 02:00 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Update ispcp 1.0.6 to 1.0.7 problem with fastCGi - Debian Lenny - viperiii - 12-04-2010 02:00 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)