Problem with ambiguous column name

tomowensphoto · 2016-05-14 01:26:36

Hi Chaps,
You are going to think I am a real numpty asking all these questions but I have been trying to see how to implement my different gallery types and use the rather neat menu set. However, I'm coming up with obstacles that may or may not be of my making.

In CE4 I had 1 Publisher, different templates and three galleries - Arts Practice, Commercial and Edgelands. Albums sat under these.
I'm just trying out the first two in the test build. I've tried two methods, One Publisher instance and two publisher instances pointing at the sub-directories. I get a positive result on authentication. However I was not seeing what I wanted to see on the site so I have tried one instance of Publisher
Screen%20Shot%202016-05-13%20at%2017.07.03.png
The Publisher bit looks like this

On clicking Publish on either of these Albums in the Album set I get
Screen%20Shot%202016-05-13%20at%2017.05.54.png

This error has been cropping up most of the day.

I use Album sets well in CE4. I may be missing a trick with the Backlight process though.
Regards
TomO

(edited by moderator to put screen shots in IMG tags)

rod barbee · 2016-05-14 02:38:13

I believe I've seen mention of the error recently on the forum. I'll have to search for it.

rod barbee · 2016-05-14 02:39:40

found it: http://community.theturninggate.net/vie … hp?id=6408

tomowensphoto · 2016-05-14 03:38:30

Thanks Rod,
I'll take a deeper look at this thread.
Regards,
TomO

rod barbee · 2016-05-14 04:36:34

Looks like Ben updated the 1.0.1 download. You may just need to download that and replace the backlight/publisher/application/helpers/PathBuilder.php file.

tomowensphoto · 2016-05-14 06:10:14

Thanks Rod,
I'll check that out in the morning. Every little helps. I thought I'd seen something but I get lost in the threads at times.
Regards,
TomO

Ben · 2016-05-14 09:07:44

This error seems to be related to a difference in how 'order by' fields are used between different versions of SQLite. Specifically, if you have a query like this:

select title from album a left join publisher_root pr on a.publisher_root_id = pr.id order by title

(publisher_root is the internal table name for Top-level galleries)

Some versions of SQLite will fall over because both album and publisher_root have a 'title' column, even though only the album's title is being drawn from the database. The version of SQLite on my development and testing setups doesn't fail on this query. The fix was to remove any cause of ambiguity by ordering by a.title.

tomowensphoto · 2016-05-14 14:46:23

Thanks Ben,
Should I be chasing my ISP to install a later version of SQLite? I won't get much support from them over a weekend. I'll download the update in the meantime.
Regards,
TomO

Ben · 2016-05-14 15:58:11

Hi Tom, I don't know whether that will help. I ran the above query in a SQLite on the Mac command line, which is version 3.9, and received the ambiguous column error. So it doesn't look like a problem with SQLite 2 that doesn't affect SQLite 3. It's something for me to keep in mind when writing queries. I'll see if I can configure my setup to raise the error in the browser, so at least I'll be able to test against it.

I should add that this isn't a bug in SQLite, but rather varying behaviour between versions.

tomowensphoto · 2016-05-14 16:06:42

OK thanks Ben.

tomowensphoto · 2016-05-14 17:59:30

OK I've downloaded the latest 101 and updated just the single file that Rod referred to above.
I have uploaded 3 albums without the error I was getting yesterday so that is good.

However, something else is going awry.
I have set up two Album sets. One Album sits in one set and two albums in another.
The display on screen was not as I expected so I added sub-menus to the default menu set.
Then it got really weird.
Screen%20Shot%202016-05-14%20at%2009.39.10.png
I suspect there may be corruption in a table somewhere as this shot of uploaded albums and sets does not reflect the current position.
How do the albums/sets value get down-dated when albums or sets are deleted via the Publisher? Should this screen show the current position or incremented values?
Screen%20Shot%202016-05-14%20at%2009.41.00.png
I expected Arts practice to have 1 sub-menu and Commercial to have 2

This is a snapshot of the Publisher position in LR5.7

I expect it is my hand of Midas in reverse having some effect here.
I hope the screen shots help?
Regards,
TomO

Edited by moderator to place image urls inside img tags

rod barbee · 2016-05-14 23:28:34

Hi Tom,
I updated your post to put the image urls inside the img tags:

[img]image url here[/img]

This also looks like it may be a different issue to that of the post topic. In future, could you start a new post with its own topic name so that it's easier to find for those facing similar issues?

tomowensphoto · 2016-05-15 00:41:08

OK Thanks Rod,
If I post screen shots in the future, I'll do as above. I was concerned about screen real estate usage.
Sorry,I thought this was a follow on from the SQLite issue and possible a database problem with the difference between Publisher count in LR and Publisher count in Backlight as I had only updated the one file from the latest 101.
So this is something else then?
Regards,
TomO

rod barbee · 2016-05-15 00:53:29

I don't know if it's something else. But if someone runs across the problem and they don't see that same error first, they wouldn't know to look at this topic

Community @ The Turning Gate

#1 2016-05-14 01:26:36

Problem with ambiguous column name

#2 2016-05-14 02:38:13

Re: Problem with ambiguous column name

#3 2016-05-14 02:39:40

Re: Problem with ambiguous column name

#4 2016-05-14 03:38:30

Re: Problem with ambiguous column name

#5 2016-05-14 04:36:34

Re: Problem with ambiguous column name

#6 2016-05-14 06:10:14

Re: Problem with ambiguous column name

#7 2016-05-14 09:07:44

Re: Problem with ambiguous column name

#8 2016-05-14 14:46:23

Re: Problem with ambiguous column name

#9 2016-05-14 15:58:11

Re: Problem with ambiguous column name

#10 2016-05-14 16:06:42

Re: Problem with ambiguous column name

#11 2016-05-14 17:59:30

Re: Problem with ambiguous column name

#12 2016-05-14 23:28:34

Re: Problem with ambiguous column name

#13 2016-05-15 00:41:08

Re: Problem with ambiguous column name

#14 2016-05-15 00:53:29

Re: Problem with ambiguous column name

Board footer