Migrating from CE4 to Backlight 2 error

Kubicixfactor · 2020-01-07 00:59:30

Hi folks,

Found some time at last to migrate my CE4 site and ran into the error below when running the migration tool. Any advice please?
Updating Backlight Publisher from version 2.3.2 to 4.0.0

Backing up databases...
Backed up master.sq3
Upgrading to version 2.3.3...
Updating settings
Unable to upgrade to version 2.3.3
Error message: SQLSTATE[HY000]: General error: 1 no such column: descriptionSQLSTATE[HY000]: General error: 1 no such column: pr.template|#0 /var/www/web/backlight/modules/module-framework/dao/PdoExtended.php(524): PDO->prepare('select pr.id, p...') #1 /var/www/web/backlight/modules/module-framework/dao/PdoExtended.php(156): PdoExtended->_prepareAndExecuteSqlQuery('select pr.id, p...', Array) #2 /var/www/web/backlight/modules/module-publisher/application/dao/AlbumDAO.php(212): PdoExtended->selectRows('select pr.id, p...') #3 /var/www/web/backlight/modules/module-publisher/application/delegates/PublisherDelegate.php(1247): AlbumDAO->getAllTopLevelGalleryDirectories() #4 /var/www/web/backlight/modules/module-publisher/application/controllers/PublisherAdminController.php(23): PublisherDelegate->updateAlbumFiles() #5 /var/www/web/backlight/modules/module-framework/models/Dispatchable.php(292): PublisherAdminController->__construct('list_top_level_...') #6 /var/www/web/backlight/modules/module-framework/models/Dispatchable.php(215): Dispatchable->createControllerIfNeeded() #7 /var/www/web/backlight/modules/module-framework/models/Dispatchable.php(89): Dispatchable->processParameters() #8 /var/www/web/backlight/modules/module-framework/Framework.php(50): Dispatchable->init() #9 /var/www/web/backlight/index.php(32): Framework->route() #10 {main}|URL: /backlight/index.php

Kubicixfactor · 2020-01-07 01:08:31

Note sure what's broken here but I'm also getting an error code 418 from Lightroom when trying to publish to the live Backlight 2 site. The Publisher API is authenticating and it works fine if I direct it to upload an album to my test site.

rod barbee · 2020-01-07 01:58:18

did you install the latest TTG Publisher plug-in for Lightroom? It's available on your Backlight Modules page, near the top.

Kubicixfactor · 2020-01-07 02:17:29

Hi Rod, I'm running version 4 of the publisher plugin on the desktop and I've updated all the backlight modules on the server to the latest versions.

Where do I find the latest lightroom.lrplugin file?

Kubicixfactor · 2020-01-07 02:50:10

Found the plug in (right in front of my eyes ) so I can publish albums now without errors. But the pages I've transferred from my test site are a complete mess!

I've emailed Ben to see if he can resolve the migration errors, not sure whether to wait for him or reinstall Backlight and create the site again from scratch to see if that clears things up.

Kubicixfactor · 2020-01-07 03:58:21

This is a bit exasperating, reinstalled Backlight and now getting error 418 from Lightroom when I try to create an album, and the templates aren't showing up in the lightroom plugin either.

rod barbee · 2020-01-07 04:49:12

which templates are you referring to? New Backlight templates or old CE4 templates?

Kubicixfactor · 2020-01-07 05:00:27

Hi Rod, thanks for helping, it’s the new templates. If I go into lightroom and create a new album using the Publisher (version 4.0.12) plugin, the only template showing is “default album”. Then shortly after, “error 418” pops up. The plugin authenticates correctly against the API.

In Backlight admin I can’t load the publisher, I just get the error message shown in the first post. But oddly enough it looks like the old CE4 albums have tried to migrate because if I go to create a page and insert an album they’re all showing there in a drop down.

All a bit of a mess, not quite sure what to do next.

rod barbee · 2020-01-07 05:07:48

I think it's one of those things Ben will need to dig into.

Kubicixfactor · 2020-01-07 08:14:58

I don’t see any way to migrate the cart from CE4 to Backlight either, can anyone tell me where that option should be please? I’ve purchased the module.

rod barbee · 2020-01-07 08:45:18

Go to the main cart dashboard. Look under Special Links

Kubicixfactor · 2020-01-07 17:40:41

Thanks Rod, it's not there, there's a little gap where I think it should be

The good news is that Ben got in touch overnight and he's onto this now so I'm sure he'll be able to put everything right.

Ben · 2020-01-07 18:35:01

I've fixed the issue with the Publisher upgrade. The BL2 upgrade script makes changes to the Publisher database. However, when attempting to upgrade within the CE4 versions, one of the changes was broken by the BL2 upgrade. I've put in a check for this and applied the change, and the upgrade completed from 2.3.2 to 4.0.12.

There is a link on the Cart Dashboard at http://www.adecentexposure.co.uk/backli … dashboard/ called "Migrate data from CE4 Cart". If you haven't already visited it, then doing so should upgrade your Cart. Let me know if it doesn't work.

My FTP access to your site is no longer letting me in. If all goes well with the Cart migration, then I shouldn't need to be able to FTP in.

Ben · 2020-01-07 18:38:51

Also, the albums are still CE4 albums. If you intend to switch them over to use Backlight, then you'll need to update the album files by visiting this page: http://www.adecentexposure.co.uk/backli … bum_files/

Kubicixfactor · 2020-01-07 21:56:10

So it looks like I'm good to go now with the migration completed, thank you Ben!

But - the problem now is that the site is incredibly slow to load. My test site with a few albums takes about a second. My original CE4 site took about 2 seconds (up to when I overwrote it yesterday). The Backlight site contains the albums from CE4 (32 sets, 217 albums) but the load time for the home page is 15-20 seconds. Lightroom is also incredibly slow uploading an album. Backlight admin is very slow to load. Anything I should be looking at?

Matthew · 2020-01-09 10:14:13

Backlight is quite fast by default. Sounds like probably a server/hosting issue. Maybe temporary.

Sit in it for a day and see whether it improves. If not, this being a separate issue, please open a new thread. I’m closing this one as resolved.

Community @ The Turning Gate

#1 2020-01-07 00:59:30

Migrating from CE4 to Backlight 2 error

#2 2020-01-07 01:08:31

Re: Migrating from CE4 to Backlight 2 error

#3 2020-01-07 01:58:18

Re: Migrating from CE4 to Backlight 2 error

#4 2020-01-07 02:17:29

Re: Migrating from CE4 to Backlight 2 error

#5 2020-01-07 02:50:10

Re: Migrating from CE4 to Backlight 2 error

#6 2020-01-07 03:58:21

Re: Migrating from CE4 to Backlight 2 error

#7 2020-01-07 04:49:12

Re: Migrating from CE4 to Backlight 2 error

#8 2020-01-07 05:00:27

Re: Migrating from CE4 to Backlight 2 error

#9 2020-01-07 05:07:48

Re: Migrating from CE4 to Backlight 2 error

#10 2020-01-07 08:14:58

Re: Migrating from CE4 to Backlight 2 error

#11 2020-01-07 08:45:18

Re: Migrating from CE4 to Backlight 2 error

#12 2020-01-07 17:40:41

Re: Migrating from CE4 to Backlight 2 error

#13 2020-01-07 18:35:01

Re: Migrating from CE4 to Backlight 2 error

#14 2020-01-07 18:38:51

Re: Migrating from CE4 to Backlight 2 error

#15 2020-01-07 21:56:10

Re: Migrating from CE4 to Backlight 2 error

#16 2020-01-09 10:14:13

Re: Migrating from CE4 to Backlight 2 error

Board footer