Problem with latest Backlight update

lmiller41 · 2016-10-06 23:49:06

Update query failed with error: SQLSTATE[HY000]: General error: 1 no such column: type sql: 'UPDATE `engine_view` SET `name`=\'index\', `type`=\'dynamic\', `path`=\'\', `rename`=\'\', `passthrough`=\'no\', `modified`=\'2016-10-06 14:47:46\' WHERE `engine_id`=\'88\' AND `view_id`=\'view.index\'' params: array ( ) in PdoExtended.php on line 552

This is what I see when I go to my galleries after the update Help!

lmiller41 · 2016-10-07 00:05:29

Re-installed, logged into Backlight and let the various updates run. All well now.

Ben · 2016-10-07 05:52:56

As you've found, the update process via Backlight admin as per the upgrade instructions is required.

admint · 2016-10-07 09:09:20

I'm having a strange issue after the update where my site will no longer display correctly when clicking on a gallery using the dropdown menu. If I click on a gallery I get a blank page...

Here's the "normal" look....

EV%20Site%20-%20Normal.PNG

When I click a gallery I get this...

EV%20Site%20-%20Error.PNG

This is similar to an issue I reported here: http://community.theturninggate.net/vie … 499#p41499

Anyway the situation is much worse since the update, and any gallery I click on gets a blank page. What's happening. BTW this is happening with IE11 under Windows 10, but NOT Edge. It's happening on two different PC's.

