Upgrade from 2.0.22 to 3.1.12

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
User avatar
3Di
Registered User
Posts: 12550
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by 3Di » Mon Feb 19, 2018 5:28 pm

No probs, "repetita juvant" :)
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

User avatar
open-your-eyes
Registered User
Posts: 59
Joined: Mon Jul 31, 2017 8:20 am

Re: Upgrade from 2.0.22 to 3.1.12

Post by open-your-eyes » Mon Feb 19, 2018 5:35 pm

warmweer wrote:
Mon Feb 19, 2018 5:11 pm
So the steps are:
1. get the phpbb2more or less installed (on localhost -Xampp) (empty the search tables)
2. update to the latest phpBB 2 (2.0.22?)
3. upgrade to 3.0.14
4. upgrade to 3.1.12 (for this step support will be plentiful on the forum)
Like I said before, I get an error when trying to import database because of search tables. I don't see how I would be able to import all tables except search tables. The only option in my mind is to comment them out in the database dump. Wich I do not know how to do yet.
Thanks.
My forum: Under construction...

User avatar
3Di
Registered User
Posts: 12550
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by 3Di » Mon Feb 19, 2018 5:38 pm

Listen, you can't comment out those data there, you simply have to delete them (do a backup first) from the .sql file you have, with a decent text-editor.

You only need the schema, not the data dump, for those tables.

Like "CREATE TABLE etc.. etc.." (schema)
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

User avatar
warmweer
Registered User
Posts: 972
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Upgrade from 2.0.22 to 3.1.12

Post by warmweer » Mon Feb 19, 2018 6:13 pm

3Di wrote:
Mon Feb 19, 2018 5:38 pm
Listen, you can't comment out those data there, you simply have to delete them (do a backup first) from the .sql file you have, with a decent text-editor.

You only need the schema, not the data dump, for those tables.

Like "CREATE TABLE etc.. etc.." (schema)
I suspect the database backup is 1 large SQL file.
Use a text editor which can handle really large files: see viewtopic.php?f=461&t=2280176
A bug is a feature that hasn't made it to the manual (yet)

User avatar
3Di
Registered User
Posts: 12550
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by 3Di » Mon Feb 19, 2018 7:27 pm

warmweer wrote:
Mon Feb 19, 2018 6:13 pm
3Di wrote:
Mon Feb 19, 2018 5:38 pm
Listen, you can't comment out those data there, you simply have to delete them (do a backup first) from the .sql file you have, with a decent text-editor.

You only need the schema, not the data dump, for those tables.

Like "CREATE TABLE etc.. etc.." (schema)
I suspect the database backup is 1 large SQL file.
Use a text editor which can handle really large files: see viewtopic.php?f=461&t=2280176
? I am supposed to use one, decent text editor. :)
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

User avatar
warmweer
Registered User
Posts: 972
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Upgrade from 2.0.22 to 3.1.12

Post by warmweer » Mon Feb 19, 2018 8:27 pm

3Di wrote:
Mon Feb 19, 2018 7:27 pm
warmweer wrote:
Mon Feb 19, 2018 6:13 pm
...
I suspect the database backup is 1 large SQL file.
Use a text editor which can handle really large files: see viewtopic.php?f=461&t=2280176
? I am supposed to use one, decent text editor. :)
Oops, that was directed at the TS, not at you (although come to think of it, it could be advice for everyone :mrgreen: )
A bug is a feature that hasn't made it to the manual (yet)

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

Re: Upgrade from 2.0.22 to 3.1.12

Post by Lumpy Burgertushie » Mon Feb 19, 2018 10:15 pm

just to muddy it up a bit.

if the OP is importing the old phpbb2 database into a new blank database, there is no way to get the error he is getting.
so, one has to assume that he is trying to import the phpbb2 database into an existing phpbb3 database.

if that is correct then that is the problem. no part of the conversion process involves importing the phpbb2 database into the phpbb3 database.

what the OP should be doing is importing it into a new empty database. then, as suggested, create a phpbb2 config.php file pointing to that database.
then using the phpbb3 install, run the phpbb2 to phpbb3 conversion.

I too suggest that you upgrade to 3.2.1 instead of trying to go all the way to 3.2.2 until all is running well.


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

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49180
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by stevemaury » Mon Feb 19, 2018 10:17 pm

You can TRUNCATE the three search_* tables and make another backup.
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
open-your-eyes
Registered User
Posts: 59
Joined: Mon Jul 31, 2017 8:20 am

Re: Upgrade from 2.0.22 to 3.1.12

Post by open-your-eyes » Mon Feb 19, 2018 10:25 pm

I have deleted all instances of INSERT INTO f762dce_search_wordlist and the installation seems to worked fine. But before upgrading to 3.1 (or first 3.0) I would like to run a database clean tables querry. To get rid of SQL added by MODs. I know there was a phpBB2 MOD for that, but don't seem to find it. If someone could point it up to me, it would be nice.
Thanks.

LATER EDIT: Nevermind. I've found it. It is Clean Tables 1.0.9.
My forum: Under construction...

Post Reply

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 24 guests