No reply. That is new.

We have a multisite, (same files, different db tables.)

I would like to know how i can delete users, without it deleting their profiles, posts, avatar, etc.
i.e. delete a user from slave site, but leave them as is on Primary.

Can you check my following explanation and see if I understand your question correctly?

1. You have 3 websites running the same user data but under different databases.

e.g.
- Primary site A (has active user)
- Development site B
- Development site C

2. If the primary site A user uploads a file on the site, it will automatically store the data into Primary site A, Development site B, and C?

So your question is, is there a way to delete a user account from the development site B/C but without deleting their data from the primary site A?

1. You have 3 websites running the same user data but under different databases.

3 websites that should eb running different users, all same DB, separate tables.

e.g.
- Primary site A (has active user)
- Slave site B
- Slave site C

2. If the primary site A user uploads a file on the site, it will automatically store the data into Primary site A, Development site B, and C?

No

Problem is, site B and C are made from clones of site A.
I need to clean up all the duplicated users from B and C., but removed them from ES on B & C removed all their posts, photos etc from the 'files', So the user on site A loses everything.

So your question is, is there a way to delete a user account from the development site B/C but without deleting their data from the primary site A?

Yes, that is what i need to do.

Important! I deleted a user from site B, can i restore their data from the dev site (separate)?

i.e. user deleted from live site
/profile/1525-megan-kopp.html

Need to import user and all input, from dev site tables to live site tables.

I cannot add user to live site as different id...
On that note can the id numbers be removed?

Thanks Arlex!

3 websites that should be running different users, all same DB, separate tables.

I am sorry that I quite not understand you here. Is it mean that 3 websites are running different users with the same user ids and 1 database with different tables?

So I assume that you have 3 different Easysocial tables in one single database?
e.g.
1. Primary site - primary_social_stream
2. Slave A - slaveA_social_stream
3. Slave B - slaveB_social_stream

Problem is, site B and C are made from clones of site A.
I need to clean up all the duplicated users from B and C., but removed them from ES on B & C removed all their posts, photos etc from the 'files', So the user on site A loses everything.

If the above my understanding is correct, so I am not sure why the Slave A/B site has duplicated user account, by right Slave A/B data should be synced with your primary site.

Yes, that is what i need to do.

Important! I deleted a user from site B, can i restore their data from the dev site (separate)?

i.e. user deleted from live site
/profile/1525-megan-kopp.html

Need to import user and all input, from dev site tables to live site tables.

I cannot add user to live site as different id...
On that note can the id numbers be removed?

I couldn't give you any advice right now since I am still not really understand what is your current database table structure and how it works behind it.

Is that mean Joomla user table #__users have only 1? Then you have 3 sets of Easysocial tables?

If the above my understanding is correct, so I am not sure why the Slave A/B site has duplicated user account, by right Slave A/B data should be synced with your primary site.

I cloned site b and c from a, so now i have accounts i need to remove from cloned sites, without effecting primary site.

Why don't we start at the beginning again...

Step 1. how do i restore a deleted user and their blogs etc from our dev site. (dev site is separate from these.) ?
I need to restore the user, and all contributions from dev

Step 2. Using Mightysites.
3 sites same DB, but each it's own complete set of tables.
Each site is on it's own, just in one table for Plugin/module to cross show blogs.

To make site B & C I duplicated the tables of Site A,
Now i need to remove the duplicated users and data from site B & C tables , without the related files on site A being affected.

As it is now i remove a user from Site B or C it also deletes their support files, that are necessary for the user on Site A.

I really need to migrate one user from dev asap.

Removing the users i can always work around by restoring the files that are deleted when i delete the user.

Many Thanks Arlex!

Since you are using MightySites extension to run multiple websites with sharing of database content together, I think that is no easy way to restore back to a specific user data after you delete.

I have deleted a member from our live site, a while ago by accident.

Is it possible to import the member and their posts, photos, blogs etc from the dev site?

I also have them in same DB just different tables

Come back to your initial question, if you accidentally delete a user account on your primary site, your cloned site shouldn't have this user data already, when you delete a user account, all the stream items, and photos will be deleted.

Unless you have a backup of your site data, so you can still roll back to your previous backup but the latest data will be gone.

But even you roll back to your previous backup on your primary site, those recent new data will be gone as well, I believe your site backup is not automatically backup for everyday right?

I think you should consult with MightySites extension provider and see if they have any experience with this.

Since you are using MightySites extension to run multiple websites with sharing of database content together, I think that is no easy way to restore back to a specific user data after you delete.

Common dude! Mightsites is not relevant.

No worries, I think i have it figured out.

Q- Can the id' in uRL be removed without 404s everywhere?

Colin

Q- Can the id' in uRL be removed without 404s everywhere?

1. You can turn off this setting from the backend > Easysocial > dashboard > setting > general > SEO > SEF Urls To Use IDs - NO

2. click the Purge all button from the backend > Easysocial > dashboard > SEF URLs

3. View on your site homepage, so it will regenerate the correct SEF URLs without containing any ids in the URL.

Very Cool!

Do the old urls with id auto-direct to the new ones?
Or is there .htaccess code to do it?

Hey Arlex, Since I got you here and you are the man...
You may have noticed we are going "all in" with SI products as the core of our fast expanding travel site.

While your products are the best, we need to customize.

We had a custom guy, but had to let him go.

So, as you guys know it best, and we can trust you, we would like to look at contracting future custom work to SI.

I am concerned about the timeline it takes for work done.
I assume, if I am regular customer, the turnaround would be relatively fast, and I would get a 'special repeat customer rate?

We are also need to start working on an app, which i will need lots of advice on.

Please Advise

Do the old urls with id auto-direct to the new ones?
Or is there .htaccess code to do it?

About the old URLs will not auto redirect to the new one if you referring to those old URLs' links shared somewhere.

And yes, you might need to add redirection rules to the .htaccess file.

Hey Arlex, Since I got you here and you are the man...
You may have noticed we are going "all in" with SI products as the core of our fast expanding travel site.

While your products are the best, we need to customize.

We had a custom guy, but had to let him go.

So, as you guys know it best, and we can trust you, we would like to look at contracting future custom work to SI.

I am concerned about the timeline it takes for work done.
I assume, if I am regular customer, the turnaround would be relatively fast, and I would get a 'special repeat customer rate?

We are also need to start working on an app, which i will need lots of advice on.

It is not an easy task if you are planning to create a native mobile app for your website, it will require a lot of work need to be done.

Having to say that, if you require us to perform the customization for you, I think it would be better if you can submit a request at https://stackideas.com/customization-works. Our salesperson would gladly send you a quote for the customization that you have requested.