Version 3.3.4 restore doesn't work

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
kooksee
Registered User
Posts: 39
Joined: Tue Sep 17, 2019 10:12 pm

Re: Version 3.3.4 restore doesn't work

Post by kooksee »

It is still not working

I did step by step the points from here
Decompress the phpBB3 archive to a local directory on your system.
Upload all the files contained in this archive (retaining the directory structure) to a web accessible directory on your server or hosting account.
Change the permissions on config.php to be writable by all (666 or -rw-rw-rw- within your FTP Client)
Change the permissions on the following directories to be writable by all (777 or -rwxrwxrwx within your FTP Client):
store/, cache/, files/ and images/avatars/upload/.
Point your web browser to the location where you uploaded the phpBB3 files with the addition of install/app.php or simply install/, e.g. http://www.example.com/phpBB3/install/app.php, http://www.example.com/forum/install/.
Click the INSTALL tab, follow the steps and fill out all the requested information.
Change the permissions on config.php to be writable only by yourself (644 or -rw-r--r-- within your FTP Client)
phpBB3 should now be available, please MAKE SURE you read at least Section 6 below for important, security related post-installation instructions, and also take note of Section 7 regarding anti-spam measures.
If you experienced problems or do not know how to proceed with any of the steps above please read the rest of this document.
I upload 3.3.3, run the install.

I connected with the DB where I imported the back up I've already had.

the result is the same thing. one post, one user.
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Version 3.3.4 restore doesn't work

Post by warmweer »

kooksee wrote: Thu Jun 17, 2021 12:25 am It is still not working
Because you did not follow the instructions (by janus and others)
What you just did is you installed a new board. That board is a new install, with a new database and with a config.php pointing to that new database.

However, we're one step further now. All you need to do is to edit the config.php so that it points to the correct database. That is the one you imported earlier, containing the bb_config
Your phpMyAdmin printscreen shows the name: kooksee_sfbacku
So now you have to edit the config.php

Code: Select all

?php
// phpBB 3.3.x auto-generated configuration file
// Do not change anything in this file!
$dbhost = 'localhost';
$dbport = '3308';
$dbname = 'qi_333';
$dbuser = 'root';
$dbpasswd = 'usbw';
$table_prefix = 'phpbb_';
$dbms = 'phpbb\\db\\driver\\mysqli';
$acm_type = 'phpbb\\cache\\driver\\file';
$phpbb_adm_relative_path = 'adm/';

@define('PHPBB_INSTALLED', true);
@define('PHPBB_ENVIRONMENT', 'production');
//@define('DEBUG_CONTAINER', true);
the dbname has to be edited >>> kooksee_sfbackup
dbport is probably 3306 according to your printscreen
dbhost >> localhost according to your printscreen
dbuser and dbpassword is something you know (we don't)
and then there's the table_prefix which is bb_ according to your printscreen

All depends on the state of your backup, is all data there? meaning if you look at the posts_table and users_table, does that reflect the original board? If your latest install contains only 1 forum, 1 topic, 1 post, and 1 user (not counting the bots) then that install is not using the backup of your "old" forum.

One thing that I can imagine is that you used your backupdatabase to install the new board and may have overwritten the original data.
If that's the case, then just reimport you original backup data into the current database.
(and you might want to show a phpMyAdmin printscreen of the tables list (so that we can see the number of records per table).
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.
kooksee
Registered User
Posts: 39
Joined: Tue Sep 17, 2019 10:12 pm

Re: Version 3.3.4 restore doesn't work

Post by kooksee »

hello

the config.php that I have points to the DB named kooksee_sfbckp wich is the DB where I already imported the backup.
The user (with the same name for the sake of simplicity) is assigned to DB.

this my current config.php
<?php
// phpBB 3.3.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysqli';
$dbhost = '';
$dbport = '';
$dbname = 'kooksee_sfbckp';
$dbuser = 'kooksee_sfbckp';
$dbpasswd = 'xxxxxxxxx';
$table_prefix = 'phpbb_';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';

@define('PHPBB_INSTALLED', true);
@define('PHPBB_ENVIRONMENT', 'production');
// @define('DEBUG_CONTAINER', true);
Because you did not follow the instructions
Which point I didn't follow?
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Version 3.3.4 restore doesn't work

Post by janus_zonstraal »

Which point I didn't follow?
Point your web browser to the location where you uploaded the phpBB3 files with the addition of install/app.php or simply install/, e.g. http://www.example.com/phpBB3/install/app.php, http://www.example.com/forum/install/.
Click the INSTALL tab, follow the steps and fill out all the requested information.
I only said "upload the files" not install a new board.

But if you change the config.php correct that it must be OK.

Can you access the database with phpmyadmin and look into the post table and look if there are posts?
Sorry! My English is bat ;) !!!
kooksee
Registered User
Posts: 39
Joined: Tue Sep 17, 2019 10:12 pm

Re: Version 3.3.4 restore doesn't work

Post by kooksee »

yes, there are.

I don't understand why the are not shown
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Version 3.3.4 restore doesn't work

Post by janus_zonstraal »

Is it possible that config.php is somewhere in a cache?
Are you ore your host use a cache system?
Sorry! My English is bat ;) !!!
kooksee
Registered User
Posts: 39
Joined: Tue Sep 17, 2019 10:12 pm

