Nitro Porter, the inter-software migration toolkit

MoshBit

So I took another stab at this, and I think where I got confused was that the db prefix field is labeled 'optional'. I didn't put anything in that field and all I got was a blank page with no log file.

I tried again today and put xf_ in the db prefix field and i still got a blank page, but now there's a log file:

[2023-04-08T21:49:20.795134+00:00] porter.INFO: export: User — 14944 rows, 01.16s (6.8mb) [] [] [2023-04-08T21:49:20.803896+00:00] porter.INFO: export: Role — 12 rows, 00.01s (5.8mb) [] [] [2023-04-08T21:49:20.966543+00:00] porter.INFO: export: UserRole — 17437 rows, 00.16s (6.3mb) [] [] [2023-04-08T21:49:21.065402+00:00] porter.INFO: export: UserMeta — 2596 rows, 00.10s (6.5mb) [] [] [2023-04-08T21:49:21.073183+00:00] porter.INFO: export: Category — 70 rows, 00.01s (5.9mb) [] [] [2023-04-08T21:49:24.130848+00:00] porter.INFO: export: Discussion — 25744 rows, 03.06s (9.1mb) [] [] [2023-04-08T21:49:28.965809+00:00] porter.INFO: inserting 'Comment': 100,000 done... [] [] [2023-04-08T21:49:33.870370+00:00] porter.INFO: inserting 'Comment': 200,000 done... [] [] [2023-04-08T21:49:34.706633+00:00] porter.INFO: export: Comment — 216461 rows, 10.58s (7.2mb) [] [] [2023-04-08T21:49:36.160500+00:00] porter.INFO: export: Media — 29331 rows, 01.45s (7mb) [] []

It doesn't say 'success' or anything, but the data appears to be in the db now when I check it with phpmyadmin (in the tables with the PORT_ prefix).

What I don't quite get yet though is what the next step is? This doesn't seem to port the data over to the flaum tables. The user guide says:

Currently, it only uses the default table prefix for targets but you can specify the source prefix.

I'm not sure what the default table prefix for flarum is. All I've been able to find so far is a thread here saying you should avoid using them, so my installation doesn't have db prefixes.

I am using the web installer since I didn't have any luck at all with the CLI. I also have the folder nitro-porter as a sub-directory in my root xenforo install.

linc

MoshBit It doesn't say 'success' or anything, but the data appears to be in the db now when I check it with phpmyadmin (in the tables with the PORT_ prefix).

Ah, that's because it's crashing. It's supposed to do private messages after attachments ("Media"). Sounds like there's a glitch in the Xenforo converter.

linc

@MoshBit Nitro Porter 3.3 should work for you. Just released. The issue was Xenforo allows longer subject lines in PMs than the other systems so they needed to get truncated at 200 characters.

I also fixed a problem where if you were importing to Flarum but didn't preinstall it (in which case Porter will set up the tables), it could lead to a very long delay in the postscript while it was numbering posts due to a missing index.

Some other nice improvements in there too like (very basic) IPB4 support, better logging, an ASP Playground fix, and I took PHPStan up a level (4 to 5). (Most of this work was done over the holidays and just hadn't been released yet).

Jbugy

linc will this work on an old IPB site 3.3.x that runs on cPanel and that would like to keep flarum on the same cPanel (using some modified install)

Thank you

CATER_COM

Hi linc i get some troubles trying to use nitro porter to migrate from Vanilla 3/4 to Flarum. I setup source and destination connections on 2 MySQL databases on 2 différent server.

Edit : Vanilla 3.3 (Garden 3.3 and Conversation 2.4.201) / Flarum latest version from last days

I get a "PDOException SQLSTATE[HY000].... time out" The exception appear after 10 sometimes 20 seconds

Porter's log say
porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] []
porter.INFO: Source: Vanilla 2+ (source) [] []
porter.INFO: Target: Flarum (flarum_test) [] []
porter.INFO: Flag: Use Discussion Body: Enabled [] []

The 2 database are on OVH Private SQL server. The source database in on MySQL 5.6 server and destination is on MySQL 8 server. Each database has its own admin user. The webhosting is shared on OVH (performance) .

Connection settings are the one working on vanilla forum et flarum empty forum.

