Tied Entries
ExpressionEngine 2
Back to this add-on's main page
View Other Add-ons From Adam Khan
Displaying data
General
Lulu
|
Posted: 08 September 2011 09:12 AM |
|
|
|
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
|
Posted: 08 September 2011 09:37 AM |
# 1
|
|
|
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 Number: 1064
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 d, exp_playa_relationships AS r WHERE d.channel_id = 5 AND r.parent_entry_id = d.entry_id AND r.child_entry_id IN 196) ORDER BY d.entry_id ;
Filename: third_party/tied_entries/pi.tied_entries.php
Line Number: 555
|
|
|
Adam Khan
|
Posted: 14 December 2011 08:24 PM |
# 2
|
|
Developer
|
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
|
|
|
samuelddarden
|
Posted: 06 January 2021 09:50 PM |
# 3
|
|
|
–
|
|
|