Check out the SMF Function DB!
Started by css_script_writer, September 15, 2010, 08:38:00 PM
Quote from: xenovanis on September 20, 2010, 07:37:34 AMYou'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.Code Select Expand/index.php?action=moderate;area=postmod;sa=approve;topic=topic_id_here;msg=message_id_here;session_stuff_here
Quote from: xenovanis on September 20, 2010, 03:02:11 PMSo, 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.0Just drop me a PM. I'll either take a look tonight or tomorrow.
SELECT * FROM `smf_messages` WHERE `approved` = '0'
Quote from: css_script_writer on September 29, 2010, 10:41:07 AMThanks, 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
SELECT * FROM `smf_topics` WHERE `unapproved_posts` > 0
QuoteSELECT * FROM `smf_topics` WHERE `unapproved_topics` > 0SELECT * FROM `smf_topics` WHERE `unapproved_replies` > 0
Quote from: Oya on September 29, 2010, 12:59:57 PMQuoteSELECT * FROM `smf_topics` WHERE `unapproved_topics` > 0SELECT * FROM `smf_topics` WHERE `unapproved_replies` > 0these 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 servergo 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 AMThanks 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: Joker™ on September 29, 2010, 01:23:58 PMJust a suggestion , try thisAdministration Center » Forum Maintenance » Database » Optimize all tables
UPDATE smf_messages SET `approved` = '1';
UPDATE smf_topics SET `approved` = '1' AND `unapproved_posts` = '0';