Make Private Albums Public?

[dj83]

Hello,

I've removed the option for members to make their albums private. I need a way to make the albums that are marked private public. Is there a query that I can run?

please excuse my english

[ozzy47]

I just tested this and it works. (Add a table prefix, if needed). ACP --> Maintenance --> Execute SQL Query

UPDATE album SET state='public'

[dj83]

Once again thanks for all of the help :)

[ozzy47]

You need to set your user to be able to run queries in the includes/config.php file.

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';