Skip Navigation

[Resolved] Unknown column relationships autodelete_intermediary in field list

This support ticket is created 5 years, 4 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 - -
13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 - -

Supporter timezone: America/New_York (GMT-04:00)

This topic contains 5 replies, has 2 voices.

Last updated by Christian Cox 5 years, 4 months ago.

Assisted by: Christian Cox.

Author
Posts
#1304127

apache/php logs have this in loop:
[30-Jul-2019 15:17:43 UTC] WordPress errore sul database Unknown column 'relationships.autodelete_intermediary' in 'field list' per la query SELECT
relationships.id AS id,
relationships.slug AS slug,
relationships.display_name_plural AS display_name_plural,
relationships.display_name_singular AS display_name_singular,
relationships.driver AS driver,
relationships.parent_domain AS parent_domain,
relationships.child_domain AS child_domain,
relationships.intermediary_type AS intermediary_type,
relationships.ownership AS ownership,
relationships.cardinality_parent_max AS cardinality_parent_max,
relationships.cardinality_parent_min AS cardinality_parent_min,
relationships.cardinality_child_max AS cardinality_child_max,
relationships.cardinality_child_min AS cardinality_child_min,
relationships.is_distinct AS is_distinct,
relationships.scope AS scope,
relationships.origin AS origin,
relationships.role_name_parent AS role_name_parent,
relationships.role_name_child AS role_name_child,
relationships.role_name_intermediary AS role_name_intermediary,
relationships.role_label_parent_singular AS role_label_parent_singular,
relationships.role_label_child_singular AS role_label_child_singular,
relationships.role_label_parent_plural AS role_label_parent_plural,
relationships.role_label_child_plural AS role_label_child_plural,
relationships.needs_legacy_support AS needs_legacy_support,
relationships.is_active AS is_active,
relationships.autodelete_intermediary AS autodelete_intermediary,
relationships.parent_types AS parent_types_set_id,
relationships.child_types AS child_types_set_id,
GROUP_CONCAT(DISTINCT parent_types_table.type) AS parent_types,
GROUP_CONCAT(DISTINCT child_types_table.type) AS child_types
FROM archiviodeigiochi_it_toolset_relationships AS relationships
JOIN archiviodeigiochi_it_toolset_type_sets AS parent_types_table
ON (relationships.parent_types = parent_types_table.set_id )
JOIN archiviodeigiochi_it_toolset_type_sets AS child_types_table
ON (relationships.child_types = child_types_table.set_id )
WHERE ( ( relationships.child_domain = 'posts' ) AND ( child_types_table.type = 'pubblicazione' ) ) AND ( relationships.is_active = 1 ) AND ( ( (
relationships.parent_domain != 'posts'
OR parent_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'wpcf7_contact_form', 'rl_gallery', 'pubblicazione' )
) ) AND ( (
relationships.child_domain != 'posts'
OR child_types_table.type IN ( 'post', 'page', 'attachment', 'oembed_cache', 'user_request', 'wpcf7_contact_form', 'rl_gallery', 'pubblicazione' )
) ) ) AND ( relationships.origin = 'wizard' ) GROUP BY relationships.id fatta da require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/newstube/archive.php'), get_template_part, locate_template, load_template, require('/themes/newstube/html/loop/content.php'), get_the_excerpt, apply_filters('get_the_excerpt'), WP_Hook->apply_filters, wp_trim_excerpt, apply_filters('the_content'), WP_Hook->apply_filters, Toolset_Object_Relationship->record_post_relationship_belongs, Toolset_Object_Relationship->force_record_post_relationship_belongs, wpcf_pr_get_belongs, wpcf_pr_admin_get_belongs, toolset_get_related_post_types, Toolset_Relationship_Query_V2->get_results

We have this software versions:
Toolset Types - 3.2.7
Toolset Views Lite - 2.8.0.1-lite

And the alter table is already present here:
wp-content/plugins/types/vendor/toolset/toolset-common/inc/autoloaded/upgrade/Command/AddRelationshipTableColumnAutodeleteIntermediaryPosts.php

So I supposed we missed an upgrade ?

#1304151

Hi, a private reply field is active here so you can share any download link.

#1304179

Thanks, I'm trying to download now but it keeps stalling out at 110Mb. I'll wait a bit and try again. I just did a quick search on the site and I can see a similar error message and discussion in this ticket:
https://toolset.com/forums/topic/filtering-archive-and-pagination-issue/page/4/

I am linking that ticket here for my team's future reference.

#1304373

Beda's instructions here fixed the fatal error for me locally, can you try the same steps as before?
https://toolset.com/forums/topic/filtering-archive-and-pagination-issue/page/4/#post-1171677

#1308867

This website is single-language, so no WPML.
Wich steps are you referring to? "WPML Reset" guide?

#1308899