Results 1 to 14 of 14

Thread: incorrect info in quick moderation module

  1. #1
    Join Date
    Dec 2004
    Posts
    299

    Question incorrect info in quick moderation module

    I have (3) Posts showing up in the 'Quick Moderation' module on the CMPS homepage. (see attached image) But when I go to moderation that are no posts or threads to moderate. I had this before upgrading to vb 3.5 and thought maybe it would get cleared up with the upgrades to 3.5 and CMPS 2.0.0. Any idea how to clear this out?
    NCangler

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: incorrect info in quick moderation module

    This query should remove any entries in that table:

    DELETE FROM moderation

  3. #3
    Join Date
    Dec 2004
    Posts
    299

    Default Re: incorrect info in quick moderation module

    Thanks Brian. Do I run that from the 'Execute SQL Query' withing vba CP? Or in phpmyadmin for the 'Moderation' table?

    Quote Originally Posted by Brian
    This query should remove any entries in that table:

    DELETE FROM moderation
    NCangler

  4. #4
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: incorrect info in quick moderation module

    Either one should work fine.

  5. #5
    Join Date
    Dec 2004
    Posts
    299

    Default Re: incorrect info in quick moderation module

    Worked like a charm. Thanks Brian!
    NCangler

  6. #6

    Default Re: incorrect info in quick moderation module

    WOW!! All this time I had to put up with that "3" ghost post moderations.... now they are gone! Thank you, Thank you, Thank you!

  7. #7

    Default Re: incorrect info in quick moderation module

    you can give me real direction what to do?

    i dont find any dalate optin

  8. #8
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: incorrect info in quick moderation module

    You need to run the query posted above through your Admin CP or phpMyAdmin.

  9. #9
    Join Date
    Aug 2008
    Location
    New England
    Posts
    24

    Default

    Sorry to bump this old thread.

    I have the same problem with posts showing up in the Quick Moderation module that don't exist.

    I tried the SQL Query above but I get an error that the Forums_moderation table doesn't exist. Is there another way to clear the stats in that module?

    I'm running VB 3.81 PL1 and CMPS v3.1.0.

    Thanks.

  10. #10
    Join Date
    Aug 2008
    Location
    New England
    Posts
    24

    Default

    I found the problem. The query needed to be: DELETE FROM vb3_moderation

  11. #11

    Default

    Can any one speek in english?
    link to direct how to do this
    sory
    i dont understand what you gays tallk here
    please show me how
    thanks

  12. #12
    Join Date
    Apr 2004
    Location
    Florida
    Posts
    45

    Default

    Please make sure you have already moderatored all new members, threads and, posts before running the query.

  13. #13
    Join Date
    Jul 2012
    Posts
    1

    Default

    You need to run the query posted above through your Admin
    Last edited by peterr77; 10-30-2012 at 11:36 PM.

  14. #14
    Join Date
    Aug 2008
    Location
    New England
    Posts
    24

    Default

    Thanks but I solved this problem 4 years ago.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 27
    Last Post: 10-09-2010, 03:21 PM
  2. Quick Moderation module
    By antivirus in forum "How Do I..." Questions
    Replies: 6
    Last Post: 03-26-2006, 07:49 AM
  3. Quick moderation module
    By Paulo in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 10-24-2005, 02:09 PM
  4. Turned off Quick Moderation module, and not it wont work anymore
    By cmiller1014 in forum Troubleshooting / "How do I..." Questions
    Replies: 1
    Last Post: 04-03-2005, 11:03 PM
  5. Replies: 6
    Last Post: 08-05-2004, 10:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •