Tag extension

CalvaJoo

The extension tag is not working for me. When I try to enable it just disable suddenly without indicting any error or anything

I re install flarum and composer again both are working completely fine without any issues

I'm using non public path with 8.2 php version

Flarum core: 1.8.5
PHP version: 8.2.12
MySQL version: 8.2.0
Loaded extensions: Core, bcmath, calendar, ctype, date, filter, hash, iconv, json, SPL, pcre, random, readline, Reflection, session, standard, mysqlnd, tokenizer, zlib, libxml, dom, PDO, bz2, SimpleXML, xml, xmlreader, xmlwriter, openssl, curl, fileinfo, gd, gettext, mbstring, exif, mysqli, pdo_mysql, pdo_sqlite, Phar, ftp
+--------------------------+---------+------------------------------------------+
| Flarum Extensions        |         |                                          |
+--------------------------+---------+------------------------------------------+
| ID                       | Version | Commit                                   |
+--------------------------+---------+------------------------------------------+
| flarum-suspend           | v1.8.1  |                                          |
| flarum-subscriptions     | v1.8.0  |                                          |
| flarum-sticky            | v1.8.0  |                                          |
| flarum-statistics        | v1.8.0  |                                          |
| flarum-mentions          | v1.8.3  |                                          |
| flarum-markdown          | v1.8.0  |                                          |
| flarum-lock              | v1.8.0  |                                          |
| flarum-likes             | v1.8.0  |                                          |
| flarum-lang-arabic       | v0.2.1  | c66af6177ee06c45a6e635b5dbba9cbc0a6a0ed4 |
| flarum-flags             | v1.8.0  |                                          |
| flarum-extension-manager | v1.0.2  |                                          |
| flarum-emoji             | v1.8.0  |                                          |
| flarum-bbcode            | v1.8.0  |                                          |
+--------------------------+---------+------------------------------------------+
Base URL: http://localhost:800/flarum
Installation path: C:\xampp2\htdocs\flarum
Queue driver: sync
Session driver: file
Mail driver: mail
Debug mode: off

luceos

CalvaJoo usually this happens due to an error. Check the error log in storage/logs for more information or copy it here.

CalvaJoo

luceos #60 C:\xampp2\htdocs\flarum\vendor\laminas\laminas-stratigility\src\MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#61 C:\xampp2\htdocs\flarum\vendor\laminas\laminas-stratigility\src\MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
#62 C:\xampp2\htdocs\flarum\vendor\laminas\laminas-httphandlerrunner\src\RequestHandlerRunner.php(73): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
#63 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Http\Server.php(45): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#64 C:\xampp2\htdocs\flarum\index.php(26): Flarum\Http\Server->listen()
#65 {main}

luceos

CalvaJoo these are.lines 60-65 of one error trace. We will need the lines 0 to 25 at least and especially the one line above it.

CalvaJoo

luceos
Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1826 Duplicate foreign key constraint name 'tags_parent_id_foreign' (SQL: alter table tags add constraint tags_parent_id_foreign foreign key (parent_id) references tags (id) on delete set null) in C:\xampp2\htdocs\flarum\vendor\illuminate\database\Connection.php:712
Stack trace:
#0 C:\xampp2\htdocs\flarum\vendor\illuminate\database\Connection.php(672): Illuminate\Database\Connection->runQueryCallback('alter table ta...', Array, Object(Closure)) #1 C:\xampp2\htdocs\flarum\vendor\illuminate\database\Connection.php(490): Illuminate\Database\Connection->run('alter tableta...', Array, Object(Closure))
#2 C:\xampp2\htdocs\flarum\vendor\illuminate\database\Schema\Blueprint.php(109): Illuminate\Database\Connection->statement('alter table `ta...')
#3 C:\xampp2\htdocs\flarum\vendor\illuminate\database\Schema\Builder.php(364): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 C:\xampp2\htdocs\flarum\vendor\illuminate\database\Schema\Builder.php(211): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 C:\xampp2\htdocs\flarum\vendor\flarum\tags\migrations\2018_06_27_085300_change_tags_add_foreign_keys.php(31): Illuminate\Database\Schema\Builder->table('tags', Object(Closure))
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#7 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(194): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#8 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(213): Flarum\Database\Migrator->runClosureMigration(Array, 'up')
#9 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(127): Flarum\Database\Migrator->resolveAndRunClosureMigration('C:\xampp2\htdoc...', '2018_06_27_0853...')
#10 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(113): Flarum\Database\Migrator->runUp('C:\xampp2\htdoc...', '2018_06_27_0853...', Object(Flarum\Extension\Extension))
#11 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Database\Migrator.php(87): Flarum\Database\Migrator->runMigrationList('C:\xampp2\htdoc...', Array, Object(Flarum\Extension\Extension))
#12 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Extension\Extension.php(499): Flarum\Database\Migrator->run('C:\xampp2\htdoc...', Object(Flarum\Extension\Extension))
#13 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(337): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#14 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Extension\ExtensionManager.php(208): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#15 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Extension\Command\ToggleExtensionHandler.php(36): Flarum\Extension\ExtensionManager->enable('flarum-tags')
#16 C:\xampp2\htdocs\flarum\vendor\illuminate\bus\Dispatcher.php(122): Flarum\Extension\Command\ToggleExtensionHandler->handle(Object(Flarum\Extension\Command\ToggleExtension))
#17 C:\xampp2\htdocs\flarum\vendor\illuminate\pipeline\Pipeline.php(128): Illuminate\Bus\Dispatcher->Illuminate\Bus{closure}(Object(Flarum\Extension\Command\ToggleExtension))
#18 C:\xampp2\htdocs\flarum\vendor\illuminate\pipeline\Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline{closure}(Object(Flarum\Extension\Command\ToggleExtension))
#19 C:\xampp2\htdocs\flarum\vendor\illuminate\bus\Dispatcher.php(132): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#20 C:\xampp2\htdocs\flarum\vendor\illuminate\bus\Dispatcher.php(78): Illuminate\Bus\Dispatcher->dispatchNow(Object(Flarum\Extension\Command\ToggleExtension))
#21 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Api\Controller\UpdateExtensionController.php(42): Illuminate\Bus\Dispatcher->dispatch(Object(Flarum\Extension\Command\ToggleExtension))
#22 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Http\RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Laminas\Diactoros\ServerRequest))
#23 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Http\Middleware\ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http{closure}(Object(Laminas\Diactoros\ServerRequest), Array)
#24 C:\xampp2\htdocs\flarum\vendor\laminas\laminas-stratigility\src\Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Closure))
#25 C:\xampp2\htdocs\flarum\vendor\flarum\core\src\Api\Middleware\ThrottleApi.php(33): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))

CalvaJoo

After many tries I soled the issue
The problem was that a column called icons in the table tags is duplicated "it just initialized automatically i don't know why"

The solution:
run the following MySQL query in the created database

ALTER TABLE tags DROP COLUMN icon;