Recent content by Xon

Yes that would be fine. You'll need to remove entries in xf_report and xf_report_comment table, and then rebuild the search index for reports and report comments to flush those out.

Xon updated Limit bots with a new update entry: 2.5.0 - Feature update Read the rest of this update entry...

Xon updated Search Improvements with a new update entry: 2.19.0 - Feature & bugfix update Read the rest of this update entry...

Xon updated Report Centre Essentials with a new update entry: 2.15.4 - Bugfix update Read the rest of this update entry...

Xon updated Content Ratings with a new update entry: 2.8.9 - Compatibility & Bugfix update Read the rest of this update entry...

This requires database queries (or code to manually poke the delete method on the entity) as the XF UI doesn't support deleting reports.

Check if you've got customizations to the svReportCentreEssentials_report_macros template and the template is out of date or has unmerged changes. The macro report_response exists in there in the default style.

It took about +40 seconds to manually prune the table in batches of 50k rows. Looking at the on-disk copy of the table shows why: $ du -hs --apparent-size /var/lib/mysql/sbforums/xf_search.ibd 14G /var/lib/mysql/sbforums/xf_search.ibd

Unbound deletes can run into the issue that MariaDB Galera Cluster have an effective maximum delete/write size. This is very relevant for the xf_search table which has very wide rows and modern crawlers hammer the site in unexpected ways. XF\Db\Exception: MySQL query error [1105]: Maximum...

This should actually be replicatable with stock XF behavior. XF has the option "Delete IP usage data after", which defaults to a year. This will leave a dangling xf_ip.ip_id reference on the xf_post/xf_thread tables. So if a moderator edits a thread title of an old enough thread this error...

Xon updated Thread SEO changes with a new update entry: 1.1.1 - Bugfix update Read the rest of this update entry...

Xon updated Thread SEO changes with a new update entry: 1.1.0 - Feature update Read the rest of this update entry...

Xon updated Alert Improvements by Xon with a new update entry: 2.14.4 - Bugfix update Read the rest of this update entry...

There is an "edit" link on a thread in the thread list. Clicking it shows the "edit thread" dialog; which includes a manual display order field when this add-on is installed.

Minimum supported php version for this add-on is php 7.2, as this add-on works for XF2.2. It is generally only my XF2.3 only add-ons which require php 8+