Not so fast, using your old database in a fresh setup of phpBB requires knowing some data (which may have to be edited before your old board can function properly).Tobias Claren wrote: ↑Mon Oct 25, 2021 2:36 pm This is quite possible. So do I have to download and install a phpBB 3.1.
The reason for that is probably that you installed the board with a different table_prefix than the one from the backup.Tobias Claren wrote: ↑Mon Oct 18, 2021 1:49 pm Then the backup. There are no errors, but also no forums.
There is only "Your first forum". But in the MySQL database, the old forums are there .
Code: Select all
DROP TABLE IF EXISTS phpbb_ext;
CREATE TABLE `phpbb_ext` (
`ext_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`ext_active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ext_state` text COLLATE utf8_bin NOT NULL,
UNIQUE KEY `ext_name` (`ext_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Code: Select all
DROP TABLE IF EXISTS phpbb_styles;
CREATE TABLE `phpbb_styles` (
`style_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`style_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`style_copyright` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`style_active` tinyint(1) unsigned NOT NULL DEFAULT '1',
`style_path` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'kNg=',
`style_parent_id` int(4) unsigned NOT NULL DEFAULT '0',
`style_parent_tree` text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`style_id`),
UNIQUE KEY `style_name` (`style_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO phpbb_styles (style_id, style_name, style_copyright, style_active, style_path, bbcode_bitfield, style_parent_id, style_parent_tree) VALUES (1, 'prosilver', '© phpBB Limited', 1, 'prosilver', 'kNg=', 0, ''),(2, 'DVGFX', '© Prosk8er, 2014', 1, 'DVGFX', '+Ng=', 1, 'prosilver'),(5, 'BlackSlate', '© phpbbireland 2008', 1, 'blackslate', '+Ng=', 1, 'prosilver');
A fresh setup = a completely new board. Just importing that database won't make it work, but it can be upgraded if the database is imported correctly and prepared for upgrading)Tobias Claren wrote: ↑Mon Oct 25, 2021 5:19 pm What kind of "fresh setup"?
In the new installation of 3.3.5 (apps installer of the web space) it does not work.
And I didn't manage to install 3.1.11.
It might work, but I can't install it by hand.
And the apps installer on the Goodnet web space (and others) does not contain an old version.
There is no "server" or personal web space at home.
I can't find a "Field" in the backup in Notepad ++.
This is good news: no extensions (that's assuming there's no INSERT statement which you forgot to copy).Tobias Claren wrote: ↑Mon Oct 25, 2021 5:19 pm 237kb: "backup_1517857192_4af404fecb3c6c95.sql.gz"
# Table: phpbb_extCode: Select all
DROP TABLE IF EXISTS phpbb_ext; CREATE TABLE `phpbb_ext` ( `ext_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `ext_active` tinyint(1) unsigned NOT NULL DEFAULT '0', `ext_state` text COLLATE utf8_bin NOT NULL, UNIQUE KEY `ext_name` (`ext_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
So you have 3 styles. Prosilver needs to be the only active (and default) style when upgrading.Tobias Claren wrote: ↑Mon Oct 25, 2021 5:19 pmCode: Select all
# Table: phpbb_styles INSERT INTO phpbb_styles (style_id, style_name, style_copyright, style_active, style_path, bbcode_bitfield, style_parent_id, style_parent_tree) VALUES (1, 'prosilver', '© phpBB Limited', 1, 'prosilver', 'kNg=', 0, ''),(2, 'DVGFX', '© Prosk8er, 2014', 1, 'DVGFX', '+Ng=', 1, 'prosilver'),(5, 'BlackSlate', '© phpbbireland 2008', 1, 'blackslate', '+Ng=', 1, 'prosilver');
After you’ve successfully upgraded phpBB, as opposed to just ”viewing the forum structure”, there’s a bridge called BridgeDD PRO that supports phpBB 3.3 but it isn't free.
WordPress wrote:BridgeDD PRO supports phpBB 3.1, 3.2, and 3.3, and it is fully compatible with the Gutenberg/Block editor