Error update from 3.0 to 3.1 "unknown column style_path"

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
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.
Locked
TheSailor
Registered User
Posts: 2
Joined: Thu Feb 19, 2015 1:06 pm

Error update from 3.0 to 3.1 "unknown column style_path"

Post by TheSailor » Thu Feb 19, 2015 2:55 pm

My forum was phpbb 3.0.13, but when trying to update to 3.1.3 based on the info in the topic here, i ran into errors. I have php 5.5, use the standard prosilver theme.

I fixed some with the "mysql updater script" (like field 'xxxx' doesn't have a default value [1364]).
But this issue remains when running the database install script

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

Code: Select all

Updating database to latest stable release

Database type :: mysql4
Previous version :: 3.0.13-PL1
Installing Data: \phpbb\db\migration\data\v310\bot_update.
Installed Data: \phpbb\db\migration\data\v310\bot_update; Time: 0.03 seconds
Installing Schema: \phpbb\db\migration\data\v310\gold.
Installed Schema: \phpbb\db\migration\data\v310\gold; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\gold.
Installed Data: \phpbb\db\migration\data\v310\gold; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\style_update.
Installed Schema: \phpbb\db\migration\data\v31x\style_update; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\style_update.
SQL ERROR [ mysql4 ]

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

SQL

SELECT style_path, style_id FROM phpbb3_styles

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/v31x/style_update.php
LINE: 38
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\data\v31x\style_update->update_installed_styles()

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

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

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

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

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

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

FILE: [ROOT]/install/database_update.php
LINE: 206
CALL: phpbb\db\migrator->update()
Any ideas on how to fix this? Thanks for your time!

Korkel
Registered User
Posts: 391
Joined: Mon Jun 02, 2014 7:09 am
Location: ~/home/Liz/Desktop
Name: Liz Aalderink
Contact:

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by Korkel » Thu Feb 19, 2015 7:23 pm

I'm currently helping him with this, can it be a problem with the style and some modifications that are installed?
"If you lose your left arm, your right arm will be left."
“The most important property of a program is whether it accomplishes the intention of its user.”
Image

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21736
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by Mick » Thu Feb 19, 2015 7:40 pm

How are you upgrading, what method?

This is the recommended path: 3.1 User guide Upgrading from 3.0 to 3.1
"The more connected we get the more alone we become" - Kyle Broflovski

Korkel
Registered User
Posts: 391
Joined: Mon Jun 02, 2014 7:09 am
Location: ~/home/Liz/Desktop
Name: Liz Aalderink
Contact:

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by Korkel » Thu Feb 19, 2015 8:07 pm

Mick wrote:How are you upgrading, what method?

This is the recommended path: 3.1 User guide Upgrading from 3.0 to 3.1
We are using that method, but that isn't working. Also a clean install gives a white page at the last step.
"If you lose your left arm, your right arm will be left."
“The most important property of a program is whether it accomplishes the intention of its user.”
Image

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69470
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by KevC » Thu Feb 19, 2015 8:20 pm

Run the Support Toolkit database cleaner before you update.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Korkel
Registered User
Posts: 391
Joined: Mon Jun 02, 2014 7:09 am
Location: ~/home/Liz/Desktop
Name: Liz Aalderink
Contact:

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by Korkel » Fri Feb 20, 2015 8:09 am

KevC wrote:Run the Support Toolkit database cleaner before you update.
Hi Kev,

Uploaded it, when I go to domain/stk/ on Google Chrome it keeps loading, on Firefox I got a white page, seems there is something good wrong.
"If you lose your left arm, your right arm will be left."
“The most important property of a program is whether it accomplishes the intention of its user.”
Image

TheSailor
Registered User
Posts: 2
Joined: Thu Feb 19, 2015 1:06 pm

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by TheSailor » Fri Feb 20, 2015 11:29 am

Hello KevC,

Korkel is a friend of mine who was helping with the issue.
What you suggested, running that database cleaner was indeed the fix. Now I could finally finish the update to 3.1.3 without any issues. Thanks a lot!

alf007
Registered User
Posts: 36
Joined: Sun Mar 13, 2005 5:46 pm
Location: France (78)

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by alf007 » Sun Apr 26, 2015 11:22 pm

Hello there,

having the same issue, i tried the suggestion but do not get it solved.

What i've found out is that some new fields exists in phpbb_styles table (like the 'style_path') for 3.1.x,
but these new fields are never added when migrating from 3.0.13 to 3.1.3!

As i've previously done an upgrade from 3.0.12 to 3.1.0 without this issue (but didn't kept it :roll: ),
i guess there has been some database updating operations disconnected from the process somewhat between upgrade of version 3.1.0 to version 3.1.3...
:?

This should happens in phpbb/db/migration/data/v310/style_update_p1.php
which have depends_on of '\phpbb\db\migration\data\v30x\release_3_0_11'
and looking at the migrations log (in store) the v310\* is all ignored, defined as already installed!?!

Oh well, looks like that's somewhat my database still got the previous v310 migrations data trace :oops:
so that's should be ok finally, after removing this traces.

That's it! :roll:

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

Re: Error update from 3.0 to 3.1 "unknown column style_path"

Post by stevemaury » Mon Apr 27, 2015 12:37 am

No. Running database_update.php adds the necessary fields.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Locked

Return to “[3.1.x] Support Forum”