search

FriendsOfFlarum / webhooks

Flarum with outgoing webhooks
MIT License
21 stars 12 forks source link

Extension cannot be activated #38

Closed DursunCanPoyraz closed 2 years ago

DursunCanPoyraz commented 3 years ago

Bug Report

Current Behavior

Extension cannot be activated.

Screenshots image

Environment

Flarum core 1.0.2
PHP version: 7.4.12
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, mbstring, tokenizer, xml, i360, bcmath, dom, fileinfo, gd, imagick, imap, intl, json, exif, mysqli, mysqlnd, PDFlib, PDO, pdo_mysql, pdo_sqlite, Phar, posix, soap, sockets, sqlite3, tidy, xmlreader, xmlrpc, xmlwriter, xsl, zip, ionCube Loader, Zend OPcache
+-------------------------------+--------------+--------+
| Flarum Extensions             |              |        |
+-------------------------------+--------------+--------+
| ID                            | Version      | Commit |
+-------------------------------+--------------+--------+
| flarum-suspend                | v1.0.0       |        |
| flarum-subscriptions          | v1.0.0       |        |
| flarum-tags                   | v1.0.2       |        |
| flarum-flags                  | v1.0.0       |        |
| flarum-markdown               | v1.0.1       |        |
| flarum-likes                  | v1.0.0       |        |
| fof-user-directory            | 1.0.1        |        |
| fof-follow-tags               | 1.0.0        |        |
| flarum-sticky                 | v1.0.0       |        |
| flarum-lock                   | v1.0.0       |        |
| flarum-approval               | v1.0.0       |        |
| fof-geoip                     | 1.0.0        |        |
| clarkwinkelmann-group-list    | 1.0.0        |        |
| fof-terms                     | 1.0.0        |        |
| flarum-lang-turkish           | 1.0.2.3      |        |
| askvortsov-pwa                | v3.0.3       |        |
| therealsujitk-gifs            | v4.0.0       |        |
| malago-ads                    | 0.3.1        |        |
| justoverclock-hashtag         | 0.1.9        |        |
| phenomlab-scrolltotop         | 0.1.6        |        |
| nearata-no-self-likes         | v1.2.0       |        |
| fof-subscribed                | 1.0.0        |        |
| fof-default-user-preferences  | 1.0.0        |        |
| zerosonesfun-direct-links     | 2.1          |        |
| noriods-auto-more             | v1.0.0       |        |
| flarum-bbcode                 | v1.0.0       |        |
| fof-best-answer               | 1.0.1        |        |
| fof-profile-image-crop        | 1.0.0        |        |
| fof-share-social              | 1.0.0        |        |
| fof-username-request          | 1.0.0        |        |
| v17development-seo            | v1.8.0       |        |
| fof-linguist                  | 1.0.0        |        |
| migratetoflarum-canonical     | 1.0.0        |        |
| flarum-statistics             | v1.0.0       |        |
| flarum-mentions               | v1.0.0       |        |
| flarum-lang-english           | v1.0.0       |        |
| flarum-emoji                  | v1.0.0       |        |
| fof-user-bio                  | 1.0.0        |        |
| askvortsov-categories         | v3.0.0       |        |
| glowingblue-password-strength | 3.0.0        |        |
| fof-formatting                | 1.0.0        |        |
| ianm-follow-users             | 1.0.0        |        |
| fof-split                     | 1.0.0        |        |
| fof-socialprofile             | 1.0.0        |        |
| fof-polls                     | 1.0.2        |        |
| phenomlab-fancybox-wrapper    | 0.8          |        |
| fof-discussion-thumbnail      | 1.0.0        |        |
| kilowhat-audit-free           | 1.4.0        |        |
| ianm-diff                     | 3.0.0        |        |
| clarkwinkelmann-emojionearea  | 1.0.0        |        |
| fof-moderator-notes           | 1.0.0        |        |
| fof-upload                    | 1.0.1        |        |
| askvortsov-moderator-warnings | v0.6.0       |        |
| sycho-profile-cover           | v1.3.0       |        |
| ianm-synopsis                 | 1.0.0        |        |
| fof-drafts                    | 1.0.0        |        |
| flarum-pusher                 | v1.0.0       |        |
| extiverse-mercury             | 0.1.2        |        |
| fof-byobu                     | 1.0.0-beta.6 |        |
| justoverclock-readmore        | 1.0.1        |        |
+-------------------------------+--------------+--------+
Base URL: https://sourceturk.org
Installation path: /home/oyundede/sourceturk.org
Debug mode: off
Next Illuminate\Database\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'tag_id' (SQL: alter table `webhooks` add `tag_id` int unsigned null) in /home/oyundede/sourceturk.org/vendor/illuminate/database/Connection.php:685
Stack trace:
#0 /home/oyundede/sourceturk.org/vendor/illuminate/database/Connection.php(645): Illuminate\Database\Connection->runQueryCallback('alter table `we...', Array, Object(Closure))
#1 /home/oyundede/sourceturk.org/vendor/illuminate/database/Connection.php(479): Illuminate\Database\Connection->run('alter table `we...', Array, Object(Closure))
#2 /home/oyundede/sourceturk.org/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('alter table `we...')
#3 /home/oyundede/sourceturk.org/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /home/oyundede/sourceturk.org/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /home/oyundede/sourceturk.org/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(24): Illuminate\Database\Schema\Builder->table('webhooks', Object(Closure))
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}(Object(Illuminate\Database\Schema\MySqlBuilder))
#7 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func(Object(Closure), Object(Illuminate\Database\Schema\MySqlBuilder))
#8 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration(Array)
#9 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp('/home/oyundede/...', '2020_12_27_add_...', Object(Flarum\Extension\Extension))
#10 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList('/home/oyundede/...', Array, Object(Flarum\Extension\Extension))
#11 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run('/home/oyundede/...', Object(Flarum\Extension\Extension))
#12 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate(Object(Flarum\Database\Migrator), 'up')
#13 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate(Object(Flarum\Extension\Extension))
#14 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable('fof-webhooks')
#15 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle(Object(Laminas\Diactoros\ServerRequest))
#16 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}(Object(Laminas\Diactoros\ServerRequest), Array)
#17 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Closure))
#18 /home/oyundede/sourceturk.org/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#19 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#20 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#21 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#22 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#23 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#24 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#25 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#26 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#27 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#28 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#29 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#30 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#31 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#32 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#33 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#34 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#35 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#36 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#37 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#38 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#39 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#40 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#41 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#42 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#43 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#44 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#45 /home/oyundede/sourceturk.org/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#46 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#47 /home/oyundede/sourceturk.org/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#48 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#49 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#50 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#51 /home/oyundede/sourceturk.org/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#52 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#53 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#54 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\Next))
#55 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle(Object(Laminas\Diactoros\ServerRequest))
#56 /home/oyundede/sourceturk.org/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process(Object(Laminas\Diactoros\ServerRequest), Object(Laminas\Stratigility\EmptyPipelineHandler))
#57 /home/oyundede/sourceturk.org/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle(Object(Laminas\Diactoros\ServerRequest))
#58 /home/oyundede/sourceturk.org/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#59 /home/oyundede/sourceturk.org/index.php(26): Flarum\Http\Server->listen()
#60 {main}
DursunCanPoyraz commented 3 years ago

