Unapproved post notification will not go away (Topics value -1)

Started by OCJ, November 18, 2013, 08:24:57 AM

Previous topic - Next topic

OCJ

SMF 2.06

Not sure how this topic got to the state of 'unapproved' - it was my post. I clicked 'Approve' but on the board view it still shows the Unapproved posts symbol (!)

On mouse hover it shows Topics value as -1.
It wont go away even after going through all maintenance tasks - recount stats etc.
Screenshot attached.

margarett

That is a really strange problem...

I've tried to reproduce here, but setting directly the values to -1 in the boards table and I can't get that "Topics: 1-, Posts: 0"

Anyway, if you have no other posts pending approval, you can fix it via phpmyadmin, with the following queries:

UPDATE smf_boards
SET unapproved_posts = 0, unapproved_topics = 0


UPDATE smf_topics
SET unapproved_posts = 0


UPDATE smf_messages
SET approved = 1


I'm not sure you can call this a bug because we don't know how it got like this.
What MODs do you have installed?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Shambles

I'm sure I've seen this reported before.

I seem to remember the solution involving turning post moderation off then back on (or vice-versa) in Core Features.

emanuele



Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Arantor

All turning it off and on again does is brute force approve everything. I'm not sure how it gets out of sync,  I've seen it too but never on a forum of my own where I could debug it :(

OCJ

Yes I forgot to add that - when going to the moderation panel there is nothing to moderate.

Anyway, looking at it today its gone! I think I had that before too. What is resetting things 'during the night' I don't know.
Something in the scheduled maintenance I suppose or date change.


   Mod Name    Version    
1.    mp notification style    v1    [ Uninstall ] [ List Files ] [ Delete ]
2.    Order Custom Profile Fields    1.1.1    [ Uninstall ] [ List Files ] [ Delete ]
3.    RepliesViewsNewLayout    1.0    [ Uninstall ] [ List Files ] [ Delete ]
4.    Advanced Language Menu    3.0.1    [ Uninstall ] [ List Files ] [ Delete ]
5.    Avatar on Member List    2.0    [ Uninstall ] [ List Files ] [ Delete ]
6.    Simple Youtube Video Embedder/BBC    1.1    [ Uninstall ] [ List Files ] [ Delete ]
7.    Scrolling Buttons    0.3    [ Uninstall ] [ List Files ] [ Delete ]
8.    Aeva ~ Auto-Embed Video & Audio    7.2    [ Install Mod ] [ List Files ] [ Delete ]
9.    Alternate User Posting    1.0.1    [ Uninstall ] [ List Files ] [ Delete ]
10.    Disable to send EMail with Forum-System for Users lower than Admin    1.0    [ Uninstall ] [ List Files ] [ Delete ]
11.    Akismet Spam Blocking    1.2    [ Uninstall ] [ List Files ] [ Delete ]
12.    Send Locked Topics To Bottom    1.0    [ Uninstall ] [ List Files ] [ Delete ]
13.    SimplePortal    2.3.5    [ Uninstall ] [ List Files ] [ Delete ]
14.    BoardColor    V1    [ Uninstall ] [ List Files ] [ Delete ]
15.    Double Check your Email in Registration by SmfSimple.com    1.0    [ List Files ] [ Delete ]
16.    Admin Notepad    2.0.2    [ Uninstall ] [ List Files ] [ Delete ]
17.    Change All Subjects    1.1.2    [ Uninstall ] [ List Files ] [ Delete ]
18.    Look But No Read    1.3    [ Uninstall ] [ List Files ] [ Delete ]
19.    Email Template Editor    1.0    [ List Files ] [ Delete ]
20.    Topic Descriptions    1.3    [ Uninstall ] [ List Files ] [ Delete ]
21.    SMF 1.1.19 / 2.0.6 Update    1.0    [ Uninstall ] [ List Files ] [ Delete ]
22.    Force Topic Read On Login Mod    2.1    [ Uninstall ] [ List Files ] [ Delete ]
23.    MetaTags Modification    2.0.2    [ Uninstall ] [ List Files ] [ Delete ]
24.    Post Template Mod    0.1.3    [ Uninstall ] [ List Files ] [ Delete ]
25.    Remove Post Count    1.0.2    [ Uninstall ] [ List Files ] [ Delete ]
26.    SimpleColorizer    1.1    [ Uninstall ] [ List Files ] [ Delete ]
27.    FancyBox 4 SMF    0.5    [ Uninstall ] [ List Files ] [ Delete ]
28.    PM Informer    4.0    [ Uninstall ] [ List Files ] [ Delete ]
29.    Topic Author    0.1    [ Uninstall ] [ List Files ] [ Delete ]
30.    Ad Managment    3.0.1    [ Install Mod ] [ List Files ] [ Delete ]
31.    Holiday/Sunday Color Red    1.0.1    [ List Files ] [ Delete ]
32.    Menu Editor Lite    1.0.5    [ Uninstall ] [ List Files ] [ Delete ]
33.    SMF 2.0.5 Update    1.0    [ List Files ] [ Delete ]
34.    Clabicons    1.0    [ List Files ] [ Delete ]
35.    Users Online Today    2.0.3    [ Uninstall ] [ List Files ] [ Delete ]
36.    PM Warning    1.0    [ Uninstall ] [ List Files ] [ Delete ]

ormuz

How to remove this bug from appear in the boardindex and messageindex at least?

emanuele



Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

ormuz

The mod that is causing this: Akismet Spam Blocking... just saying.

emanuele

Good that you find it!
Then a nudge to the author in the mod's support topic would be very nice. ;)


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

OCJ


Advertisement: