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
Don't bump within 24 hours, the only result you can get by that is being ignored.
cant u delete the posts
Could you try Admin -> Maintenance -> Find and repair any errors?
Thank you for the replies. Unfortunately, none of the above worked. Any other suggestions?.
waht happened when u tried to delete teh posts
also how did u try it
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
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
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.
admin / maintenence / routine / clear file cahce
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...
@Oya
Yes, I've tried that and have included screenshots to show what I'm talking about.
i didnt talk about ur browsers cache
i meant *server* cache which is something totally different
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
yes their is
Quote from: Oya on September 16, 2010, 07:34:19 PM
admin / maintenence / routine / clear file cahce
Yes, I've already done that and it didn't resolve the issue.
Quote from: Oya on September 16, 2010, 10:41:07 PM
yes their is
Quote from: Oya on September 16, 2010, 07:34:19 PM
admin / maintenence / routine / clear file cahce
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
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.
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.
Sorry to bump this up (it's been over 24 hours) but this has really become an issue. Any ideas out there?.
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
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
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
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
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.
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.
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.
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
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
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
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
Just a suggestion , try this
Administration Center » Forum Maintenance » Database » Optimize all tables
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
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
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!