Batch Article Edit

[gsmela]

This viewtopic.php?f=808&t=1013168&p=3734581 ... s#p3734581 today reminded me of the only thing I like about Wordpress.

When any user account is deleted in WP there is an option to assign all the postings from that user to another user. I couldn't find any extension for Joomla that does that. I've changed the assignment of many articles using phpmyadmin but it would be nice if there was an option under the Actions/Batch pull-down selection in Articles.

[pe7er]

With RO Users (paid extension) you can replace invalid user IDs in content and categories
(which fixes the error JUser: :_load: Unable to load user with ID)
https://extensions.joomla.org/extension/ro-users/

[Webdongle]

https://extensions.joomla.org/extension/db-replacer/ is free
Backup your database first

[toivo]

Here is an example how to replace missing author ids in bulk by running a SQL script in phpMyAdmin.

The first statement sets the user id of the new author. The CREATE statement creates a temporary table. The subsequent query finds all the articles where the author details cannot be found and adds the article ids to a temporary table, which is then accessed to update those articles with the new author.

The same pattern can be used to update the column 'modified_by'. Replace 'ep28r' with your own table prefix.

Code: Select all

SET @author = 123;
DROP TEMPORARY TABLE IF EXISTS deleted_users;
CREATE TEMPORARY TABLE deleted_users (
`id` int(10) unsigned NOT NULL, PRIMARY KEY (`id`)
)
SELECT c.id FROM ep28r_content c
LEFT JOIN ep28r_users u ON c.created_by = u.id
WHERE u.id IS NULL;
UPDATE ep28r_content c SET c.created_by = @author
WHERE c.id IN(SELECT d.id FROM deleted_users d);

[gsmela]

Thank you all for those suggestions! I’ll put them in my toolbox. I haven’t needed to do this very often and I’ve just muddled through phpmyadmin when I’ve needed it. This is a big help!