How's this? > SELECT Cast(user_name AS CHAR), Cast(User_Email AS CHAR) FROM user where > user_name = 'Kg4wsv'; +-------------------------+--------------------------+ | Cast(user_name AS CHAR) | Cast(User_Email AS CHAR) | +-------------------------+--------------------------+ | Kg4wsv | | +-------------------------+--------------------------+ 1 row in set (0.00 sec)
> UPDATE user SET user_email='CHANGED TO PROTECT FROM SPAM' WHERE user_name = > 'Kg4wsv'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 > SELECT Cast(user_name AS CHAR), Cast(User_Email AS CHAR) FROM user where > user_name = 'Kg4wsv'; +-------------------------+--------------------------+ | Cast(user_name AS CHAR) | Cast(User_Email AS CHAR) | +-------------------------+--------------------------+ | Kg4wsv | CHANGED TO PROTECT FROM SPAM | +-------------------------+--------------------------+ 1 row in set (0.00 sec) Try it now Jason! On Mon, Jul 15, 2019 at 9:03 AM km5vy Tom Russo <[email protected]> wrote: > > On Mon, Jul 15, 2019 at 08:37:14AM -0700, we recorded a bogon-computron > collision of the <[email protected]> flavor, containing: > > Or delete the user and create a fresh account? > > There is apparently no longer a way to delete a user from the web interface > anymore, either: > https://www.mediawiki.org/wiki/Topic:Uufq7bc2yldm78jq > > The recommended method of faking it, "merging a user to an anonymous account", > can only be done with an extension that does not appear to be installed > on this instance of the wiki. > > > On Mon, Jul 15, 2019 at 8:30 AM Tom Russo <[email protected]> wrote: > > > > > > It appears that there is no way to change a users' email address from the > > > MediaWiki web interface (at least in the version that's installed on > > > xastir.org). It has to be done externally to the web, on the command > > > line. > > > That means Curt will have to take care of it. > > > > > > https://www.mediawiki.org/wiki/Manual:ResetUserEmail.php > > > > > > > > > On Mon, Jul 15, 2019 at 09:19:35AM -0600, we recorded a bogon-computron > > > collision of the <[email protected]> flavor, containing: > > > > On Mon, Jul 15, 2019 at 10:18:01AM -0500, we recorded a bogon-computron > > > > collision of the <[email protected]> flavor, containing: > > > > > On Mon, Jul 15, 2019 at 9:02 AM Tom Russo <[email protected]> wrote: > > > > > > > > > > > > > > > > According to the user list page on the wiki, you not only have an > > > > > > account > > > > > > on the wiki, but also edit permissions. > > > > > > > > > > > > > > > > In my (failed) search for my password, I stumbled across this gem > > > > > (from me, > > > > > circa 2009): > > > > > > > > > > I have a login (Kg4wsv), but apparently did not supply an email > > > > > > address (needed for the software to reset the password) and I don't > > > > > > remember the password. > > > > > > Is there a wiki admin who can reset my password, or stick my email > > > > > > address on the wiki account? > > > > > > > > > > > > > > > Is there a wiki admin that can help me out? > > > > > > > > Heh. I'll see what I can do. It is so infrequent that I use my mad > > > > admin > > > > skilz that I don't remember if there's an admin feature to edit a user > > > > account. If there is, I'll add the email address you're posting from > > > > now. > > > > > > > > -- > > > > Tom Russo KM5VY > > > > Tijeras, NM > > > > > > > > echo "prpv_a'rfg_cnf_har_cvcr" | sed -e 's/_/ /g' | tr [a-m][n-z] > > > > [n-z][a-m] > > > > > > -- > > > Tom Russo KM5VY > > > Tijeras, NM > > > > > > echo "prpv_a'rfg_cnf_har_cvcr" | sed -e 's/_/ /g' | tr [a-m][n-z] > > > [n-z][a-m] > > > > > > _______________________________________________ > > > Xastir mailing list > > > [email protected] > > > http://xastir.org/mailman/listinfo/xastir > > > > > > > > -- > > Curt, WE7U http://we7u.wetnet.net http://www.sarguydigital.com > > -- > Tom Russo KM5VY > Tijeras, NM > > echo "prpv_a'rfg_cnf_har_cvcr" | sed -e 's/_/ /g' | tr [a-m][n-z] [n-z][a-m] > -- Curt, WE7U http://we7u.wetnet.net http://www.sarguydigital.com _______________________________________________ Xastir mailing list [email protected] http://xastir.org/mailman/listinfo/xastir
