By Fred Schonenberg on Thursday, 27 July 2017
Replies 3
Likes 0
Views 794
Votes 0
Hi,

We're going from test environment to production and I'd like to clean up all testing records, messages, users, discussions, etc without corrupting the database.
Is there a tool to do this or do we have to delete all records manually?
If manually, what records do we have to clean?

Thanks in advance,
Fred
Hello Fred,

We don't actually have a tool to wipe out data as we are afraid users may accidentally use it without understanding it. You can however run the following queries if you need to clear the database,

[gist]
truncate table #__social_access_logs;
truncate table #__social_albums;
truncate table #__social_albums_favourite;
truncate table #__social_stream;
truncate table #__social_stream_item;
truncate table #__social_comments;
truncate table #__social_likes;
truncate table #__social_avatars;
truncate table #__social_badges_history;
truncate table #__social_badges_maps;
truncate table #__social_block_users;
truncate table #__social_bookmarks;
truncate table #__social_broadcasts;
truncate table #__social_clusters_news;
truncate table #__social_clusters_reject;
truncate table #__social_conversations;
truncate table #__social_conversations_message;
truncate table #__social_conversations_message_maps;
truncate table #__social_conversations_participants;
truncate table #__social_covers;
truncate table #__social_discussions;
truncate table #__social_discussions_files;
truncate table #__social_feeds;
truncate table #__social_files;
truncate table #__social_files_collections;
truncate table #__social_friends;
truncate table #__social_friends_invitations;
truncate table #__social_links;
truncate table #__social_lists;
truncate table #__social_lists_maps;
truncate table #__social_logger;
truncate table #__social_mailer;
truncate table #__social_moods;
truncate table #__social_notes;
truncate table #__social_notifications;
truncate table #__social_notifications_browser;
truncate table #__social_oauth_history;
truncate table #__social_photos;
truncate table #__social_photos_meta;
truncate table #__social_photos_tag;
truncate table #__social_points_history;
[/gist]

Replace #__ with the appropriate prefix
·
Thursday, 27 July 2017 23:39
·
0 Likes
·
0 Votes
·
0 Comments
·
I'll give it a shot

Thanks Mark
·
Friday, 28 July 2017 15:52
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Fred
·
Friday, 28 July 2017 17:01
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post