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 » Wed Apr 18, 2018 9:46 am

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: 19125
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

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

Post by Mick » Wed Apr 18, 2018 9:54 am

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

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

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 » Wed Apr 18, 2018 10:00 am

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: 49039
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 » Wed Apr 18, 2018 2:14 pm

Try this tool to clean the database - viewtopic.php?p=14945791#p14945791
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

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 » 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?

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: 49039
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 » Thu Apr 19, 2018 2:36 pm

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+
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

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 » Fri Apr 20, 2018 12:35 pm

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 » Fri Apr 20, 2018 12:41 pm

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: 49039
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 » Fri Apr 20, 2018 2:44 pm

The database version is given by the value of the "version" field in the config table.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

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 » Fri Apr 20, 2018 3:51 pm

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: 49039
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 » Fri Apr 20, 2018 4:24 pm

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.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Lumpy Burgertushie
Registered User
Posts: 64267
Joined: Mon May 02, 2005 3:11 am
Contact:

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

Post by Lumpy Burgertushie » 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.

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
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

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 » Fri Apr 20, 2018 4:46 pm

"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 » Fri Apr 20, 2018 4:54 pm

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: 49039
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 » Fri Apr 20, 2018 5:02 pm

Screen Shot 2018-04-20 at 12.00.56 PM.jpg
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Baidu [Spider], Brf, david63, Holger Laux, Mohammed AlSarsawi, morkus, stevemaury and 31 guests