Nitro Porter, the only multi-community migration tool

SnakePromise

linc I was unclear, sorry. It does list commands after that, I was just confused about version mismatch, I thought I installed 3.6, that shows as the latest available on Github.

panda232

Hello! I have a phpbb 3.3.14 forum and I wish to migrate over to flarum instead. I have PHP 8.3.12, composer and latest porter installed after following this https://nitroporter.org/guide. I have also copied the config-sample.php and made a config.php with my db details inside.

Now to the part where I get stuck, if I try to run "porter run" command I get
PHP Fatal error: Uncaught Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY on linc\nitro-porter\config.php:18.

If I remove this part of the config:

'options' => [
                PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => false, // Critical for large datasets.
            ],

then porter command starts to work. But when I try to run migration command I can't really get it to run properly. Maybe its my command or idk...

Any ideas? @linc 🙂

UPDATE: I got it working, I had a unique table prefix for my old db which nitro porter didn't like. After changing that it started the process. Now I have new "PORT_users" and "FLA_users" tables and many more with the same prefix on my new flarum installation. However I also still have "users" table, the log told me to remove the "PORT" tables so I did that. But whats next, do I just rename the "FLA_" tables to replace the old? Or is there a way to merge them with existing ones?

mafesa

MoshBit Hi, I'm trying to convert from Xenforo and it gets stuck at the same point for me too, how did you solve it?

import: group_user — 5466 rows, 00.73s (5.3mb)Illuminate\Database\QueryException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'discussion_count' cannot be null

I'm running porter on a clean flarum pre-install

https://nitroporter.org/guide

Optional: Install the target software
Nitro Porter tends to work the smoothest when you pre-install the new software so its database tables preexist when running the migration. However, it should also work without doing this, so keep reporting issues in either scenario.

If I don't preinstall flarum there are no errors but the forum is inaccessible because all the other tables in the database are missing.
How did you do it?
Thanks

EDIT: I tried with a clean installation of Xenforo and I have the same error with group_user, I think it's a bug and only @linc can help us...

mafesa

I also tried to convert a SMF 1 forum and I get the same error
import: group_user — 1243 rows, 00.51s (2.8mb)Illuminate\Database\QueryException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'discussion_count' cannot be null

I don't understand why I'm the only one having this problem, the last update of the converter is 4 months old, it's impossible that no one has tried to convert a site in all this time.

GeorgP

mafesa I have the same problem with the user group, how did you convert xenforo?

mafesa

GeorgP hi, for now I have abandoned the conversion...
I also tried some previous versions of the converter and I always get the "Integrity constraint violation: 1048 Column 'discussion_count' cannot be null" error.
Out of curiosity I also created a test forum with SMF 2.1.4 but I always get this error.
I think that there is a problem with my VPS settings because it's impossible that it doesn't work only for me.
You can try to convert to MyBB and then to Flarum with this.

GeorgP

mafesa the error is in the SQL query for Tags

