Problems after uninstalling extensions

vimo

The issue

I deleted 2 extensions that i don't use.
Now i have some errors when posting new messages;

New messages are posted 2 times now
I can't delete messages
New messages in a discussion are not marked anymore as "new", so in the discussionslist you can't see where a new messages posted.

Flarum information

Flarum core: 1.8.14
PHP version: CLI: 8.2.29, Web: 8.2.29
PHP memory limit: CLI: 2048M, Web: unable to detect
MySQL version: 10.6.20-MariaDB-cll-lve
Loaded extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, json, iconv, SPL, pcntl, random, readline, Reflection, session, standard, mbstring, shmop, SimpleXML, tokenizer, xml, litespeed, bcmath, dom, fileinfo, gd, intl, exif, mcrypt, PDO, mysqlnd, mysqli, pdo_mysql, pdo_sqlite, Phar, posix, soap, sockets, xmlreader, xmlwriter, xsl, zip
+------------------------------+----------+--------+-------+
| Flarum Extensions            |          |        |       |
+------------------------------+----------+--------+-------+
| ID                           | Version  | Commit | Notes |
+------------------------------+----------+--------+-------+
| flarum-tags                  | v1.8.6   |        |       |
| flarum-flags                 | v1.8.2   |        |       |
| flarum-suspend               | v1.8.5   |        |       |
| v17development-seo           | v2.0.9   |        |       |
| fof-pages                    | 1.0.8    |        |       |
| flarum-approval              | v1.8.2   |        |       |
| fof-user-bio                 | 1.4.3    |        |       |
| afrux-forum-widgets-core     | v0.1.7   |        |       |
| huseyinfiliz-show-password   | 1.0.0    |        |       |
| huseyinfiliz-bump            | 1.1.1    |        |       |
| huseyinfiliz-awards          | 1.1      |        |       |
| forumaker-magicbb            | 1.0.0    |        |       |
| fof-upload                   | 1.8.11   |        |       |
| fof-split                    | 1.1.1    |        |       |
| fof-sitemap                  | 2.5.0    |        |       |
| fof-polls                    | 2.3.1    |        |       |
| fof-nightmode                | 1.6.0    |        |       |
| fof-links                    | 1.4.0    |        |       |
| fof-gamification             | 1.6.12   |        |       |
| fof-formatting               | 1.1.2    |        |       |
| fof-filter                   | 1.2.2    |        |       |
| fof-discussion-views         | 1.0.0    |        |       |
| fof-direct-links             | 1.0.1    |        |       |
| fof-best-answer              | 1.7.1    |        |       |
| fof-badges                   | 1.0.5    |        |       |
| flarum-subscriptions         | v1.8.1   |        |       |
| flarum-sticky                | v1.8.2   |        |       |
| flarum-statistics            | v1.8.1   |        |       |
| flarum-mentions              | v1.8.5   |        |       |
| flarum-markdown              | v1.8.1   |        |       |
| flarum-lock                  | v1.8.2   |        |       |
| flarum-lang-english          | v1.8.0   |        |       |
| flarum-lang-dutch            | v1.4.1   |        |       |
| flarum-extension-manager     | v1.0.7   |        |       |
| flarum-emoji                 | v1.8.1   |        |       |
| flarum-bbcode                | v1.8.0   |        |       |
| datlechin-link-preview       | v1.6.1   |        |       |
| damonhu-biosignature         | 1.8.0.41 |        |       |
| clarkwinkelmann-mailing      | 1.1.0    |        |       |
| clarkwinkelmann-emojionearea | 1.1.1    |        |       |
| afrux-top-posters-widget     | v0.1.5   |        |       |
| afrux-online-users-widget    | v0.1.9   |        |       |
+------------------------------+----------+--------+-------+
Base URL: https://282-forum.be
Installation path: /home/vimo282/domains/282-forum.be/public_html
Queue driver: sync
Session driver: file
Scheduler status: Nooit uitvoeren
Mail driver: smtp
Debug mode: off

GreXXL

vimo what extensions did you delete? How did you delete them? Did you use composer remove? After removing did you runphp flarum migrate and php flarum cache:clear?

vimo

GreXXL I used the clean and uninstall button in the Flarum menu. After that i did a cache clear in the flarum dashboard.

Deleted extension: resofire/discussion-participants
It was already toggled off

More information about posting/deleting:

When i post a message it say "Oops! Something went wrong. Reload the page and try again."
But the message is posted.
Same error for deleting. Message is gone after refresh

huseyinfiliz

vimo Flarum logs file likely contains detailed information about the error. Could you share it?

vimo

Yes, but that's a big file. do i need to share it with a link?

I also deleted magicslider extension

huseyinfiliz

vimo Sharing just the first 5 lines will be enough.

vimo

[2026-03-26 02:56:41] flarum.INFO: [FoF Sitemap] Generator.generate() started, deploy class: FoF\Sitemap\Deploy\Memory  
[2026-03-26 02:56:41] flarum.INFO: [FoF Sitemap] Generator resources count: 5  
[2026-03-26 06:28:02] flarum.ERROR: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 
'participant_count' in 'SET' in /home/vimo282/domains/282-forum.be/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82

huseyinfiliz

vimo It looks like the issue is caused by the participant_count column being missing from the discussions table.

From what I can tell, this column is added by the resofire/discussion-participants extension via a migration. However, when the extension is uninstalled, its down() migration removes the column again. If something else (or even Flarum itself, depending on your setup) still expects this column to exist, you’ll end up with the error you're seeing.

So your database is currently in an inconsistent state:

The code expects participant_count
But the column no longer exists

🔧 Temporary fix

You can manually recreate the column with this SQL:

ALTER TABLE discussions 
ADD COLUMN participant_count INT UNSIGNED NULL AFTER comment_count;

After that, clear the cache:

php flarum cache:clear

You should also report this issue in the extension’s discussion. An extension should not remove a column if it might still be used elsewhere, or at least should handle this more safely.

Also, while vibe coding are great, situations like this show why migrations need to be handled carefully, otherwise uninstalling something can unexpectedly break the database.

vimo

Thx, i gonna try this tonight. Hopefully this works.

vimo

I fixed the problem temporary by re-installing this extension again (but disabled).
I know what to do now.

Thank you guys.

Forogramero

vimo I had the same problem:

ALTER TABLE fg_discussions ADD participant_count INT(10) UNSIGNED DEFAULT

But I fixed it doing what huseyinfiliz recommended:

ALTER TABLE discussions
ADD COLUMN participant_count INT UNSIGNED NULL AFTER comment_count;

stryguardian

Sorry about that guys. My newness is showing right now, but I will be fixing it ASAP.