Today, my client notified me that they were unable to delete a post on their site. Clearly, this post has become corrupt. The error log on the server was > 2GB in size after all his attempts and he actually crashed his VPS.
Perhaps I am over-complicating this manual deletion but I am aware that post data fragements are stored in the following tables:
There are 29 rows associated with the offending post in wp_posts. Each has a unique post ID.
Has anyone written a query that I can use to locate all these posts and their related fragements from the tables? Alternatively, can anyone offer guidance on how I would structure this SQL code?