Re: Version 3.3.4 restore doesn't work

Post by kooksee »

I did not set up a cache system.

My host is hostgator, a guy from the support just told me there is cache on their side.

should I try again but this time not installing just upload the files?
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Version 3.3.4 restore doesn't work

Post by janus_zonstraal »

a guy from the support just told me there is cache on their side.
Ask to clear the cache or wait.
Sorry! My English is bat ;) !!!
kooksee
Registered User
Posts: 39
Joined: Tue Sep 17, 2019 10:12 pm

Re: Version 3.3.4 restore doesn't work

Post by kooksee »

janus_zonstraal wrote: Fri Jun 18, 2021 9:09 pm
a guy from the support just told me there is cache on their side.
Ask to clear the cache or wait.
They cleared the cache, I waited, no luck

only one forum and one user although the DB is populated with many topics
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Version 3.3.4 restore doesn't work

Post by janus_zonstraal »

$table_prefix = 'phpbb_';
Is there a other prefix in the same database?
Sorry! My English is bat ;) !!!
kooksee
Registered User
Posts: 39
Joined: Tue Sep 17, 2019 10:12 pm

Re: Version 3.3.4 restore doesn't work

Post by kooksee »

janus_zonstraal wrote: Sat Jun 19, 2021 10:00 pm
$table_prefix = 'phpbb_';
Is there a other prefix in the same database?
I have also bb prefix
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Version 3.3.4 restore doesn't work

Post by warmweer »

kooksee wrote: Mon Jun 21, 2021 8:39 pm I have also bb prefix
So check the number of users (or forums for that matter) to find out which of those prefixes points to your complete board, not to the fresh install.
Once you've determined that, remove the tables with the incorrect prefix.
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.
kooksee
Registered User
Posts: 39
Joined: Tue Sep 17, 2019 10:12 pm

Re: Version 3.3.4 restore doesn't work

Post by kooksee »

apparently all the tables are doubled (bb and phpbb prefix)

the ones with the bb prefix contain the data from the backed up forum, the ones with phpbb seem to be empty

should I simply delete all the phpbb tables?
User avatar
warmweer
Jr. Extension Validator
Posts: 11234
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Version 3.3.4 restore doesn't work

Post by warmweer »

kooksee wrote: Mon Jun 21, 2021 9:54 pm should I simply delete all the phpbb tables?
"
If the phpbb_users table contain only anonymous (user_id =1), the founder (user_id =2 ) and bots then that's a new install and all the "phpbb_"tables can be removed.
Then modify your config.php so that the "bb_"tables are used.

Currently, with all that has been done, I have no idea which version of phpBB that will be (before or after the update) nor whether it's complete.
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
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: Version 3.3.4 restore doesn't work

Post by janus_zonstraal »

Maybe it is better to ask someone who is more experienced with phpbb to look to your database.
Sorry! My English is bat ;) !!!
Post Reply

Return to “[3.3.x] Support Forum”