Community @ The Turning Gate

Support community for TTG plugins and products.

NOTICE

The Turning Gate's Community has moved to a new home, at https://discourse.theturninggate.net.

This forum is now closed, and exists here as a read-only archive.

  • New user registrations are disabled.
  • Users cannot create new topics.
  • Users cannot reply to existing topics.

You are not logged in.

#1 2016-05-12 18:29:19

Rainer Goergen
Member
From: Trier, Germany
Registered: 2016-05-01
Posts: 401
Website

Problem with Search

Hi, I have updated to 1.01, copied only the folders and files to my NAS.
Cleared the Cache, all looks good. I don't no what I did later. When I renamed the search site to German, I tried to do a wrong search to have a look to all messages to translate them too. I did this in Designer. Now I tried to do a search with a right keyword and I always get the error message:

Something went wrong
SQLSTATE[HY000]: General error: 1 ambiguous column name: title in PdoExtended.php on line 524

---------------

This message appears too in Publisher - Top level galleries - if I click on - Albums -.


What happened?

Thanks, Rainer

Offline

#2 2016-05-12 19:41:51

rod barbee
Moderator
From: Port Ludlow, WA USA
Registered: 2012-09-24
Posts: 17,830
Website

Re: Problem with Search

I'm not certain, but that error could indicate that your host has not enabled a required feature.
Can you check to see if your hosting conforms to the requirements found on this page?
http://theturninggate.net/product-colle … backlight/
If it doesn't, you'll probably have to contact them. If it does, Ben will need to take a look. He'll likely need Backlight admin access and FTP access.


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

Offline

#3 2016-05-12 20:32:52

Ben
Moderator
From: Melbourne, Australia
Registered: 2012-09-29
Posts: 4,399

Re: Problem with Search

Hi Rainer,  this is an issue that came up immediately upon launch of 1.0.1.  The underlying cause is that not all versions of SQLite are the same, and some process the queries slightly differently.  We re-uploaded the 1.0.1 zip file last night, with a small fix to cover this.  The only changed file is backlight/publisher/application/helpers/PathBuilder.php

Can you try downloading Backlight 1.0.1 again, and replacing that file? 

The change is nothing more than adding two characters to the query, changing this line from:

$albums = $this->albumDAO->getAllAlbums($filter, 'title');

to:

$albums = $this->albumDAO->getAllAlbums($filter, 'a.title');

Offline

#4 2016-05-12 20:39:54

Rainer Goergen
Member
From: Trier, Germany
Registered: 2016-05-01
Posts: 401
Website

Re: Problem with Search

Sorry, thanks, it works.

I thought the problem with galleries.

Rainer

Last edited by Rainer Goergen (2016-05-12 20:43:13)

Offline

Board footer

Powered by FluxBB