Environment

# php flarum info
Flarum core 1.0.4
PHP version: 8.0.7
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, pcntl, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml, bcmath, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, gmp, iconv, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+---------------------------------+--------------+--------+
| Flarum Extensions               |              |        |
+---------------------------------+--------------+--------+
| ID                              | Version      | Commit |
+---------------------------------+--------------+--------+
| flarum-flags                    | v1.0.0       |        |
| flarum-suspend                  | v1.0.0       |        |
| flarum-subscriptions            | v1.0.0       |        |
| flarum-tags                     | v1.0.3       |        |
| flarum-approval                 | v1.0.0       |        |
| flarum-sticky                   | v1.0.0       |        |
| flarum-nicknames                | v1.0.0       |        |
| flarum-lock                     | v1.0.0       |        |
| fof-user-directory              | 1.0.2        |        |
| fof-follow-tags                 | 1.0.1        |        |
| flarum-likes                    | v1.0.0       |        |
| flarum-markdown                 | v1.0.1       |        |
| askvortsov-pwa                  | v3.0.3       |        |
| fof-pages                       | 1.0.1        |        |
| the-turk-diff                   | 1.1.0        |        |
| nearata-internal-links-noreload | v2.0.1       |        |
| justoverclock-contactme         | 0.2.0        |        |
| clarkwinkelmann-author-change   | 1.0.1        |        |
| fof-github-autolink             | 1.0.0        |        |
| fof-byobu                       | 1.0.0-beta.7 |        |
| extiverse-mercury               | 0.1.2        |        |
| flarum-pusher                   | v1.0.0       |        |
| fof-drafts                      | 1.0.1        |        |
| ianm-synopsis                   | 1.0.0        |        |
| sycho-profile-cover             | v1.3.0       |        |
| askvortsov-moderator-warnings   | v0.6.0       |        |
| fof-upload                      | 1.0.1        |        |
| fof-moderator-notes             | 1.0.0        |        |
| clarkwinkelmann-emojionearea    | 1.0.0        |        |
| kilowhat-audit-free             | 1.4.0        |        |
| fof-discussion-thumbnail        | 1.0.0        |        |
| phenomlab-fancybox-wrapper      | 0.8          |        |
| fof-polls                       | 1.0.3        |        |
| fof-socialprofile               | 1.0.0        |        |
| fof-split                       | 1.0.0        |        |
| ianm-follow-users               | 1.0.0        |        |
| fof-formatting                  | 1.0.0        |        |
| glowingblue-password-strength   | 3.0.0        |        |
| fof-user-bio                    | 1.0.0        |        |
| flarum-emoji                    | v1.0.0       |        |
| flarum-lang-english             | v1.0.0       |        |
| flarum-mentions                 | v1.0.0       |        |
| flarum-statistics               | v1.0.0       |        |
| migratetoflarum-canonical       | 1.0.0        |        |
| fof-linguist                    | 1.0.0        |        |
| v17development-seo              | v1.8.0       |        |
| fof-username-request            | 1.0.0        |        |
| fof-share-social                | 1.0.0        |        |
| fof-profile-image-crop          | 1.0.0        |        |
| fof-best-answer                 | 1.0.1        |        |
| flarum-bbcode                   | v1.0.0       |        |
| noriods-auto-more               | v1.0.0       |        |
| zerosonesfun-direct-links       | 2.1          |        |
| fof-default-user-preferences    | 1.0.0        |        |
| fof-subscribed                  | 1.0.0        |        |
| nearata-no-self-likes           | v1.2.0       |        |
| phenomlab-scrolltotop           | 0.1.6        |        |
| justoverclock-hashtag           | 0.1.9        |        |
| malago-ads                      | 0.3.1        |        |
| therealsujitk-gifs              | v4.0.0       |        |
| flarum-lang-turkish             | 1.0.4.2      |        |
| fof-terms                       | 1.0.0        |        |
| clarkwinkelmann-group-list      | 1.0.0        |        |
| fof-geoip                       | 1.0.0        |        |
| justoverclock-purify            | 0.1.5        |        |
| the-turk-pallet-theme           | 0.1.0-beta.4 |        |
| fof-sitemap                     | 1.0.0        |        |
| fof-links                       | 1.0.0        |        |
| jslirola-login2seeplus          | v0.2         |        |
+---------------------------------+--------------+--------+
Base URL: https://sourceturk.org
Installation path: /var/flarum2
Debug mode: off
Next Illuminate\Database\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'tag_id' (SQL: alter table `webhooks` add `tag_id` int unsigned null) in /var/flarum2/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/flarum2/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/flarum2/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#2 /var/flarum2/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#5 /var/flarum2/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(24): Illuminate\Database\Schema\Builder->table()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/flarum2/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#12 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/flarum2/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#15 /var/flarum2/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#16 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#17 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#18 /var/flarum2/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle()
#19 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process()
#20 /var/flarum2/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#21 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#22 /var/flarum2/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#23 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#24 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#25 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#26 /var/flarum2/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#27 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#28 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#29 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#30 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#31 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#32 /var/flarum2/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#33 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#34 /var/flarum2/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#35 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#36 /var/flarum2/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#37 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#38 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#39 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#40 /var/flarum2/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#41 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#42 /var/flarum2/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#43 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#44 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#45 /var/flarum2/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#46 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#47 /var/flarum2/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#48 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#49 /var/flarum2/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#50 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#51 /var/flarum2/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#52 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#53 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#54 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#55 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#56 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#57 /var/flarum2/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#58 /var/flarum2/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#59 /var/flarum2/index.php(26): Flarum\Http\Server->listen()
#60 {main}
dsevillamartin commented 3 years ago

