As an example of some of the tables that can immediately be removed, based on them not having any content and by using the "find" command line utility to see if they are referenced in any script files;
What is 'ysa_options' table for? Is this something Sapple has added?
As a quick way to see if a specific table is referenced in the script files, for example 'se_friendexplains', I ran the following from the SSH command line;
I'm not sure that I have made it clear, but in the past when I asked your team to clean-up the files and database, I was referring to issues like I will demonstrate below. I was trying to find the "Bishopric Sign-up Confirmation" email content, so I searched the file system for "Dear Brethren", as you see there are only 2 files where this appears, but 6 different project folders which are just backups of the real content. I know I get confused with all of these backups, so I can only imagine your developers are even more confused. In this example I can guarantee the following main project directories and all thier sub-directories can be deleted... ysa_project4, ysa_project_backup_16August, ysa_project5, ysa_project_old2, and ysa_project_old. The only main project folder out of these that is for the current project is 'ysa_project' from my understanding. I would of course ask that your team double check my assumptions. These same directories are probably replicated on the staging and live websites as well. Please clean-up the easily identifiable directory, file and database issues. We can then work on the more difficult ones as we have time.
Also, I'm 98% sure none of the current code is using the scripts in the '/var/www/html/staging.ysacentral.com/social_engine/' directory or it's sub-directories. It wouldn't hurt for your team to review my checks to make sure I'm thinking correctly.
As you can see all references to the 'social_engine' directory are within its own directory. I would suggest renaming the 'social_engine' directory temporarily, then we test most systems and then make the determination to delete it after the testing.
I also checked the httpd.conf file and didn't find a virtual host pointing to the 'social_engine' directory.
Cleanup Database Tables to Remove Excess Test Data