Kunena to Flarum migration - SQLSTATE[42000]: Syntax error or access violation

[Spipora]

Getting the following exception. A note - I am connecting to mysql running under MAMP, not the internal one.

import: tags — 25 rows, 00.02s (30.1mb)
Mentions map memory usage at 30mbIlluminate\Database\QueryException SQLSTATE[42000]: Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead (Connection: zidic, SQL: create table `discussions` (`id` int null, `user_id` int null, `title` varchar(200) null, `slug` varchar(200) null, `created_at` datetime null, `first_post_id` int null, `last_post_id` int null, `last_posted_at` datetime null, `last_posted_user_id` int null, `post_number_index` int null, `is_private` tinyint null, `is_sticky` tinyint null, `is_locked` tinyint null, primary key (`id`)) default character set utf8mb4)
(thrown in /app/vendor/illuminate/database/Connection.php:825)

Stack Trace:

  0) Illuminate\Database\Connection->runQueryCallback('create table `discussions` (`id` int null, `user_id` int null, `title` varchar(200) null, `slug` varchar(200) null, `created_at` datetime null, `first_post_id` int null, `last_post_id` int null, `last_posted_at` datetime null, `last_posted_user_id` int null, `post_number_index` int null, `is_private` tinyint null, `is_sticky` tinyint null, `is_locked` tinyint null, primary key (`id`)) default character set utf8mb4', [], Closure)
     at /app/vendor/illuminate/database/Connection.php:779
  1) Illuminate\Database\Connection->run('create table `discussions` (`id` int null, `user_id` int null, `title` varchar(200) null, `slug` varchar(200) null, `created_at` datetime null, `first_post_id` int null, `last_post_id` int null, `last_posted_at` datetime null, `last_posted_user_id` int null, `post_number_index` int null, `is_private` tinyint null, `is_sticky` tinyint null, `is_locked` tinyint null, primary key (`id`)) default character set utf8mb4', [], Closure)
     at /app/vendor/illuminate/database/Connection.php:560
  2) Illuminate\Database\Connection->statement('create table `discussions` (`id` int null, `user_id` int null, `title` varchar(200) null, `slug` varchar(200) null, `created_at` datetime null, `first_post_id` int null, `last_post_id` int null, `last_posted_at` datetime null, `last_posted_user_id` int null, `post_number_index` int null, `is_private` tinyint null, `is_sticky` tinyint null, `is_locked` tinyint null, primary key (`id`)) default character set utf8mb4')
     at /app/vendor/illuminate/database/Schema/Blueprint.php:118
  3) Illuminate\Database\Schema\Blueprint->build(Illuminate\Database\MySqlConnection, Illuminate\Database\Schema\Grammars\MySqlGrammar)
     at /app/vendor/illuminate/database/Schema/Builder.php:564
  4) Illuminate\Database\Schema\Builder->build(Illuminate\Database\Schema\Blueprint)
     at /app/vendor/illuminate/database/Schema/Builder.php:418
  5) Illuminate\Database\Schema\Builder->create('discussions', Closure)
     at /app/src/Storage/Database.php:231
  6) Porter\Storage\Database->createOrUpdateTable('discussions', ['int', 'int', 'varchar(200)', 'varchar(200)', 'datetime', 'int', 'int', 'datetime', 'int', 'int', 'tinyint', 'tinyint', 'tinyint', [['primary', ['id']]]])
     at /app/src/Storage/Database.php:196
  7) Porter\Storage\Database->prepare('discussions', ['int', 'int', 'varchar(200)', 'varchar(200)', 'datetime', 'int', 'int', 'datetime', 'int', 'int', 'tinyint', 'tinyint', 'tinyint', [['primary', ['id']]]])
     at /app/src/Target.php:199
  8) Porter\Target->import('discussions', Staudenmeir\LaravelCte\Query\Builder, ['int', 'int', 'varchar(200)', 'varchar(200)', 'datetime', 'int', 'int', 'datetime', 'int', 'int', 'tinyint', 'tinyint', 'tinyint', [['primary', ['id']]]], ['id', 'user_id', 'title', 'created_at', 'first_post_id', 'last_post_id', 'last_posted_at', 'last_posted_user_id', 'comment_count', 'is_sticky', 'is_locked'], ['createDiscussionSlugs', 'emptyToZero', 'emptyToZero'])
     at /app/src/Target/Flarum.php:393
  9) Porter\Target\Flarum->discussions()
     at /app/src/Target/Flarum.php:201
  10) Porter\Target\Flarum->run()
     at /app/src/Controller.php:47
  11) Porter\Controller->doImport(Porter\Target\Flarum)
     at /app/src/Controller.php:150
  12) Porter\Controller->run(Porter\Request)
     at /app/src/Command/RunCommand.php:72
  13) Porter\Command\RunCommand->execute()
     at /app/vendor/adhocore/cli/src/Application.php:458
  14) Ahc\Cli\Application->doAction(Porter\Command\RunCommand)
     at /app/vendor/adhocore/cli/src/Application.php:348
  15) Ahc\Cli\Application->handle(['/app/bin/porter', 'run', '-s', 'Kunena', '-i', 'input', '-t', 'Flarum'])
     at /app/bin/porter:15
www@7b7dee02db16:/app$ 

[linc]

Did you figure out what the issue was?

[Spipora]

Hello - yes, if I recall correctly it had something to do with using external mysql DB - I switched to the containerized one provided by Nitro-Porter and it went well. Lesson learned to to overcomplicate things.