And I'm also getting a double scroll bar on a smaller screen size that wasn't there before the update (at lest I don't remember it being there). I Just got the outside scroll bar, not the inner.

Thanks.

Last edited by admint (2016-10-07 09:11:19)

rod barbee · 2016-10-07 09:21:54

make sure you've completed the update by visiting the Design and Publisher sections as well a clearing your template cache

from the readme file:

Clear the Designer Template Cache by visiting Backlight -> Designer -> Templates -> Clear Template Cache =
Visit each of the Backlight, Designer and Publisher admin sections to allow Backlight to run any
necessary database updates.

admint · 2016-10-07 11:18:21

Thanks Rod, I already did that. Anyway I realized I forgot to list my website: http://www.exposedvisions.com

rod barbee · 2016-10-07 12:47:30

I'm seeing it in IE11 too. But I'm seeing the thumbnails pop into existence for a fraction of a second then they disappear.
I hate Internet Explorer....

also seeing the double scroll bar in IE11.

Did I mention I hate IE?

admint · 2016-10-07 13:30:45

rod barbee wrote:

I'm seeing it in IE11 too. But I'm seeing the thumbnails pop into existence for a fraction of a second then they disappear.
I hate Internet Explorer....
also seeing the double scroll bar in IE11.
Did I mention I hate IE?

LOL

Unfortunately though, IE11 is still a highly used browser. I'm still using it over Edge. That said, I didn't have this issue before the 105 update. And yeah, that's exactly what happens, the thumbnails pop up for a second than disappear.

Anyway hopefully it gets fixed fast because I can't tell my site visitors not to use IE11

In the meantime, I'll re-download the 105 update with the corrected SQL file and reinstall and see if that helps.

Until then...

Edit: Reinstalling update didn't work. Oh man...

Last edited by admint (2016-10-07 13:55:25)

Matthew · 2016-10-07 14:52:19

So the IE hack in 1.0.5 that was meant to make things better isn't doing it's job quite in the way that I had hoped. I've been bashing me head on this since I woke up this morning, and have had some better luck replicating the described problems now that we're all running on up-to-date code. I've been enhancing the hack, and might have found a workable solution. Try the following changes.

Edit /backlight/modules/standard-page/dynamic/css/layout.php, add the following at the bottom:

/* *** IE layout hack *** */
	.page__wrapper {
		display: table;
		min-height: calc( 100vh - <?php echo $model->value('page_layout.mt'); ?>px - <?php echo $model->value('page_layout.mb'); ?>px - <?php echo $model->value('page_layout.mt') > 0 ? $model->value('page_layout.border') : 0 ?>px - <?php echo $model->value('page_layout.mb') > 0 ? $model->value('page_layout.border') : 0 ?>px );
		width: 100%;	
	}
	.ie__hack {
		height: 100%;
	}
	.page__width {
		width: 999999px;
	}
/* /** IE layout hack *** */

Edit /backlight/modules/standard-page/dynamic/js/scaffolding.php, find:

if (version === false || version >= 12) {
	// do nothing
} else {
	document.getElementById("page__body").style.height = "100vh";
}

Replace with:

if (version === false || version >= 12) {
	// do nothing
} else {
	//document.getElementById("page__body").style.height = "100vh";

	var el = document.getElementById("page__body");
	el.className += " ie__hack";

	var wrapper = document.createElement('div');
	wrapper.className = "page__wrapper";
	el.parentNode.insertBefore(wrapper, el);
	wrapper.appendChild(el);

}

After making these changes, clear the template cache in Backlight.

admint · 2016-10-07 15:00:39

Thanks Matt,

I'll give this hack a try in the morning as it's getting late here and I'm exhausted as its been a long day. That said, I'm glad to see you were able to replicate the issue and that it wasn't just me.

Anyway I'll definitely give it a try sometime in the morning and post back.

Till then...

admint · 2016-10-07 15:57:27

OK, Matt, I tried the fix, but it didn't work, so I reverted back to the original file; however I'll give it another try in the morning as I may have copied something wrong.

In the meantime I discovered that all the galleries exhibit the issue I'm having, except for Museum Gallery, which has a sub-menu for Chrysler Museum. That gallery works without issue; thus I'm wondering if the issue has anything to do with "Top Level" galleries.

It's just weird that the only gallery that works is the one with a sub-menu.

Anyway the site is back to the original 105 update files without any edits to the files you talked about above. And this is where the only gallery that works in the Museum/Chrysler gallery.

Just food for thought. Thanks.

Matthew · 2016-10-07 16:10:02

Did you clear the template cache after making the updates? Also, clear your browser cache to ensure it's not loading the previous version of the page. I find the browser cache in IE is rather sticky, so you may need to force reload; I think that's Ctrl-F5?

Matthew · 2016-10-07 16:17:59

For curiosity's sake, here's a page where I've implemented this hack and have been doing my testing:
http://campagnapictures.com/troubleshooting/

speacock110 · 2016-10-07 16:51:31

I had exactly the same problem on both of my sites. So I implemented Matt's fix and it worked, I had to make sure I cleared the browser cache as well as backlights cache

markh · 2016-10-07 20:22:37

I was also seeing this problem in IE which I never, ever use for anything (but like the man says, a lot of people still do use it). The fix outlined above worked great to fix it.
P.S. I've begun using VIVALDI as my go-to browser and I'm pretty impressed with it. FYI.
Mark

Last edited by markh (2016-10-07 20:30:41)

volvoxturbo · 2016-10-07 21:12:26

Hi all,

I have the same problems like admint.

Tried Matts instruction with the IE hack several times but doesnt work (after clearing cashes in backlight and IE11) even not in firefox (no menu anymore and homepage logo out of center).

See www.oliver-blum.com

Any further idea???

thx a lot

best regards,
Oliver

Last edited by volvoxturbo (2016-10-07 21:30:44)

rod barbee · 2016-10-07 22:04:32

The fix works on my test site in IE11.

rod barbee · 2016-10-07 22:58:16

UPDATE:
I noticed in IE11 that when the browser window gets tall enough to hold the entire page, instead of the scroll bar disappearing like normal, it jumps from the side of the browser window to the side of the page content. The page content then needs to be scrolled to view the footer.
But there are no longer two scroll bars, just the one

rod barbee · 2016-10-07 23:54:07

UPDATE 2:

Hi Matt, it also looks like this fix messes with the responsiveness of the masthead. (all browsers)
With the fix above in place, my masthead graphic no longer resizes to fit smaller spaces.
After noticing this I reverted to the original files and the masthead acted as normal.

I'll upload the changed files again so you can see what's happening.
http://backlight-rb-test.barbeephoto.com/home/

rod barbee · 2016-10-08 00:46:01

looks like the footer is affected in a similar way.

Matthew · 2016-10-08 00:53:42

I have some further work on this that I hope/think improves things. Files here:

https://www.dropbox.com/sh/i23bzo8o7qej … 5MHqa?dl=0

Replace:

/backlight/modules/standard-page/css/layout.php
/backlight/modules/standard-page/js/scaffolding.php

volvoxturbo · 2016-10-08 01:12:14

Thank you Matt,

I guess the folders are:
/backlight/modules/standard-page/dynamic/css/layout.php
/backlight/modules/standard-page/dynamic/js/scaffolding.php

Your fix seems to work again in Firefox, still no success to the menu on my homepage in IE11 -> www.oliver-blum.com

Best regards,
oliver

Last edited by volvoxturbo (2016-10-08 01:12:53)

rod barbee · 2016-10-08 01:14:42

that seems to have taken care of things in modern browsers. IE 11 is still a hot mess.
Scroll bar on content rather than whole page.
There are issues with responsiveness:
-Masthead and footer
-Page content disappears when narrowing browser window to mobile (tablet and smaller) sizes.

Matthew · 2016-10-08 01:18:55

Oliver, you have the strangest configuration I've yet seen. If you send me a login, I'll take a look at what you've got going on.

admint · 2016-10-08 01:45:32

Matthew wrote:

I have some further work on this that I hope/think improves things. Files here:
https://www.dropbox.com/sh/i23bzo8o7qej … 5MHqa?dl=0
Replace:
/backlight/modules/standard-page/css/layout.php
/backlight/modules/standard-page/js/scaffolding.php

Fix worked with downloaded files. And as someone else posted, should be...

/backlight/modules/standard-page/dynamic/css/layout.php
/backlight/modules/standard-page/dynamic/js/scaffolding.php

1) - Make sure you clear template cache in Backlight panel
2) - Clear Internet Cache: Windows 10... Tools (gear icon), Safety, Delete browsing history; uncheck "Preserve Favorites website data", hit Delete.

