How do get a created by user in the files as batch task in order to make changes and delete? I am the only user. The jDownloads installation is a restore moved to a new template. All the created by user (only one - super user) is blank due to super user ID changes.
I could not find the solution to this issue with words being simple, the search created unrelated solutions.
Hi
Sorry but there is no batch or other 'quick' method of assigning a 'Created by User' as a regular tool or similar
Assume you are on jD 3.7.x If
Not then the insructions below are WRONG as the naming has changed from jD 3.2 series.
If you are a bit familiar with sql you can set up a query in phpMyAdmin similar to below
UPDATE `xxxx_jdownloads_files`
SET `created_by`=nnn
where the xxxx is the actual prefix and nnn is the actual super user id found from the Users. eg 215
Suggest you make a backup first just in case.
You need to select SQL then the Update button Also phpMyAdmin has a 'Simulate Query' option that will check your syntax.
Tried it AOK on one of my test sites.
Colin