Topics awaiting approval: No Topics awaiting...

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
razster
Registered User
Posts: 14
Joined: Tue Sep 02, 2008 4:03 pm

Topics awaiting approval: No Topics awaiting...

Post by razster »

Support Request Template
What version of phpBB are you using? phpBB 3.0.6
What is your board's URL? No answer given
Who do you host your board with? No answer given
How did you install your board? I used a tool provided by my host
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? No
Is registration required to reproduce this issue? No
What styles do you currently have installed? prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
When did your problem begin? When I removed a spam account.
Please describe your problem. The spam account had tried to add a topic.
I was unable to remove topic from the message board via topic approval so I went into MySQL and deleted the pending topic, but now I still have the Triangle icon alerting me that I still have a pending Topic.
I would like to reset the pending topic so that the alert icon goes away.
Generated by SRT Generator
User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Topics awaiting approval: No Topics awaiting...

Post by HGN »

razster wrote:I was unable to remove topic from the message board via topic approval so I went into MySQL and deleted the pending topic, but now I still have the Triangle icon alerting me that I still have a pending Topic.
What exactly did you do running MySQL? I suppose you removed the unapproved topic, but didn't remove the unapproved post from the posts table.
Geoff_C8
Registered User
Posts: 10
Joined: Sun May 08, 2016 6:26 am

Re: Topics awaiting approval: No Topics awaiting...

Post by Geoff_C8 »

Pity there was no completion to this thread. I have the same issue in 3.0.9 but it was arrived at legitimately, if very stupidly.

A new poster made three identical posts. They were held in the waiting for approval status, but an admin went into the back end, and cleared all posts by that user, and this is shown in the admin logs. This has now left the offensive triangle on the forum, albeit only visible to admins, and when clicked shows three unapproved posts, but when any of these is selected, the reply is "You are not authorised to do this". I am a founder, cant get more authority. I don't want to have to go into SQL to fix this.

If the response here is that this has been fixed in a later version, I guess I will try once again to see if the webmaster will do that.

Geoff
Geoff_C8
Registered User
Posts: 10
Joined: Sun May 08, 2016 6:26 am

Re: Topics awaiting approval: No Topics awaiting...

Post by Geoff_C8 »

Well I have now discovered that deleting the user with all their posts does NOT fix this issue, so unless I get someone into the database, I guess I am stuck with this forever?

Geoff
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Topics awaiting approval: No Topics awaiting...

Post by stevemaury »

What is "the back end"?
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Locked

Return to “[3.0.x] Support Forum”