Community @ The Turning Gate

ric

Member

Registered: 2013-02-02

Posts: 13

CE4 CRG HTTP Error 500

I have never managed to get the CE4 CRG to work. I get an Error 500 when trying to view a published page. I matched the template name in the TTG-BE. My PHP version is 7.0.33

www.bringacamera.com

I would appreciate help troubleshooting and getting this working.
Thank you

rod barbee

Moderator

From: Port Ludlow, WA USA

Registered: 2012-09-24

Posts: 17,830

Website

Re: CE4 CRG HTTP Error 500

can you point to a specific album or gallery?

I matched the template name in the TTG-BE

What exactly to you mean by this?

---

Rod 
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site

ric

Member

Registered: 2013-02-02

Posts: 13

Re: CE4 CRG HTTP Error 500

Actually... when I hit PHP version in the TTG-BE it replies PHP Version 5.6.37

ric

Member

Registered: 2013-02-02

Posts: 13

Re: CE4 CRG HTTP Error 500

I mean that I went into the TTG-BE and selected the template name that I uploaded to the templates area as the default template (CRG Settings > CRG Template)

Ben

Moderator

From: Melbourne, Australia

Registered: 2012-09-29

Posts: 4,399

Re: CE4 CRG HTTP Error 500

500 errors are difficult to diagnose.  All it means is that 'something failed' on your server.  Can you provide me with the exact steps to see the error, FTP and any TTG admin access needed via email.

---

Ben

Email
https://somethingchanged.com

rod barbee

Moderator

From: Port Ludlow, WA USA

Registered: 2012-09-24

Posts: 17,830

Website

Re: CE4 CRG HTTP Error 500

I mean that I went into the TTG-BE and selected the template name that I uploaded to the templates area as the default template (CRG Settings > CRG Template)

That is for the page the client sees when logging into their sites (if using Managed Albums):
http://www.bringacamera.com/ttg-be/crg/

Did you also assign that template to your albums when publishing?

---

Rod 
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site

ric

Member

Registered: 2013-02-02

Posts: 13

Re: CE4 CRG HTTP Error 500

I sent an email to Ben re FTP and TTG-BE access. Yes, I created a CRG template, uploaded it to TTB-BE>Templates and then used Publisher, using the template that successfully appears in the drop-down list for the site. This all happens with no error message. The final step is to view the published album and that is when I get the Error 500. I should note that non-CRG galleries continue to upload and work without issue.

ric

Member

Registered: 2013-02-02

Posts: 13

Re: CE4 CRG HTTP Error 500

I should note that when I click "Assign Albums" under Client Management I get the following error:

SQLSTATE[HY000]: General error: 1 no such column: crg_client_mode|#0 /home7/kwintouc/public_html/bringacamera/ttg-be/framework/dao/PdoExtended.php(520): PDO->prepare('SELECT id, publ...') #1 /home7/kwintouc/public_html/bringacamera/ttg-be/framework/dao/PdoExtended.php(156): PdoExtended->_prepareAndExecuteSqlQuery('SELECT id, publ...', Array) #2 /home7/kwintouc/public_html/bringacamera/ttg-be/crg/application/helpers/PublisherHelper.php(134): PdoExtended->selectRows('SELECT id, publ...', Array) #3 /home7/kwintouc/public_html/bringacamera/ttg-be/crg/application/helpers/PublisherHelper.php(14): PublisherHelper->fillLookups() #4 /home7/kwintouc/public_html/bringacamera/ttg-be/crg/application/dao/ClientDAO.php(184): PublisherHelper->__construct(Object(SQLiteHandler)) #5 /home7/kwintouc/public_html/bringacamera/ttg-be/crg/application/controllers/AdminController.php(262): ClientDAO->getAllCRGEnabledGalleries() #6 [internal function]: AdminController->assign_albums('28') #7 /home7/kwintouc/public_html/bringacamera/ttg-be/framework/controllers/Controller.php(41): call_user_func_array(Array, Array) #8 /home7/kwintouc/public_html/bringacamera/ttg-be/framework/Framework.php(124): Controller->dispatch(Array) #9 /home7/kwintouc/public_html/bringacamera/ttg-be/crg/index.php(24): Framework->route() #10 {main}|URL: /ttg-be/crg/index.php

rod barbee

Moderator

From: Port Ludlow, WA USA

Registered: 2012-09-24

Posts: 17,830

Website

Re: CE4 CRG HTTP Error 500

That’s a good clue and something Ben will likely be able to work with,
Looks like it could be a database issue.

What version of the Publisher plugin are you using?

---

Rod 
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site

ric

Member

Registered: 2013-02-02

Posts: 13

Re: CE4 CRG HTTP Error 500

Publisher plugin version 2.3.3

Thank you for your attention.

Last edited by ric (2019-02-24 17:19:40)

ric

Member

Registered: 2013-02-02

Posts: 13

Re: CE4 CRG HTTP Error 500

Ben told me that my publisher version was old. I had gotten the updates and thought I had installed them correctly. Ben explained that if I copy the new Publisher version to the web I must then access the settings page in ttg-be for the new version to install and update the database. I did this and everything was working.

Thank you.
Ric