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

[Author]

Posts

[joeW-3]

Thanks. I talked with the WPEngine folks and they feel it is a plugin issue and not a platform/environment issue. If there is something specific I need to ask them, please let me know. Since I'm not getting the issue on all sites with WPEngine, I don't think it is with their environment.

[joeW-3]

Sorry for the large number of posts. But trying to get to the bottom of this before I leave for the morning. I went in and made a site duplicate. I deactivated the Twentyseventeen integration plugin, changed the theme to Twentyfifteen and then updated to the latest Toolset plugins. Still getting the same error message.

[Minesh]

Well - the error could be there as the missing columns were added with Types version 3.1 so the issue could be from there as when you tried to update Types to 3.1 before those columns were not added.

Could you please share test site so I can try to add those missing columns manually and that may help you to resolve your issue.

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

[joeW-3]

I've made a backup of this site, so you can use the information above. Though the site is technically live, it is unannounced and undergoing changes before an official launch. So, it should be fine to tinker with.

[Minesh]

Well - just to wanted to double check with you that you took the complete backup of your site so in the worst case if it is broken you can use the backup.

[joeW-3]

Yes. Site is fully backed up, both content and database, and can be restored within 5 minutes. Please break away if needed...

[joeW-3]

FYI, for whatever reason, the error is not happening on all sites, even those running the same theme and plugins.
This site (hidden link) uses the same setup, same theme, and same retired Toolset plugin to allow Layouts to control the entire theme, and it appears to have updated fine.

[Minesh]

Yes - so this is as I suspected, the current install is somehow broken/corrupted due to whatever reason that we do not know.

Finally, I've added those missing columns as marked with the following screenshot to the database table "wp_toolset_relationships" and now to me it looks OK:
=> hidden link

Could you please confirm the notice you see is gone and everything is fine at your end.

[joeW-3]

Confirmed. Things appear to be working as expected and no errors. Is there an easy way for me to add these same tables to the two other websites? I have the same error message on alconcrete.org and atrcaging.com. Thanks!

[Minesh]

Well - Considering that you do not created any relationship, I mean your "wp_toolset_relationships" table does not contain any data.

*** Please make a FULL BACKUP of your database and website.***
please try to run following query on your database:

 DROP TABLE IF EXISTS `wp_toolset_relationships`; CREATE TABLE `wp_toolset_relationships` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `driver` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `parent_domain` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `parent_types` bigint(20) unsigned NOT NULL DEFAULT '0', `child_domain` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `child_types` bigint(20) unsigned NOT NULL DEFAULT '0', `intermediary_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ownership` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none', `cardinality_parent_max` int(10) NOT NULL DEFAULT '-1', `cardinality_parent_min` int(10) NOT NULL DEFAULT '0', `cardinality_child_max` int(10) NOT NULL DEFAULT '-1', `cardinality_child_min` int(10) NOT NULL DEFAULT '0', `is_distinct` tinyint(1) NOT NULL DEFAULT '0', `scope` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `origin` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `role_name_parent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `role_name_child` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `role_name_intermediary` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `role_label_parent_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `role_label_child_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `role_label_parent_plural` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `role_label_child_plural` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `needs_legacy_support` tinyint(1) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '0', `autodelete_intermediary` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `slug` (`slug`(191)), KEY `is_active` (`is_active`), KEY `needs_legacy_support` (`needs_legacy_support`), KEY `parent_type` (`parent_domain`,`parent_types`), KEY `child_type` (`child_domain`,`child_types`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

*** Please make a FULL BACKUP of your database and website.***

That's it. I hope the above solution will help you to resolve your issue. 🙂 Have a great weekend.

[Minesh]

Could you please confirm that the solution I shared help you to resolve your issue.

[joeW-3]

Sorry for the delay in response. The issue is resolved on the one site that you worked on directly. Could you explain exactly how to run the query? I don't use MYSQL but infrequently. Screenshot of my interface attached. Sorry. And thanks again for the help.

[Minesh]

Well - first of all:
*** Please make a FULL BACKUP of your database and website.*** - really important 🙂

Then, once you selected your database, select "SQL" tab and copy paste the query which I shared with you in the empty box and click on "Go" button. Please check the following screenshot:
=> hidden link

Here I shared the query you need to copy/paste:
=> https://toolset.com/forums/topic/unknown-column-is_active-in-wp_toolset_relationships/page/2/#post-1161655

[joeW-3]

Wonderful. That worked perfectly. Thanks so much for the help. I'll close the ticket now. Thanks again for helping me with this issue!

[joeW-3]

My issue is resolved now. Thank you!