DB exp_category_posts cleanup
Development and Programming
I am looking at the relationship between category_posts and channel_data and want to know if category_posts is related to any other tables. I have some data in channel_data to bulk delete/update. When I remove those entries from channel_data it leaves orphaned records in category_posts. Is it safe to delete those orphaned records are does category_posts relate to some other table I am not looking at?
Here is the super simple query I am using to find these nulls
select e.entry_id,c.entry_id from exp_channel_data e right outer JOIN exp_category_posts c ON (e.entry_id = c.entry_id) where e.entry_id is null group by c.entry_idI wasn’t expecting as many results as I am getting which is why the concern.
I think my question extends to exp_channel_titles and its relationship to channel_data also. If I delete an entry from channel_data do I need to also do cleanup and delete from channel_title?
Thanks for your help.
What I would recommend is turning on the Output Profiler:
Administration System Administration Output and Debugging Preferences Display Output Profiler?
Then publish an entry and note which tables get updated. This will give you some clues about which tables to look at for deleting.
I tried enabling that, I get a green check like it did it successfully but the window comes back to the output settings with that turned off. I took a look at the config.php file and I really don’t see anything referencing that type of setting. Any thoughts?
Is your config file server-editable?
sorry for the late reply. Yes my config file is server editable and owned by the apache user. On my test server the www directory is a mounted drive and on my other servers its a mounted nfs server. I am having the issue in all locations. Let me know what you think.