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';