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
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by 3Di »

No probs, "repetita juvant" :)
๐Ÿ†“ Free support for our extensions also provided here: phpBB Studio
๐Ÿš€ Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity ยบ PhpStorm's proud user ยบ Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
open-your-eyes
Registered User
Posts: 94
Joined: Mon Jul 31, 2017 8:20 am
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by open-your-eyes »

warmweer wrote: โ†‘Mon Feb 19, 2018 5:11 pmSo 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.
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by 3Di »

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)
๐Ÿ†“ Free support for our extensions also provided here: phpBB Studio
๐Ÿš€ Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity ยบ PhpStorm's proud user ยบ Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
warmweer
Jr. Extension Validator
Posts: 11242
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by warmweer »

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
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
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by 3Di »

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. :)
๐Ÿ†“ Free support for our extensions also provided here: phpBB Studio
๐Ÿš€ Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity ยบ PhpStorm's proud user ยบ Extensions, Scripts, MOD porting, Update/Upgrades
User avatar
warmweer
Jr. Extension Validator
Posts: 11242
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by warmweer »

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: )
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
Lumpy Burgertushie
Registered User
Posts: 69224
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by Lumpy Burgertushie »

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
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.
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: Upgrade from 2.0.22 to 3.1.12

Post by stevemaury »

You can TRUNCATE the three search_* tables and make another backup.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
open-your-eyes
Registered User
Posts: 94
Joined: Mon Jul 31, 2017 8:20 am
Contact:

Re: Upgrade from 2.0.22 to 3.1.12

Post by open-your-eyes »

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

Return to โ€œ[3.1.x] Support Forumโ€