I tried firts to run Nitro Porter from OVH web root. Thinking the problem would be about time out as explained on your documentation I ran Nitro Porter from an other sharedhost provider that give me more control on php.ini but get the exactly same results. I allowed connection to database from external IP, same results. I don't understand what are those "permisions not migrated". Should I make the migration inside the same database or on the same server with the same user ?
Note that's a little community with less than 1000 discussions and comments..

Thanks for your job with Nitro Porter, this is the ability to keep Vanilla forum content and users that pull me to Flarum.

Cédric

linc

Jbugy It should. If you run into any problems let me know.

pawliniak

Hi, I'm trying to transfer the base from ipboard to flarum, but an error occurs. The database is 600MB and has about 150,000 users. Plesk, PHP 8.1.18. Please help below error.

AH01071: Got error 'PHP message: PHP Fatal error: Uncaught TypeError: fixDuplicateDeletedNames(): Argument #1 ($value) must be of type string, null given in /var/www/vhosts/domain.pl/httpdocs/src/Functions/filter.php:37\nStack trace:\n#0 [internal function]: fixDuplicateDeletedNames()\n#1 /var/www/vhosts/domain.pl/httpdocs/src/Storage.php(88): call_user_func()\n#2 /var/www/vhosts/domain.pl/httpdocs/src/Storage.php(60): Porter\Storage->filterData()\n#3 /var/www/vhosts/domain.pl/httpdocs/src/Storage/Database.php(101): Porter\Storage->normalizeRow()\n#4 /var/www/vhosts/domain.pl/httpdocs/src/ExportModel.php(260): Porter\Storage\Database->store()\n#5 /var/www/vhosts/domain.pl/httpdocs/src/Target/Flarum.php(243): Porter\ExportModel->import()\n#6 /var/www/vhosts/domain.pl/httpdocs/src/Target/Flarum.php(188): Porter\Target\Flarum->users()\n#7 /var/www/vhosts/domain.pl/httpdocs/src/Controller.php(48): Porter\Target\Flarum->run()\n#8 /var/www/vhosts/domai...', referer: https://domain.pl/!<

linc

CATER_COM How many users? That's what gets migrated first.

MoshBit

@linc so I finally got a chance to get a working installation going on my server and test the nitro-porter script, and it did complete once, but I screwed something else up and had to re-do it, and it keeps stalling out on the group_user table:

[2023-05-05T02:41:33.894167+00:00] porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] []
[2023-05-05T02:41:33.894866+00:00] porter.INFO: Source: Xenforo (source) [] []
[2023-05-05T02:41:33.894898+00:00] porter.INFO: Target: Flarum (test) [] []
[2023-05-05T02:41:33.894922+00:00] porter.INFO: Flag: Use Discussion Body: Enabled [] []
[2023-05-05T02:41:35.001690+00:00] porter.INFO: export: User — 15007 rows, 01.11s (7.1mb) [] []
[2023-05-05T02:41:35.009717+00:00] porter.INFO: export: Role — 12 rows, 00.01s (5.9mb) [] []
[2023-05-05T02:41:35.188537+00:00] porter.INFO: export: UserRole — 17508 rows, 00.18s (6.3mb) [] []
[2023-05-05T02:41:35.231811+00:00] porter.INFO: export: UserMeta — 2596 rows, 00.04s (6.5mb) [] []
[2023-05-05T02:41:35.238713+00:00] porter.INFO: export: Category — 70 rows, 00.01s (5.9mb) [] []
[2023-05-05T02:41:38.322973+00:00] porter.INFO: export: Discussion — 25792 rows, 03.08s (9.1mb) [] []
[2023-05-05T02:41:42.961233+00:00] porter.INFO: inserting 'Comment': 100,000 done... [] []
[2023-05-05T02:41:47.719939+00:00] porter.INFO: inserting 'Comment': 200,000 done... [] []
[2023-05-05T02:41:48.549904+00:00] porter.INFO: export: Comment — 216647 rows, 10.23s (7.3mb) [] []
[2023-05-05T02:41:50.008016+00:00] porter.INFO: export: Media — 29361 rows, 01.46s (7.1mb) [] []
[2023-05-05T02:41:52.292850+00:00] porter.INFO: inserting 'Conversation': 100,000 done... [] []
[2023-05-05T02:41:53.093395+00:00] porter.INFO: export: Conversation — 134757 rows, 03.09s (6.5mb) [] []
[2023-05-05T02:41:57.564873+00:00] porter.INFO: inserting 'ConversationMessage': 100,000 done... [] []
[2023-05-05T02:42:04.008870+00:00] porter.INFO: inserting 'ConversationMessage': 200,000 done... [] []
[2023-05-05T02:42:04.448081+00:00] porter.INFO: export: ConversationMessage — 211325 rows, 11.35s (14.3mb) [] []
[2023-05-05T02:42:05.478895+00:00] porter.INFO: inserting 'UserConversation': 100,000 done... [] []
[2023-05-05T02:42:06.391105+00:00] porter.INFO: inserting 'UserConversation': 200,000 done... [] []
[2023-05-05T02:42:07.277068+00:00] porter.INFO: inserting 'UserConversation': 300,000 done... [] []
[2023-05-05T02:42:08.152990+00:00] porter.INFO: inserting 'UserConversation': 400,000 done... [] []
[2023-05-05T02:42:08.263851+00:00] porter.INFO: export: UserConversation — 411608 rows, 03.82s (6.3mb) [] []
[2023-05-05T02:42:09.737557+00:00] porter.INFO: import: users — 15007 rows, 01.38s (7.2mb) [] []
[2023-05-05T02:42:09.806906+00:00] porter.INFO: import: groups — 12 rows, 00.01s (6.2mb) [] []
[2023-05-05T02:42:09.998347+00:00] porter.INFO: import: group_user — 17508 rows, 00.19s (6.6mb) [] []

