5
votes
Accepted
Playa broken in MySQL > 5.7.4
So far I've discovered and fixed one case and will add more here if discovered.
File: mod.playa.php
Line: 550
FROM
$sql = 'SELECT DISTINCT(rel.child_entry_id) AS entry_id
TO
$sql = 'SELECT ...
- 692
3
votes
Accepted
Using Playa passing values
I have resolved this by adding the option parse="inward" to the {exp:playa:parents} tag. So my code looks like below
{exp:playa:parents channel="article|blogs|calendar_events|contests|podcasts|...
- 51
2
votes
Accepted
Playa with large number of entries +20,000
Yes. Playa has a useful setting to limit the number of entries that are loaded initially. This helps performance. The user can then search to find additional entries to choose from.
- 7,961
2
votes
Accepted
I'm having trouble getting simple IF statements within a Playa tag to evaluate properly
There are some issues in EE 2.9 with conditionals on prefixed variables and variable modifiers which I don't totally grok. (See bug report here for some discussion.)
But the moral is, try this:
{if '...
- 17.4k
2
votes
Accepted
Playa - PHP error after moving server
See this bug report thread - this error arises when you run 2.5.3 on certain PHP versions. Upgrading to at minimum 2.5.4 should fix this. From the release notes:
Fixed a bug (#18263) where PHP may ...
- 17.4k
2
votes
Accepted
Parsing code in a textarea field pulled in with Playa
Wow! This looks so complex...
Please, try using this first party add-on:
{exp:channel:entries channel="Pages" disable="member_data|pagination|categories|category_fields"}
{exp:playa:children var="...
- 6,108
2
votes
EE3 and Playa - do they work together
Brandon Kelly would definitely list it in a change log if it were released for EE3. I don't think he's actually published a road map for EE3 as of yet, but has tweeted that he is working on EE3-izing ...
- 5,900
2
votes
Accepted
EE3 Relationships VS Playa
I haven't used the latest Playa but the with relationships being native it will stop painful upgrades to the CMS whenever you next upgrade - it's almost always better to rely on core modules then to ...
- 3,163
1
vote
How to show a certain page based on the selection of prior two pages
Let me see if I can help here. I'll discuss how I would approach this and hopefully we can go from there or I'll revise to clarify if needed.
I would probably try to tackle this in one of the ...
- 589
1
vote
Playa broken in MySQL > 5.7.4
I've encountered errors trying to open Playa fields due to the stricter group by rules (https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by)
In ft.playa.php I changed ...
- 111
1
vote
Accepted
Fetch first image of entry?
I've assumed when you refer to "The images are just inserted in the entry" and "So the body-field of an entry", that you are referring to a single text/wysiwyg field in the entry.
You won't be able ...
- 5,353
1
vote
Playa: Complex, nested and filtered
You could use {exp:playa:coparents} to list other parent entries (trips) that share the same child (outpost). Then within that loop, list the activity associated with each trip (I'm assuming you have ...
- 5,234
1
vote
Accepted
Playa in a matrix column P&T example
Looks like our Playa field tag ({neighborhood_plan}) is missing the prefix - it needs that since it's inside of your prefixed Matrix field:
{neighborhood_plans var_prefix="npd" search:...
- 17.4k
1
vote
Replacing Entries: Updating Playa/Wygwam from {page_x} to {page_y}?
Since Publisher is installed it just means whatever is updated in exp_channel_data also needs to occur in exp_publisher_data for each corresponding entry. Same for exp_sites (site_pages column) and ...
- 783
1
vote
How to pass sql entry_ids to playa?
The Query is good. Setting issue unique to my setup on the database itself. Once DB issue was taken care of, everything worked out.
- 167
1
vote
How to pass sql entry_ids to playa?
Turn on template debugging, you should be able to see if the entry id is being passed correctly to the playa tag.
- 1,987
1
vote
Conditional with Low Variables, Matrix and Playa
As with others you've spoken to, I'm very out of practice with EE. However, if you look at the EE manual for conditionals, the way you've written this is recommended against. If you look here, it will ...
- 717
1
vote
Playa Title Changes and Native Search
I've run up a test and can confirm this bug.
Additionally I can see that if you edit/submit (no change) the parent (playa holding) entry the child title is updated.
So in order to fix I beleive the ...
- 2,418
1
vote
Accepted
Playa DB field structure
Searchability.
Storing data in the exp_channel_data table makes the field searchable by the native search module as well as third party add-ons like Low Search.
Additionally, it also allows the ...
- 11.3k
1
vote
Accepted
Playa field in SAEF
You can do that like this:
{if segment_3}
<input type="hidden" name="playa_field_name[selections][]" value="{segment_3}">
{if:else}
{field:playa_field_name}
{/if}
Replace 3 with ...
- 2,931
1
vote
How to deal with 'sort by' on author field (playa) where there are multiple authors
Instead of sorting based on the contents of the TD, it would probably be better to set a data attribute to that TD and sort by that value. So instead of...
<td>2 Authors<br>Joe Bloggs<...
- 1,449
1
vote
no_parents/no_results Using playa entry results based on a url segment, want to display no results
The if no_results is actually referencing the outer exp:channel:entries tag - basically an EE parse order issue.
To test inside playa, you need to use the var_prefix parameter... as in:
{exp:playa:...
- 3,163
1
vote
Accepted
Playa field with the same data
Are you using Stash already? If so, you can use its unique parameter to exclude duplicates. Something like this:
{!-- ====================================
SET
=========================================...
- 4,885
1
vote
Accepted
Stash Playa field from Matrix (context)
Try using row_id and entry_id for the context. You might also need to increase the parse_depth on the outermost stash tag to 4.
{exp:stash:set_list name="patologie_list" parse_tags="yes" parse_depth="...
- 4,885
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
playa × 397matrix × 86
pixelandtonic × 48
relationships × 42
stash × 33
channel-entries × 31
categories × 20
low-variables × 19
ee2 × 18
safecracker × 18
add-on × 17
templates × 16
conditionals × 15
filter × 11
structure × 10
parse-order × 9
zoo-visitor × 8
related-entries × 8
search × 7
assets × 6
multi-site-manager × 6
ee2-upgrades × 6
loop × 6
channel × 5
grid × 5