Issue solved, double scroll bar gone. Good job Matt

Thanks!

Community @ The Turning Gate

#1 2016-10-06 23:49:06

Problem with latest Backlight update

#2 2016-10-07 00:05:29

Re: Problem with latest Backlight update

#3 2016-10-07 05:52:56

Re: Problem with latest Backlight update

#4 2016-10-07 09:09:20

Re: Problem with latest Backlight update

#5 2016-10-07 09:21:54

Re: Problem with latest Backlight update

#6 2016-10-07 11:18:21

Re: Problem with latest Backlight update

#7 2016-10-07 12:47:30

Re: Problem with latest Backlight update

#8 2016-10-07 13:30:45

Re: Problem with latest Backlight update

#9 2016-10-07 14:52:19

Re: Problem with latest Backlight update

#10 2016-10-07 15:00:39

Re: Problem with latest Backlight update

#11 2016-10-07 15:57:27

Re: Problem with latest Backlight update

#12 2016-10-07 16:10:02

Re: Problem with latest Backlight update

#13 2016-10-07 16:17:59

Re: Problem with latest Backlight update

#14 2016-10-07 16:51:31

Re: Problem with latest Backlight update

#15 2016-10-07 20:22:37

Re: Problem with latest Backlight update

#16 2016-10-07 21:12:26

Re: Problem with latest Backlight update

#17 2016-10-07 22:04:32

Re: Problem with latest Backlight update

#18 2016-10-07 22:58:16

Re: Problem with latest Backlight update

#19 2016-10-07 23:54:07

Re: Problem with latest Backlight update

#20 2016-10-08 00:46:01

Re: Problem with latest Backlight update

#21 2016-10-08 00:53:42

Re: Problem with latest Backlight update

#22 2016-10-08 01:12:14

Re: Problem with latest Backlight update

#23 2016-10-08 01:14:42

Re: Problem with latest Backlight update

#24 2016-10-08 01:18:55

Re: Problem with latest Backlight update

#25 2016-10-08 01:45:32

Re: Problem with latest Backlight update

Board footer