I feel like I'm close to getting this working, but I'm not sure what to check next (my max memory in PHP is set to like 384mb). Any suggestions?

CATER_COM

MoshBit Oh you also have the "Permissions are not migrated" message but something happen after so I may have some other problem but the log stop after 4 first lines.

linc

MoshBit Usually a stall is a missing index. I'd start with deleting PORT_UserRole and letting Porter recreate it on next run.

linc

CATER_COM "Permissions are not migrated" is not an error, it's just telling you the Porter doesn't do that and never will.

CATER_COM

linc Ok so that mean the process just stop

MoshBit

linc Hmm, is it supposed to start from that table when I re-run it? Because it looks like it's starting from the beginning over again each time, and still getting stuck on group_user after I dropped the PORT_UserRole table.

[2023-05-08T03:13:10.199228+00:00] porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] []
[2023-05-08T03:13:10.200015+00:00] porter.INFO: Source: Xenforo (source) [] []
[2023-05-08T03:13:10.200050+00:00] porter.INFO: Target: Flarum (test) [] []
[2023-05-08T03:13:10.200073+00:00] porter.INFO: Flag: Use Discussion Body: Enabled [] []
[2023-05-08T03:13:11.404780+00:00] porter.INFO: export: User — 15013 rows, 01.20s (7.1mb) [] []
[2023-05-08T03:13:11.410739+00:00] porter.INFO: export: Role — 12 rows, 00.01s (5.9mb) [] []
[2023-05-08T03:13:11.610084+00:00] porter.INFO: export: UserRole — 17514 rows, 00.20s (6.3mb) [] []
[2023-05-08T03:13:11.660788+00:00] porter.INFO: export: UserMeta — 2596 rows, 00.05s (6.5mb) [] []
[2023-05-08T03:13:11.670267+00:00] porter.INFO: export: Category — 70 rows, 00.01s (5.9mb) [] []
[2023-05-08T03:13:15.311471+00:00] porter.INFO: export: Discussion — 25797 rows, 03.64s (9.1mb) [] []
[2023-05-08T03:13:21.091300+00:00] porter.INFO: inserting 'Comment': 100,000 done... [] []
[2023-05-08T03:13:26.718790+00:00] porter.INFO: inserting 'Comment': 200,000 done... [] []
[2023-05-08T03:13:27.595164+00:00] porter.INFO: export: Comment — 216675 rows, 12.28s (7.3mb) [] []
[2023-05-08T03:13:29.066151+00:00] porter.INFO: export: Media — 29364 rows, 01.47s (7.1mb) [] []
[2023-05-08T03:13:31.696713+00:00] porter.INFO: inserting 'Conversation': 100,000 done... [] []
[2023-05-08T03:13:32.597723+00:00] porter.INFO: export: Conversation — 134763 rows, 03.53s (6.5mb) [] []
[2023-05-08T03:13:37.492168+00:00] porter.INFO: inserting 'ConversationMessage': 100,000 done... [] []
[2023-05-08T03:13:44.393002+00:00] porter.INFO: inserting 'ConversationMessage': 200,000 done... [] []
[2023-05-08T03:13:44.867942+00:00] porter.INFO: export: ConversationMessage — 211334 rows, 12.27s (14.3mb) [] []
[2023-05-08T03:13:46.006712+00:00] porter.INFO: inserting 'UserConversation': 100,000 done... [] []
[2023-05-08T03:13:46.977553+00:00] porter.INFO: inserting 'UserConversation': 200,000 done... [] []
[2023-05-08T03:13:47.945350+00:00] porter.INFO: inserting 'UserConversation': 300,000 done... [] []
[2023-05-08T03:13:48.941891+00:00] porter.INFO: inserting 'UserConversation': 400,000 done... [] []
[2023-05-08T03:13:49.106779+00:00] porter.INFO: export: UserConversation — 411627 rows, 04.24s (6.3mb) [] []
[2023-05-08T03:13:50.810270+00:00] porter.INFO: import: users — 15013 rows, 01.59s (10mb) [] []
[2023-05-08T03:13:50.873374+00:00] porter.INFO: import: groups — 12 rows, 00.01s (6.2mb) [] []
[2023-05-08T03:13:51.075927+00:00] porter.INFO: import: group_user — 17514 rows, 00.20s (7.3mb) [] []

I'm running this from the web page, not the CLI just in case that's important. The page goes blank after a while, but it seems like the script keeps going, but I don't know how to check that for sure.

CATER_COM

linc Actually we have 110 users, just few in fact, it's a little regional network. I think the forum size (users and messages) is small enought to not triggerring time out problems. So I understand thta the missing index is on Porter tables, not in Vanilla tables. I 'll try your suggestion.

linc

MoshBit Yes, it will start from the beginning each time. Trying to resume a failed migration would add quite a bit of complexity.

Increasing your timeout like @ymaohyd did above may help.

ymaohyd

Hopefully this is the right place to post this...

I'm trying to port Vanilla 3.3 to Flarum 1.7.0 on my Windows 10 PC which is running xampp.

Unfortunately I'm getting the follow error at a stage when judging by the phpMyAdmin table overview I think Nitro Porter is trying to port the port_comments table to the fla_posts table.

[php:error] [pid 7384:tid 1892] [client 127.0.0.1:63350] PHP Fatal error: Uncaught TypeError: nadar\\quill\\Lexer::getJsonArray(): Return value must be of type array, null returned in C:\\xampp\\htdocs\\nitro\\vendor\\nadar\\quill-delta-parser\\src\\Lexer.php:207\nStack trace:\n#0 C:\\xampp\\htdocs\\nitro\\vendor\\nadar\\quill-delta-parser\\src\\Lexer.php(217): nadar\\quill\\Lexer->getJsonArray()\n#1 C:\\xampp\\htdocs\\nitro\\vendor\\nadar\\quill-delta-parser\\src\\Lexer.php(392): nadar\\quill\\Lexer->getOps()\n#2 C:\\xampp\\htdocs\\nitro\\src\\Formatter.php(107): nadar\\quill\\Lexer->render()\n#3 C:\\xampp\\htdocs\\nitro\\src\\Formatter.php(58): Porter\\Formatter::dequill('{"ops":[{"attri...')\n#4 C:\\xampp\\htdocs\\nitro\\src\\Functions\\filter.php(23): Porter\\Formatter->toTextFormatter('Rich', '[{"attributes":...')\n#5 [internal function]: filterFlarumContent('[{"attributes":...', 'Body', Array)\n#6 C:\\xampp\\htdocs\\nitro\\src\\Storage.php(88): call_user_func('filterFlarumCon...', '[{"attributes":...', 'Body', Array)\n#7 C:\\xampp\\htdocs\\nitro\\src\\Storage.php(60): Porter\\Storage->filterData(Array, Array)\n#8 C:\\xampp\\htdocs\\nitro\\src\\Storage\\Database.php(101): Porter\\Storage->normalizeRow(Array, Array, Array, Array)\n#9 C:\\xampp\\htdocs\\nitro\\src\\ExportModel.php(260): Porter\\Storage\\Database->store('posts', Array, Array, Object(Illuminate\\Database\\Query\\Builder), Array, Object(Porter\\ExportModel))\n#10 C:\\xampp\\htdocs\\nitro\\src\\Target\\Flarum.php(483): Porter\\ExportModel->import('posts', Object(Illuminate\\Database\\Query\\Builder), Array, Array, Array)\n#11 C:\\xampp\\htdocs\\nitro\\src\\Target\\Flarum.php(191): Porter\\Target\\Flarum->comments(Object(Porter\\ExportModel))\n#12 C:\\xampp\\htdocs\\nitro\\src\\Controller.php(48): Porter\\Target\\Flarum->run(Object(Porter\\ExportModel))\n#13 C:\\xampp\\htdocs\\nitro\\src\\Controller.php(123): Porter\\Controller::doImport(Object(Porter\\Target\\Flarum), Object(Porter\\ExportModel))\n#14 C:\\xampp\\htdocs\\nitro\\index.php(12): Porter\\Controller::run(Object(Porter\\Request))\n#15 {main}\n thrown in C:\\xampp\\htdocs\\nitro\\vendor\\nadar\\quill-delta-parser\\src\\Lexer.php on line 207, referer: http://127.0.0.1/nitro/

