stevemaury wrote:Code: Select all
UPDATE phpbb_users SET `user_email` = ' ' WHERE `username` = 'Anonymous';
Houston ... I think we still may have a problem ... after using above (except using 'guest' instead of 'Anonymous') the email address for the anonymous user was successfully blanked ... but ....
I tried to create a new user using <me>@<mydomain.com> ... same address that I had blanked out of the anonymous user ... and phpbb told me that it was already in use.
Subsequent search of all users using ACP revealed none that were using <me>@<mydomain.com> so I went for more power with phpMyadmin. A search of the entire DB for 'mydomain' yielded only two records in the phpbb_log in the log_data field. Only other thing I noticed was that the user_email_hash still has a non-zero value (as opposed to other records having user_email_hash=0 if email address is blank).
Seems like simply deleting the log records and/or zeroing the hash field would be benign things to do to try to fix the problem ... but I'd feel a whole lot better if someone with more experience in these things would pass judgement on that idea.