We use cookies to help make our site work properly and to analyze how our site is used. Some are optional, but none contain your personal information, and we don't use any for ads. You can view our cookies policy, manage your cookie preferences, or consent and dismiss this banner by clicking agree:

Agree

Bug #23755 See Comments

Can’t use newly created Relationship fields

Version: 4.3.6 Reporter: Pontus —

Hi,

We are experiencing some issues with newly created Relationship fields causing the site to crash. Apparently the database takes way too long to finish when the newly created Relationship fields is used (over 9000 seconds).

We discovered this when trying to use the fields as {parents}, example:

{exp:channel:entries
   channel=“serier"
    limit="1"
}
   {parents field="serie"}
      {parents:title}
    {/parents}
{/exp:channel:entries}

Below is one of the queries that caused MySQL to hang up:

SELECT exp_channel_titles.entry_id as ChannelEntry__entry_id, ChannelEntry_field_id_1.field_id_1 as ChannelEntry__field_id_1, ChannelEntry_field_id_1.field_ft_1 as ChannelEntry__field_ft_1, ChannelEntry_field_id_2.field_id_2 as ChannelEntry__field_id_2, ChannelEntry_field_id_2.field_ft_2 as ChannelEntry__field_ft_2, ChannelEntry_field_id_3.field_id_3 as ChannelEntry__field_id_3, ChannelEntry_field_id_3.field_ft_3 as ChannelEntry__field_ft_3, ChannelEntry_field_id_4.field_id_4 as ChannelEntry__field_id_4, ChannelEntry_field_id_4.field_ft_4 as ChannelEntry__field_ft_4, ChannelEntry_field_id_9.field_id_9 as ChannelEntry__field_id_9, ChannelEntry_field_id_9.field_ft_9 as ChannelEntry__field_ft_9, ChannelEntry_field_id_10.field_id_10 as ChannelEntry__field_id_10, ChannelEntry_field_id_10.field_ft_10 as ChannelEntry__field_ft_10, ChannelEntry_field_id_60.field_id_60 as ChannelEntry__field_id_60, ChannelEntry_field_id_60.field_ft_60 as ChannelEntry__field_ft_60, ChannelEntry_field_id_5.field_id_5 as ChannelEntry__field_id_5, ChannelEntry_field_id_5.field_ft_5 as ChannelEntry__field_ft_5, ChannelEntry_field_id_6.field_id_6 as ChannelEntry__field_id_6, ChannelEntry_field_id_6.field_ft_6 as ChannelEntry__field_ft_6, ChannelEntry_field_id_7.field_id_7 as ChannelEntry__field_id_7, ChannelEntry_field_id_7.field_ft_7 as ChannelEntry__field_ft_7, ChannelEntry_field_id_8.field_id_8 as ChannelEntry__field_id_8, ChannelEntry_field_id_8.field_ft_8 as ChannelEntry__field_ft_8, ChannelEntry_field_id_11.field_id_11 as ChannelEntry__field_id_11, ChannelEntry_field_id_11.field_ft_11 as ChannelEntry__field_ft_11, ChannelEntry_field_id_12.field_id_12 as ChannelEntry__field_id_12, ChannelEntry_field_id_12.field_ft_12 as ChannelEntry__field_ft_12, ChannelEntry_field_id_13.field_id_13 as ChannelEntry__field_id_13, ChannelEntry_field_id_13.field_ft_13 as ChannelEntry__field_ft_13, ChannelEntry_field_id_14.field_id_14 as ChannelEntry__field_id_14, ChannelEntry_field_id_14.field_ft_14 as ChannelEntry__field_ft_14, ChannelEntry_field_id_15.field_id_15 as ChannelEntry__field_id_15, ChannelEntry_field_id_15.field_ft_15 as ChannelEntry__field_ft_15, ChannelEntry_field_id_18.field_id_18 as ChannelEntry__field_id_18, ChannelEntry_field_id_18.field_ft_18 as ChannelEntry__field_ft_18, ChannelEntry_field_id_19.field_id_19 as ChannelEntry__field_id_19, ChannelEntry_field_id_19.field_ft_19 as ChannelEntry__field_ft_19, ChannelEntry_field_id_20.field_id_20 as ChannelEntry__field_id_20, ChannelEntry_field_id_20.field_ft_20 as ChannelEntry__field_ft_20, ChannelEntry_field_id_21.field_id_21 as ChannelEntry__field_id_21, ChannelEntry_field_id_21.field_ft_21 as ChannelEntry__field_ft_21, ChannelEntry_field_id_22.field_id_22 as ChannelEntry__field_id_22, ChannelEntry_field_id_22.field_ft_22 as ChannelEntry__field_ft_22, ChannelEntry_field_id_23.field_id_23 as ChannelEntry__field_id_23, ChannelEntry_field_id_23.field_ft_23 as ChannelEntry__field_ft_23, ChannelEntry_field_id_24.field_id_24 as ChannelEntry__field_id_24, ChannelEntry_field_id_24.field_ft_24 as ChannelEntry__field_ft_24, ChannelEntry_field_id_25.field_id_25 as ChannelEntry__field_id_25, ChannelEntry_field_id_25.field_ft_25 as ChannelEntry__field_ft_25, ChannelEntry_field_id_26.field_id_26 as ChannelEntry__field_id_26, ChannelEntry_field_id_26.field_ft_26 as ChannelEntry__field_ft_26, ChannelEntry_field_id_27.field_id_27 as ChannelEntry__field_id_27, ChannelEntry_field_id_27.field_ft_27 as ChannelEntry__field_ft_27, ChannelEntry_field_id_28.field_id_28 as ChannelEntry__field_id_28, ChannelEntry_field_id_28.field_ft_28 as ChannelEntry__field_ft_28, ChannelEntry_field_id_29.field_id_29 as ChannelEntry__field_id_29, ChannelEntry_field_id_29.field_ft_29 as ChannelEntry__field_ft_29, ChannelEntry_field_id_30.field_id_30 as ChannelEntry__field_id_30, ChannelEntry_field_id_30.field_ft_30 as ChannelEntry__field_ft_30, ChannelEntry_field_id_31.field_id_31 as ChannelEntry__field_id_31, ChannelEntry_field_id_31.field_ft_31 as ChannelEntry__field_ft_31, ChannelEntry_field_id_32.field_id_32 as ChannelEntry__field_id_32, ChannelEntry_field_id_32.field_ft_32 as ChannelEntry__field_ft_32, ChannelEntry_field_id_33.field_id_33 as ChannelEntry__field_id_33, ChannelEntry_field_id_33.field_ft_33 as ChannelEntry__field_ft_33, ChannelEntry_field_id_67.field_id_67 as ChannelEntry__field_id_67, ChannelEntry_field_id_67.field_ft_67 as ChannelEntry__field_ft_67, ChannelEntry_field_id_68.field_id_68 as ChannelEntry__field_id_68, ChannelEntry_field_id_68.field_ft_68 as ChannelEntry__field_ft_68, ChannelEntry_field_id_69.field_id_69 as ChannelEntry__field_id_69, ChannelEntry_field_id_69.field_ft_69 as ChannelEntry__field_ft_69, ChannelEntry_field_id_70.field_id_70 as ChannelEntry__field_id_70, ChannelEntry_field_id_70.field_ft_70 as ChannelEntry__field_ft_70, ChannelEntry_field_id_71.field_id_71 as ChannelEntry__field_id_71, ChannelEntry_field_id_71.field_ft_71 as ChannelEntry__field_ft_71, ChannelEntry_field_id_73.field_id_73 as ChannelEntry__field_id_73, ChannelEntry_field_id_73.field_ft_73 as ChannelEntry__field_ft_73, ChannelEntry_field_id_74.field_id_74 as ChannelEntry__field_id_74, ChannelEntry_field_id_74.field_ft_74 as ChannelEntry__field_ft_74, ChannelEntry_field_id_75.field_id_75 as ChannelEntry__field_id_75, ChannelEntry_field_id_75.field_ft_75 as ChannelEntry__field_ft_75, ChannelEntry_field_id_76.field_id_76 as ChannelEntry__field_id_76, ChannelEntry_field_id_76.field_ft_76 as ChannelEntry__field_ft_76, ChannelEntry_field_id_77.field_id_77 as ChannelEntry__field_id_77, ChannelEntry_field_id_77.field_ft_77 as ChannelEntry__field_ft_77, ChannelEntry_field_id_78.field_id_78 as ChannelEntry__field_id_78, ChannelEntry_field_id_78.field_ft_78 as ChannelEntry__field_ft_78, ChannelEntry_field_id_79.field_id_79 as ChannelEntry__field_id_79, ChannelEntry_field_id_79.field_ft_79 as ChannelEntry__field_ft_79, ChannelEntry_field_id_80.field_id_80 as ChannelEntry__field_id_80, ChannelEntry_field_id_80.field_ft_80 as ChannelEntry__field_ft_80, ChannelEntry_field_id_81.field_id_81 as ChannelEntry__field_id_81, ChannelEntry_field_id_81.field_ft_81 as ChannelEntry__field_ft_81, ChannelEntry_field_id_82.field_id_82 as ChannelEntry__field_id_82, ChannelEntry_field_id_82.field_ft_82 as ChannelEntry__field_ft_82, ChannelEntry_field_id_83.field_id_83 as ChannelEntry__field_id_83, ChannelEntry_field_id_83.field_ft_83 as ChannelEntry__field_ft_83, ChannelEntry_field_id_84.field_id_84 as ChannelEntry__field_id_84, ChannelEntry_field_id_84.field_ft_84 as ChannelEntry__field_ft_84, ChannelEntry_field_id_85.field_id_85 as ChannelEntry__field_id_85, ChannelEntry_field_id_85.field_ft_85 as ChannelEntry__field_ft_85FROM (`exp_channel_titles`)LEFT JOIN `exp_channel_data_field_1` AS ChannelEntry_field_id_1 ON `ChannelEntry_field_id_1`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_2` AS ChannelEntry_field_id_2 ON `ChannelEntry_field_id_2`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_3` AS ChannelEntry_field_id_3 ON `ChannelEntry_field_id_3`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_4` AS ChannelEntry_field_id_4 ON `ChannelEntry_field_id_4`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_9` AS ChannelEntry_field_id_9 ON `ChannelEntry_field_id_9`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_10` AS ChannelEntry_field_id_10 ON `ChannelEntry_field_id_10`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_60` AS ChannelEntry_field_id_60 ON `ChannelEntry_field_id_60`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_5` AS ChannelEntry_field_id_5 ON `ChannelEntry_field_id_5`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_6` AS ChannelEntry_field_id_6 ON `ChannelEntry_field_id_6`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_7` AS ChannelEntry_field_id_7 ON `ChannelEntry_field_id_7`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_8` AS ChannelEntry_field_id_8 ON `ChannelEntry_field_id_8`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_11` AS ChannelEntry_field_id_11 ON `ChannelEntry_field_id_11`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_12` AS ChannelEntry_field_id_12 ON `ChannelEntry_field_id_12`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_13` AS ChannelEntry_field_id_13 ON `ChannelEntry_field_id_13`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_14` AS ChannelEntry_field_id_14 ON `ChannelEntry_field_id_14`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_15` AS ChannelEntry_field_id_15 ON `ChannelEntry_field_id_15`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_18` AS ChannelEntry_field_id_18 ON `ChannelEntry_field_id_18`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_19` AS ChannelEntry_field_id_19 ON `ChannelEntry_field_id_19`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_20` AS ChannelEntry_field_id_20 ON `ChannelEntry_field_id_20`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_21` AS ChannelEntry_field_id_21 ON `ChannelEntry_field_id_21`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_22` AS ChannelEntry_field_id_22 ON `ChannelEntry_field_id_22`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_23` AS ChannelEntry_field_id_23 ON `ChannelEntry_field_id_23`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_24` AS ChannelEntry_field_id_24 ON `ChannelEntry_field_id_24`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_25` AS ChannelEntry_field_id_25 ON `ChannelEntry_field_id_25`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_26` AS ChannelEntry_field_id_26 ON `ChannelEntry_field_id_26`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_27` AS ChannelEntry_field_id_27 ON `ChannelEntry_field_id_27`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_28` AS ChannelEntry_field_id_28 ON `ChannelEntry_field_id_28`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_29` AS ChannelEntry_field_id_29 ON `ChannelEntry_field_id_29`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_30` AS ChannelEntry_field_id_30 ON `ChannelEntry_field_id_30`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_31` AS ChannelEntry_field_id_31 ON `ChannelEntry_field_id_31`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_32` AS ChannelEntry_field_id_32 ON `ChannelEntry_field_id_32`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_33` AS ChannelEntry_field_id_33 ON `ChannelEntry_field_id_33`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_67` AS ChannelEntry_field_id_67 ON `ChannelEntry_field_id_67`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_68` AS ChannelEntry_field_id_68 ON `ChannelEntry_field_id_68`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_69` AS ChannelEntry_field_id_69 ON `ChannelEntry_field_id_69`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_70` AS ChannelEntry_field_id_70 ON `ChannelEntry_field_id_70`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_71` AS ChannelEntry_field_id_71 ON `ChannelEntry_field_id_71`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_73` AS ChannelEntry_field_id_73 ON `ChannelEntry_field_id_73`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_74` AS ChannelEntry_field_id_74 ON `ChannelEntry_field_id_74`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_75` AS ChannelEntry_field_id_75 ON `ChannelEntry_field_id_75`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_76` AS ChannelEntry_field_id_76 ON `ChannelEntry_field_id_76`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_77` AS ChannelEntry_field_id_77 ON `ChannelEntry_field_id_77`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_78` AS ChannelEntry_field_id_78 ON `ChannelEntry_field_id_78`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_79` AS ChannelEntry_field_id_79 ON `ChannelEntry_field_id_79`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_80` AS ChannelEntry_field_id_80 ON `ChannelEntry_field_id_80`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_81` AS ChannelEntry_field_id_81 ON `ChannelEntry_field_id_81`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_82` AS ChannelEntry_field_id_82 ON `ChannelEntry_field_id_82`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_83` AS ChannelEntry_field_id_83 ON `ChannelEntry_field_id_83`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_84` AS ChannelEntry_field_id_84 ON `ChannelEntry_field_id_84`.`entry_id` = `exp_channel_titles`.`entry_id`LEFT JOIN `exp_channel_data_field_85` AS ChannelEntry_field_id_85 ON `ChannelEntry_field_id_85`.`entry_id` = `exp_channel_titles`.`entry_id`WHERE `exp_channel_titles`.`entry_id` IN (3, 4, 16)