The last entry in the porter.log is:

porter.INFO: import: discussion_user — 231985 rows, 2:19.64 (6.7mb) [] []

Any help or suggestions on what could be going wrong and how I could fix it would be greatly appreciated.

ymaohyd

ymaohyd Managed to resolve this issue (somehow) by adding the following to my Apache httpd.conf file:

Timeout 1800

And also by adding/changing these values in my php.ini file:

max_allowed_packet=64M wait_timeout=28800 interactive_timeout=28800

Hope that helps someone who may encounter the same or similar problems.

CATER_COM

ymaohyd I don't actualy have access to apache and php.ini setting on my sharedhost, but I plan to move Vanilla to another sharedhost to isolate it on php7 the time to be able to move to Flarum 😉 . Moreover I will be able to try the migration managing better granularity settings with this new sharedhosting hostprovider.
Thanks 🙂

linc

ymaohyd Are you sure all of those changes were required? My understanding was that simply the Timeout 1800 in the Apache conf would suffice. I have that note in the guide.

ymaohyd

Unfortunately I've run into another problem whilst trying to port Vanilla 3.3 to Flarum 1.7.0 on my Windows PC running xampp with Nitro Porter 3.3

The port stalls after the 'build: mention_users' stage is completed. Here is the porter.log file entry:

