PhpBB migrate script - Updated for beta 5

varma

Hey,

I recently tried this script.
I was able to migrate all post and topics, but the username in the posts view are [deleted]

But on the home page, i was able to see the correct username of users for the specific post. When checking the database 'post' table the user_id is 0 for all.

How can I solve that? @robrotheram @deseven

varma

On the way, i have actually solved it ?

On line 161 its says $posterID = 0; which i chnaged to
$posterID = $post['poster_id'];

Solving the issue. now looking for a appropriate way to redirect the Xenforo URL to flarum ?

Nomak

deseven

Parse error: syntax error, unexpected '$exportDbConnection' (T_VARIABLE) in /home/nomakele/public_html/flarum/phpbb/php_to_flarum.php on line 21

Nomak

I can not login with any user of imported, it is as if all the passwords were wrong

BartVB

@Nomak; check out the README.md file ?
The passwords are reset for all users.

@robrotheram I haven't checked how passwords are handled in Flarum but sha1(md5(time())) is extremely easy to brute force. time() only changes once per second. It's probably safer to set this the password to something like 'disabled' or an empty string (depending on how passwords in Flarum are handled).

scitommy

Where do you upload the php file?

scitommy

I uploaded the php_to_flaurm.php file to the directory where my flarum is installed. I edited the file and entered the username and password of the phpBB database and the phpBB database name for export and Flarum database name for import.

I accessed the script at /flarum/php_to_flaurm.php and I get:

Export - Connected successfully
Current character set: utf8
Warning: mysqli::mysqli(): (HY000/1044): Access denied for user 's_scitommy'@'localhost' to database 's_flarum' in /home/s/public_html/flarum/php_to_flaurm.php on line 39
Import - Connection failed: Access denied for user 's_scitommy'@'localhost' to database 's_flarum'

The instructions never said where to upload the file or how to edit the file. Please help.

Thanks,

Thomas

Ralkage

scitommy Modify php_to_flarum.php and make sure the following variables are filled-in correctly with regards to your phpbb DB config settings:

$servername = "localhost";
$username = "user";
$password = "password";
$exportDBName = "PHPforums";
$importDBName = "flarum";

You ideally drop it in the root of your phpbb installation and make your way to it.

When it completes, it will dump a sql file in the same root directory.

scitommy

Thanks for your response. I originally uploaded the file to my flarum root and got the error above. I moved the file to my phpbb root and I get the same error.

scitommy

I got it to work. I had to give both the phpbb and flarum database users persmission to access both databases. It would probably also work if both phpbb and flarum both shared the same database user and password.

I got a ton of errors during the conversion, but it was fast and it worked. The only problem is the deleted users, which I think there is a fix above.

Thanks.

scitommy

I got most sorted out after the conversion, but noticed if I sticky any or anyones post, it always has the text from the first ever post that was created. Really strange.

Does anyone have any idea on how to fix this?

Thanks,

ThomasLewis

I've tried running this on phpBB 3.2.1 and Flarum Beta 7. All that happens is the script connects to the two databases and throws "something went wrong" errors on Users and Categories. It then says the User Discussion tables are empty and updates the user table with no data. Any ideas what could be impeding the script?

luceos

ThomasLewis I'd recommending installing Flarum beta.5, doing the migration and then upgrading to beta 7. Or you can wait for an update on this script, which is less likely to happen soon ?

ThomasLewis

luceos I've not used composer before, so which part of the installation command needs to change to pull beta 5 instead of 7?

luceos

Out of my head,

composer create-project flarum/flarum -s beta directory 0.1.0-beta.5

Ralkage

@ThomasLewis there was a new column that was introduced called "is_private" in beta 7, though, beta 5 to 7 is still a big leap and that script was last updated in May.

As @luceos stated, you have those two options until the script is updated (or someone makes a mind-blowing importer/migrator through an extension lol)

ThomasLewis

Digging a bit further, it seems the failure is after an SQL query to the phpBB DB. $result->num_rows gets set to a Boolean instead of an int count of the number of rows. I’m thinking the DB format for 3.2.1 may be different than the one the script was written for. I’m going to look at the tables and see if there are differences that would cause the query to not return any results.

ThomasLewis

I found the error. The SQL queries to the phpBB database used "FROM phpbb_[field]", and the database contained "bb_[field]". So, a quick removal of "php" from each of those lines allowed the script to run successfully.

tommysvr

Not much action in this thread for a while. I'm trying to run this on a site with ~10000 posts and keep getting a 503. Any simple way to get things to work? Would increasing the memory potentially help?

Edit: looks like the script actually worked reasonably well! It's really nice...except one pretty big issue: the thread starter's username shows up in the main boards section, but when you enter a thread, everyone is suddenly [deleted]. Any one else had a similar issue? Could it be that the posts etc worked ok, but the users table didn't? Checking the database, the users are indeed in there.

jeopangindian

tommysvr There's a fixed above by varma

On line 161 its says $posterID = 0; which i chnaged to
$posterID = $post['poster_id'];

miczja94

Hi guys,

When i importing from phpbb3 to flarum i have errors:

Wrong SQL: INSERT INTO users (id, username, email, password, join_time, is_activated) VALUES ( '4009', 'x', 'x', 'x', '2016-12-14 15:57:11', 1) Error: Table 'flarumbeta5.users' doesn't exist

my config:

$servername = "localhost";
$username = "AgostSan";
$password = "MY_PASS:)";
$exportDBName = "phpbb3";
$importDBName = "flarumbeta5";

it looks as if the flarumbeta5.users' doesn't exist:
https://i.imgur.com/WVMYhG2.png

What am I doing wrong?

tommysvr

miczja94 I had the same issue, it's fixed by manually adding your table prefix (flarum_) to all table names after INSERT INTO.

For example:

$query = "INSERT INTO users (id, username, email, password, join_time, is_activated) VALUES ( '$id', '$formatedUsername', '$email', '$password', '$jointime', 1)";

Becomes

$query = "INSERT INTO flarum_users (id, username, email, password, join_time, is_activated) VALUES ( '$id', '$formatedUsername', '$email', '$password', '$jointime', 1)";

« Previous Page Next Page »