Are you using Publisher? Is this error happening on the front-end or when doing a Live Preview in the CP?

The ext.bloqs.php file has the following method at line 127:

public function relationships_query($fieldName, $entry_ids, $depths, $sql)

Change the beginning of it to this instead and see if that fixes it (you’re adding the str_replace part)

public function relationships_query($fieldName, $entry_ids, $depths, $sql)
    {
        // We only want to use this hook when previewing...
        if (!ee('LivePreview')->hasEntryData()) {
            $sql = str_replace(
                'child_id, order',
                'child_id, `order`',
                $sql
            );

            return ee('db')->query($sql)->result_array();
        }

Sure, edit the ticket and provide FTP info to a dev site, and make sure that the publisher files are writable. Provide entry_id of an entry that I can use to replicate the issue, and the URL to where I can see it on the front-end.

Try now… I really need to fix that bug on my own site :/

No, just add it as a private comment. I’d rather not have people’s FTP info in my inbox 😊

Does the repeated block issue sound like this? https://boldminded.com/support/ticket/1877

Create a new ticket for that issue, include as much information as possible, and break it down into a repeatable case in a template with nothing else in it, no snippets, embeds, etc, only the code necessary to replicate the issue. Same as before, provide the entry_id and the URL in which I can see the error happen on the front end.

It’s doubling part of the query string for some reason prior to it being executed.

This one works fine…

string(458) "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
FROM (`exp_relationships` as L0)
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 (13) 
ORDER BY `L0`.`order` asc"

This is the one failing…

string(898) "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 (13) 
AND `L0`.`fluid_field_data_id` =  0
AND `L0`.`grid_field_id` IN (1, '0') 
AND `L0`.`grid_row_id` IN (13) 
ORDER BY `L0`.`order` asc, `L0`.`order` asc"

So, at its core, this is an EE issue. I submitted a PR that fixes it… you can make the code change in EE directly since it’s a very simple fix.

https://github.com/ExpressionEngine/ExpressionEngine/pull/24