Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Relationship Field Issues

Status Resolved
Add-on / Version Bloqs 4.0.13
Severity
EE Version 5.0.1

Lea Alcantara

Dec 06, 2018

Hi there! I always get this weird error _only_ on the Bloq that has native EE Relationships field:

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'L0':
SELECT DISTINCT L0.field_id as L0_field, L0.grid_field_id as L0_grid_field_id, L0.grid_col_id as L0_grid_col_id, L0.grid_row_id as L0_grid_row_id, L0.parent_id AS L0_parent, L0.child_id as L0_id, L0.order, L0.field_id as L0_field, L0.grid_field_id as L0_grid_field_id, L0.grid_col_id as L0_grid_col_id, L0.grid_row_id as L0_grid_row_id, L0.grid_row_id AS L0_parent, L0.child_id as L0_id, L0.order FROM (`exp_relationships` as L0, `exp_relationships` as L0) LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL LEFT JOIN `exp_relationships` as L1 ON `L0`.`child_id` = `L1`.`parent_id` OR L1.parent_id = NULL WHERE `L0`.`fluid_field_data_id` = 0 AND `L0`.`grid_field_id` = 0 AND `L0`.`parent_id` IN (18) AND `L0`.`fluid_field_data_id` = 0 AND `L0`.`grid_field_id` IN (14, '0') AND `L0`.`grid_row_id` IN (18) ORDER BY `L0`.`order` asc, `L0`.`order` asc

I have other bloq types that work just fine (all other fieldtypes). Hiding just this field bloq renders the page as expected.

Here’s the template code (not actual production but basically close enough):

{related_bloq}
                {relationship_field}
                <li>{relationship_field:title}</li>
                {/relationship_field}
    {/related_bloq}
#1

BoldMinded (Brian)

Hi, Lea! See if comment #19 in this ticket fixes your issue. https://boldminded.com/support/ticket/1881

#2

Lea Alcantara

Yay, thanks Brian. That seems to have sorted everything out! 😊

#3

BoldMinded (Brian)

Sweet! I like bug reports like this :D

Login to reply