Community @ The Turning Gate

Support community for TTG plugins and products.

You are not logged in.

#1 2018-09-10 05:44:39

johnbrks
Member
From: Los Angeles
Registered: 2015-08-14
Posts: 137
Website

update gives error: SQLSTATE[HY000]

i updated one site to backlight 2 with no problems.  another site in a different directory gives me an error.
I ran the updater correctly, but when i went to the pages section to update, i got the error:

Backing up databases...
Backed up master.sq3
Upgrading to version 1.2.2...
Configuring localizations
Unable to upgrade to version 1.2.2
Error message: SQLSTATE[HY000]: General error: 1 no such table: localisation_master

I get the same for templates.

All of my templates and pages are listed, but the site doesn't load of course.

(i left custom and data in place, as instructed)

thoughts?

(i had emailed matt, but then i realized i wasn't sure what his hours are and it may be better in support).

Offline

#2 2018-09-10 06:00:29

Matthew
Administrator
From: Seoul, South Korea
Registered: 2012-09-24
Posts: 5,439
Website

Re: update gives error: SQLSTATE[HY000]

This a question Ben can answer better than I, when he wakes.

In the meantime, check to ensure that your host is running PHP 5.4 minimum, 5.6 or newer recommended. You should be able to check or change this in your host's CPanel.

Also, in admin, visit the Dashboard, Designer, Cart and Client Response areas (as applicable) to force a database upgrade, and click the "Update Album Files" link on the dashboard to make sure generated files are up-to-date following the upgrade.


Campagna Pictures, http://campagnapictures.com
The Turning Gate, http://theturninggate.net

Offline

#3 2018-09-10 06:16:37

Ben
Moderator
From: Melbourne, Australia
Registered: 2012-09-29
Posts: 3,747

Re: update gives error: SQLSTATE[HY000]

This is a tricky one. The BL update mechanism removes the localization_master table in the Designer database, but your Designer is upgrading from a version that is not the latest BL1 release and that expects the table to still be there. I’ll work out a strategy to get around this and will get back to you.

Offline

#4 2018-09-10 06:23:13

johnbrks
Member
From: Los Angeles
Registered: 2015-08-14
Posts: 137
Website

Re: update gives error: SQLSTATE[HY000]

Thanks.  I have PHP 5.6.  I updated the albums, which said it worked., however designer, pages, etc still say it is unable to upgrade to version 1.2.2 with the same error.

Offline

#5 2018-09-10 06:42:32

johnbrks
Member
From: Los Angeles
Registered: 2015-08-14
Posts: 137
Website

Re: update gives error: SQLSTATE[HY000]

thanks ben.  i probably forgot to update BL1 consistently on that site as it gets neglected at times..

Offline

#6 2018-09-10 07:23:40

Ben
Moderator
From: Melbourne, Australia
Registered: 2012-09-29
Posts: 3,747

Re: update gives error: SQLSTATE[HY000]

Hi John, I've applied a patch to work around this.  To fix it:
1) Log into Backlight
2) Visit Backlight > Backlight Modules
3) Click Reinstall on the line for module-designer
4) Click the Reinstall to confirm
5) Visit Designer

Offline

Board footer

Powered by FluxBB