Cannot log into admin after update to 1.1.0

bcobb10b · 2016-11-14 07:45:11

I'm running Backlight and Pages. After uploading updates to both, Backlight will not accept my log-in and returns me to the admin login screen when I try. Have not been able to complete the update process. Have repeated the delete / upload process twice.

When I go the the URL for the Backlight site, I see this in a red panel:

Something went wrong
Update query failed with error: SQLSTATE[HY000]: General error: 1 no such column: type sql: 'UPDATE `engine_view` SET `name`=\'include\', `type`=\'dynamic\', `path`=\'\', `rename`=\'\', `passthrough`=\'no\', `modified`=\'2016-11-13 22:38:26\' WHERE `engine_id`=\'89\' AND `view_id`=\'view.include\'' params: array ( ) in PdoExtended.php on line 552

Bill Cobb

Ben · 2016-11-14 08:23:52

Hi Bill, which version of Backlight were you updating from? 1.0.5 or something earlier?

Can you provide me with a Backlight admin login, via the Email link under my picture. It would also be helpful to have FTP access so that I can see what's going wrong on the server.

bcobb10b · 2016-11-14 08:32:06

Ben wrote:

Hi Bill, which version of Backlight were you updating from? 1.0.5 or something earlier?
Can you provide me with a Backlight admin login, via the Email link under my picture. It would also be helpful to have FTP access so that I can see what's going wrong on the server.

I was updating from 1.0.3. Will send info shortly. Thanks. - Bill

rdinterman · 2016-11-14 09:22:28

I have the same, but slightly different issue:
SQLSTATE[HY000]: General error: 1 no such column: pr.show_breadcrumb_for_children in PdoExtended.php on line 524

Ben · 2016-11-14 09:25:40

Hi Ray, what action did you perform before seeing that message? Have you completed the upgrade process by logging into Backlight and visiting each of the Backlight, Designer and Backlight > Publisher menus?

rdinterman · 2016-11-14 09:39:22

This is the error I get when I try to get to the Admin screen...
Warning: include_once(../framework/../config.php) [function.include-once]: failed to open stream: No such file or directory in /home/content/r/d/i/rdinterman/html/framework/init.php on line 29

Warning: include_once() [function.include]: Failed opening '../framework/../config.php' for inclusion (include_path='.:/usr/local/php5_3/lib/php') in /home/content/r/d/i/rdinterman/html/framework/init.php on line 29
mkdir() [function.mkdir]: No such file or directory|#0 [internal function]: ErrorHandler::handleError(2, 'mkdir() [

Ben · 2016-11-14 09:43:12

Hi Ray, it looks like not all of your files have been uploaded. I suggest re-uploading the Backlight directories as outlined in the upgrade instructions. Which FTP client are you using?

rdinterman · 2016-11-14 09:45:32

I use CyberDuck...hosting is GoDaddy. I'll us a different FTP client and see what happens.

bcobb10b · 2016-11-14 12:39:45

bcobb10b wrote:

I'm running Backlight and Pages. After uploading updates to both, Backlight will not accept my log-in and returns me to the admin login screen when I try. Have not been able to complete the update process. Have repeated the delete / upload process twice.
When I go the the URL for the Backlight site, I see this in a red panel:
Something went wrong
Update query failed with error: SQLSTATE[HY000]: General error: 1 no such column: type sql: 'UPDATE `engine_view` SET `name`=\'include\', `type`=\'dynamic\', `path`=\'\', `rename`=\'\', `passthrough`=\'no\', `modified`=\'2016-11-13 22:38:26\' WHERE `engine_id`=\'89\' AND `view_id`=\'view.include\'' params: array ( ) in PdoExtended.php on line 552
Bill Cobb

Thanks to Ben for his quick response to my quandary. If any of you encounter my situation -- which was not being able to log in after loading the v1.1.0 Backlight software -- be sure to refresh your browser to load a new copy of the admin login page. Evidently I had not. My hypothesis is that the old version of admin login page loaded in my cache could not communicate with the new software that was loaded to my server, so threw up its hands and returned control to me with no error message. When I finally got smart and refreshed my browser to display the new admin login page (and the spiffy new TTG logo in its upper left hand corner), everything returned to normal. If you don't see new logo after loading the new software, refresh your browser.

All is good in Georgia.

Bill Cobb

rdinterman · 2016-11-14 22:52:54

Tried a different ftp client (Forklift)...still get the same errors

rdinterman · 2016-11-14 23:32:13

Fixed...not sure how I did it...combination of addresses to get into the Admin panel. Finally worked once the update ran.
Thanks for the help!!!

Community @ The Turning Gate

#1 2016-11-14 07:45:11

Cannot log into admin after update to 1.1.0

#2 2016-11-14 08:23:52

Re: Cannot log into admin after update to 1.1.0

#3 2016-11-14 08:32:06

Re: Cannot log into admin after update to 1.1.0

#4 2016-11-14 09:22:28

Re: Cannot log into admin after update to 1.1.0

#5 2016-11-14 09:25:40

Re: Cannot log into admin after update to 1.1.0

#6 2016-11-14 09:39:22

Re: Cannot log into admin after update to 1.1.0

#7 2016-11-14 09:43:12

Re: Cannot log into admin after update to 1.1.0

#8 2016-11-14 09:45:32

Re: Cannot log into admin after update to 1.1.0

#9 2016-11-14 12:39:45

Re: Cannot log into admin after update to 1.1.0

#10 2016-11-14 22:52:54

Re: Cannot log into admin after update to 1.1.0

#11 2016-11-14 23:32:13

Re: Cannot log into admin after update to 1.1.0

Board footer