Can't upgrade to 3.1 Unknown column 'forum_posts_approved' in 'field list' [1054]

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Get Involved
Post Reply
afinta
Registered User
Posts: 19
Joined: Sat Oct 22, 2005 3:37 pm

Can't upgrade to 3.1 Unknown column 'forum_posts_approved' in 'field list' [1054]

Post by afinta » Sun Nov 27, 2016 5:32 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.14
What is your board's URL? http://www.virgin-islands-on-line.com/virgin-islands
Who do you host your board with? Rackspace/myself
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No (can't be reproduced at the moment - but the old board back in place)
Do you have any MODs installed? Not that I know of - just some template changes for display only
Do you have any extensions installed? No
What version of phpBB3 did you update from? trying to go from phpBB 3.0.14 to 3.1.x
What styles do you currently have installed ?prosilver
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL 5 is running - but board was installed on 4.x
What is your level of experience? Experienced with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Installed version is 3.0.14 on mysql4 DB - but now my server says I am running MySQL version 5.1.73

Trying to update to latest version, carefully following instructions - fails when loading http://www.virgin-islands-on-line.com/v ... update.php into browser - (you won't see this - moved back to the 3.0.14 version)

Please describe your problem.

Error when loading http://www.virgin-islands-on-line.com/v ... update.php into browser - below:

Updating database to latest stable release

Database type :: mysql4
Previous version :: 3.0.14
SQL ERROR [ mysql4 ]

Unknown column 'forum_posts_approved' in 'field list' [1054]

SQL

UPDATE phpbb_forums SET forum_posts_approved = forum_posts WHERE forum_type = 2

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/db/migration/data/v310/softdelete_p1.php
LINE: 162
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\data\v310\softdelete_p1->update_forums_topic_and_post_counts()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 591
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 538
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 361
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 276
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 216
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 199
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/install/database_update.php
LINE: 205
CALL: phpbb\db\migrator->update()
[size=60]Generated by SRT Generator[/size]

afinta
Registered User
Posts: 19
Joined: Sat Oct 22, 2005 3:37 pm

Re: Can't upgrade to 3.1 Unknown column 'forum_posts_approved' in 'field list' [1054]

Post by afinta » Tue Nov 29, 2016 1:30 am

Bueller?

User avatar
Leinad4Mind
Translator
Posts: 804
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

Re: Can't upgrade to 3.1 Unknown column 'forum_posts_approved' in 'field list' [1054]

Post by Leinad4Mind » Thu Sep 21, 2017 7:58 pm

I got this too when upgrading a 3.0.12 forum with 3.1.11 release, and 3.2.1 too.

Even after running STK fr 3.0.x mysql_upgrader.

EDIT: I've re-send the database to the server and now it worked... I'll never know what happened... lol
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator

Post Reply

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: Sogou [Spider] and 15 guests

cron