How do I mass publish Images that are set as being unpublished yet the album they are in shows Published? do i have to edited individually or is there a mass publish tool?

admin -> albums -> choose an album -> click the tab "images"

On the right side of the page is a dropdown menu "Bulk actions"
Directly under the dropdown is a checkbox to select all images.

Check the checkbox and choose "Publish" from the dropdown menu.

And another one: Admin Overview page > Utilities > Publish content

I'm using the SVN version (1.4.2-BETA [8604]) and I cannot see this "publish content" link in the overview page. Any thought?

Sorry, in 1.4.2 we skipped that as we have the bulk actions. You can set a default publish status on Options > Gallery now.

humm, you guys should have made this change more obvious on the 1.4.2, cause now i've got a pretty large gallery filled with unpublished images (that for days now i thought were live on the site) and now when i want to publish them, its not so easy, especially with the removal of the "Admin Overview page > Utilities > Publish content", the only way it seems is to go through every album and publish it in batches, that's gonna take forever...

Something has gone awry with the upgrade on my system. Albums that are a year old, that I know were fully published at the time of upload, now contain unpublished images. I don't know how that happened. The albums themselves are all published.

I've got over 100 albums. Is there an SQL command that could publish every image for me?

You need to change the "show" field in the images or albums database table from 0 to 1.

Thanks acrylian, that worked for me.

For the sake of any others who have this problem, this is what I did this in the mysql command line client:

USE zenphoto_db;

UPDATE zp_images set `show`=1 WHERE `show`=0;

The only trouble I had is that 'show' is a reserved word. I guessed as much, but couldn't get regular quotes to work... it required the backticks.

Yes, back ticks is the only way to workaround this. "show" was there since forever (before I even got to ZP), changing this now will result in a lot of issues and compatibility issues we fear so we refuse doing it.