[UNSOLVABLE?] Red post-moderation "(!)" remains despite member account deletion

Started by css_script_writer, September 15, 2010, 08:38:00 PM

Previous topic - Next topic

css_script_writer

Hi everyone

We have the SMF 2.0 (RC3) post moderation and warning system set up so that the slider can be moved over to create the action "All users posts will be moderated". If a user has this action performed on their account, Moderators and admins will see a red "(!)" next to the forum category where the post(s) or topic(s) are awaiting approval. When you position the cursor over this red "(!)" it reads "Unapproved Posts (Topics: 0 Posts: 2)"

The problem we are having here is that the member who recently had this action performed on their account has since had their account deleted and yet the red "(!)" still remains next to the form category where their posts where waiting to be approved. Since this member no longer has an account, I am unable to approve their 2 replies (which no longer exist) and can find no way either within the forum or database to remove the red "(!)".

Here is an example...

Sleep Disorders Forum  (!)

Any suggestions would be greatly appreciated.

- CSS
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

CapadY

Don't bump within 24 hours, the only result you can get by that  is being ignored.
Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.


xenovanis

"Insanity: doing the same thing over and over again and expecting different results."

css_script_writer

Thank you for the replies. Unfortunately, none of the above worked. Any other suggestions?.
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

Oya

waht happened when u tried to delete teh posts

also how did u try it

css_script_writer

Well, I can't actually delete the posts because they no longer exist since the account associated with them is now gone. I'm assuming these posts are simply cached bits or artifacts and yet I've done all sorts of forum maintenance and can't seem to get rid of them.

Quote from: Oya on September 16, 2010, 05:35:38 PM
waht happened when u tried to delete teh posts

also how did u try it
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

Oya

um no the posts should still be there

deleting an account doesnt remove the posts too

failing taht click on the red (!) to see waht still needs approving

css_script_writer

That's just it...when I hover the cursor over the red "(!)" it says "(Topics: 0 Posts: 2)"  but when I actually click on the red "(!)" to see what needs approved, it says "(Topics: 0 Posts: 0)" and there is nothing to delete. They look like ghost posts and I have no idea how to get rid of something like this.
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php


css_script_writer

Here's what I've done so far to no avail...

1) Ran ALL routine maintenance tasks.
2) Disabled warning system and post moderation.
3) Used PHPMyAdmin to repair DB.
4) Dropped ALL references to deleted account from DB.
5) Ran ALL scheduled tasks.
6) Deleted ALL logs.
7) Cleared everything in my browsers cache, history, cookies, sessions, etc.

And I am still seeing the red "(!)" next to this one forum category name (first screen capture) and when I click on this red "(!)" I get what is seen in the second screen capture...
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

css_script_writer

@Oya

Yes, I've tried that and have included screenshots to show what I'm talking about.
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

Oya

i didnt talk about ur browsers cache

i meant *server* cache which is something totally different

css_script_writer

Interesting, is there a method for clearing this within SMF's admin section?.

Quote from: Oya on September 16, 2010, 09:34:18 PM
i didnt talk about ur browsers cache

i meant *server* cache which is something totally different
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php


css_script_writer

Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

css_script_writer

I'm looking at the URL associated with the little red "!" and referencing it with a few things I've read about SMF's file cache and what sticks out to me is the long cryptic number at the very end of the URL and yet I've performed every possible maintenance function and it still remains. Where is this coming from?. I can't find it in the database. Nothing seems to be able to remove it. Here's the URL (perhaps it will provide a clue to some hard-core veteran out there)...

http://www.anxietyzone.com/index.php?action=moderate;area=postmod;sa=posts;brd=57;bc1d337f3=910aea2c79e89b0e6863832b37acbf75
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

xenovanis

It's just two posts?

Could you try this url (you have to be logged in as an moderator/admin for it to work)

/index.php?action=moderate;area=postmod;sa=approve;topic=topic_id_here;msg=message_id_here;bc1d337f3=910aea2c79e89b0e6863832b37acbf75

replace 'topic_id_here' and 'message_id_here' with the actual id numbers of the concerning posts. If the session id is any different than the one I posted, replace that as well.
"Insanity: doing the same thing over and over again and expecting different results."

css_script_writer

That's a very good idea and it looks like it should work but since the posts are basically "ghosts" and don't really exist, I don't know how to find the topic ID or message ID for them. Since there are only two of these non-existent posts, can't I just type in an URL that approves all messages/topics?. Not sure how to proceed with this or where to locate the topic/message ID's.

UPDATE: I just experimented with...

/index.php?action=moderate;area=postmod;sa=approve

The result was a session verification error and the red "!" was still there.

Thanks again for your help!.

Quote from: xenovanis on September 17, 2010, 02:25:25 AM
It's just two posts?

Could you try this url (you have to be logged in as an moderator/admin for it to work)

/index.php?action=moderate;area=postmod;sa=approve;topic=topic_id_here;msg=message_id_here;bc1d337f3=910aea2c79e89b0e6863832b37acbf75

replace 'topic_id_here' and 'message_id_here' with the actual id numbers of the concerning posts. If the session id is any different than the one I posted, replace that as well.
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

css_script_writer

Sorry to bump this up (it's been over 24 hours) but this has really become an issue. Any ideas out there?.
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

Advertisement: