Skip to main content
Share Your Experience: Take the 2024 Developer Survey
9 votes
Accepted

Assets errors with MySQL 5.7.X

The problem is that many developers don't know how to write compliant SQL statements - they're software developers who find themselves also filling the role of database developers. This problem crops ...
Paul's user avatar
  • 692
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 ...
Paul's user avatar
  • 692
3 votes

How can I add an ampersand (or similar) following all but the final entry in a Matrix loop?

I think the best way achieve this is to do by adding CSS. For that you just need to create one class pipe containing the + sign (either with an image or with color). Then put that pipe class on ...
Harsh Barach's user avatar
2 votes
Accepted

Limit S3 Upload Size in P&T Assets?

Sorry, Kristen, Assets does not have that feature.
Andris Sevcenko's user avatar
2 votes

Display only unique values from a Matrix column

Well, the query module gives you direct access to SQL querying your database tables, so this seem quite possible. It depends on the complexity: Are you looking to isolate rows based on a unique column?...
jrothafer's user avatar
  • 5,900
1 vote
Accepted

How can I add an ampersand (or similar) following all but the final entry in a Matrix loop?

if you change this {if total_results >= "1"} + {/if} to this {if count != total_results} + {/if} Then you will get the "+" if there are multiple and it will ...
Jim Wyse's user avatar
  • 1,987
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 ...
Pete Smith's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible