Flamarkt Taxonomies

MrEugene

Hi there,

Feel stupid but I'm stuck at part 2 for accessing Backoffice. I'm struggling some "route" problem.

On the classic admin panel I have
…/flarum/public/admin#/extension/flamarkt-backoffice

But for the "Settings in back office" button I have
…/backoffice/extension/flamarkt-backoffice

And a Not Found requested url message when I clic.

If I use my username > Backoffice shortcut, I have the Backoffice inferface (hooray!) but with same "route" problem, aka

…/backoffice/
…/backoffice/users
…/backoffice/taxonomies/discussions

[…]

And not …/flarum/public/…

Where Am I wrong? Some config file I forget? If someone could have a clue…

Thanks!

clarkwinkelmann

MrEugene is it supposed to work with subfolder installations but I don't think I tested it. It's possible there's a bug when using the extension with that configuration.

Before going further you should fix your public URL and update the value in config.php https://docs.flarum.org/install/#customizing-paths This might fix the issue.

Darkle

clarkwinkelmann The idea of making a page similar to how it works now for the tags but for the taxonomies would be really nice, since the other one with the filters sounds interesting but I'm not so sure how it would work having the featured articles, maybe it would be something more use case specific.

Out of curiosity how much work do you think it would take to make it similar to the tags page?

clarkwinkelmann

Version 0.1.9

Fix discussion composer breaking when FoF Drafts is enabled
Add integration with FoF Drafts to save selected taxonomies in discussion composer

shantur

@clarkwinkelmann : Thanks for this awesome plugin.
I am planning to use it inplace of Tags plugin as it allows users to create new.
My plan is to use Taxinomies - Category and Tags ( like HashTags )

I have a couple of questions

Is there any way I can get list of Categories on the left panel under All discussions to filter discussions for each Category - Like Tags ?
Is there anyway to get a page with all the values of a Taxinomy (for Tags in my case ) ?
Can one search for a Taxinomy in the search bar?

Thanks

clarkwinkelmann

shantur no, those features are not available at the moment. But I see no technical reasons that would prevent you from implementing such a feature using the Flarum extension API.

I am currently not adding any more feature to the extension due to my limited time but it could also be a sponsored feature in the future.

The only place end-users can see a list of the available taxonomy terms is if you enable the filter on the discussion list. Then the dropdown at the top of the discussion list will show all available taxonomies. It might not be a good idea for user-created taxonomies because the amount of data to load at once might be too big.

If you mean searching for discussions using keywords present in the taxonomy term names, this is supported if you use the Scout Search extension with any of its alternate search drivers https://discuss.flarum.org/d/30874-scout-search

Searching for terms to then select a term and see all discussions associated is not available at this time. If I remember correctly this feature however exists for users when the FoF User Directory extension is enabled, you can type a taxonomy term name in the user filter bar and then select the term to filter the list by.

jedafe

I have quick suggestions on the Discussion Taxonomy Term's Filter UI. I think it would be nice to enable search in the dropdown just like the one in the "Filter by Author" or "tag" extension.

Presently, it's very difficult to locate a term in the dropdown if there are lots of terms associated with a taxonomy.

MoshBit

@clarkwinkelmann I've followed the instructions for installing this extension, but when I click the 'activate' button for taxonomies, the toggle just turns back off with no error message.

im at a bit of a loss on what to do here.

clarkwinkelmann

MoshBit can you check the browser development tools for any error in the javascript console or the response in the network tab?

qianmoQ

Fixed

/app/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php

// modfiy
$table->primary(['discussion_id', 'term_id']);
// to
$table->primary(['discussion_id', 'term_id'], 'custom_primary_index');

Litalino

I reinstalled backoffice and taxonomies

Composer is displayed

"flamarkt/backoffice": "0.1.3",
"flamarkt/taxonomies": "0.1.9",

I enable backoffice. In the backoffice settings, I enable additional taxonomies and get an error

POST https://flarum.khatvongsong.vn/api/extensions/flamarkt-taxonomies 500 (Internal Server Error)
(anonymous) @ request.js:173
(anonymous) @ request.js:23
(anonymous) @ request.js:22
e.request @ Application.tsx:518
n.toggle @ ExtensionPage.tsx:228
n.onchange @ Checkbox.tsx:59
(anonymous) @ withAttr.ts:14
j.handleEvent @ render.js:888
flamarkt-taxonomies:1 


Uncaught (in promise) mr {status: 500, options: {…}, xhr: XMLHttpRequest, responseText: '{"errors":[{"status":"500","code":"unknown"}]}', response: {…}, …}alert: {type: 'error', content: Array(1), controls: false}options: {background: true, url: 'https://flarum.khatvongsong.vn/api/extensions/flamarkt-taxonomies', method: 'POST', body: {…}, deserialize: ƒ, …}response: {errors: Array(1)}responseText: "{\"errors\":[{\"status\":\"500\",\"code\":\"unknown\"}]}"status: 500xhr: XMLHttpRequest {readyState: 4, timeout: 0, withCredentials: false, abort: ƒ, onreadystatechange: ƒ, …}[[Prototype]]: Object
Promise.then (async)
n.toggle @ ExtensionPage.tsx:235
n.onchange @ Checkbox.tsx:59
(anonymous) @ withAttr.ts:14
j.handleEvent @ render.js:888

LOG:

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'kvs_flamarkt_discussion_taxonomy_term' already exists in /home/flarum.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/flarum.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#5 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#7 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#8 /home/flarum.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#11 /home/flarum.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#12 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#13 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#14 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#15 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#16 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#17 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#18 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#19 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#20 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#22 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#23 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#24 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#25 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#26 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#27 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Abstract/PurgeMiddleware.php(28): Laminas\Stratigility\Next->handle()
#28 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Abstract\PurgeMiddleware->process()
#29 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Abstract/PurgeMiddleware.php(28): Laminas\Stratigility\Next->handle()
#30 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Abstract\PurgeMiddleware->process()
#31 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Abstract/PurgeMiddleware.php(28): Laminas\Stratigility\Next->handle()
#32 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Abstract\PurgeMiddleware->process()
#33 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Middleware/LSTagsMiddleware.php(16): Laminas\Stratigility\Next->handle()
#34 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Middleware\LSTagsMiddleware->process()
#35 /home/flarum.khatvongsong.vn/public_html/vendor/fof/reactions/src/Middleware/BindRequestToContainer.php(35): Laminas\Stratigility\Next->handle()
#36 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\Reactions\Middleware\BindRequestToContainer->process()
#37 /home/flarum.khatvongsong.vn/public_html/vendor/malago/flarum-achievements/src/Middlewares/MiddlewarePosted.php(27): Laminas\Stratigility\Next->handle()
#38 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Malago\Achievements\Middlewares\MiddlewarePosted->process()
#39 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#40 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#41 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Middleware/LSCacheControlMiddleware.php(28): Laminas\Stratigility\Next->handle()
#42 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Middleware\LSCacheControlMiddleware->process()
#43 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Middleware/VaryCookieMiddleware.php(35): Laminas\Stratigility\Next->handle()
#44 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Middleware\VaryCookieMiddleware->process()
#45 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#46 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#47 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#48 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#49 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#50 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#51 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#52 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#53 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#54 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#55 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#56 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#57 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#58 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#59 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#60 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#61 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#62 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#63 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#64 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#65 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#66 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#67 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#68 /home/flarum.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#69 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#70 /home/flarum.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#71 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#72 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#73 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#74 /home/flarum.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#75 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#76 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#77 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#78 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#79 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#80 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#81 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#82 /home/flarum.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#83 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'flamarkt_discussion_taxonomy_term' already exists (SQL: create table `kvs_flamarkt_discussion_taxonomy_term` (`discussion_id` int unsigned not null, `term_id` int unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#2 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#4 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#5 /home/flarum.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#8 /home/flarum.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#9 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#10 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#11 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#12 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#13 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#14 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#15 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#16 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#17 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#19 /home/flarum.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#20 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#21 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#22 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#23 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#24 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Abstract/PurgeMiddleware.php(28): Laminas\Stratigility\Next->handle()
#25 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Abstract\PurgeMiddleware->process()
#26 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Abstract/PurgeMiddleware.php(28): Laminas\Stratigility\Next->handle()
#27 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Abstract\PurgeMiddleware->process()
#28 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Abstract/PurgeMiddleware.php(28): Laminas\Stratigility\Next->handle()
#29 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Abstract\PurgeMiddleware->process()
#30 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Middleware/LSTagsMiddleware.php(16): Laminas\Stratigility\Next->handle()
#31 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Middleware\LSTagsMiddleware->process()
#32 /home/flarum.khatvongsong.vn/public_html/vendor/fof/reactions/src/Middleware/BindRequestToContainer.php(35): Laminas\Stratigility\Next->handle()
#33 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): FoF\Reactions\Middleware\BindRequestToContainer->process()
#34 /home/flarum.khatvongsong.vn/public_html/vendor/malago/flarum-achievements/src/Middlewares/MiddlewarePosted.php(27): Laminas\Stratigility\Next->handle()
#35 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Malago\Achievements\Middlewares\MiddlewarePosted->process()
#36 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#37 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#38 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Middleware/LSCacheControlMiddleware.php(28): Laminas\Stratigility\Next->handle()
#39 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Middleware\LSCacheControlMiddleware->process()
#40 /home/flarum.khatvongsong.vn/public_html/vendor/acpl/flarum-lscache/src/Middleware/VaryCookieMiddleware.php(35): Laminas\Stratigility\Next->handle()
#41 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ACPL\FlarumCache\Middleware\VaryCookieMiddleware->process()
#42 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#43 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#44 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#45 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#46 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#47 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#48 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#49 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#50 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#51 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#52 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#53 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#54 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#55 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#56 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#57 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#58 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#59 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#60 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#61 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#62 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#63 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#64 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#65 /home/flarum.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#66 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#67 /home/flarum.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#68 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#69 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#70 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#71 /home/flarum.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#72 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#73 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#74 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#75 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#76 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#77 /home/flarum.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#78 /home/flarum.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#79 /home/flarum.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#80 {main}

clarkwinkelmann

Litalino if this is the first time you install Taxonomies (and therefore have not created or assigned any taxonomy in the past), you can safely delete the kvs_flamarkt_discussion_taxonomy_term table manually and the extension will be able to attempt the creation again.

Keep an eye on the logs next time you enable the extension, there might be a different error message. For the forum to have ended up in this state, there was likely an SQL error during the first time the table was created, maybe something to do with an index not being able to be created.

Litalino

clarkwinkelmann

my delete the kvsflamarkt_discussion_taxonomy_term

Still getting the above error..

I click enable Taxonomies and then it goes back to disable and see the js error

TAX


       POST https://fla.khatvongsong.vn/api/extensions/flamarkt-taxonomies 500 (Internal Server Error) : request.js:173 
(anonymous) @ request.js:173
(anonymous) @ request.js:23
(anonymous) @ request.js:22
e.request @ Application.tsx:518
n.toggle @ ExtensionPage.tsx:228
n.onchange @ Checkbox.tsx:59
(anonymous) @ withAttr.ts:14
j.handleEvent @ render.js:888
flamarkt-taxonomies:1 Uncaught (in promise) mr {status: 500, options: {…}, xhr: XMLHttpRequest, responseText: '{"errors":[{"status":"500","code":"unknown"}]}', response: {…}, …}
Promise.then (async)
n.toggle @ ExtensionPage.tsx:235
n.onchange @ Checkbox.tsx:59
(anonymous) @ withAttr.ts:14
j.handleEvent @ render.js:888

[2023-10-23 00:59:41] flarum.ERROR: PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'kvsflamarkt_discussion_taxonomy_term' already exists in /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#5 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#7 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#8 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#11 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#12 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#13 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#14 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#15 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#16 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#17 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#18 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#19 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#20 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#22 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#23 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#24 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#25 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#26 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#27 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#28 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#29 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#30 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#31 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#32 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#33 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#34 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#35 /home/fla.khatvongsong.vn/public_html/vendor/clarkwinkelmann/flarum-ext-sudo-mode/src/Middleware/RetrieveSudoMiddleware.php(34): Laminas\Stratigility\Next->handle()
#36 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ClarkWinkelmann\SudoMode\Middleware\RetrieveSudoMiddleware->process()
#37 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#38 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#39 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#40 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#41 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#42 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#43 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#44 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#45 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#46 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#47 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#48 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#49 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#50 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#51 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#52 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#53 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#54 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#55 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#56 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#57 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#58 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#59 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#60 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#61 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#62 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#63 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#64 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#65 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#66 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#67 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#68 /home/fla.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#69 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'kvsflamarkt_discussion_taxonomy_term' already exists in /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#5 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#7 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#8 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#11 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#12 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#13 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#14 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#15 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#16 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#17 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#18 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#19 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#20 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#22 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#23 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#24 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#25 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#26 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#27 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#28 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#29 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#30 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#31 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#32 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#33 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#34 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#35 /home/fla.khatvongsong.vn/public_html/vendor/clarkwinkelmann/flarum-ext-sudo-mode/src/Middleware/RetrieveSudoMiddleware.php(34): Laminas\Stratigility\Next->handle()
#36 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ClarkWinkelmann\SudoMode\Middleware\RetrieveSudoMiddleware->process()
#37 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#38 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#39 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#40 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#41 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#42 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#43 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#44 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#45 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#46 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#47 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#48 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#49 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#50 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#51 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#52 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#53 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#54 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#55 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#56 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#57 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#58 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#59 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#60 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#61 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#62 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#63 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#64 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#65 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#66 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#67 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#68 /home/fla.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#69 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'kvsflamarkt_discussion_taxonomy_term' already exists (SQL: create table `kvsflamarkt_discussion_taxonomy_term` (`discussion_id` int unsigned not null, `term_id` int unsigned not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) in /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#2 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#4 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#5 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#8 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#9 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#10 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#11 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#12 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#13 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#14 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#15 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#16 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#17 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#19 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#20 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#21 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#22 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#23 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#24 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#25 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#26 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#27 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#28 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#29 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#30 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#31 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#32 /home/fla.khatvongsong.vn/public_html/vendor/clarkwinkelmann/flarum-ext-sudo-mode/src/Middleware/RetrieveSudoMiddleware.php(34): Laminas\Stratigility\Next->handle()
#33 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): ClarkWinkelmann\SudoMode\Middleware\RetrieveSudoMiddleware->process()
#34 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#35 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#36 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#37 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#38 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#39 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#40 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#41 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#42 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#43 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#44 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#45 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#46 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#47 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#48 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#49 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#50 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#51 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#52 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#53 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#54 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#55 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#56 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#57 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#58 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#59 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#60 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#61 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#62 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#63 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#64 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#65 /home/fla.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#66 {main}

Litalino

I reinstalled the brand new Flarum package:

Install 3 utility extensions

"composer requires flamarkt/backoffice"
"composer requires flamarkt/classification"
"composer requests clarkwinkelmann/flarum-ext-discussion-lists"

File composer.json

{
    "name": "flarum/flarum",
    "description": "Delightfully simple forum software.",
    "type": "project",
    "keywords": [
        "forum",
        "discussion"
    ],
    "homepage": "https://flarum.org/",
    "license": "MIT",
    "authors": [
        {
            "name": "Flarum",
            "email": "info@flarum.org",
            "homepage": "https://flarum.org/team"
        }
    ],
    "support": {
        "issues": "https://github.com/flarum/core/issues",
        "source": "https://github.com/flarum/flarum",
        "docs": "https://docs.flarum.org/"
    },
    "require": {
        "clarkwinkelmann/flarum-ext-discussion-lists": "^1.0",
        "flamarkt/backoffice": "^0.1.3",
        "flamarkt/taxonomies": "^0.1.9",
        "flarum/approval": "*",
        "flarum/bbcode": "*",
        "flarum/core": "^1.8",
        "flarum/emoji": "*",
        "flarum/flags": "*",
        "flarum/lang-english": "*",
        "flarum/likes": "*",
        "flarum/lock": "*",
        "flarum/markdown": "*",
        "flarum/mentions": "*",
        "flarum/nicknames": "*",
        "flarum/pusher": "*",
        "flarum/statistics": "*",
        "flarum/sticky": "*",
        "flarum/subscriptions": "*",
        "flarum/suspend": "*",
        "flarum/tags": "*"
    },
    "config": {
        "preferred-install": "dist",
        "sort-packages": true
    }
}

error as above :: I removed kvs_flamarkt_discussion_taxonomy_term

Got the error again:

TAX-

[2023-10-23 01:32:43] flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'kvs_flamarkt_discussion_taxonomy_term_discussion_id_term_id_primary' is too long in /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute()
#1 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#5 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#7 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#8 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#11 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#12 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#13 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#14 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#15 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#16 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#17 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#18 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#19 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#20 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#22 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#23 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#24 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#25 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#26 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#27 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#28 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#29 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#30 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#31 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#32 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#33 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#34 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#35 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#36 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#37 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#38 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#39 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#40 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#41 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#42 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#43 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#44 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#45 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#46 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#47 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#48 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#49 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#50 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#51 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#52 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#53 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#54 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#55 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#56 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#57 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#58 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#59 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#60 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#61 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#62 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#63 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#64 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#65 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#66 /home/fla.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#67 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'kvs_flamarkt_discussion_taxonomy_term_discussion_id_term_id_primary' is too long in /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(501): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#4 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#5 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#7 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#8 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#11 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#12 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#13 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#14 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#15 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#16 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#17 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#18 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#19 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#20 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#21 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#22 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#23 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#24 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#25 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#26 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#27 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#28 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#29 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#30 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#31 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#32 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#33 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#34 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#35 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#36 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#37 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#38 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#39 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#40 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#41 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#42 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#43 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#44 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#45 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#46 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#47 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#48 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#49 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#50 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#51 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#52 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#53 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#54 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#55 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#56 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#57 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#58 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#59 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#60 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#61 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#62 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#63 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#64 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#65 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#66 /home/fla.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#67 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'kvs_flamarkt_discussion_taxonomy_term_discussion_id_term_id_primary' is too long (SQL: alter table `kvs_flamarkt_discussion_taxonomy_term` add primary key `kvs_flamarkt_discussion_taxonomy_term_discussion_id_term_id_primary`(`discussion_id`, `term_id`)) in /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback()
#1 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run()
#2 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build()
#4 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build()
#5 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/taxonomies/migrations/20210401_000200_create_discussion_term_table.php(26): Illuminate\Database\Schema\Builder->create()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(194): call_user_func()
#8 /home/fla.khatvongsong.vn/public_html/vendor/flamarkt/backoffice/src/Database/AugmentedMigrator.php(26): Flarum\Database\Migrator->runClosureMigration()
#9 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(113): Flamarkt\Backoffice\Database\AugmentedMigrator->runUp()
#10 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Database/Migrator.php(87): Flarum\Database\Migrator->runMigrationList()
#11 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Extension.php(499): Flarum\Database\Migrator->run()
#12 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(337): Flarum\Extension\Extension->migrate()
#13 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate()
#14 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Extension/Command/ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable()
#15 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle()
#16 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus\{closure}()
#17 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#18 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then()
#19 /home/fla.khatvongsong.vn/public_html/vendor/illuminate/bus/Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow()
#20 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(43): Illuminate\Bus\Dispatcher->dispatch()
#21 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#22 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#23 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#24 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#25 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#26 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#27 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#28 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(69): Laminas\Stratigility\Next->handle()
#29 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#30 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#31 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#32 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#33 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#34 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#35 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#36 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#37 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#38 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#39 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#40 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#41 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#42 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#43 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#44 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#45 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#46 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#47 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#48 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#49 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#50 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#51 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#52 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#53 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#54 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#55 /home/fla.khatvongsong.vn/public_html/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#56 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#57 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#58 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#59 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#60 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#61 /home/fla.khatvongsong.vn/public_html/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle()
#62 /home/fla.khatvongsong.vn/public_html/vendor/flarum/core/src/Http/Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#63 /home/fla.khatvongsong.vn/public_html/index.php(26): Flarum\Http\Server->listen()
#64 {main}

flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'kvs_flamarkt_discussion_taxonomy_term_discussion_id_term_id_primary' is too long in /home/fla.khatvongsong.vn/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117

According to the Mysql, character should be 64 or less than that.

clarkwinkelmann

Litalino it's this issue flamarkt/taxonomies10

Unfortunately I have not yet addressed it. I thought 4 letter table prefixes would have worked but I guess it's too long already 😬

No easy solution unfortunately, some manual renaming of indexes will be needed. If this is a brand new install you could install again without any prefix.

Litalino

clarkwinkelmann Due to prefix: i omitted kvs_ << everything is fine

Litalino

@clarkwinkelmann GOOD

Gerriet

Replace the extension the core extension ?

clarkwinkelmann

Gerriet I don't understand your question. This extension doesn't replace any other.

ernestdefoe

@clarkwinkelmann is there a way to only allow certain user groups to use a certain taxonomy?

clarkwinkelmann

ernestdefoe no, I believe the permissions are global.

But the feature could be created.

« Previous Page Next Page »