LR Publish error after updating to 1.1

dchew · 2016-11-11 02:36:02

I use a theater splash page, ver 1.03. Just updated to Backlight 1.1, and now after publishing to the Home Splash Album, I get the following error. It seems to work fine on the website, but the error keeps coming up. Do I need to set something different in the breadcrumb instructions?

Dave

Here is the home page:
http://www.davechewphotography.com/TempBacklight/

Edit: I use GoDaddy...

Last edited by dchew (2016-11-11 02:54:24)

charlie.choc · 2016-11-11 02:40:23

I have the same problem.

rod barbee · 2016-11-11 02:58:18

did you update the LR Publisher plug-in as well?

dchew · 2016-11-11 02:59:11

Yes. I re-opened LR several times to make sure it took. I will try a restart...

Dave

charlie.choc · 2016-11-11 03:06:19

My plugin version is 3.0.5 and I have restarted LR multiple times.

dchew · 2016-11-11 03:07:22

Same error after restart. I just went to LR plugin manager, it says V3.0.5. Should I click reload plugin, or should I first save and send the Diagnostic Log?

Dave

dchew · 2016-11-11 03:10:39

Well I tried reloading the plugin, quit and restarted LR. Still the same error. I saved the error log but I think it is exactly like the screenshot just in a text file.

Dave

rod barbee · 2016-11-11 03:27:42

I just tried updating one of my own Theater slide show and got the same error, though the album was updated on the site and added images appear. This will be something for Ben to look at when he wakes up on the other side of the world

I'm not seeing the error in regular albums though. So far it's happening with Theater on a full screen Vegas slide show and a Flickity album.

Ben, just to be clear: new images are being added to both my Flickity and full-screen slideshows, despite that error appearing.

Ben · 2016-11-11 05:11:53

The upgrade instructions state that you need to log into Backlight, and visit Publisher and Designer to complete the upgrade process. Have you done that?

charlie.choc · 2016-11-11 05:14:04

I did all that before I tried updating an album from LR.

Ben · 2016-11-11 05:26:00

Hi Charlie, when you log into Backlight and click on Backlight > Publisher, what version number of Publisher does it show? It should be 3.1.0. If you see update messages when clicking on Publisher, then that should be the final step needed.

If you still have this problem, can you provide me with a Backlight admin login, using the Email link under my picture on the left?

charlie.choc · 2016-11-11 05:32:00

It is 3.1.0. I did the update earlier. The TTG publisher version is 3.0.5, though. That's the lrplugin that was in the downloaded file.

Ben · 2016-11-11 05:45:29

Hi Charlie, thanks for the login. Looking at your database, I see that the column shown in the error message, show_breadcrumb_for_children, has actually been created as expected. Are you still seeing the error in Lightroom? If so, can you copy and paste the full error from the popup into your reply?

I missed updating the version number in the LR Plugin.

charlie.choc · 2016-11-11 05:48:28

Plug-in error log for plug-in at: /Applications/TTG-Publisher.lrplugin

**** Error 1

An error occurred while attempting to sort photos on this service.
Unable to perform action: setPhotoOrder

Message: Update query failed with error: SQLSTATE[HY000]: General error: 1 no such column: show_breadcrumb_for_children
sql:
'UPDATE `album` SET
`id`=\'42309\',
`publisher_root_id`=\'1\',
`parent_id`=\'\',
`type`=\'album\',
`slug`=\'flowers-and-plants\',
`breadcrumb`=\'\',
`title`=\'Flowers and Plants\',
`description`=\'Things growing in the ground\',
`template`=\'3\',
`page_copy`=\'Things growing in the ground\',
`page_copy_placement`=\'replace\',
`sidebar_copy`=\'\',
`sidebar_copy_placement`=\'above\',
`tray2_copy`=\'\',
`tray2_copy_placement`=\'above\',
`enable_video`=\'no\',
`video_id`=\'\',
`cover_image`=\'\',
`items_per_page`=\'15\',
`enable_maps`=\'yes\',
`enable_password`=\'no\',
`username`=\'\',
`password`=\'enc_a0636379347e32d1ff25e9cfa632d385\',
`enable_cart`=\'yes\',
`pricing_scheme`=\'default\',
`enable_crg`=\'no\',
`crg_feedback_profile_id`=\'\',
`crg_client_mode`=\'\',
`ordering`=\'capture_time_desc\',
`has_user_order`=\'yes\',
`hide_from_autoindex`=\'no\',
`hide_from_search`=\'no\',
`show_breadcrumbs`=\'yes\',
`needs_first_visit`=\'yes\',
`created`=\'2016-10-22 11:12:06\',
`modified`=\'2016-11-10 20:32:21\',
`show_breadcrumb_for_children`=\'yes\'
WHERE `id`=\'42309\''
params:
array (
) in PdoExtended.php on line 551

dchew · 2016-11-11 06:00:43

Ben,
My error looks the same. Publisher v 3.1.0:
Unable to perform action: setPhotoOrder

Message: Update query failed with error: SQLSTATE[HY000]: General error: 1 no such column: show_breadcrumb_for_children
sql:
'UPDATE `album` SET
`id`=\'47656\',
`publisher_root_id`=\'1\',
`parent_id`=\'\',
`type`=\'album\',
`slug`=\'Home-Splash-Album\',
`breadcrumb`=\'\',
`title`=\'Home Splash Album\',
`description`=\'\',
`template`=\'13\',
`page_copy`=\'\',
`page_copy_placement`=\'above\',
`sidebar_copy`=\'\',
`sidebar_copy_placement`=\'above\',
`tray2_copy`=\'\',
`tray2_copy_placement`=\'above\',
`enable_video`=\'no\',
`video_id`=\'\',
`cover_image`=\'\',
`items_per_page`=\'100\',
`enable_maps`=\'no\',
`enable_password`=\'no\',
`username`=\'\',
`password`=\'enc_a0636379347e32d1ff25e9cfa632d385\',
`enable_cart`=\'no\',
`pricing_scheme`=\'\',
`enable_crg`=\'no\',
`crg_feedback_profile_id`=\'\',
`crg_client_mode`=\'\',
`ordering`=\'lightroom\',
`has_user_order`=\'yes\',
`hide_from_autoindex`=\'yes\',
`hide_from_search`=\'yes\',
`show_breadcrumbs`=\'yes\',
`needs_first_visit`=\'no\',
`created`=\'2016-08-27 10:12:21\',
`modified`=\'2016-11-10 18:03:10\',
`show_breadcrumb_for_children`=\'yes\'
WHERE `id`=\'47656\''
params:
array (
) in PdoExtended.php on line 552

Ben · 2016-11-11 06:04:45

Thanks. I have found the problem. On sorting by custom order, the album details are fetched from the database, including the field show_breadcrumbs_for_children from the associated top-level gallery. This fails when trying to save the updated album, because show_breadcrumbs_for_children isn't a setting for the album itself.

Ben · 2016-11-11 06:12:25

I have applied a silent update that addresses this. If you want to apply the fix, re-download Backlight and either replace the entire backlight/publisher directory, or just the single file: backlight/publisher/application/dao/AlbumDAO.php.

The Publisher LR plugin has also been updated, with the only change being the version number displayed now showing 3.1.

dchew · 2016-11-11 06:14:01

Thanks Ben!

No error.

Last edited by dchew (2016-11-11 06:28:59)

charlie.choc · 2016-11-11 06:23:14

Very cool, worked like a charm. Thanks.

admint · 2016-11-24 11:01:44

Did an album update just now and discovered I have the same error as the first post. Ben's fix (post #17) solved the problem. Probably a good idea to re-push this update with the new file. If I hadn't remembered this thread who knows where I'd be.

That said (note to self), It'd probably also be a good idea to test site immediately after updates

Thanks.

R42itus · 2016-11-25 02:59:22

I was lucky, I did a search for the error and the solution fixed my problem as well. Thank you.

Community @ The Turning Gate

#1 2016-11-11 02:36:02

LR Publish error after updating to 1.1

#2 2016-11-11 02:40:23

Re: LR Publish error after updating to 1.1

#3 2016-11-11 02:58:18

Re: LR Publish error after updating to 1.1

#4 2016-11-11 02:59:11

Re: LR Publish error after updating to 1.1

#5 2016-11-11 03:06:19

Re: LR Publish error after updating to 1.1

#6 2016-11-11 03:07:22

Re: LR Publish error after updating to 1.1

#7 2016-11-11 03:10:39

Re: LR Publish error after updating to 1.1

#8 2016-11-11 03:27:42

Re: LR Publish error after updating to 1.1

#9 2016-11-11 05:11:53

Re: LR Publish error after updating to 1.1

#10 2016-11-11 05:14:04

Re: LR Publish error after updating to 1.1

#11 2016-11-11 05:26:00

Re: LR Publish error after updating to 1.1

#12 2016-11-11 05:32:00

Re: LR Publish error after updating to 1.1

#13 2016-11-11 05:45:29

Re: LR Publish error after updating to 1.1

#14 2016-11-11 05:48:28

Re: LR Publish error after updating to 1.1

#15 2016-11-11 06:00:43

Re: LR Publish error after updating to 1.1

#16 2016-11-11 06:04:45

Re: LR Publish error after updating to 1.1

#17 2016-11-11 06:12:25

Re: LR Publish error after updating to 1.1

#18 2016-11-11 06:14:01

Re: LR Publish error after updating to 1.1

#19 2016-11-11 06:23:14

Re: LR Publish error after updating to 1.1

#20 2016-11-24 11:01:44

Re: LR Publish error after updating to 1.1

#21 2016-11-25 02:59:22

Re: LR Publish error after updating to 1.1

Board footer