SQLSTATE[42000]: Syntax error or access violation: 1173

Min

Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 1173 This table type requires a primary key (SQL: create tablemigrations(migrationvarchar(255) not null,extensionvarchar(255) null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

PHP VERSION:

php -v PHP 7.1.26 (cli) (built: Feb 19 2019 12:16:38) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.1.0, Copyright (c) 1998-2018 Zend Technologies with Zend OPcache v7.1.26, Copyright (c) 1999-2018, by Zend Technologies
mySQL VERSION:

MariaDB 10.1.9

The innodb_force_primary_key IS OFF

🤣

luceos

Very odd. Not heard of this before. Might be related to the mariadb version.

Min

luceos

I modified /vendor/flarum/core/src/Database/DatabaseMigrationRepository.php

public function createRepository() { $schema = $this->connection->getSchemaBuilder(); $schema->create($this->table, function ($table) { $table->string('migration', 100)->primary(); $table->string('extension')->nullable(); }); }

Still Not Working

Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 1173 This table type requires a primary key (SQL: create tablemigrations(migrationvarchar(100) not null,extensionvarchar(255) null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

luceos

Min instead of making migration primary add an entry $table->increments('id'); and see if that helps.