3.1.3. Installation - Post approval problem

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Krek Bristle
Registered User
Posts: 9
Joined: Sun Feb 12, 2012 10:40 am

3.1.3. Installation - Post approval problem

Post by Krek Bristle »

What version of phpBB are you using? phpBB 3.1.3 (installed today)
What is your board's URL? http://indieshaman.co.uk/community/shamanicforum/
Who do you host your board with? https://www.unlimitedwebhosting.co.uk/
How did you install your board?
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? Not sure
Do you have any MODs installed? No
What version of phpBB3 did you update from? sorry can't remember number - the last one available
What styles do you currently have installed?
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL 5.5.41-cll-lve
What is your level of experience? Moderate
When did your problem begin? After update
Please describe your problem.


I've just updated to 3.1.1. and now it appears all previous posts are now 'awaiting approval' meaning they can no longer be viewed by users.

The only way I could find to bulk approve posts was in the 'moderator panel' which lists some of the more recent posts (only). But clicking on 'approve' there just led to the following error message.

General Error
SQL ERROR [ mysql4 ]

BIGINT UNSIGNED value is out of range in '(`phpbb_a`.`forums`.`forum_posts_unapproved` - 1)' [1690]


UPDATE forums SET forum_posts_unapproved = forum_posts_unapproved - 1, forum_posts_approved = forum_posts_approved + 1 WHERE forum_id = 17


FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/phpbb/content_visibility.php
LINE: 517
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/mcp/mcp_queue.php
LINE: 685
CALL: phpbb\content_visibility->set_post_visibility()

FILE: [ROOT]/includes/mcp/mcp_queue.php
LINE: 60
CALL: mcp_queue::approve_posts()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: mcp_queue->main()

FILE: [ROOT]/mcp.php
LINE: 310
CALL: p_master->load_active()

Has anyone else had this issue? Any help much appreciated.

How do I stop the 'needing approval' issue which is happening for all types of board members posts including the administrators and moderators!

How can I 'approve' the posts without having to go through every post one by one? :shock:

Many thanks
User avatar
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: 3.1.3. Installation - Post approval problem

Post by Oyabun1 »

What method did you use to update/upgrade? Any errors whilst upgrading?
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
Krek Bristle
Registered User
Posts: 9
Joined: Sun Feb 12, 2012 10:40 am

Re: 3.1.3. Installation - Post approval problem

Post by Krek Bristle »

Thanks for the reply.

Upgraded via Plesk Panel. No, no errors while upgrading and looked to be all OK until I looked at the board itself.
Krek Bristle
Registered User
Posts: 9
Joined: Sun Feb 12, 2012 10:40 am

Re: 3.1.3. Installation - Post approval problem

Post by Krek Bristle »

Last post edited as I realised it was actually set to 'yes can post without authorization' :oops:

I think new posts are now OK. So I'm just having to manually approve every old topic (can batch approve posts under topics fortunately!) already on the board individually which were all changed to needing approval :?

A good opportunity to 'clean up' some of the board content I suppose ...
User avatar
Lumpy Burgertushie
Registered User
Posts: 68562
Joined: Mon May 02, 2005 3:11 am

Re: 3.1.3. Installation - Post approval problem

Post by Lumpy Burgertushie »

if using the host's upgrade procedure broke this, then there is no telling what else it broke.

I would suggest that you do a complete file replacement and database update using the files you get from here.
the correct procedure for upgrading to 3.1 from 3.0 is found here:
https://www.phpbb.com/support/docs/en/3 ... /upgrade3/

I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.

Return to “[3.1.x] Support Forum”