• Welcome to Simple Machines Community Forum. Please login or sign up.
September 21, 2021, 04:47:40 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


[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

css_script_writer

Sorry to do this (I really need help here!). It's been another 24 hours (almost to the minute). Surely, there must be a developer or tech-savvy user who has some semblance of a solution to this. As I indicated the other day, I've already done all of the obvious things. In fact, I've systematically gone down the list and performed/checked every way I could possibly find to try and resolve this issue.

Any idea as to what might be causing this and what can be done to fix it?...please?...

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

xenovanis

You'll have to enter the correct session_id for this to work. Hover over that or any other topic awaiting approval and it should show the session stuff.



/index.php?action=moderate;area=postmod;sa=approve;topic=topic_id_here;msg=message_id_here;session_stuff_here
"Insanity: doing the same thing over and over again and expecting different results."

css_script_writer

Thank you so much for responding!. When I hover the cursor over the red "(!)" it says "Unapproved Posts (Topics:0 Posts: 2)" but when I actually click on the red "(!)", it takes me to a page that says "There are currently no posts awaiting approval" and shows 0 topics and 0 replies so there really is nothing there to delete apparently. I'm assuming this is some sort of remnant or artifact left over in the cache and yet I've cleared the file cache, browser cache  and done all sorts of other things to make it go away. I even tried the following modification with your URL...

YOUR CODE:
/index.php?action=moderate;area=postmod;sa=approve;topic=topic_id_here;msg=message_id_here;session_stuff_here

MY MODIFICATION:
http://www.anxietyzone.com/index.php?action=moderate;area=postmod;sa=approve;brd=57;db66faa54367=d15370b7a5d1a45fd3d5720ab9354177

Not sure what to do next...

- CSS

Quote from: xenovanis on September 20, 2010, 07:37:34 AM
You'll have to enter the correct session_id for this to work. Hover over that or any other topic awaiting approval and it should show the session stuff.



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

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

MrVista

You are not alone with a problem like this.

After upgrading our forum all old posts are like this and I can't get it working either.
Sadly not much help in my thread...

http://www.simplemachines.org/community/index.php?topic=387804.0;topicseen

xenovanis

So, on my testforum I created a testaccount. I set the warninglevel for the testaccount to postmoderation. I made two posts with the testaccount and then deleted it, without deleting the posts.

As an admin, I still was able to approve one post and delete another one which wasn't approved, and the exclamation mark disappeared.

So I created a new testaccount and put it on postmoderation. I let the account post 2 topics and deleted the account, including their posts and topics. The posts were gone and so was the notice (!) for moderators.

Funny things going on then ;)

Could you provide me with an admin account css_script_writer? Please read this first:
http://www.simplemachines.org/community/index.php?topic=228940.0

Just drop me a PM. I'll either take a look tonight or tomorrow.
"Insanity: doing the same thing over and over again and expecting different results."

css_script_writer

Hi

Well, I'm really not at liberty to provide that information - even as much as I genuinely appreciate the effort you obviously went to in testing and attempting to reproduce this apparent glitch. I hope that won't cause any hard feelings or prevent further discussion of this matter with the possibility of a positive outcome if someone can figure out what is causing this to occur.

Perhaps, it will be resolved when a patch is released or when 2.0 Final comes out. This is one of only a number of bugs but of course that is to be expected with any unfinished software.

- CSS

Quote from: xenovanis on September 20, 2010, 03:02:11 PM
So, on my testforum I created a testaccount. I set the warninglevel for the testaccount to postmoderation. I made two posts with the testaccount and then deleted it, without deleting the posts.

As an admin, I still was able to approve one post and delete another one which wasn't approved, and the exclamation mark disappeared.

So I created a new testaccount and put it on postmoderation. I let the account post 2 topics and deleted the account, including their posts and topics. The posts were gone and so was the notice (!) for moderators.

Funny things going on then ;)

Could you provide me with an admin account css_script_writer? Please read this first:
http://www.simplemachines.org/community/index.php?topic=228940.0

Just drop me a PM. I'll either take a look tonight or tomorrow.
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

xenovanis

No hard feelings  ;) I'm just reaching a point where I have to see things for myself though.

Could you run this query in phpMyAdmin?

SELECT * FROM `smf_messages` WHERE `approved` = '0'


phpMyAdmin will return a list of unapproved messages. Please see if you can find the messages that are haunting you are there.
"Insanity: doing the same thing over and over again and expecting different results."

css_script_writer

Thanks, I tried the query and it returned an "empty result" which means that these "ghost" topics/posts awaiting approval do not exist in the database. So where are they coming from?. This is really odd.

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

Oya

Quote from: css_script_writer on September 29, 2010, 10:41:07 AM
Thanks, I tried the query and it returned an "empty result" which means that these "ghost" topics/posts awaiting approval do not exist in the database. So where are they coming from?. This is really odd.

- CSS

please now run
SELECT * FROM `smf_topics` WHERE `unapproved_posts` > 0

css_script_writer

Thanks, just tried it and here is the result...

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0296 sec )

I also experimented with...

SELECT * FROM `smf_topics` WHERE `unapproved_topics` > 0
SELECT * FROM `smf_topics` WHERE `unapproved_replies` > 0

Really puzzling now...

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

Oya

Quote
SELECT * FROM `smf_topics` WHERE `unapproved_topics` > 0
SELECT * FROM `smf_topics` WHERE `unapproved_replies` > 0

these two columns do not exist so im not sure what querying would have told u...

the *only* other place this value can now remain is in the file cache on the server

go to cache/ and remove every file except for any .htaccess file and index.php

Joker™

Just a suggestion , try this

Administration Center » Forum Maintenance » Database » Optimize all tables
Github Profile
Android apps
Medium

How to enable Post Moderation

"For the wise man looks into space and he knows there is no limited dimensions." - Laozi

All support seeking PM's get microwaved

css_script_writer

Thanks for all of the help and info. What's really odd is that when I FTP into cache/, I only see those two files (ie; .htaccess and index.php). There is nothing else there. Could it be cached elsewhere?.

Quote from: Oya on September 29, 2010, 12:59:57 PM
Quote
SELECT * FROM `smf_topics` WHERE `unapproved_topics` > 0
SELECT * FROM `smf_topics` WHERE `unapproved_replies` > 0

these two columns do not exist so im not sure what querying would have told u...

the *only* other place this value can now remain is in the file cache on the server

go to cache/ and remove every file except for any .htaccess file and index.php
Anxiety Zone Forums & Chat Rooms
http://www.anxietyzone.com/index.php

Joker™

Quote from: css_script_writer on September 30, 2010, 08:54:07 AM
Thanks for all of the help and info. What's really odd is that when I FTP into cache/, I only see those two files (ie; .htaccess and index.php). There is nothing else there. Could it be cached elsewhere?.
Afaik , answer is no. Have you tried this
Quote from: Joker™ on September 29, 2010, 01:23:58 PM
Just a suggestion , try this

Administration Center » Forum Maintenance » Database » Optimize all tables
Github Profile
Android apps
Medium

How to enable Post Moderation

"For the wise man looks into space and he knows there is no limited dimensions." - Laozi

All support seeking PM's get microwaved

xenovanis

Running out of options, but please try these queries:


UPDATE smf_messages SET `approved` = '1';


and

UPDATE smf_topics SET `approved` = '1'  AND `unapproved_posts` = '0';


BACKUP UP YOUR DATABASE FIRST!
"Insanity: doing the same thing over and over again and expecting different results."

Advertisement: