Adobe Forums: How to stop "re-publishing" of my modified photos to Flickr

Skip navigation

Adobe

Products

Creative Suite

Photoshop

Acrobat family

Flash Platform

Online Marketing Suite

Digital Enterprise Platform

Digital Publishing Suite

More products

Solutions Learning Help Downloads Company

Store

Adobe Store for home and home office

Education Store for students, educators, and staff

Business Store for small and medium businesses

Other ways to buy

Info Sign in

My cart My orders My Adobe

Up to Discussions in Photoshop Lightroom

1256 Views 13 Replies Latest reply: Nov 12, 2010 2:54 AM by Jasonized

Calculating status...

DhammikaHeenpella

20 posts since
Jan 19, 2010

Currently Being Moderated

Jul 9, 2010 12:33 AM

How to stop "re-publishing" of my modified photos to Flickr

I have uploaded some photos to Flickr through LR3 and later did some changes to some of those photos with in LR3. Now those I modified have been queued up again to be re-published to Flickr which I do not want to happen. I tried doing it by removing it off the "published" cluster. Then the photos I removed appeared in another cluster named "Photos to remove" and have been queued up to remove it from Flick completely - again which I don't want to do.

Can someone please explain how control this?

Thanks in advance.

Dhammika

Like (0)

Dorin Nicolaescu-Musteață
3,090 posts since
Apr 4, 2008

Currently Being Moderated

1. Jul 9, 2010 1:10 AM (in response to DhammikaHeenpella)
Re: How to stop "re-publishing" of my modified photos to Flickr

This is not possible.

Report Abuse

Like (0)
TK2142
371 posts since
Jan 20, 2010

Currently Being Moderated

2. Jul 9, 2010 1:37 AM (in response to Dorin Nicolaescu-Musteață)
Re: How to stop "re-publishing" of my modified photos to Flickr

dorin_nicolaescu wrote:

This is not possible.

I've modified the Flickr Publish Service (it is part of the SDK) and after this modification I can now choose to skip images when publishing. Skipping in my version moves them back into the "Published" state.

I'm puzzled why the original publish service didn't allows something like this right from the start.

Report Abuse

Like (0)
Dorin Nicolaescu-Musteață
3,090 posts since
Apr 4, 2008

Currently Being Moderated

3. Jul 9, 2010 1:43 AM (in response to TK2142)
Re: How to stop "re-publishing" of my modified photos to Flickr

Well, I went on and run an SQL query on the catalog (AgRemotePhoto.photoNeedsUpdating = 0) and that moved photos back to the "Published" group. But, such methods are not suitable for most users, I think...

Report Abuse

Like (0)
njl
39 posts since
May 21, 2006

Currently Being Moderated

4. Jul 9, 2010 2:01 AM (in response to DhammikaHeenpella)
Re: How to stop "re-publishing" of my modified photos to Flickr

There is no way to remove the images from the 'to be re-published' section, short of actually re-publishing them, but you can drag and drop the images from the 'for deletion' section back into 'published'.

There are a number of threads regarding this issue and we are hopeful that the problem will be addressed in the first update.

Regards,
Norman

Report Abuse

Like (0)
TK2142
371 posts since
Jan 20, 2010

Currently Being Moderated

5. Jul 9, 2010 4:44 AM (in response to Dorin Nicolaescu-Musteață)
Re: How to stop "re-publishing" of my modified photos to Flickr

dorin_nicolaescu wrote:

Well, I went on and run an SQL query on the catalog (AgRemotePhoto.photoNeedsUpdating = 0) and that moved photos back to the "Published" group. But, such methods are not suitable for most users, I think...
Dorin, I'd be indebted to you if you could let me know how you did that.
Did you write a plug-in that loops over the photos in the catalogue?

Where/How can I execute an SQL query that has the effect that you described?

It would be fantastic to be hearing from you.

Report Abuse

Like (0)
Dorin Nicolaescu-Musteață
3,090 posts since
Apr 4, 2008

Currently Being Moderated

6. Jul 9, 2010 4:59 AM (in response to TK2142)
Re: How to stop "re-publishing" of my modified photos to Flickr

I use SQLiteSpy to open the catalog on Windows. On Macs, there are built-in tools, as far as I know.

This will set all photos as published:

update AgRemotePhoto set photoNeedsUpdating = 0

This will set photo identified by its Flickr url as published:
update AgRemotePhoto set photoNeedsUpdating = 0 where url = '<url>'

Report Abuse

Like (0)
TK2142
371 posts since
Jan 20, 2010

Currently Being Moderated

7. Jul 9, 2010 5:11 AM (in response to Dorin Nicolaescu-Musteață)
Re: How to stop "re-publishing" of my modified photos to Flickr

Dorin, that's awesome!

I'm assuming you can just open the LR catalogue with out providing a database schema?

To everyone reading this, please be very cautios to what you do to your catalogue. It is easy to corrupt it and make it (partially) unusable.

Report Abuse

Like (0)
Dorin Nicolaescu-Musteață
3,090 posts since
Apr 4, 2008

Currently Being Moderated

8. Jul 9, 2010 5:15 AM (in response to TK2142)
Re: How to stop "re-publishing" of my modified photos to Flickr

I'm assuming you can just open the LR catalogue with out providing a database schema?

There's only one schema in there. SQLiteSpy just show everything that's in the database.

Report Abuse

Like (0)
TK2142
371 posts since
Jan 20, 2010

Currently Being Moderated

9. Jul 9, 2010 8:51 PM (in response to Dorin Nicolaescu-Musteață)
Re: How to stop "re-publishing" of my modified photos to Flickr

Dorin, I just got round to trying your workaround and it worked a treat.

Thanks ever so much for sharing this!

Much appreciated, indeed.

Report Abuse

Like (0)
franckpaul
4 posts since
Aug 22, 2010

Currently Being Moderated

10. Aug 22, 2010 11:30 PM (in response to Dorin Nicolaescu-Musteață)
Re: How to stop "re-publishing" of my modified photos to Flickr

Thank you for your instructions, it works as a charm :-)

I wrote some instructions for Mac users, here (but in french) : http://open-time.net/post/2010/08/23/Lightroom-3-et-les-services-de-pu blication

Report Abuse

Like (0)
franckpaul
4 posts since
Aug 22, 2010

Currently Being Moderated

11. Aug 22, 2010 11:54 PM (in response to Dorin Nicolaescu-Musteață)
Re: How to stop "re-publishing" of my modified photos to Flickr

Oups double post

Message was edited by: franckpaul

Report Abuse

Like (0)
Calculating status...
lsseppal
3 posts since
Oct 28, 2009

Currently Being Moderated

12. Nov 10, 2010 11:49 PM (in response to DhammikaHeenpella)
Re: How to stop "re-publishing" of my modified photos to Flickr

Removing or replacing the keywords on photos stuck in Modified Photos Re-Publish pool and then re-publishing the photos seems to move them to Published Photos.

Just cut and paste the keywords back and re-publish. If the photo did not have any keywords, then add some. This worked for me.

Report Abuse

Like (0)
Jasonized
614 posts since
Jul 11, 2010

Currently Being Moderated

13. Nov 12, 2010 2:54 AM (in response to TK2142)
Re: How to stop "re-publishing" of my modified photos to Flickr

Hey TK2142,

Could you make the changes you made available?

Cheers!

Report Abuse

Like (0)