How to move an acco...
 
Notifications
Clear all

How to move an account from one reseller to the other

6 Posts
5 Users
0 Reactions
1,560 Views
Posts: 24
 ori
Topic starter
(@oslasi)
Eminent Member
Joined: 7 years ago

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

5 Replies
Posts: 1964
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

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.

Reply
Posts: 68
(@dolphyn5)
Estimable Member
Joined: 8 years ago

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!

 

Reply
2 Replies
Admin
(@trobinson)
Joined: 9 years ago

Noble Member
Posts: 1456

@dolphyn5 I would expect maybe the PackageID is not correct in [dbo].[ServiceItems].

Reply
(@dolphyn5)
Joined: 8 years ago

Estimable Member
Posts: 68

@trobinson 

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]

Reply
Posts: 237
(@hxkd)
Reputable Member
Joined: 7 years ago

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.

Reply
Share: