An error appears when trying to activate the achievements extension from the admin panel.

Flarum information

[2024-11-06 00:21:59] flarum.ERROR: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'achievements' already exists in /var/www/Hide/data/www/forumspace.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /var/www/Hide/data/www/forumspace.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `a...', Array)
#3 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('create table `a...', Array, Object(Closure))
#4 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/database/Connection.php(490): Illuminate\Database\Connection->run('create table `a...', Array, Object(Closure))
#5 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('create table `a...')
#6 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/database/Schema/Builder.php(223): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#8 /var/www/Hide/data/www/forumspace.ru/vendor/justoverclock/flachievements/migrations/2021_03_27_000000_add_achievements_table.php(8): Illuminate\Database\Schema\Builder->create('achievements', Object(Closure))
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#10 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#11 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Database/Migrator.php(213): Flarum\Database\Migrator->runClosureMigration(Array, 'up')
#12 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Database/Migrator.php(127): Flarum\Database\Migrator->resolveAndRunClosureMigration('/var/www/u27488...', '2021_03_27_0000...')
#13 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Database/Migrator.php(113): Flarum\Database\Migrator->runUp('/var/www/u27488...', '2021_03_27_0000...', Object(Flarum\Extension\Extension))
#14 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList('/var/www/u27488...', Array, Object(Flarum\Extension\Extension))
#15 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run('/var/www/u27488...', Object(Flarum\Extension\Extension))
#16 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#17 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#18 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable('justoverclock-f...')
#19 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle(Object(Flarum\Extension\Command\ToggleExtension))
#20 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}(Object(Flarum\Extension\Command\ToggleExtension))
#21 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Flarum\Extension\Command\ToggleExtension))
#22 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#23 /var/www/Hide/data/www/forumspace.ru/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow(Object(Flarum\Extension\Command\ToggleExtension))
#24 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(42): Illuminate\Bus\Dispatcher->dispatch(Object(Flarum\Extension\Command\ToggleExtension))
#25 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Laminas\Diactoros\ServerRequest))
#26 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Laminas\Diactoros\ServerRequest), Array)
#27 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ExecuteRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Closure))
#28 /var/www/Hide/data/www/forumspace.ru/vendor/fof/reactions/src/Middleware/BindRequestToContainer.php(35): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#29 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): FoF\Reactions\Middleware\BindRequestToContainer->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#30 /var/www/Hide/data/www/forumspace.ru/vendor/foskym/flarum-sorts-for-user-directory/src/Middleware/AfterMiddleware.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#31 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): FoskyM\SortsForUserDirectory\Middleware\AfterMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#32 /var/www/Hide/data/www/forumspace.ru/vendor/foskym/flarum-sorts-for-user-directory/src/Middleware/BeforeMiddleware.php(48): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#33 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): FoskyM\SortsForUserDirectory\Middleware\BeforeMiddleware->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#34 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#35 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Api\Middleware\ThrottleApi->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#36 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#37 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#38 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#39 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ResolveRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#40 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#41 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\SetLocale->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#42 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#43 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#44 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#45 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#46 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#47 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\RememberFromCookie->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#48 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#49 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\StartSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#50 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#51 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#52 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#53 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ParseJsonBody->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#54 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#55 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\HandleErrors->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#56 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#57 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\InjectActorReference->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#58 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#59 /var/www/Hide/data/www/forumspace.ru/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#60 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\RequestHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#61 /var/www/Hide/data/www/forumspace.ru/vendor/middlewares/base-path-router/src/BasePathRouter.php(99): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#62 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePathRouter->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#63 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#64 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Laminas\Stratigility\Middleware\OriginalMessages->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#65 /var/www/Hide/data/www/forumspace.ru/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#66 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Middlewares\BasePath->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#67 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#68 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/Next.php(52): Flarum\Http\Middleware\ProcessIp->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#69 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(77): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#70 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(66): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
#71 /var/www/Hide/data/www/forumspace.ru/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
#72 /var/www/Hide/data/www/forumspace.ru/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#73 /var/www/Hide/data/www/forumspace.ru/index.php(28): Flarum\Http\Server->listen()
#74 {main}

What did I do and it didn't help

SHOW TABLES LIKE 'achievements';
DROP TABLE achievements;
DELETE FROM migrations WHERE migration LIKE '%add_achievements_table%';
php flarum cache:clear

When you try to activate the plugin, the table appears again, and the plugin swears at it