Starting up with a fresh installation using an existing DB

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Starting up with a fresh installation using an existing DB

Post by just211 »

Hi Pros,

I'd like to start over with a fresh installation of 3.2.2 using an existend DB which currently is still runnig with a V 3.0.13-PL1 - Board.
Yes, that's (far to) old, I just took over the responsibility for the board and what I can see is that there are many issues that makes me want to start over completely, without loosing the posts of course.

My plan is to test everything in parallel with a sqldump of the old DB in a new, second DB. When everything ist working I will then set the board in maintenance-mode, make an actual dump, do the upgrade procedure again and switch everything to the new installation.

What yould be your recommendation? Should I upgrade the DB step by step, or is there a way to make it happen in one step?
Challenge is that I can't find any indication of which version the DB is. There is no entry "version" in the config-table.

Meanwhile I've spent hours of research, I am lost. :(

Can you help?
Last edited by just211 on Fri Apr 20, 2018 4:10 pm, edited 1 time in total.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26503
Joined: Fri Aug 29, 2008 9:49 am

Re: Starting up with a fresh installation using an existend DB

Post by Mick »

Notes:
  • Your server must be running at least PHP 5.4.7 or higher.
  • phpBB 3.2 is not compatible with 3.0 and most of the previous files will need to be removed prior to upgrading.
  • Styles and MODs from 3.0 cannot be installed on phpBB 3.2. To upgrade, perform the following steps:
  1. Make a back-up of the original files and database
  2. Deactivate all styles except for prosilver
  3. Remove all MOD-related changes from the database. The Support Toolkit's Database Cleaner can be used for this.
  4. Ensure that the activated spambot countermeasure is one of the standard phpBB plugins (Simple image, GD image, GD 3D image, Q&A, reCaptacha).
  5. Set British English as the only language pack and delete all other language pack directories from your server
  6. Delete all of your phpBB 3.0.x files EXCEPT for the following:
    • The config.php file
    • The /images/ directory
    • The /files/ directory
    • The /store/ directory
  7. Upload the contents of the phpBB3 directory from the uncompressed 3.2.x Full Package (EXCEPT for config.php) into your forum's directory (Note: you don't want to overwrite your original config.php file)
  8. Browse to www.example.com/install/
  9. Click the Update tab
  10. Click the Update button
  11. Select "Update database only" and click Submit
  12. Wait for the progress bar to reach 100% and for a message indicating that the update has completed
  13. Delete or rename the /install/ directory
  • "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
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Re: Starting up with a fresh installation using an existing DB

Post by just211 »

Hi Mick,

thanks a lot for this. I should have said that I tried exact this before... sorry.

Unfortunately the STK does not start.
Every time I try to start it it gives me an error mesage "Emergency Repair Toolkit" missing index "rand_seed".

Juergen
Last edited by just211 on Fri Apr 20, 2018 4:11 pm, edited 1 time in total.
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: Starting up with a fresh installation using an existend DB

Post by stevemaury »

Try this tool to clean the database - viewtopic.php?p=14945791#p14945791
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Re: Starting up with a fresh installation using an existend DB

Post by just211 »

Thanks for the link.
At which stage should I use this tool? Seems that 3.2.2 needs to be installed to make it work?

1. Delete all styles except "prosilver" in 3.0.13-PL1.
2. Delete all languages except "en" in 3.0.1-PL1.
3. Upload the files of the full 3.2.2-Package except the folders "/images", "/files", "/store" and the "config.php".
4. Add the folders "/images", "/files", "/store" and the "config.php" of the old 3.0.13-PL1.

Now the tool to clean the DB?


Questions:

Is it necessary to exchange
$dbms = 'mysql';
with
$dbms = 'mysqli';
?

Which PHP-Version would be the best for this purpose?
Currently running 5.5.35, can change to any (stable) Version up to 7.1.10.
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: Starting up with a fresh installation using an existend DB

Post by stevemaury »

just211 wrote: Thu Apr 19, 2018 7:03 am Thanks for the link.
At which stage should I use this tool? Seems that 3.2.2 needs to be installed to make it work?

That appears to be correct, but you can PM the author, 3di and ask.

1. Delete all styles except "prosilver" in 3.0.13-PL1.
2. Delete all languages except "en" in 3.0.1-PL1.
3. Upload the files of the full 3.2.2-Package except the folders "/images", "/files", "/store" and the "config.php".
4. Add the folders "/images", "/files", "/store" and the "config.php" of the old 3.0.13-PL1.

Now the tool to clean the DB?


Questions:

Is it necessary to exchange
$dbms = 'mysql';
with
$dbms = 'mysqli';
?

Yes

Which PHP-Version would be the best for this purpose?
Currently running 5.5.35, can change to any (stable) Version up to 7.1.10.

phpBB 3.2.2 requires php 5.7+
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Re: Starting up with a fresh installation using an existend DB

Post by just211 »

stevemaury wrote: Thu Apr 19, 2018 2:36 pm ...That appears to be correct, but you can PM the author, 3di and ask.
Thank you.

As I am having less than 5 posts I am just allowed to PM team members.
Please take my apologies for abusing this topic...
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Re: Starting up with a fresh installation using an existend DB

Post by just211 »

I don't want to abuse it by 100% here's what I am going to do:

I will ask 3Di for help upgrading the confusing DB.
There even is no clue of which version the DB actually is.

I've spent hours installing nearly every version of phpbb, coming to no result. Maybe he can help...
...let's see.

:D Juergen
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: Starting up with a fresh installation using an existend DB

Post by stevemaury »

The database version is given by the value of the "version" field in the config table.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Re: Starting up with a fresh installation using an existend DB

Post by just211 »

stevemaury wrote: Fri Apr 20, 2018 2:44 pm ...the value of the "version" field in the config table.
No such field in the .config table.
It seems that someone did updates without taking care of the db in the very past.
So I have no clue which version the db is. :?

I also have no overview of what manually was manipulated.
This is the reason for what I'd like to start over with a fresh and clean installation.
All I need is a cleaned and prepared db for 3.2.2. :mrgreen:
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: Starting up with a fresh installation using an existing DB

Post by stevemaury »

Technically it is a value in the config_name field 'version'. Run this SQL

Code: Select all

SELECT config_value FROM phpbb_config WHERE config_name = 'version'
If your table prefix is not phpbb_, change accordingly.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Starting up with a fresh installation using an existing DB

Post by Lumpy Burgertushie »

the only thing phpbb needs to install is a blank database. there is no prepared type of thing.

if you are still wanting to do what you posted originally then you can install a whole phpbb using a new blank database and then import your old database to it and then update that database. however, if you simply follow the instructions for updating your current board you will wind up with the same thing.

also, I seriously doubt that the version field is missing from your config table. most likely you have not viewed all of the rows of that table. if using phpmyadmin you will see a drop down box with page numbers in it at the bottom of the page showing the rows of the config table. keep advancing through the pages until you find the one with that row.

or, do what steve said above .

robert
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.
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Re: Starting up with a fresh installation using an existing DB

Post by just211 »

"Empty result", as there is no field "version" ;)
just211
Registered User
Posts: 24
Joined: Wed Apr 18, 2018 8:55 am

Re: Starting up with a fresh installation using an existing DB

Post by just211 »

Hi Robert,

thank you for your explanation.
Lumpy Burgertushie wrote: Fri Apr 20, 2018 4:43 pm the only thing phpbb needs to install is a blank database. there is no prepared type of thing.

if you are still wanting to do what you posted originally then you can install a whole phpbb using a new blank database and then import your old database to it and then update that database. however, if you simply follow the instructions for updating your current board you will wind up with the same thing.

This fails at the point where I want to use the STK. It gives a message like "Emergency Repair Toolkit - missing index rand_seed".
I already tried to give the tool what it expects, but then another missing index ocurs, etc.


also, I seriously doubt that the version field is missing from your config table. most likely you have not viewed all of the rows of that table. if using phpmyadmin you will see a drop down box with page numbers in it at the bottom of the page showing the rows of the config table. keep advancing through the pages until you find the one with that row.

or, do what steve said above .

There's no such field. Steves mysql-command gives an empty result.

robert
Juergen
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: Starting up with a fresh installation using an existing DB

Post by stevemaury »

Screen Shot 2018-04-20 at 12.00.56 PM.jpg
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Post Reply

Return to “[3.2.x] Support Forum”