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.
SQL ERROR [ mysql4 ]
BIGINT UNSIGNED value is out of range in '(`phpbb_a`.`forums`.`forum_posts_unapproved` - 1)' 
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)
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?