Bug Report

Current Behavior

Since this set of package updates was applied for our forum, marking users as spammers is no longer suspending them only removing their posts. It still properly marks their posts as deleted. Redoing it doesn't change anything and it's consistently not working rather than just sometimes not working. I don't see any relevant changes in this repository, so I'm confused about why this would be happening.

GrapheneOS/discuss.grapheneos.org@baa636e

Can anyone else replicate the problem? We're really unable to dedicate time to debugging this right now.

Steps to Reproduce

Mark a non-suspended user as a spammer with the extension.

Expected Behavior

Should suspend the user in addition to deleting posts. Happens with any browser and not caused by browser extensions.

Environment

Flarum core: 1.8.3
PHP version: 8.2.12
MySQL version: 11.1.2-MariaDB
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, ctype, dom, fileinfo, filter, hash, json, mbstring, pcntl, SPL, session, PDO, standard, posix, random, readline, Reflection, Phar, SimpleXML, tokenizer, xml, xmlreader, xmlwriter, mysqlnd, curl, gd, pdo_mysql, zip, Zend OPcache
+----------------------+---------+--------+
| Flarum Extensions    |         |        |
+----------------------+---------+--------+
| ID                   | Version | Commit |
+----------------------+---------+--------+
| flarum-flags         | v1.8.0  |        |
| flarum-suspend       | v1.8.1  |        |
| flarum-tags          | v1.8.0  |        |
| flarum-approval      | v1.8.0  |        |
| fof-user-bio         | 1.3.1   |        |
| fof-sitemap          | 2.2.1   |        |
| fof-nightmode        | 1.5.3   |        |
| fof-filter           | 1.1.3   |        |
| flarum-subscriptions | v1.8.0  |        |
| flarum-sticky        | v1.8.0  |        |
| flarum-statistics    | v1.8.0  |        |
| flarum-mentions      | v1.8.2  |        |
| flarum-markdown      | v1.8.0  |        |
| flarum-lock          | v1.8.0  |        |
| flarum-likes         | v1.8.0  |        |
| flarum-lang-english  | v1.8.0  |        |
+----------------------+---------+--------+
Base URL: https://discuss.grapheneos.org
Installation path: /opt/flarum
Queue driver: sync
Session driver: file
Scheduler status: Active
Mail driver: smtp
Debug mode: off

Additional Context

See GrapheneOS/discuss.grapheneos.org@baa636e for the set of updates which caused this. May help with figuring out the issue.

We generally need to think about who is allowed to mark who.

Feature Request

Currently this extension only suspending spammers and hiding their posts and discussions.
I noticed that spammers also set spam links in fof/socialprofile and fof/user-bio. It would be nice if this extension was compatible with other Friend Of Flarum extensions.

Additionally, it could remove the user avatar as well.

Via Discord

Marking a spammer could also remove any pending Flags on the spammer's posts (since they've now been taken care of permanently). Saves clicks.

Hi all,

Thanks for this promising extension!

However, upon clicking "Spammer" I am getting below error.

How can I further debug this?

Thanks for your help!

Hi, just leaving a quick bug report here, in case someone else has a similar problem.

When using the dotronglong/flarum-hide-me extension and spamblock at the same time, the site breaks in both front-end and back-end. I have left a bug report on hide-me also, for reference: dotronglong/flarum-hide-me#3

The error message (below) seems to be caused primarily by hide-me (though it works fine without spamblock enabled), so there must be some strange interaction between the two extensions.

Illuminate \ Database \ QueryException (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flaanonymous_group' doesn't exist (SQL: select flagroups.*, flaanonymous_group.anonymous_idaspivot_anonymous_id, flaanonymous_group.group_idaspivot_group_idfromflagroupsinner joinflaanonymous_grouponflagroups.id=flaanonymous_group.group_idwhereflaanonymous_group.anonymous_id = -1) Previous exceptions SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flaanonymous_group' doesn't exist (42S02) SQLSTATE[42S02]: Base table or view not found: 1146 Table 'flarum.flaanonymous_group' doesn't exist (42S02)