EE4 compatibility updates:

  • Publisher is EE4 and EE5 compatible, but it does not currently support the Fluid field.
  • 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 violation1066 Not unique table/alias'L0':
SELECT DISTINCT L0.field_id as L0_fieldL0.grid_field_id as L0_grid_field_idL0.grid_col_id as L0_grid_col_idL0.grid_row_id as L0_grid_row_idL0.parent_id AS L0_parentL0.child_id as L0_idL0.orderL0.field_id as L0_fieldL0.grid_field_id as L0_grid_field_idL0.grid_col_id as L0_grid_col_idL0.grid_row_id as L0_grid_row_idL0.grid_row_id AS L0_parentL0.child_id as L0_idL0.order FROM (`exp_relationships` as L0, `exp_relationships` as L0LEFT 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` = AND `L0`.`grid_field_id` = AND `L0`.`parent_idIN (18) AND `L0`.`fluid_field_data_id` = AND `L0`.`grid_field_idIN (14'0') AND `L0`.`grid_row_idIN (18ORDER BY `L0`.`orderasc, `L0`.`orderasc 

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! smile

#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.