phpBB 3.1.0-dev upgrading to phpBB 3.2.2

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.
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by stevemaury »

Backup all the phpBB files and the phpBB database on your host to your local computer. Then:

1. Download this and unzip on your computer - https://download.phpbb.com/pub/release/ ... -3.1.0.zip
2. From the unzipped package, delete the config.php file and the /files, /store, and /images folders.
3. From your 3.0.1 dev installation on the host, delete every file and folder EXCEPT the config.php file and the /files, /store, and /images folders.
4. Upload the remaining files from step 2 from your local computer to the root directory of your board (/phpBB3) on your host.
5. Browse to www.arnhemseluitjes/phpBB3/install and select the option to update the database.
6. After the database update is done, delete the /install folder.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by 3Di »

I highly doubt that would work, though.

We shouldn't forget that the very first "test" version officially released here it was "phpBB 3.1.0-beta1", and all of the alpha versions located here weren't mentioned/announced at all in this very site's announcements forum
We are pleased to announce the release of phpBB 3.1.0 Beta1, the "Bertie Skypes Without Pants" release. This is the first test version of the upcoming phpBB 3.1.0 feature release and introduces major changes and new functionality

..snip...

Support Status
This beta release is not intended for use in a production environment and only very-limited support will be offered with the express purpose of identifying bugs. As has always been the case, no assistance will be offered for updating from any beta release. Please do not ignore this warning.
To many of things changed since Ascraeus@dev to 3.1.0 "Gold"
(which dev though :?: , considering the DEV version is not a release at all, but bleeding edge code which changes every day, like at the area 51's site === master branch at github).

Not to ruin a party here but.. considering the board has a very limited number of posts (if I correctly recall, yesterday I lurked at it) I would go for a sort of copy&paste of those, instead, into an archive forum.
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by stevemaury »

Marco, the advice I gave to first update to 3.1.0 was given me by the Devs.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by 3Di »

stevemaury wrote: Tue Jan 30, 2018 8:09 pm Marco, the advice I gave to first update to 3.1.0 was given me by the Devs.
I am sure of that, I highly doubt it will work though, again.

How the OP downloaded and installed a nightly build? A snapshot of a bleeding edge code.. not a release at all. :roll:

From github.

Surely this operation needs a bit of knowledge since that needs to install the dependencies etc.., and what about the date of such snapshot?
A @dev is before of any "alpha", btw. It is a daily development stage.
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by Lumpy Burgertushie »

unless there is some problem with the database update, replacing all of the files with current version should work.
running the database update shouldn't be a problem either.


why should the fact that it was a dev version be any harder for the database update than upgrading from 3.0 to 3.2 is?

rolbert
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.
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by canonknipser »

Lumpy Burgertushie wrote: Wed Jan 31, 2018 2:54 am why should the fact that it was a dev version be any harder for the database update
Maybe because the database migration files in a official version are not properly created to correct database issues happening only in the dev version?
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB
frnksttrhn
Registered User
Posts: 53
Joined: Sun Jan 14, 2018 2:04 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by frnksttrhn »

LS
Tried the suggestion of Stevemaury.
Downloaded phpbb3.1.0
because it is an English version
I changed the language in test forum on arnhemseluitjes.net/updateforum2, to english
then i did run
https://arnhemseluitjes.net/updateforum ... update.php

Frank

result see below:

Code: Select all

 
Updating database to latest stable release

Database type :: mysqli
Previous version :: 3.1.0-dev
Installing Data: \phpbb\db\migration\data\v310\acp_style_components_module.
Installed Data: \phpbb\db\migration\data\v310\acp_style_components_module; Time: 2.89 seconds
Migration already effectively installed (skipped): \phpbb\db\migration\data\v310\jquery_update
Installing Schema: \phpbb\db\migration\data\v310\allow_cdn.
Installed Schema: \phpbb\db\migration\data\v310\allow_cdn; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\allow_cdn.
Installed Data: \phpbb\db\migration\data\v310\allow_cdn; Time: 0.10 seconds
Installing Schema: \phpbb\db\migration\data\v310\auth_provider_oauth.
Installed Schema: \phpbb\db\migration\data\v310\auth_provider_oauth; Time: 0.02 seconds
Installing Data: \phpbb\db\migration\data\v310\auth_provider_oauth.
Installed Data: \phpbb\db\migration\data\v310\auth_provider_oauth; Time: 6.83 seconds
Installing Schema: \phpbb\db\migration\data\v310\avatars.
Installed Schema: \phpbb\db\migration\data\v310\avatars; Time: 0.56 seconds
Installing Data: \phpbb\db\migration\data\v310\avatars.
Installed Data: \phpbb\db\migration\data\v310\avatars; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v310\boardindex.
Installed Schema: \phpbb\db\migration\data\v310\boardindex; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\boardindex.
Installed Data: \phpbb\db\migration\data\v310\boardindex; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\config_db_text.
Installed Schema: \phpbb\db\migration\data\v310\config_db_text; Time: 0.01 seconds
Installing Data: \phpbb\db\migration\data\v310\config_db_text.
Installed Data: \phpbb\db\migration\data\v310\config_db_text; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\forgot_password.
Installed Schema: \phpbb\db\migration\data\v310\forgot_password; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\forgot_password.
Installed Data: \phpbb\db\migration\data\v310\forgot_password; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\mod_rewrite.
Installed Schema: \phpbb\db\migration\data\v310\mod_rewrite; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\mod_rewrite.
Installed Data: \phpbb\db\migration\data\v310\mod_rewrite; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\mysql_fulltext_drop.
Installed Schema: \phpbb\db\migration\data\v310\mysql_fulltext_drop; Time: 0.07 seconds
Installing Data: \phpbb\db\migration\data\v310\mysql_fulltext_drop.
Installed Data: \phpbb\db\migration\data\v310\mysql_fulltext_drop; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\namespaces.
Installed Schema: \phpbb\db\migration\data\v310\namespaces; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\namespaces.
Installed Data: \phpbb\db\migration\data\v310\namespaces; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\notifications.
Installed Schema: \phpbb\db\migration\data\v310\notifications; Time: 0.02 seconds
Installing Data: \phpbb\db\migration\data\v310\notifications.
Installed Data: \phpbb\db\migration\data\v310\notifications; Time: 0.07 seconds
Installing Schema: \phpbb\db\migration\data\v310\notifications_cron.
Installed Schema: \phpbb\db\migration\data\v310\notifications_cron; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\notifications_cron.
Installed Data: \phpbb\db\migration\data\v310\notifications_cron; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v310\notifications_schema_fix.
Installed Schema: \phpbb\db\migration\data\v310\notifications_schema_fix; Time: 0.03 seconds
Installing Data: \phpbb\db\migration\data\v310\notifications_schema_fix.
Installed Data: \phpbb\db\migration\data\v310\notifications_schema_fix; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\notification_options_reconvert.
Installed Schema: \phpbb\db\migration\data\v310\notification_options_reconvert; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\notification_options_reconvert.
Installed Data: \phpbb\db\migration\data\v310\notification_options_reconvert; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v310\plupload.
Installed Schema: \phpbb\db\migration\data\v310\plupload; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\plupload.
Installed Data: \phpbb\db\migration\data\v310\plupload; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v310\signature_module_auth.
Installed Schema: \phpbb\db\migration\data\v310\signature_module_auth; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\signature_module_auth.
Installed Data: \phpbb\db\migration\data\v310\signature_module_auth; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\softdelete_p1.
Installed Schema: \phpbb\db\migration\data\v310\softdelete_p1; Time: 0.86 seconds

The database update has not yet completed.

Continue database update 
Powered by phpBB® Forum Software © phpBB Limited 

Code: Select all

Updating database to latest stable release

Database type :: mysqli
Previous version :: 3.1.0-dev
Installing Data: \phpbb\db\migration\data\v310\softdelete_p1.
Installed Data: \phpbb\db\migration\data\v310\softdelete_p1; Time: 8.43 seconds
Installing Schema: \phpbb\db\migration\data\v310\softdelete_p2.
Installed Schema: \phpbb\db\migration\data\v310\softdelete_p2; Time: 0.21 seconds
Installing Data: \phpbb\db\migration\data\v310\softdelete_p2.
Installed Data: \phpbb\db\migration\data\v310\softdelete_p2; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\softdelete_mcp_modules.
Installed Schema: \phpbb\db\migration\data\v310\softdelete_mcp_modules; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\softdelete_mcp_modules.
Installed Data: \phpbb\db\migration\data\v310\softdelete_mcp_modules; Time: 1.74 seconds

The database update has not yet completed.

Continue database update 

Code: Select all

 
Updating database to latest stable release

Database type :: mysqli
Previous version :: 3.1.0-dev
Installing Schema: \phpbb\db\migration\data\v310\teampage.
Installed Schema: \phpbb\db\migration\data\v310\teampage; Time: 0.01 seconds
Installing Data: \phpbb\db\migration\data\v310\teampage.
Installed Data: \phpbb\db\migration\data\v310\teampage; Time: 0.62 seconds
Installing Schema: \phpbb\db\migration\data\v310\alpha1.
Installed Schema: \phpbb\db\migration\data\v310\alpha1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\alpha1.
Installed Data: \phpbb\db\migration\data\v310\alpha1; Time: 0.02 seconds
Installing Schema: \phpbb\db\migration\data\v310\notifications_cron_p2.
Installed Schema: \phpbb\db\migration\data\v310\notifications_cron_p2; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\notifications_cron_p2.
Installed Data: \phpbb\db\migration\data\v310\notifications_cron_p2; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v310\alpha2.
Installed Schema: \phpbb\db\migration\data\v310\alpha2; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\alpha2.
Installed Data: \phpbb\db\migration\data\v310\alpha2; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\avatar_types.
Installed Schema: \phpbb\db\migration\data\v310\avatar_types; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\avatar_types.
Installed Data: \phpbb\db\migration\data\v310\avatar_types; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v310\passwords.
Installed Schema: \phpbb\db\migration\data\v310\passwords; Time: 2.60 seconds
Installing Data: \phpbb\db\migration\data\v310\passwords.
Installed Data: \phpbb\db\migration\data\v310\passwords; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\profilefield_types.
Installed Schema: \phpbb\db\migration\data\v310\profilefield_types; Time: 0.03 seconds
Installing Data: \phpbb\db\migration\data\v310\profilefield_types.
Installed Data: \phpbb\db\migration\data\v310\profilefield_types; Time: 3.56 seconds
Installing Schema: \phpbb\db\migration\data\v310\alpha3.
Installed Schema: \phpbb\db\migration\data\v310\alpha3; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\alpha3.
Installed Data: \phpbb\db\migration\data\v310\alpha3; Time: 0.00 seconds
Migration already effectively installed (skipped): \phpbb\db\migration\data\v310\soft_delete_mod_convert
Installing Schema: \phpbb\db\migration\data\v310\reset_missing_captcha_plugin.
Installed Schema: \phpbb\db\migration\data\v310\reset_missing_captcha_plugin; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v310\reset_missing_captcha_plugin.
Installed Data: \phpbb\db\migration\data\v310\reset_missing_captcha_plugin; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\profilefield_show_novalue.
Installed Schema: \phpbb\db\migration\data\v310\profilefield_show_novalue; Time: 0.02 seconds
Installing Data: \phpbb\db\migration\data\v310\profilefield_show_novalue.
Installed Data: \phpbb\db\migration\data\v310\profilefield_show_novalue; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v310\profilefield_interests.
Installed Schema: \phpbb\db\migration\data\v310\profilefield_interests; Time: 0.01 seconds
Installing Data: \phpbb\db\migration\data\v310\profilefield_interests.
SQL ERROR [ mysqli ]

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

SQL

INSERT INTO phpbb_profile_fields (field_name, field_type, field_ident, field_length, field_minlen, field_maxlen, field_novalue, field_default_value, field_validation, field_required, field_show_novalue, field_show_on_reg, field_show_on_pm, field_show_on_vt, field_show_profile, field_hide, field_no_view, field_active, field_order) VALUES ('phpbb_interests', 'profilefields.type.text', 'phpbb_interests', '3|30', '2', '500', '', '', '.*', 0, 0, 0, 0, 0, 1, 0, 0, 1, 1)

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/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()

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

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

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\profilefield_base_migration->create_custom_field()

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

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

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

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

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

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

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

FILE: [ROOT]/install/database_update.php
LINE: 206
CALL: phpbb\db\migrator->update()

Powered by phpBB® Forum Software © phpBB Limited 
frnksttrhn
Registered User
Posts: 53
Joined: Sun Jan 14, 2018 2:04 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by frnksttrhn »

LS
I tried to update to phpBB 3.2.2.NL(dutch version) and used an older version of my database. and succeeded tot update
http://www.arnhemseluitjes.net/luitforum.
So what can be wrong with the most recent database of
http://wwwarnhemseluitjes/phpBB3??
Frank
Last edited by frnksttrhn on Mon Feb 19, 2018 1:11 pm, edited 1 time in total.
frnksttrhn
Registered User
Posts: 53
Joined: Sun Jan 14, 2018 2:04 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by frnksttrhn »

LS
Thank you for your help. I do appreciate it very much.
So I managed to update from phpBB 3.1.0-dev to phpBB3.2.2 Using the db from january 14.
see:
http://www.arnhemseluitjes.net/luitforum
So far so good.
But I'm facing the problem that the users of the forum, I still do want to update http://wwwarnhemseluitjes.net/phpBB3, still going on with their messages. Also in the meantime I did clean the forum of old and archived messages because I hoped to speed up the forum. Till now I did not manage to update this forum wich is: phpBB 3.1.0-dev to phpBB 3.2.2.

Is there a way to merge the db from 14 january with the changed db from february 3? and then again try to update to phpBB 3.2.2?

Frank
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by janus_zonstraal »

Is there a way to merge the db from 14 january with the changed db from february 3? and then again try to update to phpBB 3.2.2?
No
Sorry! My English is bat ;) !!!
frnksttrhn
Registered User
Posts: 53
Joined: Sun Jan 14, 2018 2:04 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by frnksttrhn »

Apparently there is no method to merge two db's.
The problem stays then how to update most recent db? see the failures till now.
It was possible to update the db from 14 januari.
What can be a reason, it is not possible for the db today?
In my humble opinion it seems to be a db thing.
Is there a way to investigate that the db?
Frank
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by janus_zonstraal »

Changing to a better host is a start.

Now 16:19 hour your site in off line
Sorry! My English is bat ;) !!!
frnksttrhn
Registered User
Posts: 53
Joined: Sun Jan 14, 2018 2:04 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by frnksttrhn »

Janus_zonstraal advised
Changing to a better host is a start.
.
Define better host?
Maybe slowness of the forum is due to a shared hostingplan?
Meaning another host will provide more speed?
Then my problem is still I cannot upgrade with the most recent db.
Is there a difference in speed between phpBB 3.1.0-dev and version phpBB 3.2.2? Meaning is it a necessity to upgrade?

So if I want to upgrade to phpBB 3.2.2? with the most recent db of my forum http://www.arnhemseluitjes.netphBB3 and I do not succeed.
But I do succeed to upgrade to phpBB 3.2.2? with a db of the same forum of 14 january 2018.
What can possibly be the cause of this?
Frank
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by janus_zonstraal »

A better host will give you more speed, speed has very little to do with the phpbb version, shared or non shared.
Sorry! My English is bat ;) !!!
frnksttrhn
Registered User
Posts: 53
Joined: Sun Jan 14, 2018 2:04 pm

Re: phpBB 3.1.0-dev upgrading to phpBB 3.2.2

Post by frnksttrhn »

Thanks, it's clear to me now there is no difference in speed between phpbb versions and that shared hosting is not an explanation for the slowness of my forum. Again, I've contacted my host about that because I hope he will solve this problem at the end. My website, forum and weblog are hosted there since 2005. Till this problem arrived our relation was 24/7 o.k.

Still this question remains
So if I want to upgrade to phpBB 3.2.2? with the most recent db of my forum http://www.arnhemseluitjes.netphBB3 and I do not succeed.
But I do succeed to upgrade to phpBB 3.2.2? with a db of the same forum of 14 january 2018.
What can possibly be the cause of this?
Frank
Locked

Return to “[3.1.x] Support Forum”