Upgrade to 1.63, failed on migration of flarum-mentions extension

dust2k

The issue

I have a problem when upgrade my flarum installation from 1.2 to 1.63 today, the error message shows on 5th floor, after that, I re-run the command "php flarum migrate", it give the error message like this:

Migrating Flarum...
Nothing to migrate.
Migrating extension: flarum-flags
Nothing to migrate.
Migrating extension: flarum-suspend
Nothing to migrate.
Migrating extension: flarum-approval
Nothing to migrate.
Migrating extension: flarum-tags
Nothing to migrate.
Migrating extension: fof-user-bio
Nothing to migrate.
Migrating extension: fof-upload
Nothing to migrate.
Migrating extension: fof-terms
Nothing to migrate.
Migrating extension: fof-pages
Nothing to migrate.
Migrating extension: fof-merge-discussions
Nothing to migrate.
Migrating extension: fof-links
Nothing to migrate.
Migrating extension: fof-byobu
Nothing to migrate.
Migrating extension: fof-best-answer
Nothing to migrate.
Migrating extension: flarum-subscriptions
Nothing to migrate.
Migrating extension: flarum-sticky
Nothing to migrate.
Migrating extension: flarum-mentions
In Connection.php line 712:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mf_post_mentions_group' already exists (SQL: create table mf_post_mentions_group (post_id int unsigned not null, mentions_group_id int unsigned not null, created_at datetime default CURRENT_TIMESTAMP null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)
In Exception.php line 18:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mf_post_mentions_group' already exists
In PDOStatement.php line 117:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'mf_post_mentions_group' already exists
migrate

Flarum information

