incorrect info in quick moderation module

[ncangler]

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?

[Brian]

This query should remove any entries in that table:

DELETE FROM moderation

[ncangler]

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

Originally Posted by Brian

This query should remove any entries in that table:

DELETE FROM moderation

[Brian]

Either one should work fine.

[ncangler]

Worked like a charm. Thanks Brian!

[Webber]

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!

[avitor]

you can give me real direction what to do?

i dont find any dalate optin

[Brian]

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

[Don Z.]

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.

[Don Z.]

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

[avitor]

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

[clearchannel]

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

[peterr77]

You need to run the query posted above through your Admin

[mugni16]

oke sip,, thanks information