3.1.3. Installation - Post approval problem

[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.

Hi

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]

SQL

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

BACKTRACE

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?

Many thanks

[Oyabun1]

What method did you use to update/upgrade? Any errors whilst upgrading?

[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]

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

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 ...

[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/


robert