change the author for all blogs with an SQL Query
By Tom on Wednesday, 05 December 2018
Posted in General Issues
Replies 6
Likes 0
Views 508
Votes 0
Using PHP MySQL how do I change the author for all blogs with an SQL Query?

I want to change all of the Guest entries to one of the Joomla users.

Thanks
Hi Tom,

Unfortunately, using SQL to change the author is not recommended as it involves a few tables and you would also need to change the data on some huge, compressed data blocks in some tables.

Would it be better for you to change the author in the backend post listing? http://take.ms/qzi0C

You should be able to filter those posts which are created by 'Guest' on the listing.
Raymond
·
Wednesday, 05 December 2018 11:14
·
0 Likes
·
0 Votes
·
0 Comments
·
I didn't know that menu item existed... Thanks, it does what I needed to do.
Tom
·
Wednesday, 05 December 2018 18:08
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome Tom. Glad to know that the backend method works for you.

Regards.
Raymond
·
Wednesday, 05 December 2018 18:13
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post