Support

Admin Tools

#9833 SA email adress changes, undesirable results

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Wednesday, 13 April 2011 04:34 CDT

user13224
Hi Nicholas,

First up, this is not a fault of Admin Tools but there is a clear issue for users of K2 when changing the SA ID. It tripped me up, and I have seen it also trip up a number of other seasoned Joomla users, so I wanted to make you aware of it (just in case you are not already).

As the default behaviour of K2 is to display the authors email address along with every post, any posts created by the original SA will (after using AT to change SA ID) display the randomised and email address of the blocked user ID 62.

Of course, I would like all old posts (made by the SA) to display the correct email address. I know that opening and then saving the old K2 items will assign the correct user again, but that is not ideal on large sites.

Would it be possible to use a replace operation on the K2 author db field after SA ID is changed?

Thanks for your consideration and for providing such a kick-ass tool.

Regards,


Seth
@nternetinspired

nicholas
Akeeba Staff
Manager
You are right! I always disable the display of the email address for spam reasons. That said, if you wish to fix this very easily you can do a mass search-and-replace in the K2 tables using a simple update SQL command, changing the owner of the affected items to the new user ID.

Another trick is to use phpMyAdmin to change the email of the old SA user back to its original setting. You can't do that from within Joomla! because it will detect that another user is using the same email address and will throw an error, not applying the change.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user13224
Whoah!

Thanks for the lightning fast response!

Yes, I am aware of those options for fixes, but I am not sure that all users are confident about making such changes.

That is why I was hoping you might consider either:

1) Making it crystal clear to the k2 user that this will happen (i.e. not just in the docs, as they don't get read ;) but within AT itself), or;

2) Automating the search-and-replace operation, post ID change.

Just my $0.02

nicholas
Akeeba Staff
Manager
There is a reason why I am not implementing this kind of features in my software - even though I am frequently asked to do so. There are different exceptions and workarounds required for different versions of different extensions. If I add a workaround for K2, someone else will ask for a workaround for VirtueMart. As soon as I add that, someone will ask me for a workaround for another extension and so on. Soon enough I'll receive thousands of such requests. Just the thought of implementing and, more importantly, maintaining those workarounds is terrifying. It would require an army of full time developers. So, no, I'm not going to add such a feature ;)

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

user13224
Of course, you are right. I understand completely.

Thanks for taking the time to respond.

Keep up the good work!

:)

nicholas
Akeeba Staff
Manager
No problem! If you want more details about that, I guess we can discuss that over a beer at JaB11 in a couple of weeks :)

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!