@User Tag in profile comments generates moderation cue / cant be deleted

[Freelancer]

Strange bug, and maybe it has to do with @Daniel Hood's ModEss (not sure), but this can not be deleted, nor approved.... what can I do?

 

[Daniel Hood]

I don't believe that there's anything in Moderator Essentials that should be causing this.

 

[Freelancer]

I don't believe that there's anything in Moderator Essentials that should be causing this.

I did not want to allege that it was causing it, unnecessarily...

 

[Paul B]

I just tagged Chris on his profile, unapproved the post, and was able to approve and delete it.

 

[Freelancer]

I just tagged Chris on his profile, unapproved the post, and was able to approve it.

Indeed.... I tried to replicate it, and now it worked properly. But I still cant delete the initial profile post. Maybe a glitch? How can I remove it? Is there a workaround?

 

[Daniel Hood]

Indeed.... I tried to replicate it, and now it worked properly. But I still cant delete the initial profile post. Maybe a glitch? How can I remove it? Is there a workaround?

Are any errors being thrown? How'd it end up in the moderation queue?

 

[Freelancer]

That's the first question I had come to mind. I did not expect it appearing in the mod queue.... The user just tagged another name under his own profile post. To make the other user aware of his own profile post.

 

[Freelancer]

How can I clean it up?

 

[Mike]

I would recommend disabling all add-ons (via the ACP). There shouldn't be anything stopping you from cleaning it up.

 

[Freelancer]

Believe it or not, but here is what I did:

1. Deactivated all add-ons... mod queue delete (did not work)
2. Activated all add-ons...
3. Went to the profile page and tried to delete the post via inline-mod (worked!)
4. Moderation Queue Cleared...

I have no idea why this worked. It was like picking a combination lock and accidentally finding the right combination.

 

[Chris D]

Off the top of my head I think he seen this before and I think it relates to the content being valid, somehow, while it leaves an orphaned moderator queue record.

I think in terms of reproducing it, if you unapproved a profile post, then edited the message_state manually in the DB to be valid, it would leave the moderator queue record there and it would never be possible to alter its state there because I think we check for that before changing anything.

If my hunch is correct, the real question is how it came to be in that state. That could well be an add on but it might not be possible to reproduce it now.

 

[Freelancer]

Could it be that crossing over super admins, who set different states at the same time, caused the problem? Because I was switching between accounts, and I can not really remember the order of actions but, when I did different tries like inline-delete, then unapproval, then moderation queue delete and that from different accounts on different devices (smartphone and desktop), that the database got a hiccup due to wrong record states? I still wonder why it finally worked again...

 

[Chris D]

Not sure how it happened. That seems unlikely unless it literally happened in the same split second.

As for why it worked, I think the moderation queue actions will only happen if the content is 'moderated'. It's possible the content was actually 'visible' despite there still being a record in the moderation queue (which is a separate table). If this was the case then going to the content and deleting it would work because it doesn't concern itself with what the current state is.

I'm still sort of guessing at the moment but it's really the only thing that makes sense.

I would say unless it happens again, don't worry about it.

 

[Freelancer]

I am fast, but not that fast to have different things happen in the same second I think this was a glitch. It hasnt repeated so far.

I would say unless it happens again, don't worry about it.

Will do, because XenForo is by far making more happiness than worries and I launched my Forum on the 24th, and the users are overwhelmed with the features and joy.

Thanks guys. You do a fantastic job.