Be sure to checkout our newest add-on Reading Time Pro!

EE4 compatibility updates:

  • Publisher is EE4 and EE5 compatible, but it does not currently support the Fluid field (it's in the works).
  • Reel is EE4 and EE5 compatible, but it does not currently support the Fluid field.

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)

Dec 07, 2018

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

#2

Lea Alcantara

Dec 07, 2018

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

#3

BoldMinded (Brian)

Dec 07, 2018

Sweet! I like bug reports like this :D

Login to reply

Contact

For add-on support, please use the Support section. General inquries and pre-sale questions can be sent to support@boldminded.com.