Co-authored-by: Claire <claire.github-309c@sitedethib.com>

* Apply Rubocop Rails/WhereNot

* Update spec for where.not

* Autofix Rails/EagerEvaluationLogMessage

* Update spec for debug block syntax

* Add tests

* Fix account activation being triggered before email confirmation

Fixes #23098

* Fix ・ detection in hashtag regex to construct hashtag correctly

* Fixed rubocop liniting issues

* More rubocop linting fix

* Add requested_by to relationship maps

* Display whether an account has requested to follow you on their profile

* Save avatar or header correctly if other one fails

* Fix test

* Fix 500 error when trying to migrate to an invalid address

* Add tests

* Don't allow URLs that contain non-normalized paths to be verified

This stops things like https://example.com/otheruser/../realuser where
"/otheruser" appears to be the verified URL, but the actual URL being
verified is "/realuser" due to the "/../".

Also fix a test to use 'https', so it is testing the right thing, now
that since #20304 https is required.

* missing do

Fix #19156

* Test blank account field verifiability

This change tests the need for #20428, which ensures that we guard against a situation in which `at_xpath` returns `nil`.

* Test verifiability of blank fields for remote account profiles

This adds a counterpart test for remote account profiles' fields' verifiability when those fields are blank. I previously added the same test for local accounts.

Fix #3833