import: group_user — 3216 rows, 00.84s (3.7mb)Illuminate\Database\QueryException SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'discussion_count' cannot be null (SQL: insert into FLA_tags (description, discussion_count...

Is there a way to avoid importing tags?

mafesa

GeorgP no, I don't think it's possible...

I managed to modify the table from phpmyadmin, in addition to the error above there are also these:

Integrity constraint violation: 1048 Column 'slug' cannot be null (SQL: insert into FLA_tags

Integrity constraint violation: 1048 Column 'post_number_index' cannot be null (SQL: insert into FLA_discussions

Setting them to NULL by default (phpmyadmin) the conversion ends successfully but the forum does not work.
Activating debug I see the error Call to a member function updateLastSeen() on null

I give up 😭

GeorgP

mafesa don't waste your time, this is an abandoned project.
I will try in these days to convert xenforo to mybb and then to flarum, if it fails I will use discourse which has a working converter.

linc

mafesa I've fixed the issues you described in version 3.7. It's possible for errors like this to crop up in only certain combinations of packages. If you find more of those 'cannot be null' errors, please let me know. A reasonable workaround is to try setting them to a non-null value (usually '0') not to modify the database constraints.

linc

GeorgP It's not, I'm just not on call and sometimes it takes me a bit to circle back. 🙃 There's more than 20 fixes in 3.7, just released.

mafesa

@linc thank you for your help 🙏

Flarum installation before conversion with FLA_ prefix on database

Flarum core: 1.8.10
PHP version: 8.2.7
MySQL version: 10.11.3-MariaDB-1
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, random, Reflection, SPL, session, standard, sodium, zip, mysqlnd, PDO, xml, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, intl, exif, mcrypt, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, Zend OPcache
+--------------------------+---------+--------+
| Flarum Extensions        |         |        |
+--------------------------+---------+--------+
| ID                       | Version | Commit |
+--------------------------+---------+--------+
| flarum-flags             | v1.8.2  |        |
| flarum-approval          | v1.8.2  |        |
| flarum-tags              | v1.8.4  |        |
| flarum-suspend           | v1.8.4  |        |
| fof-upload               | 1.8.5   |        |
| fof-byobu                | 1.4.3   |        |
| flarum-subscriptions     | v1.8.1  |        |
| flarum-sticky            | v1.8.2  |        |
| flarum-statistics        | v1.8.1  |        |
| flarum-mentions          | v1.8.5  |        |
| flarum-markdown          | v1.8.1  |        |
| flarum-lock              | v1.8.2  |        |
| flarum-likes             | v1.8.1  |        |
| flarum-lang-english      | v1.8.0  |        |
| flarum-extension-manager | v1.0.7  |        |
| flarum-emoji             | v1.8.1  |        |
| flarum-bbcode            | v1.8.0  |        |
+--------------------------+---------+--------+

With version 3.7.0 I still get errors but the conversion continues

import: group_user — 5466 rows, 00.93s (6mb)

Batch insert error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'discussion_count' cannot be null (Connection: flarum2, SQL: insert into `FLA_tags` (`description`, `discussion_count`, `id`, `name`, `parent_id`, `position`, `slug`)

and

Batch insert error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'type' cannot be null (Connection: flarum2, SQL: insert into `FLA_fof_upload_files` (`actor_id`, `base_name`, `created_at`, `discussion_id`, `id`, `path`, `post_id`, `size`, `tag`, `type`, `upload_method`, `url`) values

Once the conversion is complete, the forum doesn't load.

Debug show this error:
[2025-08-26 12:34:35] flarum.ERROR: Error: Call to a member function updateLastSeen() on null in /var/www/html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php:41

Just curious, in which folder should I copy the xenforo attachments?

linc

mafesa Can you remind me what folder Xenforo keeps its attachments in, how it's organized (dated folders? separated by type? all in 1 place?), and what a web link to one of them looks like? I don't need the domain part, just the path (from the slash). I haven't tested Xenforo's attachments making it to Flarum (only Vanilla and years ago), so I may need to update that a bit.

Alternatively, if someone has a copy of Xenforo they wouldn't mind sending me to refine the migration script, porter@lincolnwebs.com would reach me. (I promise I'm not gonna put it online and get your license flagged, I'm very familiar with how they operate.) I haven't had access to a fresh database in 6+ years, so I imagine it's changed a bit.

mafesa

linc They're inside folders, in my case just one, same thing for the avatars.
I'll send you an email with the details.

mafesa

@linc

mafesa Once the conversion is complete, the forum doesn't load.

Debug show this error:
[2025-08-26 12:34:35] flarum.ERROR: Error: Call to a member function updateLastSeen() on null in /var/www/html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php:41

Emptying the database table FLA_access_tokens, Flarum loads correctly, but the forum is empty...

linc

mafesa I found an issue with my not-null fix. I'll put out an update here shortly.

linc

Yeah I implemented the null filters wrong, try this update: linc/nitro-porterreleases/tag/v3.7.1

I may not get to the attachments thing for a few more days.

mafesa

linc
Sorry, I don't understand how to update, it always makes me use version 3.7

 - Installing linc/nitro-porter (v3.7.1): Extracting archive
25 package suggestions were added by new dependencies, use `composer suggest` to see details.
Generating autoload files
14 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
No security vulnerability advisories found
Using version ^3.7 for linc/nitro-porter

linc

mafesa I believe you have successfully upgraded. The nomenclature ^3.7 in Composer means "any version matching 3.7.x" which includes 3.7.1.

« Previous Page Next Page »