SQL error when upgrading to flarum 9

kael

I have these errors when i did migration
php flarum migrate

result

In Connection.php line 664:

SQLSTATE[HY000]: General error: 1005 Can't create table flarum.#sql-8b8_45370 (errno: 150 "Foreign key constraint i
s incorrectly formed") (SQL: alter table posts add constraint posts_user_id_foreign foreign key (user_id) refe
rences users (id) on delete set null)

In PDOStatement.php line 119:

SQLSTATE[HY000]: General error: 1005 Can't create table flarum.#sql-8b8_45370 (errno: 150 "Foreign key constraint is incorrectly formed")

In PDOStatement.php line 117:

SQLSTATE[HY000]: General error: 1005 Can't create table flarum.#sql-8b8_45370 (errno: 150 "Foreign key constraint is incorrectly formed")

luceos

kael can you post the full output from the error?

Leanna

kael Try to restart mysql try

kael

luceos

Migrating Flarum...

In Connection.php line 664:

SQLSTATE[HY000]: General error: 1005 Can't create table flarum.#sql-8b8_4c26e (errno: 150 "Foreign key constraint i
s incorrectly formed") (SQL: alter table posts add constraint posts_user_id_foreign foreign key (user_id) refe
rences users (id) on delete set null)

In PDOStatement.php line 119:

SQLSTATE[HY000]: General error: 1005 Can't create table flarum.#sql-8b8_4c26e (errno: 150 "Foreign key constraint i
s incorrectly formed")

In PDOStatement.php line 117:

SQLSTATE[HY000]: General error: 1005 Can't create table flarum.#sql-8b8_4c26e (errno: 150 "Foreign key constraint i
s incorrectly formed")

migrate

luceos

kael try running with -vvv

kael

i try to create to change the database but same thing

Migrating Flarum...

In Connection.php line 664:

[Illuminate\Database\QueryException (HY000)]
SQLSTATE[HY000]: General error: 1005 Can't create table lespro_flarum.#sql-8b8_4d291 (errno: 150 "Foreign key constraint i
s incorrectly formed") (SQL: alter table mast_posts add constraint mast_posts_user_id_foreign foreign key (user_id) refe
rences mast_users (id) on delete set null)

Exception trace:
() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:664
Illuminate\Database\Connection->runQueryCallback() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:624
Illuminate\Database\Connection->run() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:459
Illuminate\Database\Connection->statement() at /home/lespro/public_html/vendor/illuminate/database/Schema/Blueprint.php:97
Illuminate\Database\Schema\Blueprint->build() at /home/lespro/public_html/vendor/illuminate/database/Schema/Builder.php:264
Illuminate\Database\Schema\Builder->build() at /home/lespro/public_html/vendor/illuminate/database/Schema/Builder.php:149
Illuminate\Database\Schema\Builder->table() at /home/lespro/public_html/vendor/flarum/core/migrations/2018_01_18_135100_change_posts_add_foreign_keys.php:38
Illuminate\Filesystem\Filesystem->{closure}() at n/a:n/a
call_user_func() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:199
Flarum\Database\Migrator->runClosureMigration() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:130
Flarum\Database\Migrator->runUp() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:113
Flarum\Database\Migrator->runMigrationList() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:87
Flarum\Database\Migrator->run() at /home/lespro/public_html/vendor/flarum/core/src/Database/Console/MigrateCommand.php:65
Flarum\Database\Console\MigrateCommand->upgrade() at /home/lespro/public_html/vendor/flarum/core/src/Database/Console/MigrateCommand.php:51
Flarum\Database\Console\MigrateCommand->fire() at /home/lespro/public_html/vendor/flarum/core/src/Console/AbstractCommand.php:39
Flarum\Console\AbstractCommand->execute() at /home/lespro/public_html/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at /home/lespro/public_html/vendor/symfony/console/Application.php:921
Symfony\Component\Console\Application->doRunCommand() at /home/lespro/public_html/vendor/symfony/console/Application.php:273
Symfony\Component\Console\Application->doRun() at /home/lespro/public_html/vendor/symfony/console/Application.php:149
Symfony\Component\Console\Application->run() at /home/lespro/public_html/vendor/flarum/core/src/Console/Server.php:41
Flarum\Console\Server->listen() at /home/lespro/public_html/flarum:22

In PDOStatement.php line 119:

[Doctrine\DBAL\Driver\PDOException (HY000)]
SQLSTATE[HY000]: General error: 1005 Can't create table lespro_flarum.#sql-8b8_4d291 (errno: 150 "Foreign key constraint i
s incorrectly formed")

Exception trace:
() at /home/lespro/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Doctrine\DBAL\Driver\PDOStatement->execute() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:458
Illuminate\Database\Connection->Illuminate\Database{closure}() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:657
Illuminate\Database\Connection->runQueryCallback() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:624
Illuminate\Database\Connection->run() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:459
Illuminate\Database\Connection->statement() at /home/lespro/public_html/vendor/illuminate/database/Schema/Blueprint.php:97
Illuminate\Database\Schema\Blueprint->build() at /home/lespro/public_html/vendor/illuminate/database/Schema/Builder.php:264
Illuminate\Database\Schema\Builder->build() at /home/lespro/public_html/vendor/illuminate/database/Schema/Builder.php:149
Illuminate\Database\Schema\Builder->table() at /home/lespro/public_html/vendor/flarum/core/migrations/2018_01_18_135100_change_posts_add_foreign_keys.php:38
Illuminate\Filesystem\Filesystem->{closure}() at n/a:n/a
call_user_func() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:199
Flarum\Database\Migrator->runClosureMigration() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:130
Flarum\Database\Migrator->runUp() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:113
Flarum\Database\Migrator->runMigrationList() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:87
Flarum\Database\Migrator->run() at /home/lespro/public_html/vendor/flarum/core/src/Database/Console/MigrateCommand.php:65
Flarum\Database\Console\MigrateCommand->upgrade() at /home/lespro/public_html/vendor/flarum/core/src/Database/Console/MigrateCommand.php:51
Flarum\Database\Console\MigrateCommand->fire() at /home/lespro/public_html/vendor/flarum/core/src/Console/AbstractCommand.php:39
Flarum\Console\AbstractCommand->execute() at /home/lespro/public_html/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at /home/lespro/public_html/vendor/symfony/console/Application.php:921
Symfony\Component\Console\Application->doRunCommand() at /home/lespro/public_html/vendor/symfony/console/Application.php:273
Symfony\Component\Console\Application->doRun() at /home/lespro/public_html/vendor/symfony/console/Application.php:149
Symfony\Component\Console\Application->run() at /home/lespro/public_html/vendor/flarum/core/src/Console/Server.php:41
Flarum\Console\Server->listen() at /home/lespro/public_html/flarum:22

In PDOStatement.php line 117:

[PDOException (HY000)]
SQLSTATE[HY000]: General error: 1005 Can't create table lespro_flarum.#sql-8b8_4d291 (errno: 150 "Foreign key constraint i
s incorrectly formed")

Exception trace:
() at /home/lespro/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
PDOStatement->execute() at /home/lespro/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Doctrine\DBAL\Driver\PDOStatement->execute() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:458
Illuminate\Database\Connection->Illuminate\Database{closure}() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:657
Illuminate\Database\Connection->runQueryCallback() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:624
Illuminate\Database\Connection->run() at /home/lespro/public_html/vendor/illuminate/database/Connection.php:459
Illuminate\Database\Connection->statement() at /home/lespro/public_html/vendor/illuminate/database/Schema/Blueprint.php:97
Illuminate\Database\Schema\Blueprint->build() at /home/lespro/public_html/vendor/illuminate/database/Schema/Builder.php:264
Illuminate\Database\Schema\Builder->build() at /home/lespro/public_html/vendor/illuminate/database/Schema/Builder.php:149
Illuminate\Database\Schema\Builder->table() at /home/lespro/public_html/vendor/flarum/core/migrations/2018_01_18_135100_change_posts_add_foreign_keys.php:38
Illuminate\Filesystem\Filesystem->{closure}() at n/a:n/a
call_user_func() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:199
Flarum\Database\Migrator->runClosureMigration() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:130
Flarum\Database\Migrator->runUp() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:113
Flarum\Database\Migrator->runMigrationList() at /home/lespro/public_html/vendor/flarum/core/src/Database/Migrator.php:87
Flarum\Database\Migrator->run() at /home/lespro/public_html/vendor/flarum/core/src/Database/Console/MigrateCommand.php:65
Flarum\Database\Console\MigrateCommand->upgrade() at /home/lespro/public_html/vendor/flarum/core/src/Database/Console/MigrateCommand.php:51
Flarum\Database\Console\MigrateCommand->fire() at /home/lespro/public_html/vendor/flarum/core/src/Console/AbstractCommand.php:39
Flarum\Console\AbstractCommand->execute() at /home/lespro/public_html/vendor/symfony/console/Command/Command.php:255
Symfony\Component\Console\Command\Command->run() at /home/lespro/public_html/vendor/symfony/console/Application.php:921
Symfony\Component\Console\Application->doRunCommand() at /home/lespro/public_html/vendor/symfony/console/Application.php:273
Symfony\Component\Console\Application->doRun() at /home/lespro/public_html/vendor/symfony/console/Application.php:149
Symfony\Component\Console\Application->run() at /home/lespro/public_html/vendor/flarum/core/src/Console/Server.php:41
Flarum\Console\Server->listen() at /home/lespro/public_html/flarum:22

migrate

luceos

kael what is the output of mysql -v?

kael

luceos 10.0.38-MariaDB MariaDB Server

luceos

Are you able to access the database and see what type and length the following columns are and whether they are nullable:

mast_posts.user_id
mast_users.id

luceos

luceos in addition please post the php version php -v

kael

luceos
php -v

PHP 7.3.6 (cli) (built: Jul 1 2019 21:53:01) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.6, Copyright (c) 1998-2018 Zend Technologies
with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v10.3.2, Copyright (c) 2002-2018, by ionCube Ltd.
with Zend OPcache v7.3.6, Copyright (c) 1999-2018, by Zend Technologies

For database

mast_users.id
id (Primary) Type: int(10) UNSIGNED Null: No Default value: None AUTO_INCREMENT

mast_posts.user_id
user_id Type: int(10) Attributs: UNSIGNED Null: YES Default value: NULL

kael

luceos Can i send you my database through email?