Nitro Porter, the inter-software migration toolkit

ymaohyd

linc I'm not 100% sure to be honest.

When I ran into the timeout problems and started researching solutions, there were a range of suggested fixes, so I tried to cover all bases to be on the safe side.

It was probably overkill, but as it worked I was happy 😊

Winckle

Hi all 👋,

I'm trying to migrate my phpbb3 forum to flarum using nitro-porter and I'm getting the following error from php:
2023/06/05 16:39:50 [error] 2502733#2502733: *85045716 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Europe/London' for columnflarum.PORT_User.HourOffsetat row 1 in /home/www-data/php8/nitro/nitro-porter/vendor/illuminate/database/Connection.php:501 Stack trace: #0 /home/www-data/php8/nitro/nitro-porter/vendor/illuminate/database/Connection.php(501): PDOStatement->execute() #1 /home/www-data/php8/nitro/nitro-porter/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /home/www-data/php8/nitro/nitro-porter/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #3 /home/www-data/php8/nitro/nitro-porter/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run() #4 /home/www-data/php8/nitro/nitro-porter/vendor/illuminate/database/Connection.php(454): Illuminate\Database\Connection->statement() #5 /home/www-data/php8/nitro/nitro-porter/ve" while reading response header from upstream
It's got me pretty stumped. I don't think the config is incorrect.
There's nothing too useful in porter.log:
[2023-06-05T15:54:04.096007+00:00] porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] [] [2023-06-05T15:54:04.096352+00:00] porter.INFO: Source: phpBB 3 (phpbb) [] [] [2023-06-05T15:54:04.096426+00:00] porter.INFO: Target: Flarum (flarum) [] [] [2023-06-05T15:54:04.096492+00:00] porter.INFO: Flag: Use Discussion Body: Enabled [] []
Any help or advice would be appreciated.

Winckle

Ok, I looked at it further, and it's trying to write a timezone object to the hour offset value, which structure.php says must be an int. I am not familiar enough with your code to simply force it to be 0 offset or similar. Is my forum unusual for having these values as timezones rather than offset integers?

Walid

Winckle Hi, have you found a solution to your problem, because I'm having the same one?

[Tue Jun 13 13:19:10.052430 2023] [proxy_fcgi:error] [pid 191323] [client XXXXXXXX] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'UTC' for column 'HourOffset' at row 1 in /var/www/mysite/public/migration/vendor/illuminate/database/Connection.php:501\nStack trace:\n#0 /var/www/mysite/public/migration/vendor/illuminate/database/Connection.php(501): PDOStatement->execute()\n#1 /var/www/mysite/public/migration/vendor/illuminate/database/Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()\n#2 /var/www/mysite/public/migration/vendor/illuminate/database/Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback()\n#3 /var/www/mysite/public/migration/vendor/illuminate/database/Connection.php(502): Illuminate\\Database\\Connection->run()\n#4 /var/www/mysite/public/migration/vendor/illuminate/database/Connection.php(454): Illuminate\\Database\\Connection->statement()\n#5 /var/www/mysite/new/publ...', referer: http://mysite.com/migration/index.php

I've uploaded the nitro-porter files to a "migration" folder on my server (got the zip from the latest release on github v3.3) than created and edited the config.php file like indicated and run the index.php page on the browser, selected the right options and when I launched the script, I instantly got a error 500 and when I checked the porter.log it just says:
[...] porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] [] [...] porter.INFO: Source: phpBB 3 (source_PHPBB) [] [] [...] porter.INFO: Target: Flarum (source_PHPBB) [] [] [...] porter.INFO: Flag: Use Discussion Body: Enabled [] []

yes i'm using the same database. When I check the database, there's just a new PORTER_user table created with nothing in it. So then I check the apache error log for my site and I found what I published at the top of this post.

how can I fix this?

erbosha

Hello. Can anyone help for a nominal amount, please.

I want to switch from xenforo
topics 104,127
posts 104,806
users 3,161
to flarum

I am using fastpanel (FastCGI, php81) with the latest flarum branch and can't configure php limits
I get 504 Gateway Time Out (cloudflare) and HTTP ERROR 500 errors

i'm from disgraceful russia and can only pay in cryptocurrency

wbntff

is migration to flarum possible from XMBforum ?
Its a 20 years old forum with no activity since past 15 years but i want to keep a backup of it for reading purpose only.
XMB is dead and could not migrate it to SMF