Did you install reflar/webhooks first? This extension only creates the tag_id column once in a migration, the only reason that code would run twice is if it ran for reflar/webhooks and then fof/webhooks (reflar/webhooks receives same updates as fof/ because the repository was migrated, can't really disable that)

DursunCanPoyraz commented 3 years ago 
Next Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum2.webhooks' doesn't exist (SQL: alter table `webhooks` add `tag_id` int unsigned null) in /var/flarum2/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/flarum2/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/flarum2/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#2 /var/flarum2/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#5 /var/flarum2/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(24): Illuminate\Database\Schema\Builder->table()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/flarum2/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#12 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/flarum2/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#15 /var/flarum2/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#16 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#17 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#18 /var/flarum2/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle()
#19 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process()
#20 /var/flarum2/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#21 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#22 /var/flarum2/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#23 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#24 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#25 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#26 /var/flarum2/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#27 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#28 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#29 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#30 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#31 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#32 /var/flarum2/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#33 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#34 /var/flarum2/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#35 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#36 /var/flarum2/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#37 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#38 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#39 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#40 /var/flarum2/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#41 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#42 /var/flarum2/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#43 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#44 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#45 /var/flarum2/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#46 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#47 /var/flarum2/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#48 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#49 /var/flarum2/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#50 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#51 /var/flarum2/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#52 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#53 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#54 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#55 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#56 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#57 /var/flarum2/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#58 /var/flarum2/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#59 /var/flarum2/index.php(26): Flarum\Http\Server->listen()
#60 {main}
DursunCanPoyraz commented 3 years ago

I removed the extension. I deleted all database rows of the extension.

dsevillamartin commented 3 years ago

If you do that you also need to delete the rows in the migrations (extension = 'fof-webhoks') table to make sure the migrations run again with php flarum migrate.

DursunCanPoyraz commented 3 years ago

i did what you say about extension, but it says me foreign key error. how can i fix it?

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1005 Can't create table `flarum2`.`webhooks` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table `webhooks` add constraint `webhooks_tag_id_foreign` foreign key (`tag_id`) references `tags` (`id`) on delete set null) in /var/flarum2/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/flarum2/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/flarum2/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#2 /var/flarum2/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#5 /var/flarum2/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(24): Illuminate\Database\Schema\Builder->table()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/flarum2/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#12 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/flarum2/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#15 /var/flarum2/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#16 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#17 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#18 /var/flarum2/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle()
#19 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process()
#20 /var/flarum2/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#21 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#22 /var/flarum2/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#23 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#24 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#25 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#26 /var/flarum2/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#27 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#28 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#29 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#30 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#31 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#32 /var/flarum2/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#33 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#34 /var/flarum2/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#35 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#36 /var/flarum2/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#37 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#38 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#39 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#40 /var/flarum2/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#41 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#42 /var/flarum2/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#43 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#44 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#45 /var/flarum2/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#46 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#47 /var/flarum2/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#48 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#49 /var/flarum2/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#50 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#51 /var/flarum2/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#52 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#53 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#54 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#55 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#56 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#57 /var/flarum2/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#58 /var/flarum2/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#59 /var/flarum2/index.php(26): Flarum\Http\Server->listen()
#60 {main}
dsevillamartin commented 3 years ago

I'm.. not sure where all these issues are coming from to be honest. I can only think that you didn't fully remove everything from the ext - specifically, the foreign index. I don't know what else I can say.

image

DursunCanPoyraz commented 3 years ago

I'm.. not sure where all these issues are coming from to be honest. I can only think that you didn't fully remove everything from the ext - specifically, the foreign index. I don't know what else I can say.

image

I ran the following commands accordingly.

DROP TABLE `webhooks`;

DELETE FROM `migrations` WHERE extension = "fof-webhooks";

ALTER TABLE `tags` DROP FOREIGN KEY `webhooks_tag_id_foreign`;

php flarum migrate

Logs:

Next Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1005 Can't create table `flarum2`.`webhooks` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table `webhooks` add constraint `webhooks_tag_id_foreign` foreign key (`tag_id`) references `tags` (`id`) on delete set null) in /var/flarum2/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/flarum2/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/flarum2/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#2 /var/flarum2/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#5 /var/flarum2/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(24): Illuminate\Database\Schema\Builder->table()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/flarum2/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#12 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/flarum2/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#15 /var/flarum2/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#16 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#17 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#18 /var/flarum2/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle()
#19 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process()
#20 /var/flarum2/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#21 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#22 /var/flarum2/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#23 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#24 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#25 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#26 /var/flarum2/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#27 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#28 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#29 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#30 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#31 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#32 /var/flarum2/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#33 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#34 /var/flarum2/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#35 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#36 /var/flarum2/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#37 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#38 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#39 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#40 /var/flarum2/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#41 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#42 /var/flarum2/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#43 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#44 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#45 /var/flarum2/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#46 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#47 /var/flarum2/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#48 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#49 /var/flarum2/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#50 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#51 /var/flarum2/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#52 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#53 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#54 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#55 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#56 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#57 /var/flarum2/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#58 /var/flarum2/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#59 /var/flarum2/index.php(26): Flarum\Http\Server->listen()
#60 {main} 
sudo mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 51690
Server version: 10.3.29-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> USE flarum2;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [flarum2]> DROP TABLE `webhooks`;
Query OK, 0 rows affected (0.003 sec)

MariaDB [flarum2]> DELETE FROM `migrations` WHERE extension = "fof-webhooks";
Query OK, 3 rows affected (0.002 sec)

MariaDB [flarum2]> ALTER TABLE `tags` DROP FOREIGN KEY `webhooks_tag_id_foreign`;
Query OK, 14 rows affected (0.008 sec)             
Records: 14  Duplicates: 0  Warnings: 0

MariaDB [flarum2]> exit
Bye
root@dursun:~# cd /var/flarum2
root@dursun:/var/flarum2# php flarum migrate
Migrating Flarum...
Nothing to migrate.
Migrating extension: flarum-flags
Nothing to migrate.
Migrating extension: flarum-suspend
Nothing to migrate.
Migrating extension: flarum-subscriptions
Nothing to migrate.
Migrating extension: flarum-tags
Nothing to migrate.
Migrating extension: flarum-approval
Nothing to migrate.
Migrating extension: flarum-sticky
Nothing to migrate.
Migrating extension: flarum-nicknames
Nothing to migrate.
Migrating extension: flarum-lock
Nothing to migrate.
Migrating extension: fof-user-directory
Nothing to migrate.
Migrating extension: fof-follow-tags
Nothing to migrate.
Migrating extension: flarum-likes
Nothing to migrate.
Migrating extension: flarum-markdown
Nothing to migrate.
Migrating extension: askvortsov-pwa
Nothing to migrate.
Migrating extension: fof-pages
Nothing to migrate.
Migrating extension: the-turk-diff
Nothing to migrate.
Migrating extension: fof-byobu
Nothing to migrate.
Migrating extension: fof-drafts
Nothing to migrate.
Migrating extension: ianm-synopsis
Nothing to migrate.
Migrating extension: sycho-profile-cover
Nothing to migrate.
Migrating extension: askvortsov-moderator-warnings
Nothing to migrate.
Migrating extension: fof-upload
Nothing to migrate.
Migrating extension: fof-moderator-notes
Nothing to migrate.
Migrating extension: kilowhat-audit-free
Nothing to migrate.
Migrating extension: fof-polls
Nothing to migrate.
Migrating extension: fof-socialprofile
Nothing to migrate.
Migrating extension: ianm-follow-users
Nothing to migrate.
Migrating extension: glowingblue-password-strength
Nothing to migrate.
Migrating extension: fof-user-bio
Nothing to migrate.
Migrating extension: flarum-emoji
Nothing to migrate.
Migrating extension: flarum-mentions
Nothing to migrate.
Migrating extension: fof-linguist
Nothing to migrate.
Migrating extension: fof-username-request
Nothing to migrate.
Migrating extension: fof-share-social
Nothing to migrate.
Migrating extension: fof-best-answer
Nothing to migrate.
Migrating extension: fof-terms
Nothing to migrate.
Migrating extension: clarkwinkelmann-group-list
Nothing to migrate.
Migrating extension: fof-geoip
Nothing to migrate.
Migrating extension: fof-sitemap
Nothing to migrate.
Migrating extension: fof-links
Nothing to migrate.
Migrating extension: jslirola-login2seeplus
Nothing to migrate.
DONE.
dsevillamartin commented 3 years ago

Try with v1.0.3; I've removed the foreign key from the existing migration.

DursunCanPoyraz commented 3 years ago

Try with v1.0.3; I've removed the foreign key from the existing migration.

The extension is not working again. Below are 3 error outputs:

[2021-07-11 20:53:59] flarum.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'tag_id' in /var/flarum2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112
Stack trace:
#0 /var/flarum2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(112): PDOStatement->execute()
#1 /var/flarum2/vendor/illuminate/database/Connection.php(485): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/flarum2/vendor/illuminate/database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/flarum2/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#4 /var/flarum2/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#5 /var/flarum2/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#7 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#8 /var/flarum2/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(19): Illuminate\Database\Schema\Builder->table()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#11 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#12 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#13 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#14 /var/flarum2/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#15 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#16 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#17 /var/flarum2/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#18 /var/flarum2/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#19 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#20 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#21 /var/flarum2/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle()
#22 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process()
#23 /var/flarum2/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#24 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#25 /var/flarum2/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#26 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#27 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#28 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#29 /var/flarum2/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#30 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#31 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#32 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#33 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#34 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#35 /var/flarum2/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#36 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#37 /var/flarum2/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#38 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#39 /var/flarum2/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#40 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#41 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#42 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#43 /var/flarum2/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#44 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#45 /var/flarum2/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#46 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#47 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#48 /var/flarum2/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#49 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#50 /var/flarum2/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#51 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#52 /var/flarum2/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#53 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#54 /var/flarum2/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#55 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#56 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#57 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#58 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#59 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#60 /var/flarum2/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#61 /var/flarum2/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#62 /var/flarum2/index.php(26): Flarum\Http\Server->listen()
#63 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'tag_id' in /var/flarum2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/flarum2/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(114): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/flarum2/vendor/illuminate/database/Connection.php(485): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/flarum2/vendor/illuminate/database/Connection.php(685): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#3 /var/flarum2/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#4 /var/flarum2/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#5 /var/flarum2/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#6 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#7 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#8 /var/flarum2/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(19): Illuminate\Database\Schema\Builder->table()
#9 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#10 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#11 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#12 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#13 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#14 /var/flarum2/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#15 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#16 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#17 /var/flarum2/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#18 /var/flarum2/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#19 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#20 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#21 /var/flarum2/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle()
#22 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process()
#23 /var/flarum2/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#24 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#25 /var/flarum2/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#26 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#27 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#28 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#29 /var/flarum2/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#30 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#31 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#32 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#33 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#34 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#35 /var/flarum2/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#36 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#37 /var/flarum2/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#38 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#39 /var/flarum2/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#40 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#41 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#42 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#43 /var/flarum2/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#44 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#45 /var/flarum2/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#46 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#47 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#48 /var/flarum2/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#49 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#50 /var/flarum2/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#51 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#52 /var/flarum2/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#53 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#54 /var/flarum2/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#55 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#56 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#57 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#58 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#59 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#60 /var/flarum2/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#61 /var/flarum2/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#62 /var/flarum2/index.php(26): Flarum\Http\Server->listen()
#63 {main}

Next Illuminate\Database\QueryException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'tag_id' (SQL: alter table `webhooks` add `tag_id` int unsigned null) in /var/flarum2/vendor/illuminate/database/Connection.php:692
Stack trace:
#0 /var/flarum2/vendor/illuminate/database/Connection.php(652): Illuminate\Database\Connection->runQueryCallback()
#1 /var/flarum2/vendor/illuminate/database/Connection.php(486): Illuminate\Database\Connection->run()
#2 /var/flarum2/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement()
#3 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(365): Illuminate\Database\Schema\Blueprint->build()
#4 /var/flarum2/vendor/illuminate/database/Schema/Builder.php(212): Illuminate\Database\Schema\Builder->build()
#5 /var/flarum2/vendor/fof/webhooks/migrations/2020_12_27_add_tag_column.php(19): Illuminate\Database\Schema\Builder->table()
#6 [internal function]: Illuminate\Filesystem\Filesystem::{closure}()
#7 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(202): call_user_func()
#8 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(133): Flarum\Database\Migrator->runClosureMigration()
#9 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(116): Flarum\Database\Migrator->runUp()
#10 /var/flarum2/vendor/flarum/core/src/Database/Migrator.php(90): Flarum\Database\Migrator->runMigrationList()
#11 /var/flarum2/vendor/flarum/core/src/Extension/Extension.php(482): Flarum\Database\Migrator->run()
#12 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(311): Flarum\Extension\Extension->migrate()
#13 /var/flarum2/vendor/flarum/core/src/Extension/ExtensionManager.php(182): Flarum\Extension\ExtensionManager->migrate()
#14 /var/flarum2/vendor/flarum/core/src/Api/Controller/UpdateExtensionController.php(46): Flarum\Extension\ExtensionManager->enable()
#15 /var/flarum2/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\UpdateExtensionController->handle()
#16 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#17 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ExecuteRoute->process()
#18 /var/flarum2/vendor/kilowhat/flarum-ext-audit-free/src/Middlewares/SetLoggerActor.php(28): Laminas\Stratigility\Next->handle()
#19 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Kilowhat\Audit\Middlewares\SetLoggerActor->process()
#20 /var/flarum2/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#21 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\ThrottleApi->process()
#22 /var/flarum2/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(44): Laminas\Stratigility\Next->handle()
#23 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\CheckCsrfToken->process()
#24 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#25 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ResolveRoute->process()
#26 /var/flarum2/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#27 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\SetLocale->process()
#28 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(56): Laminas\Stratigility\Next->handle()
#29 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#30 /var/flarum2/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#31 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\AuthenticateWithSession->process()
#32 /var/flarum2/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#33 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\RememberFromCookie->process()
#34 /var/flarum2/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#35 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\StartSession->process()
#36 /var/flarum2/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#37 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Api\Middleware\FakeHttpMethods->process()
#38 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#39 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ParseJsonBody->process()
#40 /var/flarum2/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#41 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\HandleErrors->process()
#42 /var/flarum2/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#43 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\InjectActorReference->process()
#44 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#45 /var/flarum2/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#46 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\RequestHandler->process()
#47 /var/flarum2/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#48 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePathRouter->process()
#49 /var/flarum2/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(42): Laminas\Stratigility\Next->handle()
#50 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Laminas\Stratigility\Middleware\OriginalMessages->process()
#51 /var/flarum2/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#52 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Middlewares\BasePath->process()
#53 /var/flarum2/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#54 /var/flarum2/vendor/laminas/laminas-stratigility/src/Next.php(61): Flarum\Http\Middleware\ProcessIp->process()
#55 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(84): Laminas\Stratigility\Next->handle()
#56 /var/flarum2/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(73): Laminas\Stratigility\MiddlewarePipe->process()
#57 /var/flarum2/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#58 /var/flarum2/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#59 /var/flarum2/index.php(26): Flarum\Http\Server->listen()
#60 {main}
DursunCanPoyraz commented 3 years ago

I did a database cleanup again. The commands are in my previous post. I uninstalled the extension, reinstalled it. The extension is opened but there is an error.

EDIT 1:

Discussions do not appear on the homepage. No error log occurred.

image

dsevillamartin commented 3 years ago

This extension doesn't add anything to the frontend. So I don't know what could be causing that except perhaps a silenced error?

I released a few versions recently that improve error reporting/handling, not sure if you're already running them.

Besides, the issues you're facing seem to probably have been caused by something else, as I've never seen most of these and I don't think most other people have either.

dsevillamartin commented 2 years ago

Is this still an issue?