This is quite serious, since it makes this a server wide issue (other sites crashed because of this). MySQL also hangs up when trying to delete the relationship field.

We are running on a fresh install of 4.3.6 and old relationship fields are still functioning. The only difference is that we have installed the addon EEHARBOR User 5.0.9 since then.

Do you know what may be causing this? We can give you full access to the server if it may help.

Best regards Oskar

Report Bug

Sort Bugs

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases

© Packet Tide, All Rights Reserved. Legal Notices

Formatting Cheatsheet

ExpressionEngine implements Markdown Extra and BBCode. Please see the Markdown Extra docs and the BBCode Wikipedia article for a full reference.

Inline styles

**bold**, __bold__, *italics*, _italics_, ~strike/del~, `code()`
bold, italics, strike/del, code()

Links and Images

Link: [link title](https://example.com)

Image: ![alt text](https://example.com/image.jpg)

Quoting

[blockquote]...[/blockquote], [quote]...[/quote], and Markdown style:

> Some quoted text.
>
> This is all one quote.

Code Samples

[code]...[/code], and you can also specify the language for syntax highlighting, [code=php]...[/code]

GitHub flavored Markdown code fences are also supported:

```
public function decoderRing($str)
{
	return str_rot13($str);
}
```

Username

Password

Forgot password?
or Register