linc

wbntff I've never heard of this one. Can you get it into any other software? PHPBB is the one that sometimes folks have made a migration tool for, especially if it's that old.

Alternatively, I can add support for it in Porter if you wanna send me the database dump. Since it's so old, I would stick to the very basics: Users, Categories, Discussion & Comments.

wbntff

linc I have tried existing converters with SMF and phpBB but all have errors as they were written for old versions.
yes.. basic stuff like users, categories, discussions and posts would be enough.
Just need it for reading purpose as archive. May revive it if members are interested.
Last time we used it was in 2009.
I have emailed you link to download database dump

wbntff

linc
Hi,
did you happen to look at that SQL file.
I could run it with XMB 1.19.12 but it generates errors as its written for older versions of php and in future may not work at all.
Recently i tried converting it again to SMF 2.0.0 with older converter.
It does convert members and topics but stops midway at 5600 posts, where as total posts are 26000+
There was nothing much i could do to proceed further as nobody at SMF supports this converter anymore.

phpBB converts from SMF (that too 1.1), not from XMB

Gerriet

Hi there ;D
I have a little forum, that 13 years old. I would make a migration with the extensions from michaelbelgium. But I write here in this post issues,
https://discuss.flarum.org/d/33158-migration-from-mybb-to-flarum
Maybe, you can help me ?
Edit: I have found your Tool, so I would test with this. maybe runs better ;D

Circa

@linc We have a pretty large forum on Invision 4 and heavily utilize the Downloads module. I plan to pay a bounty for an extension to be made once we decide to move forward with this decision, but I'm curious if you'd be able to also work with us on getting those moved over too? We are trying to plan ahead of Invisions price increase and other questionable decisions, but aren't finding any alternatives without commissioning some help like this.

linc

Circa I think that's a reasonable extension to the Porter. Whenever possible, I like to support data even if it's from a plugin/extension if the extension is publicly available & widely used and the data is valuable.

I cannot promise I would be personally available to do this enhancement on a timeline you'd find useful, however.

Gerriet

Hi linc ;D
I sent you an email or better I filled out the form and sent it a week ago. Haste get the mail ? I have only a small forum, which is based on Mybb 1.8.36. Would be great if you could help me with the conversion.

Greetings from germany ;D

Circa

Gerriet did you try this first? I used it on a small mybb forum last year and it worked perfectly.

https://discuss.flarum.org/d/5506-mybb-to-flarum/125

Gerriet

Well, I know the extension and have already tried it, unfortunately error messages came again and again, so I would like to try the tool from Linc and see if the same problems occur ;D

Edit:
So, I tried the Nitro-Porter tool, but I'm not sure if I did everything right. When I started the whole thing in the browser, there was a white page. I didn't find any log files either. Therefore, I can not say what went wrong.

Gerriet

Hello 😃
Ok, I have run a test with the nitro-porter tool ;D When I start the progress, comes a white side in the browser ist the right ?

Oh and I have found the log file ;D

Gerriet

HI there ;D
Little question:
Does the tool need rights from my admin account in mybb ?

Jbugy

Hello,

I am looking to use nitro booster to convert my forum from an old IP to flarum, yay!

Now because I wish to stay on cPanel, I have found in the past that it’s quicker to download the database, do the upgrades on the database then upload again.

Would this work for flarum? Can I upgrade offline and then renable?

Would love to run my own box but it just seems such a nightmare to setup and secure!

clarkwinkelmann

Jbugy I don't know anything about using Nitro Porter, but I don't see any reason why you couldn't run it on a local copy of your forum as long as you have access to all the tools locally (PHP, Composer, etc.)

Whenever you work on a copy of your forum offline for development, testing or migration, you don't have to make it accessible over the internet so there's very little to configure in term of security since you are already working behind your private network firewall. To get PHP and a webserver on a regular PC for development there are many tools like XAMPP that makes this process easy.

The only potential issue I can see is if some tool automatically reads and stores the currently used domain name, which would likely be localhost when working locally. Even if the wrong URL ends up in the database, it's often very similar to when you would move from a domain name to another. You can perform a few search and replace in the database to fix it after you identify which tables/columns are impacted, or do the search and replace on the SQL dump itself afterwards.

« Previous Page Next Page »