[2023-05-09T18:50:03.321062+02:00] porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] [] [2023-05-09T18:50:03.325563+02:00] porter.INFO: Source: Vanilla 2+ (source) [] [] [2023-05-09T18:50:03.325616+02:00] porter.INFO: Target: Flarum (test) [] [] [2023-05-09T18:50:03.325652+02:00] porter.INFO: Flag: Use Discussion Body: Enabled [] [] [2023-05-09T18:50:04.017899+02:00] porter.INFO: export: Category — 5 rows, 00.55s (5.7mb) [] [] [2023-05-09T18:50:37.163823+02:00] porter.INFO: inserting 'Comment': 100,000 done... [] [] [2023-05-09T18:50:39.375756+02:00] porter.INFO: export: Comment — 104925 rows, 35.27s (8.8mb) [] [] [2023-05-09T18:50:40.498814+02:00] porter.INFO: export: Conversation — 92 rows, 00.77s (6.2mb) [] [] [2023-05-09T18:50:42.633861+02:00] porter.INFO: export: ConversationMessage — 367 rows, 02.07s (6.6mb) [] [] [2023-05-09T18:50:45.790804+02:00] porter.INFO: export: Discussion — 5804 rows, 03.12s (9.2mb) [] [] [2023-05-09T18:50:48.913233+02:00] porter.INFO: export: Media — 1346 rows, 02.54s (7.3mb) [] [] [2023-05-09T18:50:49.562487+02:00] porter.INFO: export: Role — 6 rows, 00.58s (6.2mb) [] [] [2023-05-09T18:50:50.313062+02:00] porter.INFO: export: Tag — 0 rows, 00.68s (0b) [] [] [2023-05-09T18:50:50.862924+02:00] porter.INFO: export: TagDiscussion — 0 rows, 00.23s (0b) [] [] [2023-05-09T18:50:52.443354+02:00] porter.INFO: export: User — 890 rows, 01.53s (9.7mb) [] [] [2023-05-09T18:51:00.258203+02:00] porter.INFO: export: UserComment — 50329 rows, 07.42s (6.7mb) [] [] [2023-05-09T18:51:00.887883+02:00] porter.INFO: export: UserConversation — 189 rows, 00.52s (6.4mb) [] [] [2023-05-09T18:51:14.595099+02:00] porter.INFO: inserting 'UserDiscussion': 100,000 done... [] [] [2023-05-09T18:51:27.777410+02:00] porter.INFO: inserting 'UserDiscussion': 200,000 done... [] [] [2023-05-09T18:51:31.194908+02:00] porter.INFO: export: UserDiscussion — 232937 rows, 30.20s (6.9mb) [] [] [2023-05-09T18:51:31.994182+02:00] porter.INFO: export: UserMeta — 44 rows, 00.34s (6.2mb) [] [] [2023-05-09T18:51:32.611460+02:00] porter.INFO: export: UserRole — 602 rows, 00.54s (6.5mb) [] [] [2023-05-09T18:51:33.311466+02:00] porter.INFO: export: Badge — 47 rows, 00.35s (6.3mb) [] [] [2023-05-09T18:51:35.046651+02:00] porter.INFO: export: UserBadge — 3053 rows, 01.73s (6.8mb) [] [] [2023-05-09T18:51:36.083279+02:00] porter.INFO: export: Rank — 7 rows, 00.95s (6.2mb) [] [] [2023-05-09T18:51:36.549955+02:00] porter.INFO: export: ReactionType — 6 rows, 00.33s (6.2mb) [] [] [2023-05-09T18:51:45.403308+02:00] porter.INFO: export: UserTag — 51907 rows, 08.85s (6.8mb) [] [] [2023-05-09T18:51:48.231177+02:00] porter.INFO: import: users — 890 rows, 02.25s (7.4mb) [] [] [2023-05-09T18:51:49.279877+02:00] porter.INFO: import: groups — 6 rows, 01.01s (6.4mb) [] [] [2023-05-09T18:51:50.547308+02:00] porter.INFO: import: group_user — 602 rows, 01.27s (6.7mb) [] [] [2023-05-09T18:51:51.855711+02:00] porter.INFO: import: tags — 4 rows, 01.31s (6.4mb) [] [] [2023-05-09T18:51:51.872902+02:00] porter.INFO: Mentions map memory usage at 6.9mb [] [] [2023-05-09T18:52:02.928737+02:00] porter.INFO: import: discussions — 5804 rows, 11.05s (7.7mb) [] [] [2023-05-09T18:52:06.654448+02:00] porter.INFO: import: discussion_tag — 5804 rows, 03.73s (7mb) [] [] [2023-05-09T18:52:27.419399+02:00] porter.INFO: inserting 'discussion_user': 100,000 done... [] [] [2023-05-09T18:53:02.797504+02:00] porter.INFO: inserting 'discussion_user': 200,000 done... [] [] [2023-05-09T18:53:14.488351+02:00] porter.INFO: import: discussion_user — 232937 rows, 1:07.83 (7mb) [] [] [2023-05-09T19:01:38.760365+02:00] porter.INFO: inserting 'posts': 100,000 done... [] [] [2023-05-09T19:04:26.592705+02:00] porter.INFO: import: posts — 110729 rows, 11:08.70 (45.4mb) [] [] [2023-05-09T19:04:28.400466+02:00] porter.INFO: import: badges — 47 rows, 01.81s (11.2mb) [] [] [2023-05-09T19:04:34.576453+02:00] porter.INFO: import: badge_user — 3053 rows, 06.18s (11.7mb) [] [] [2023-05-09T19:04:34.577193+02:00] porter.INFO: Skipping import: Polls (Source lacks support) [] [] [2023-05-09T19:04:38.316909+02:00] porter.INFO: import: reactions — 6 rows, 03.74s (9mb) [] [] [2023-05-09T19:05:48.515621+02:00] porter.INFO: import: post_reactions — 51899 rows, 36.90s (9.5mb) [] [] [2023-05-09T19:05:49.013380+02:00] porter.INFO: Discussions offset for PMs is 6312 [] [] [2023-05-09T19:05:51.415753+02:00] porter.INFO: import: discussions — 92 rows, 02.30s (9mb) [] [] [2023-05-09T19:05:52.054610+02:00] porter.INFO: Posts offset for PMs is 111784 [] [] [2023-05-09T19:05:57.928273+02:00] porter.INFO: import: posts — 367 rows, 05.87s (11.3mb) [] [] [2023-05-09T19:06:01.217526+02:00] porter.INFO: import: recipients — 189 rows, 03.29s (11mb) [] [] [2023-05-09T19:06:09.319464+02:00] porter.INFO: import: fof_upload_files — 1346 rows, 07.35s (12.1mb) [] [] [2023-05-09T19:06:09.345092+02:00] porter.INFO: Postscript found and running... [] [] [2023-05-09T19:07:31.411522+02:00] porter.INFO: build: mentions_user — 4881 rows, 1:22.07 (9mb) [] []

