By Labros Koliokotsis on Tuesday, 26 April 2016
Posted in General
Replies 5
Likes 0
Views 457
Votes 0
Hi!
We're duplicating our site (thedogspace.gr to thecatspace.gr) and i'd like to know how i can clear out the users and stream. It really ***** doing it manually 50 items at a time.
Hi Labros Koliokotsis,

I am sorry for the delay of this reply. Correct me if I am wrong, you want simply delete all your user and activity on your EasySocial stream? You can simply delete it on back end (user setting/stream setting) by select all and delete it.
Please refer this screenshot: http://screencast.com/t/jnmh1Wl0pz
·
Tuesday, 26 April 2016 10:56
·
0 Likes
·
0 Votes
·
0 Comments
·
i've tried this already but it crashes the server. there are about 3500 users and maybe 13000 stream items. is there a way i can do it through phpmyadmin?
·
Tuesday, 26 April 2016 22:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Labros Koliokotsis,

I am sorry for the inconvenience caused. Yes, you can delete by run this query:

For stream table:
TRUNCATE TABLE `#_social_stream`

For User table:
TRUNCATE TABLE `#_social_users`
·
Wednesday, 27 April 2016 10:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Alright. Stream items have been cleared but although the social_users table is now empty the users still appear in the user admin section of easysocial
·
Thursday, 28 April 2016 01:07
·
0 Likes
·
0 Votes
·
0 Comments
·
To delete a user, I would suggest that you delete it via the user's section of EasySocial at the back end rather than deleting it via phpmyadmin.

Why? The reason is because when you delete a user from the site, there are user plugins that are installed on the site that needs to perform necessary cleanup when a user is deleted.
·
Thursday, 28 April 2016 12:02
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post