Plugin

Developer
Supported

Tied Entries

ExpressionEngine 2

Back to this add-on's main page
View Other Add-ons From Adam Khan

     

You must be logged in to post.

Displaying data

General

Lulu
Lulu

Hi, I have a gallery website with channels ‘artists’ and ‘artworks’.
Artworks have a custom relationship field, called ‘artist-relationship’ with artists.

On the artist page I would like to display the related artworks for that particular artist. How do I do that?

I have tried numerous thing’s but I keep getting nothing or mysql errors.

Lulu
# 1
Lulu

At the moment I have:

{exp:channel:entries channel="artists" require_entry="yes" url_title="{segment_2}" dynamic="yes" limit="1"}

   {exp
:tied_entries entry_id="{entry_id}" tie="<artworks" limit="10" orderby="title" sort="asc"}
      {tied
:title}
   {
/exp:tied_entries}

{
/exp:channel:entries} 

And getting error:

Error Number1064

You have an error in your SQL syntax
check the manual that corresponds to your MySQL server version for the right syntax to use near '196) ORDER BY d.entry_id' at line 1

SELECT r
.parent_entry_id AS result_id FROM exp_channel_data AS dexp_playa_relationships AS r WHERE d.channel_id AND r.parent_entry_id d.entry_id AND r.child_entry_id IN 196ORDER BY d.entry_id ;

Filenamethird_party/tied_entries/pi.tied_entries.php

Line Number
555 
Adam Khan
# 2
Developer
Adam Khan

My apologies Louis, I didn’t get the notification that you posted in this thread. There’s a new version of the plugin, v1.5, that should fix this problem.

-Adam