XF 2.1 Deleting thread are not delete post record

[Nirjonadda]

Batch update threads or manually Deleting thread are not delete post id from database. Deleted thread post have a post with ID in the database. xf_post table has a record with post_id=X, If we check any none-existing post, like /posts/7565654/ we will see the message is "The requested post could not be found." but for the page /posts/7/ the message is "You do not have permission to view this page or perform this action.". Deleted some threads, that removed the thread records but did not remove the posts for the same thread.

 

[Nirjonadda]

We run this query on our database to check for orphaned posts:

SELECT p.post_id, p.thread_id
FROM xf_post AS p
LEFT JOIN xf_thread AS t ON (t.thread_id = p.thread_id)
WHERE t.thread_id IS NULL

Thread ID 4 are deleted but post are not deleted.

 

[Chris D]

The code is there to do that and in my testing a manual deletion or a batch deletion does clear the post records so this would indicate that the process is being interrupted by something else.

I can only suggest trying to repeat the process to see if it is consistently reproducible.

If it is, try the process again, but this time with all add-ons disabled.

 

[Nirjonadda]

@Chris D Please can you let me know that how to find posts which do not have valid thread numbers and delete of these orphaned posts from the xf_post and xf_deletion_log tables? Can you give SQL Query for this? We have 77737 posts have invalid thread numbers. We still not find out that why Batch update threads or manually Deleting thread are not delete post records from database.

 

[Chris D]

I think ultimately it's just best to leave them - it won't affect anything and I'm not willing to run the risk of advising how to manually clear up data as it just opens up the possibility of orphaning even more data, or accidentally deleting too much.

It's not something we'll provide official support for.

 

[Masetrix]

We still not find out that why Batch update threads or manually Deleting thread are not delete post records from database.

Maybe thisone can help. Always remember: backup, backup, backup...

Post check

Description: Verifies posts have correct associated table data. (Example of Post check page) How to use: Add 'postcheck' to your forum URL. Question and Answers: Q: Who can run this add-on? A: You must be an admin to run this add-on.

www.xf2addons.com

 

[Nirjonadda]

I have found that why post are not deleted with delete thread. This conflict with one add-on but This add-on developer no more here. So I will go to hire some developer for give compatible update.

 

[Vlady]

I have found that why post are not deleted with delete thread. This conflict with one add-on but This add-on developer no more here. So I will go to hire some developer for give compatible update.

Do you mean SEO2, right?

 

[djbaxter]

Do you mean SEO2, right?

I haven't seen any conflicts with that addon and certainly nothing like what the OP is describing.

 

[Nirjonadda]

Do you mean SEO2, right?

User Thread Count addon.

 

[djbaxter]

User Thread Count addon.

Isn't that just a XF 1.5 addon?

 

[Vlady]

I had the same problem with the SEO2 plugin. But error was disappear after SEO2 disabling/re-enabling.