Batch change owner for multiple files

[briandirl]

Hi, am I right in saying only the owner of files can search for them and delete then I'm the upload section?

If this is the case I need to change the ownership of 100s of files to a new owner so that this new owner can delete as required. Files are in multiple sub categories also.

Is there a batch process for changing ownership?

Joomla: 3.5.1
Download: 3.0.6

Thanks in advance

[Jan]

Hi, the one who have delete rights can delete the file. Delete rights can be set for the category not for file, so only for category this needs to be changed.

Jan

[briandirl]

Hi Jan, thanks for the reply.
I must be doing something wrong so. Firstly our uploaders have only got access to the front end. upload and delete rights have been set on the categories for each uploader, all registered users have access rights. It however seems that only the uploader/owner of the file can search for and delete the required files on the front end.

Thanks again for your help.

[briandirl]

Can I just confirm that an uploader is unable to search for and delete a file on the frontend unless they are the owner of that file. As I said the uploaders have been give delete rights to the categories required.

[Jan]

Hi, yes, only if the uploader uploaded the file, he/she can delete it. (if he/she does not have delete rights, he/she is even not able to do even he/she uploaded the file)

Jan

[briandirl]

Thanks for the confirmation Jan.

Can I ask if an uploader is no longer with us, what is the best process to transfer the ownership of 100s of files to another uploader?

Thanks again for your help on this matter.

[Jan]

Hi, then you need to set it for every file in file edit. Or fastest way is to create sql query to change the "owner" or "uploaded by" column for all files at once.


Jan

[briandirl]

Thanks Jan, I'll see what I can do.

[briandirl]

The following worked a treat:

UPDATE my_site_db.jos_phocadownload
SET owner_id=' '
WHERE catid=' ';

[Jan]

Ok