[Resolved] Unknown column ‘is_active’ in ‘wp_toolset_relationships’

[Author]

Posts

[joeW-3]

I am trying to: use Toolset

I get the following error message: Oops! There's been a problem when upgrading Toolset data structures. Please make sure your current configuration allows WordPress to alter database tables.If the problem persists, please don't hesitate to contact our support with this technical information:

Unknown column 'is_active' in 'wp_toolset_relationships'

This is happening after updating my Toolset plugins on some of my WPEngine website installs, at least the ones that are using Toolset's modified TwentySeventeen. Deactivating this plugin does not correct the issue though.

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - could you please share more information that which migration of relationships you were trying to follow?

Is it one-to-many or could you please share exact steps you follow that lead you to this error?

[joeW-3]

I actually have not set up ANY relationships using the relationship section in Toolset, and don't need to do so. The error happened after I updated to the latest version of Toolset.

[Minesh]

Could you please tell me where exactly you see the error you mentioned after update of Toolset plugins?

[joeW-3]

It is at the top of every page on the admin side of the website. Attached screenshot.

[joeW-3]

It is also happening on hidden link. I pulled this from my error logs.
[Tue Dec 04 10:44:13.709985 2018] [:error] [pid 20895] [client 213.174.152.187:23865] WordPress database error Unknown column 'is_active' in 'wp_toolset_relationships' for query ALTER TABLE `wp_toolset_relationships`\n\t\t\tADD `autodelete_intermediary` TINYINT(1) NOT NULL DEFAULT '1' AFTER `is_active` /* From [alconcrete.org/products/permeable-pavers/feed/] in [/nas/content/live/alconcrete/wp-content/plugins/types/vendor/toolset/toolset-common/inc/autoloaded/upgrade/Command/AddRelationshipTableColumnAutodeleteIntermediaryPosts.php:79] */ made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Types_Main->after_setup_theme, Toolset_Common_Bootstrap::get_instance, Toolset_Common_Bootstrap->__construct, do_action('toolset_common_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Toolset_Upgrade_Controller->check_upgrade, Toolset_Upgrade_Controller->do_upgrade, OTGS\\Toolset\\Common\\Upgrade\\Command\\AddRelationshipTableColumnAutodeleteIntermediaryPosts->run, OTGS\\Toolset\\Common\\Upgrade\\Command\\AddRelationshipTableColumnAutodeleteIntermediaryPosts->update_relationships_table
[Tue Dec 04 10:44:14.198751 2018] [php7:notice] [pid 9064] [client 104.197.105.53:25712] WordPress database error Unknown column 'is_active' in 'wp_toolset_relationships' for query ALTER TABLE `wp_toolset_relationships`\n\t\t\tADD `autodelete_intermediary` TINYINT(1) NOT NULL DEFAULT '1' AFTER `is_active` /* From [alconcrete.org/wp-cron.php?doing_wp_cron=1543920253.8416340351104736328125] in [/nas/content/live/alconcrete/wp-content/plugins/types/vendor/toolset/toolset-common/inc/autoloaded/upgrade/Command/AddRelationshipTableColumnAutodeleteIntermediaryPosts.php:79] */ made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('after_setup_theme'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Types_Main->after_setup_theme, Toolset_Common_Bootstrap::get_instance, Toolset_Common_Bootstrap->__construct, do_action('toolset_common_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Toolset_Upgrade_Controller->check_upgrade, Toolset_Upgrade_Controller->do_upgrade, OTGS\\Toolset\\Common\\Upgrade\\Command\\AddRelationshipTableColumnAutodeleteIntermediaryPosts->run, OTGS\\Toolset\\Common\\Upgrade\\Command\\AddRelationshipTableColumnAutodeleteIntermediaryPosts->update_relationships_table, referer: hidden link

[Minesh]

This is for sure looks like specific to your install as I also just updated Toolset plugins on my test install to the latest version and I do not able to reproduce the issue.

Could you please send me access details so I can investigate further.

I have set the next reply to private which means only you and I have access to it.

[joeW-3]

I will need to be able to replicate the solution on at least 3 other sites built with the same theme and basic setup that are getting the same error, by the way. And thanks for the help!

[Minesh]

Well - I checked and it looks like database update is not been performed when you update the plugins (I'm not sure if the issue is from this update or it happens when you update Toolset plugins before.). There may be the possibility that there isn't enough permission to make changes with the database table when you update the plugins as no other user reported such issue yet. So it looks like specific to your install.

I checked the "wp_toolset_relationships" table on your install and I see there are many table columns missing,as you can see with the following screenshots when you compare your "wp_toolset_relationships" table:
=> hidden link

All your sites hosted on the same server - could you please try to check with another server or local server?

Could you please test once and I will check with Devs what we can do here.

[joeW-3]

I'll open a ticket with my webhost too, The issues are happening on WPEngine. I've migrated all my sites to their servers. I'll update you once I hear back from them, but it will probably be later this afternoon (8 a.m. here) as I have to go out for a few hours.

[Minesh]

It's OK - I'm closing her for the day, even I will get back to tomorrow, please update me as it looks like there is not enough permission to update the database with your hosting authority.

[joeW-3]

Is there a way to "turn off" the relationships portion of Toolset? I don't use it for anything (it seems awesome, but not really something I use.) I'm checking with host now.
It does not appear to be happening on all my sites.

[joeW-3]

FYI, the issue appears as soon as I update Views. I've deactivated all my other plugins on a test server and the error persists. I'm not getting the same error on every site on the server, but do get it on all the sites that have been built using the Twentyseventeen Theme and the now retired Toolset Twenty Seventeen Integration. But after deactivating that plugin, the issue persists. (and I need that plugin to continue working as I rely on it for the design of these sites...)

[Minesh]

No - there is no such feature available to disable the post-relationship.

[joeW-3]

I went through and deactivated all the plugins on the site. Leaving only the three toolset plugins (Types, Views and Layouts) active, the error persists. I changed the default theme to Twentyfifteen. The error remains. I deactivated all but Types and the error remains. Once deactivating Types, the error disappears. It doesn't appear to cause visual issues on the front end of the website right now, though.

I have these same plugins on another site (aosbirds.org) and do not have the same issues, but it uses a different theme.