中文站点-网站精选 - How to change the author of 350 articles with one batch process

We have an employee who is no longer with our agency. This employee was an author of 350 articles in our install of Joomla 3.7.0. Is there a way in the Joomla Administrator to change the author of the articles to someone else with one batch process? Or does this have to be done using SQL at the database level?

Thanks,
Scott

Post by **imanickam** » Mon Jul 10, 2017 5:02 pm

You could do this using phpMyAdmin.

Try the following SQL:

Code: Select all

UPDATE jos_content SET created_by = YY WHERE created_by = XX;

where jos_ is the database/table prefix of your site, YY is the user id of the new author, and XX is the user_id of the old author.

Note:
Make a copy of the database content before attempting this

pintobuck · Post by **pintobuck** » Mon Jul 10, 2017 5:10 pm

Or if you do not feel comfortable with mysql language (sql novice here), you could try the free extension by RegularLabs called DB Replacer. It is very user friendly. Of course, back up you database before attempting any changes.

ssemegran · Post by **ssemegran** » Tue Jul 11, 2017 12:07 pm

Thanks! I'll do a test first with a select then perform your SQL.

Scott

LASTEST NEWS

《生死关》全集

精英主义

赌生盗,奸生杀

鲁道夫·威廉·路易斯·“鲁迪”·朱利安尼三世

中文站点-网站精选 - How to change the author of 350 articles with one batch process

How to change the author of 350 articles with one batch process

Information

Re: How to change the author of 350 articles with one batch process

Re: How to change the author of 350 articles with one batch process

Re: How to change the author of 350 articles with one batch process

最新网址

最受欢迎网址

高赞网址

特别推荐

推广联盟

推荐《互联技术》

推荐《少林功夫》

推荐《海之子》

注册会员

LASTEST NEWS

中文站点-网站精选 - How to change the author of 350 articles with one batch process

How to change the author of 350 articles with one batch process

Information