Column not found: Unknown column 'post_number_index

[JoZ3]

After a couple of minutes, the migration process stops and the browser screen goes blank. The following errors appear in the php_errors.log file:

[30-Nov-2022 13:22:29 America/Bogota] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'post_number_index' in 'field list' in /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php:522
Stack trace:
#0 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(522): PDO->prepare('update `FLA_dis...')
#1 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}('update `FLA_dis...', Array)
#2 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('update `FLA_dis...', Array, Object(Closure))
#3 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(533): Illuminate\Database\Connection->run('update `FLA_dis...', Array, Object(Closure))
#4 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(466): Illuminate\Database\Connection->affectingStatement('update `FLA_dis...', Array)
#5 /home/myuser/www/nitro-porter/vendor/illuminate/database/Query/Builder.php(3063): Illuminate\Database\Connection->update('update `FLA_dis...', Array)
#6 /home/myuser/www/nitro-porter/src/Postscript/Flarum.php(123): Illuminate\Database\Query\Builder->update(Array)
#7 /home/myuser/www/nitro-porter/src/Postscript/Flarum.php(35): Porter\Postscript\Flarum->numberPosts(Object(Porter\ExportModel))
#8 /home/myuser/www/nitro-porter/src/Controller.php(119): Porter\Postscript\Flarum->run(Object(Porter\ExportModel))
#9 /home/myuser/www/nitro-porter/index.php(12): Porter\Controller::run(Object(Porter\Request))
#10 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'post_number_index' in 'field list' (SQL: update `FLA_discussions` set `post_number_index` = 2 where `id` = 1) in /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('update `FLA_dis...', Array, Object(Closure))
#1 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(533): Illuminate\Database\Connection->run('update `FLA_dis...', Array, Object(Closure))
#2 /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php(466): Illuminate\Database\Connection->affectingStatement('update `FLA_dis...', Array)
#3 /home/myuser/www/nitro-porter/vendor/illuminate/database/Query/Builder.php(3063): Illuminate\Database\Connection->update('update `FLA_dis...', Array)
#4 /home/myuser/www/nitro-porter/src/Postscript/Flarum.php(123): Illuminate\Database\Query\Builder->update(Array)
#5 /home/myuser/www/nitro-porter/src/Postscript/Flarum.php(35): Porter\Postscript\Flarum->numberPosts(Object(Porter\ExportModel))
#6 /home/myuser/www/nitro-porter/src/Controller.php(119): Porter\Postscript\Flarum->run(Object(Porter\ExportModel))
#7 /home/myuser/www/nitro-porter/index.php(12): Porter\Controller::run(Object(Porter\Request))
#8 {main}
  thrown in /home/myuser/www/nitro-porter/vendor/illuminate/database/Connection.php on line 712

I'm using a clean version of flarum with the following addons:

• Approval
• BBCode
• Emoji
• Flags
• FoF Byōbu
• FoF Gamification
• FoF Polls
• FoF Reactions
• FoF Upload
• Lock
• Markdown
• Mentions
• Nicknames
• Statistics
• Sticky
• Subscriptions
• Suspend
• Tags
• User badges

As you can see, the active addons match the ones that exist in Vanilla and that I am using in it.

This is the content of the porter.log file:

