After installing backup from 05.02.2018 no forum structure can be seen.

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Tobias Claren
Registered User
Posts: 56
Joined: Tue Jul 29, 2003 7:14 pm
Location: Cologne
Contact:

After installing backup from 05.02.2018 no forum structure can be seen.

Post by Tobias Claren »

Hello.

I want to view the forum structure from a backup from phpBB (from 5.2.2018).
Therefore I installed phpBB 3.3.5 in a webspace.
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 :shock: .
.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26456
Joined: Fri Aug 29, 2008 9:49 am

Re: After installing backup from 05.02.2018 no forum structure can be seen.

Post by Mick »

What phpBB version is the backup you have, I guess it’s around 3.1? That being the case it won’t work properly in a 3.3 environment. Are you using a local server like xampp etc? If so you should be able to set up the server to have the requirements (PHP version etc.) for the version of phpBB you want to look at. Older versions of phpBB are here http://sourceforge.net/projects/phpbb/files/
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Tobias Claren
Registered User
Posts: 56
Joined: Tue Jul 29, 2003 7:14 pm
Location: Cologne
Contact:

Re: After installing backup from 05.02.2018 no forum structure can be seen.

Post by Tobias Claren »

This is quite possible. So do I have to download and install a phpBB 3.1.
Can I possibly transfer the structure in other forum formats? E.g. BBpress.
And then possibly back into phpBB.
I want to compare both forums.
phpBB may not integrate so well with wordpress.
I have a simple design with certain colors.
This look should not be broken.

EDIT:
I tried to install 3.1.11.
It cannot be installed.
I tried to open this:
web-site.com/phpbb/install/
And:
web-site.com/phpbb/install/install_main.php
And:
web-site.com/phpbb/install/index.php

It doesn't work.
HTTP ERROR 500
.
User avatar
warmweer
Jr. Extension Validator
Posts: 11198
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: After installing backup from 05.02.2018 no forum structure can be seen.

Post by warmweer »

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.
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).
I suggest/recommend testing on localhost (personal webserver) first (that will allow easier and faster testing - and a lot faster copying of files)
First thing to do is to find out which version of phpBB your board was.
Check the config table, field version. That the version you need to install. (and will determine which version of php you can use)
And while you're looking at the database: check the contents of the _ext table and _styles table and post those.
Once we have that information we can probably point to a relatively simple path to get your board running.

BTW what's the size of your database backup (sql or gz/zip?)

Added:
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 :shock: .
The reason for that is probably that you installed the board with a different table_prefix than the one from the backup.
Editing your config.php (change the table prefix) may solve that.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Tobias Claren
Registered User
Posts: 56
Joined: Tue Jul 29, 2003 7:14 pm
Location: Cologne
Contact:

Re: After installing backup from 05.02.2018 no forum structure can be seen.

Post by Tobias Claren »

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 ++.

237kb: "backup_1517857192_4af404fecb3c6c95.sql.gz"

# Table: phpbb_ext

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;
# Table: phpbb_styles

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');
.
User avatar
warmweer
Jr. Extension Validator
Posts: 11198
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: After installing backup from 05.02.2018 no forum structure can be seen.

Post by warmweer »

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 ++.
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)
So you installed using webhost installer.
Strictly speaking support should then be sought at the webhost itself as the host knows its files (at least they should).
It best to use files downloaded from phpBB.com as these are guaranteed not-modified.
I suspect that the webhost 's php version is not suited for phpBB3.1.x anyway.
A personal webserver is a software which emulates a host : see Installing and Setting Up Your Own Web Server.
As to "field", in your backup there are SQL-statements (like the one you posted). A text search should reveal the table "prefix"_config and then the field "version". But a text search can be tiresome in large files so use phpMyAdmin.
Tobias Claren wrote: Mon Oct 25, 2021 5:19 pm 237kb: "backup_1517857192_4af404fecb3c6c95.sql.gz"
# Table: phpbb_ext

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;
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

Code: 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');
So you have 3 styles. Prosilver needs to be the only active (and default) style when upgrading.

Your database (zipped) is only 237kb and that is quite small.
I'm willing to have a look at the database and possibly upgrade it for you. But that implies that you would need to send me the database and that I can see everything in there (not passwords: those are encrypted). PM me if you're interested (it's a free offer - no money involved, but no timetable either- I can have a look this evening (it's past 8PM in my timezone) but will only be able to start on it tomorrow evening).

Added: the DVGFX style has a version for 3.3.5, BlackSlate however doesn't.
Last edited by warmweer on Thu Oct 28, 2021 8:14 am, edited 1 time in total.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26456
Joined: Fri Aug 29, 2008 9:49 am

Re: After installing backup from 05.02.2018 no forum structure can be seen.

Post by Mick »

Please note support for phpBB versions earlier than 3.2.0 has ended. Any support requests regarding those versions are limited to help with upgrading to the latest version.
Tobias Claren wrote: Mon Oct 25, 2021 2:36 pm phpBB may not integrate so well with wordpress
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
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Post Reply

Return to “[3.3.x] Support Forum”