• tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Topic: Forum cleanup - problem with deleting orphans post

Hi everyone,

I have found that plugin Forum cleanup doesn't delete orphans post. Now number of post in few topic is higher then number of posts I can see in topic (I see blank few last pages). It is because few post in table posts have wrong(?) poster_id (user doesn't exist). This posts should be deleted.

Could you fix this plugin?

Darmowe forum - Polish free forum hosting

tomekf's Website

  • tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Re: Forum cleanup - problem with deleting orphans post

Can anyone help me?

Darmowe forum - Polish free forum hosting

tomekf's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Forum cleanup - problem with deleting orphans post

nuuskamuikkunen wrote:

Not sure if this will work (have no "orphaned" posts in my db)...

To find posts where users don't exist:

SELECT p.id
FROM posts p
LEFT JOIN users u
ON p.poster_id = u.id
WHERE u.id IS NULL

Then set poster_id for these rows to some new user id, etc etc?

From an older topic

  • tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Re: Forum cleanup - problem with deleting orphans post

Ok, but could you fix this bug in plugin Forum cleanup?

Darmowe forum - Polish free forum hosting

tomekf's Website