To many of things changed since Ascraeus@dev to 3.1.0 "Gold"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.
I am sure of that, I highly doubt it will work though, again.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.
Maybe because the database migration files in a official version are not properly created to correct database issues happening only in the dev version?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
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
NoIs 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?
.Changing to a better host is a start.