• Registered: 2006-08-22
  • Posts: 77

Topic: Clean orphan posts

Hello.
In my database, I have several hundreds posts that are not effectively displayed in my board.
To identify them, I performed this request from an old script :

SELECT p.id FROM forum_posts p LEFT JOIN forum_topics t ON p.topic_id=t.id WHERE t.id IS NULL

Do you think I can delete safely this posts?

Thank you.

  • keeshii
  • Extension Developer
  • Offline
  • From: Poland
  • Registered: 2013-04-04
  • Posts: 170

Re: Clean orphan posts

Yes, you can. I am sure, that you have installed a broken extension and it is causing this issue. My forum is running for quite long time, and:

mysql> SELECT p.id FROM punbb_posts p LEFT JOIN punbb_topics t ON p.topic_id=t.id WHERE t.id IS NULL;
Empty set (0.08 sec)
If you want to contact me quickly - send e-mail, not PM.
<?php $t='<?php $t=%c%s%c; printf($t,39,$t,39,10);%c'; printf($t,39,$t,39,10);
  • Registered: 2006-08-22
  • Posts: 77

Re: Clean orphan posts

Thank you, keeshii.

My forum is very old (2006), and this difference between posts in database and posts displayed can certainly result from an extension (that was previously installed), as you say.

I deleted all these posts, they were all written several years ago.