Mass change of author

Rooney
Topic Author
Offline
Moderator

12 years 1 week ago #37481 by Rooney

Mass change of author was created by Rooney

Hi,
is it possible to quickly change the author for lots of articles? Migrating to Joomla 2.5 I have deleted the standard Super Admin 62 because of security reasons and now I am getting error messages all the time.
Rooney

Joomla! 3.9.24 and FC 3.3.9

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

12 years 1 week ago #37496 by micker

Replied by micker on topic Mass change of author

maybe by an SQL request

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 1 week ago #37513 by ggppdk

Replied by ggppdk on topic Mass change of author

Hello,
this works exactly like joomla:

In phpmyadmin, try

UPDATE jos_content
SET created_by = new_user_id
WHERE created_by = old_user_id

in above SQL statement replace: new_user_id, old_user_id with ids of new and old owner

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

Rooney
Topic Author
Offline
Moderator

12 years 1 week ago #37587 by Rooney

Replied by Rooney on topic Mass change of author

ggppdk wrote: Hello,
this works exactly like joomla:

In phpmyadmin, try

UPDATE jos_content
SET created_by = new_user_id
WHERE created_by = old_user_id

in above SQL statement replace: new_user_id, old_user_id with ids of new and old owner

Thanks! Sometimes things are to easy to see...
Rooney

Joomla! 3.9.24 and FC 3.3.9

Please Log in or Create an account to join the conversation.