Here is a screen grab of the table structure at the time the porter stalls:

There are no errors shown in the php_error_log file either so I don't really know where to look next to find out what is going wrong.

ymaohyd

ymaohyd An update on the 'stalling' problem... it wasn't stalling after all it was me just not being patient enough to wait a few hours.

Am delighted the port from Vanilla worked and thank you so much @linc for creating Nitro Porter - you are a saviour!

Here is the full porter.log for anyone who may find it handy for gauging progress on their migration:

[2023-05-09T20:26:38.983973+02:00] porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] [] [2023-05-09T20:26:38.985694+02:00] porter.INFO: Source: Vanilla 2+ (source) [] [] [2023-05-09T20:26:38.985772+02:00] porter.INFO: Target: Flarum (test) [] [] [2023-05-09T20:26:38.985818+02:00] porter.INFO: Flag: Use Discussion Body: Enabled [] [] [2023-05-09T20:26:39.578169+02:00] porter.INFO: export: Category — 5 rows, 00.44s (5.7mb) [] [] [2023-05-09T20:27:13.077952+02:00] porter.INFO: inserting 'Comment': 100,000 done... [] [] [2023-05-09T20:27:14.742256+02:00] porter.INFO: export: Comment — 104925 rows, 35.12s (8.8mb) [] [] [2023-05-09T20:27:15.932796+02:00] porter.INFO: export: Conversation — 92 rows, 00.57s (6.2mb) [] [] [2023-05-09T20:27:17.246147+02:00] porter.INFO: export: ConversationMessage — 367 rows, 01.25s (6.6mb) [] [] [2023-05-09T20:27:20.745255+02:00] porter.INFO: export: Discussion — 5804 rows, 03.46s (9.2mb) [] [] [2023-05-09T20:27:22.911482+02:00] porter.INFO: export: Media — 1346 rows, 02.04s (7.3mb) [] [] [2023-05-09T20:27:23.543846+02:00] porter.INFO: export: Role — 6 rows, 00.27s (6.2mb) [] [] [2023-05-09T20:27:23.952708+02:00] porter.INFO: export: Tag — 0 rows, 00.31s (0b) [] [] [2023-05-09T20:27:24.644496+02:00] porter.INFO: export: TagDiscussion — 0 rows, 00.65s (0b) [] [] [2023-05-09T20:27:26.194744+02:00] porter.INFO: export: User — 890 rows, 01.50s (9.7mb) [] [] [2023-05-09T20:27:33.271284+02:00] porter.INFO: export: UserComment — 50329 rows, 07.02s (6.7mb) [] [] [2023-05-09T20:27:33.716320+02:00] porter.INFO: export: UserConversation — 189 rows, 00.31s (6.4mb) [] [] [2023-05-09T20:27:46.466284+02:00] porter.INFO: inserting 'UserDiscussion': 100,000 done... [] [] [2023-05-09T20:27:59.991105+02:00] porter.INFO: inserting 'UserDiscussion': 200,000 done... [] [] [2023-05-09T20:28:03.367277+02:00] porter.INFO: export: UserDiscussion — 232937 rows, 29.33s (6.9mb) [] [] [2023-05-09T20:28:04.158052+02:00] porter.INFO: export: UserMeta — 44 rows, 00.62s (6.2mb) [] [] [2023-05-09T20:28:04.783672+02:00] porter.INFO: export: UserRole — 602 rows, 00.55s (6.5mb) [] [] [2023-05-09T20:28:05.600325+02:00] porter.INFO: export: Badge — 47 rows, 00.60s (6.3mb) [] [] [2023-05-09T20:28:06.893876+02:00] porter.INFO: export: UserBadge — 3053 rows, 01.29s (6.8mb) [] [] [2023-05-09T20:28:07.318931+02:00] porter.INFO: export: Rank — 7 rows, 00.35s (6.2mb) [] [] [2023-05-09T20:28:08.227444+02:00] porter.INFO: export: ReactionType — 6 rows, 00.66s (6.2mb) [] [] [2023-05-09T20:28:16.825351+02:00] porter.INFO: export: UserTag — 51907 rows, 08.60s (6.8mb) [] [] [2023-05-09T20:28:18.503046+02:00] porter.INFO: import: users — 890 rows, 01.39s (7.4mb) [] [] [2023-05-09T20:28:19.272338+02:00] porter.INFO: import: groups — 6 rows, 00.46s (6.4mb) [] [] [2023-05-09T20:28:20.435970+02:00] porter.INFO: import: group_user — 602 rows, 01.16s (6.7mb) [] [] [2023-05-09T20:28:21.227644+02:00] porter.INFO: import: tags — 4 rows, 00.79s (6.4mb) [] [] [2023-05-09T20:28:21.229690+02:00] porter.INFO: Mentions map memory usage at 6.9mb [] [] [2023-05-09T20:28:33.065885+02:00] porter.INFO: import: discussions — 5804 rows, 11.71s (7.7mb) [] [] [2023-05-09T20:28:36.922882+02:00] porter.INFO: import: discussion_tag — 5804 rows, 03.86s (7mb) [] [] [2023-05-09T20:28:55.873702+02:00] porter.INFO: inserting 'discussion_user': 100,000 done... [] [] [2023-05-09T20:29:29.846282+02:00] porter.INFO: inserting 'discussion_user': 200,000 done... [] [] [2023-05-09T20:29:40.963553+02:00] porter.INFO: import: discussion_user — 232937 rows, 1:04.04 (7mb) [] [] [2023-05-09T20:36:52.072469+02:00] porter.INFO: inserting 'posts': 100,000 done... [] [] [2023-05-09T20:39:24.207320+02:00] porter.INFO: import: posts — 110729 rows, 9:39.94 (45.4mb) [] [] [2023-05-09T20:39:26.219688+02:00] porter.INFO: import: badges — 47 rows, 02.01s (11.2mb) [] [] [2023-05-09T20:39:29.705156+02:00] porter.INFO: import: badge_user — 3053 rows, 03.49s (11.7mb) [] [] [2023-05-09T20:39:29.705870+02:00] porter.INFO: Skipping import: Polls (Source lacks support) [] [] [2023-05-09T20:39:31.334059+02:00] porter.INFO: import: reactions — 6 rows, 01.63s (9mb) [] [] [2023-05-09T20:40:32.582306+02:00] porter.INFO: import: post_reactions — 51899 rows, 28.43s (9.5mb) [] [] [2023-05-09T20:40:32.688476+02:00] porter.INFO: Discussions offset for PMs is 6312 [] [] [2023-05-09T20:40:36.427711+02:00] porter.INFO: import: discussions — 92 rows, 03.70s (9mb) [] [] [2023-05-09T20:40:37.204954+02:00] porter.INFO: Posts offset for PMs is 111784 [] [] [2023-05-09T20:41:08.806377+02:00] porter.INFO: import: posts — 367 rows, 31.60s (11.3mb) [] [] [2023-05-09T20:41:12.189718+02:00] porter.INFO: import: recipients — 189 rows, 03.38s (11mb) [] [] [2023-05-09T20:41:18.167991+02:00] porter.INFO: import: fof_upload_files — 1346 rows, 05.83s (12.1mb) [] [] [2023-05-09T20:41:18.171672+02:00] porter.INFO: Postscript found and running... [] [] [2023-05-09T20:42:31.989002+02:00] porter.INFO: build: mentions_user — 4933 rows, 1:13.82 (9mb) [] [] [2023-05-09T21:32:42.400155+02:00] porter.INFO: build: post numbers — 111096 rows, 50:10.41 (11.5mb) [] [] [2023-05-09T21:34:25.485377+02:00] porter.INFO: Failed to find 29 quoted posts (perhaps deleted). [] [] [2023-05-09T21:34:25.485534+02:00] porter.INFO: build: mentions_post — 11107 rows, 1:43.08 (9.2mb) [] [] [2023-05-10T02:50:43.242962+02:00] porter.INFO: build: following last read — 232937 rows, 316:17.76 (108.6mb) [] [] [2023-05-10T02:50:43.721331+02:00] porter.INFO: Promoted to Admin: System (system@vanillacommunity.example) [] [] [2023-05-10T02:50:43.721438+02:00] porter.INFO: ELAPSED — 384:04.74 (20:26:38 - 02:50:43) [] []

« Previous Page Next Page »