Flarum core 1.6.3
PHP version: 8.1.2-1ubuntu2.10
MySQL version: 8.0.32-0ubuntu0.22.04.2
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, imagick, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+--------------------------------+---------+--------+
| Flarum Extensions              |         |        |
+--------------------------------+---------+--------+
| ID                             | Version | Commit |
+--------------------------------+---------+--------+
| flarum-flags                   | v1.6.1  |        |
| flarum-suspend                 | v1.6.1  |        |
| flarum-approval                | v1.6.1  |        |
| flarum-tags                    | v1.6.1  |        |
| fof-user-bio                   | 1.1.1   |        |
| fof-upload                     | 1.2.3   |        |
| fof-terms                      | 1.2.0   |        |
| fof-spamblock                  | 1.1.0   |        |
| fof-profile-image-crop         | 1.1.1   |        |
| fof-pages                      | 1.0.4   |        |
| fof-merge-discussions          | 1.3.1   |        |
| fof-links                      | 1.1.2   |        |
| fof-formatting                 | 1.0.2   |        |
| fof-byobu                      | 1.1.8   |        |
| fof-best-answer                | 1.2.4   |        |
| flarum-subscriptions           | v1.6.3  |        |
| flarum-sticky                  | v1.6.1  |        |
| flarum-statistics              | v1.6.1  |        |
| flarum-mentions                | v1.6.3  |        |
| flarum-markdown                | v1.6.1  |        |
| flarum-lock                    | v1.6.1  |        |
| flarum-likes                   | v1.6.1  |        |
| flarum-lang-english            | v1.6.0  |        |
| flarum-lang-chinese-simplified | v1.3.0  |        |
| flarum-emoji                   | v1.6.1  |        |
| flarum-bbcode                  | v1.6.0  |        |
+--------------------------------+---------+--------+
Base URL: https://***
Installation path: /var/www/***
Queue driver: sync
Session driver: file
Mail driver: smtp
Debug mode: off

So what am I going to do now to fix this problem??

dust2k

Anyone can help? thanks.

luceos

dust2k will look into this as soon as i can. But I'm assuming you carried out the upgrade from the web first?

dust2k

luceos But I'm assuming you carried out the upgrade from the web first?

no, I did all from linux console, but there is option to upgrade from webpage because my flarum can only show the upgrade page with database password input field.

dust2k

luceos any update or help?

dust2k

Here is the first issue from the log:

[2023-01-31 06:22:46] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'db_admin'@'db_url' for table 'flarum.mf_posts' in /var/www/weburl/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /var/www/bbs.ausmis.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#5 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#8 /var/www/bbs.ausmis.com/vendor/flarum/mentions/migrations/2022_10_21_000000_create_post_mentions_group_table.php(23): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#11 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(213): Flarum\Database\Migrator->runClosureMigration()
#12 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(127): Flarum\Database\Migrator->resolveAndRunClosureMigration()
#13 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(113): Flarum\Database\Migrator->runUp()
#14 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#15 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#16 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Extension/ExtensionManager.php(329): Flarum\Extension\Extension->migrate()
#17 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Console/MigrateCommand.php(86): Flarum\Extension\ExtensionManager->migrate()
#18 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Console/MigrateCommand.php(63): Flarum\Database\Console\MigrateCommand->upgrade()
#19 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Console/AbstractCommand.php(37): Flarum\Database\Console\MigrateCommand->fire()
#20 /var/www/bbs.ausmis.com/vendor/symfony/console/Command/Command.php(298): Flarum\Console\AbstractCommand->execute()
#21 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(1058): Symfony\Component\Console\Command\Command->run()
#22 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#23 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#24 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#25 /var/www/bbs.ausmis.com/flarum(24): Flarum\Console\Server->listen()
#26 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'db_admin'@'db_url' for table 'flarum.mf_posts' in /var/www/weburl/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/bbs.ausmis.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#5 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#7 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#8 /var/www/bbs.ausmis.com/vendor/flarum/mentions/migrations/2022_10_21_000000_create_post_mentions_group_table.php(23): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#11 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(213): Flarum\Database\Migrator->runClosureMigration()
#12 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(127): Flarum\Database\Migrator->resolveAndRunClosureMigration()
#13 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(113): Flarum\Database\Migrator->runUp()
#14 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#15 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#16 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Extension/ExtensionManager.php(329): Flarum\Extension\Extension->migrate()
#17 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Console/MigrateCommand.php(86): Flarum\Extension\ExtensionManager->migrate()
#18 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Console/MigrateCommand.php(63): Flarum\Database\Console\MigrateCommand->upgrade()
#19 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Console/AbstractCommand.php(37): Flarum\Database\Console\MigrateCommand->fire()
#20 /var/www/bbs.ausmis.com/vendor/symfony/console/Command/Command.php(298): Flarum\Console\AbstractCommand->execute()
#21 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(1058): Symfony\Component\Console\Command\Command->run()
#22 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#23 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#24 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#25 /var/www/bbs.ausmis.com/flarum(24): Flarum\Console\Server->listen()
#26 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'db_admin'@'db_url' for table 'flarum.mf_posts' (SQL: alter table `mf_post_mentions_group` add constraint `mf_post_mentions_group_post_id_foreign` foreign key (`post_id`) references `mf_posts` (`id`) on delete cascade) in /var/www/weburl/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/bbs.ausmis.com/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#2 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/bbs.ausmis.com/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#5 /var/www/bbs.ausmis.com/vendor/flarum/mentions/migrations/2022_10_21_000000_create_post_mentions_group_table.php(23): Illuminate\Database\Schema\Builder->create()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#8 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(213): Flarum\Database\Migrator->runClosureMigration()
#9 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(127): Flarum\Database\Migrator->resolveAndRunClosureMigration()
#10 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(113): Flarum\Database\Migrator->runUp()
#11 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#12 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#13 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Extension/ExtensionManager.php(329): Flarum\Extension\Extension->migrate()
#14 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Console/MigrateCommand.php(86): Flarum\Extension\ExtensionManager->migrate()
#15 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Database/Console/MigrateCommand.php(63): Flarum\Database\Console\MigrateCommand->upgrade()
#16 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Console/AbstractCommand.php(37): Flarum\Database\Console\MigrateCommand->fire()
#17 /var/www/bbs.ausmis.com/vendor/symfony/console/Command/Command.php(298): Flarum\Console\AbstractCommand->execute()
#18 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(1058): Symfony\Component\Console\Command\Command->run()
#19 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#20 /var/www/bbs.ausmis.com/vendor/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#21 /var/www/bbs.ausmis.com/vendor/flarum/core/src/Console/Server.php(42): Symfony\Component\Console\Application->run()
#22 /var/www/bbs.ausmis.com/flarum(24): Flarum\Console\Server->listen()
#23 {main}  

`

luceos

dust2k do you see the same error everytime you try to upgrade when you restored a backup of the database? It seems your hosting environment limits the capabilities of your database. Ask your provider why REFERENCES is disabled.

dust2k

luceos I installed database by myself, there is no provider except me, I am not sure why the REFERENCES has been disabled, can you help to point out where is the setting in database?

I've found the way to work around, I have used "composer remove flarum/mentions" to remove mentions and then migration is successful, my site is alright now, I guess I can reinstall mentions back now, right?

dust2k

dust2k I found the place to set permission on my database user, but still have error on using mentions extension, then I try to removed all mentions related tables, then remove mentions extension, reinstall it, everything works, thanks for your help.