Page 1 of 1

IP.Board 2.3.6 to phpBB 3.2.2

Posted: Tue May 15, 2018 6:17 pm
by SigmaTel71
Greetings! A couple of my friends is going to merge two forums into one. Since I can't find a solution, I came here to ask you the following question: how to convert IP.Board 2.1.6 database directly to the phpBB 3.2.2? I already have a full SQL copy of the IP.B forum.
Database properties:
  • Old forum: MySQL
  • New forum: MySQL with MySQLi extension
When I was trying to find a converter for a specified version of IP.B, I have found one, but it was designed for phpBB2 with MySQL, so I can't convert it.
What do I have to do? :?

P. S. If it's possible, can you tell me how to merge databases? I'm new to all this stuff... :roll:

Re: IP.Board 2.1.6 to phpBB 3.2.2

Posted: Tue May 15, 2018 10:10 pm
by thecoalman
One possible solution is to download an older version of XAMPP which will have older versions of MySQL/PHP.
P. S. If it's possible, can you tell me how to merge databases? I'm new to all this stuff...
While not impossible this is not an easy task. You may want to search for options of merging IPB or see if you can find something for merging phpBB2. In other words see if anything is available that can be used along the conversion process.

Re: IP.Board 2.1.6 to phpBB 3.2.2

Posted: Wed May 16, 2018 3:19 am
by 3Di
Is the new 3.2.2 forum running on PHP >= 7?

The original MySQL extension is being deprecated and will be removed from the core starting from PHP 7, so you can try to use a lesser version of PHP to install the 3.2.2 (i.e. 5.6.xx) and after the conversion raise again to 7. Is the convertor using specific MySQL code? In this case you can try to "convert the convertor" (lol) to MySQLi. Which is possible as well.

Re: IP.Board 2.3.6 to phpBB 3.2.2

Posted: Wed May 16, 2018 2:34 pm
by SigmaTel71
3Di wrote:
Wed May 16, 2018 3:19 am
Is the new 3.2.2 forum running on PHP >= 7?
No, it's running on PHP 5.6.30 (and couldn't be upgraded due to hosting provider settings).
Is the convertor using specific MySQL code? In this case you can try to "convert the convertor" (lol) to MySQLi. Which is possible as well.
Looks like it does, I have tried to test locally ib2phpbb convertor made in 2005. And it failed due to usage of MySQL.

Re: IP.Board 2.1.6 to phpBB 3.2.2

Posted: Wed May 16, 2018 2:51 pm
by thecoalman
SigmaTel71 wrote:
Wed May 16, 2018 2:34 pm
I have tried to test locally ib2phpbb convertor made in 2005. And it failed due to usage of MySQL.
To reiterate you can download an older version of XAMPP, one from around 2005 should probably be where to start. ;) The only trouble you might have is getting it to run under a newer OS.

https://sourceforge.net/projects/xampp/files/

If you are already using XAMPP you can run different versions of it. If I recall correctly you only need to install in different folder, create shortcuts to the .exe for each version and you can't run them both at once.

Re: IP.Board 2.3.6 to phpBB 3.2.2

Posted: Wed May 16, 2018 3:12 pm
by SigmaTel71
thecoalman wrote:
Wed May 16, 2018 2:51 pm
To reiterate you can download an older version of XAMPP, one from around 2005 should probably be where to start. ;) The only trouble you might have is getting it to run under a newer OS.
Thanks. I'll try the 1.5.0 version under Windows Server 2012 R2.
If you are already using XAMPP you can run different versions of it.
I didn't use it earlier, because I set up all things (MySQLi, Apache, etc.) manually. But thanks again for a tip!

Re: IP.Board 2.1.6 to phpBB 3.2.2

Posted: Wed May 16, 2018 9:16 pm
by 3Di
SigmaTel71 wrote:
Wed May 16, 2018 2:34 pm
Looks like it does, I have tried to test locally ib2phpbb convertor made in 2005. And it failed due to usage of MySQL.
Are you confident with PHP?
https://www.phpclasses.org/package/9199 ... nsion.html

Re: IP.Board 2.3.6 to phpBB 3.2.2

Posted: Thu May 17, 2018 5:59 pm
by SigmaTel71
XAMPP went garbage on my system (404 errors), so I have installed another software package bundled with PHP 5.6, MySQL 5.6 and Apache 2.4 (everything is x64).
Image
Now I don't really understand what to do with these errors...

Re: IP.Board 2.1.6 to phpBB 3.2.2

Posted: Thu May 17, 2018 10:37 pm
by thecoalman
I have no idea how this would work with Windows Server because I'm not familiar with it but on regular Windows machine you are going to install XAMPP in the root of the drive, e.g. C:\xampp Inside the XAMPP folder is htdocs folder which is the root of the domain.

Open the XAMPP control panel to start Apache and MySQL. Visit http://localhost/ in your browser and It should serve up the default index page in htodcs.

For phpMyadmin visit http://localhost/phpmyadmin/ , if you want to run shell commands for MySQL there is link to open the console on the XAMPP control panel labeled "Shell".

One last tip here, if you want to use the domain name instead of localhost open the hosts file in windows. On regular windows machine it is C:\Windows\System32\drivers\etc\hosts add this line and save. Of course replace example with the domain.

Code: Select all

127.0.0.1 example.com

Re: IP.Board 2.3.6 to phpBB 3.2.2

Posted: Fri May 18, 2018 12:38 pm
by SigmaTel71
thecoalman wrote:
Thu May 17, 2018 10:37 pm
I have no idea how this would work with Windows Server because I'm not familiar with it but on regular Windows machine you are going to install XAMPP in the root of the drive, e.g. C:\xampp Inside the XAMPP folder is htdocs folder which is the root of the domain.
You will laugh at me, but i forgot to modify the converter's configuration file! It had prefix that differs from ibf_ :lol: So, it's my fault.

Re: IP.Board 2.3.6 to phpBB 3.2.2

Posted: Tue May 22, 2018 4:19 pm
by SigmaTel71
Woah! I made a serious mistake in a subject! It's not IP.Board 2.1.6, it's 2.3.6! So, are there any solutions for this version of IPB?
*fixes the most of posts' subject*