[2022-11-30T13:17:42.670435-05:00] porter.INFO: export: Category — 50 rows, 00.02s (714.5kb) [] []
[2022-11-30T13:17:49.905824-05:00] porter.INFO: inserting 'Comment': 100,000 done... [] []
[2022-11-30T13:17:57.707579-05:00] porter.INFO: inserting 'Comment': 200,000 done... [] []
[2022-11-30T13:18:03.145400-05:00] porter.INFO: inserting 'Comment': 300,000 done... [] []
[2022-11-30T13:18:07.056517-05:00] porter.INFO: export: Comment — 389676 rows, 24.39s (3mb) [] []
[2022-11-30T13:18:07.304438-05:00] porter.INFO: export: Conversation — 2144 rows, 00.25s (1.8mb) [] []
[2022-11-30T13:18:08.224502-05:00] porter.INFO: export: ConversationMessage — 18099 rows, 00.92s (2mb) [] []
[2022-11-30T13:18:08.863394-05:00] porter.INFO: export: Discussion — 2552 rows, 00.64s (5.1mb) [] []
[2022-11-30T13:18:08.998497-05:00] porter.INFO: export: Media — 1078 rows, 00.13s (1.7mb) [] []
[2022-11-30T13:18:09.014989-05:00] porter.INFO: export: Role — 12 rows, 00.02s (695kb) [] []
[2022-11-30T13:18:09.160857-05:00] porter.INFO: export: Tag — 1141 rows, 00.15s (1.6mb) [] []
[2022-11-30T13:18:09.289959-05:00] porter.INFO: export: TagDiscussion — 3359 rows, 00.13s (1.2mb) [] []
[2022-11-30T13:18:09.914110-05:00] porter.INFO: export: User — 1662 rows, 00.62s (4.8mb) [] []
[2022-11-30T13:18:11.484371-05:00] porter.INFO: inserting 'UserComment': 100,000 done... [] []
[2022-11-30T13:18:12.448629-05:00] porter.INFO: inserting 'UserComment': 200,000 done... [] []
[2022-11-30T13:18:13.426701-05:00] porter.INFO: inserting 'UserComment': 300,000 done... [] []
[2022-11-30T13:18:14.396371-05:00] porter.INFO: inserting 'UserComment': 400,000 done... [] []
[2022-11-30T13:18:15.371699-05:00] porter.INFO: inserting 'UserComment': 500,000 done... [] []
[2022-11-30T13:18:15.868347-05:00] porter.INFO: export: UserComment — 551368 rows, 05.95s (1.2mb) [] []
[2022-11-30T13:18:16.140621-05:00] porter.INFO: export: UserConversation — 4887 rows, 00.27s (1.7mb) [] []
[2022-11-30T13:18:18.226559-05:00] porter.INFO: inserting 'UserDiscussion': 100,000 done... [] []
[2022-11-30T13:18:19.378406-05:00] porter.INFO: export: UserDiscussion — 171987 rows, 03.24s (1.4mb) [] []
[2022-11-30T13:18:19.813858-05:00] porter.INFO: export: UserMeta — 7989 rows, 00.43s (1.2mb) [] []
[2022-11-30T13:18:19.877896-05:00] porter.INFO: export: UserRole — 1665 rows, 00.06s (1.2mb) [] []
[2022-11-30T13:18:19.893170-05:00] porter.INFO: export: Badge — 18 rows, 00.01s (775.5kb) [] []
[2022-11-30T13:18:20.052619-05:00] porter.INFO: export: UserBadge — 2707 rows, 00.16s (1.3mb) [] []
[2022-11-30T13:18:20.063071-05:00] porter.INFO: export: Rank — 11 rows, 00.01s (765.6kb) [] []
[2022-11-30T13:18:20.082954-05:00] porter.INFO: export: ReactionType — 3 rows, 00.02s (766kb) [] []
[2022-11-30T13:18:22.068384-05:00] porter.INFO: inserting 'UserTag': 100,000 done... [] []
[2022-11-30T13:18:23.373616-05:00] porter.INFO: inserting 'UserTag': 200,000 done... [] []
[2022-11-30T13:18:24.679777-05:00] porter.INFO: inserting 'UserTag': 300,000 done... [] []
[2022-11-30T13:18:25.994772-05:00] porter.INFO: inserting 'UserTag': 400,000 done... [] []
[2022-11-30T13:18:27.590267-05:00] porter.INFO: inserting 'UserTag': 500,000 done... [] []
[2022-11-30T13:18:28.050613-05:00] porter.INFO: export: UserTag — 534670 rows, 07.97s (1.3mb) [] []
[2022-11-30T13:18:28.328046-05:00] porter.INFO: import: users — 1662 rows, 00.27s (1.9mb) [] []
[2022-11-30T13:18:28.353290-05:00] porter.INFO: import: groups — 12 rows, 00.02s (765.7kb) [] []
[2022-11-30T13:18:28.431085-05:00] porter.INFO: import: group_user — 1664 rows, 00.08s (1.2mb) [] []
[2022-11-30T13:18:28.443227-05:00] porter.INFO: import: tags — 49 rows, 00.01s (799kb) [] []
[2022-11-30T13:18:28.443282-05:00] porter.INFO: Permissions are not migrated. Verify all permissions afterward. [] []
[2022-11-30T13:18:28.444665-05:00] porter.INFO: Mentions map memory usage at 1.6mb [] []
[2022-11-30T13:18:28.853902-05:00] porter.INFO: import: discussions — 2552 rows, 00.41s (2mb) [] []
[2022-11-30T13:18:28.946248-05:00] porter.INFO: import: discussion_tag — 2552 rows, 00.09s (1.4mb) [] []
[2022-11-30T13:18:31.057422-05:00] porter.INFO: inserting 'discussion_user': 100,000 done... [] []
[2022-11-30T13:18:32.102629-05:00] porter.INFO: import: discussion_user — 171983 rows, 03.16s (1.4mb) [] []
[2022-11-30T13:20:00.531798-05:00] porter.INFO: inserting 'posts': 100,000 done... [] []
[2022-11-30T13:20:29.897801-05:00] porter.INFO: inserting 'posts': 200,000 done... [] []
[2022-11-30T13:21:03.610063-05:00] porter.INFO: inserting 'posts': 300,000 done... [] []
[2022-11-30T13:21:50.860969-05:00] porter.INFO: import: posts — 392228 rows, 3:15.36 (8.7mb) [] []
[2022-11-30T13:21:50.884679-05:00] porter.INFO: import: badges — 18 rows, 00.02s (5.2mb) [] []
[2022-11-30T13:21:51.014543-05:00] porter.INFO: import: badge_user — 2707 rows, 00.13s (5.7mb) [] []
[2022-11-30T13:21:51.050703-05:00] porter.INFO: import: reactions — 3 rows, 00.04s (5.2mb) [] []
[2022-11-30T13:22:06.820842-05:00] porter.INFO: inserting 'post_reactions': 100,000 done... [] []
[2022-11-30T13:22:08.085084-05:00] porter.INFO: inserting 'post_reactions': 200,000 done... [] []
[2022-11-30T13:22:10.785298-05:00] porter.INFO: inserting 'post_reactions': 300,000 done... [] []
[2022-11-30T13:22:12.845247-05:00] porter.INFO: inserting 'post_reactions': 400,000 done... [] []
[2022-11-30T13:22:14.865261-05:00] porter.INFO: inserting 'post_reactions': 500,000 done... [] []
[2022-11-30T13:22:15.595183-05:00] porter.INFO: import: post_reactions — 534653 rows, 14.78s (5.8mb) [] []
[2022-11-30T13:22:15.816215-05:00] porter.INFO: Discussions offset for PMs is 3509 [] []
[2022-11-30T13:22:16.215124-05:00] porter.INFO: import: discussions — 2144 rows, 00.40s (5.9mb) [] []
[2022-11-30T13:22:16.215499-05:00] porter.INFO: Posts offset for PMs is 433665 [] []
[2022-11-30T13:22:20.912729-05:00] porter.INFO: import: posts — 18099 rows, 04.70s (6.6mb) [] []
[2022-11-30T13:22:21.080309-05:00] porter.INFO: import: recipients — 4887 rows, 00.17s (3.5mb) [] []
[2022-11-30T13:22:21.256922-05:00] porter.INFO: import: fof_upload_files — 1078 rows, 00.18s (4.2mb) [] []
[2022-11-30T13:22:29.553394-05:00] porter.INFO: build: mentions_user — 4068 rows, 08.30s (3mb) [] []

[linc]

Howdy @JoZ3, thanks for checking in. The FLA_discussions.post_number_index is part of core Flarum, so it should be there by default when you install Flarum. Could you manually inspect your Flarum database and see if it exists?

[JoZ3]

Hello, I could not answer before, but seeing the changes you made it looks like you made a correction regarding the problem that caused the error you commented, and it worked :).

Thank you very much for your work, I have made the conversion without any problem, now I have to verify that everything is ok in the forum :)

[linc]

Great, congrats!

[garygreen]

Worth noting that post_number_index is deprecated in Flarum, so could be removed