Hi,
I would like to check if it is possible to move an account with the websites, emails, ext... to a different reseller account?
how can i do that?
thank you
Ori
Hello,
I'm afraid that is not possible without doing quite some database editing.
In general i would recommend to detach the customers resources, and reimport them under the new user at the new reseller.
I recently moved several end-user accounts into a new reseller account using the not-recommended method. The attached document shows an example of how I edited the SolidCP database. Everything seems fine, except the resource counts are not correct.
Viewing OldReseller's space, Default.aspx?pid=SpaceHome&SpaceID=50 counts everything too high (including disk space and number of domains), still including the items that were moved.
Viewing NewReseller's space, Default.aspx?pid=SpaceHome&SpaceID=422 indicates NewReseller is using ZERO of everything (including disk space and domains), except for the one FTP account that I created manually.
Viewing NewReseller's domains, Default.aspx?pid=SpaceDomains&SpaceID=422 shows all of the domains as expected, but the count at the bottom says zero.
Any idea what still needs to be changed? Thanks!
@dolphyn5 I would expect maybe the PackageID is not correct in [dbo].[ServiceItems].
Thanks, but that wasn't it, because I hadn't made any change to the end-user PackageID numbers.
But today I found the problem: I needed to update the ParentPackageID numbers in [dbo].[PackagesTreeCache]
Hi,
I am a bit confused by your document, you move the old domain content from a folder of the one reseller to a folder of a nother reseller ? I have scp setup across multiple web servers and db servers etc, we also have multiple resellers, but the clients domains and data dont get placed under a structure as d:\webs\reseller\client\ the clients irrespective of reseller get placed under their own d:\web\client\ folder. Is there something that I am missing or was this setup this way ?
The reason i ask is moving a client from one reseller to another reseller is as follows :
Old reseller UserId 128 PackageId/SpaceID = 100
New Reseller UserId 938 PackageId/SpaceID = 990
Client UserId 835
update [scp].[dbo].[Users] set OwnerID=990 where UserID=835
update [scp].[dbo].[Packages] set ParentPackageID=990 where UserID=835
update [scp].[dbo].[PackagesTreeCache] set ParentPackageID=990 where UserID=835 and ParentPackageID=100
Once moved to the new reseller, we just select a comparable hosting plan and save. This moves the user to the new reseller, and changes the hosting plan to the correct one of the new reseller, all the resouce counters update fine, and there is no need top move data from one location to another etc.
So Im Just curious as to why data needs to be moved around when we dont need to do that, it is possible you have configured your resellers to put the spaces under the resellers space. We dont do this as we randomize the loade across multiple servers and solidcp chooses the least loaded server to place the clients onto.
