[Closed] Database error Relationships Table

[Author]

Posts

[Paul]

Hi there, please see attached screen capture of an error I'm getting in the database relating to Toolset and post relationships.

This keeps occuring and also means that Repeatable groups and Post Relationships, for example, functions in Toolset aren't working.

Is there any advice you can give me to fix this error? I've tried reinstalling Toolset, Types, Views etc but still no joy.

Many thanks

[Minesh]

Hello. Thank you for contacting the Toolset support.

Based on the screenshot you shared - when I checked the screenshot it shows the database table does not exists error.

Have you migrated the site as the repeating field group as well as post relationship details is stored with the "toolset_relationships" table.

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

I do not know the site history so what if you try to create the following database table:

DROP TABLE IF EXISTS `wp_toolset_relationships`;
CREATE TABLE IF NOT EXISTS `wp_toolset_relationships` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` varchar(190) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `driver` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `parent_domain` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `parent_types` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `child_domain` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `child_types` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `intermediary_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `ownership` varchar(8) COLLATE utf8mb4_unicode_520_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_min` int(10) NOT NULL DEFAULT '0',
  `cardinality_child_max` int(10) NOT NULL DEFAULT '-1',
  `is_distinct` tinyint(1) NOT NULL DEFAULT '0',
  `scope` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `origin` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_name_parent` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_name_child` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_name_intermediary` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_parent_singular` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_child_singular` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_parent_plural` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `role_label_child_plural` varchar(255) COLLATE utf8mb4_unicode_520_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`),
  KEY `is_active` (`is_active`),
  KEY `needs_legacy_support` (`needs_legacy_support`),
  KEY `parent` (`parent_domain`,`parent_types`),
  KEY `child` (`child_domain`,`child_types`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

[Paul]

Hello Minesh,

The history of the site is that we used to have Toolset installed a couple of years ago, all of the plugins were deactivated and removed that long ago. I then re-added all the plugins just a couple of weeks ago to start using Types again - it's since then that this happened.

I've tried recreating the table but I'm getting this issue:

CREATE TABLE IF NOT EXISTS `wp_5d15fa9bdfcd0_toolset_relationships` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` varchar(190) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ``,
  `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ``,
  `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ``,
  `driver` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ``,
  `parent_domain` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ``,
  `parent_types` bigint(20) UNSIGNED NOT NULL DEFAULT `0`,
  `child_domain` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ``,
  `child_types` bigint(20) UNSIGNED NOT NULL DEFAULT `0`,
  `intermediary_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ``,
  `ownership` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT `none`,
  `cardinality_parent_max` int(10) NOT NULL DEFAULT `-1`,
  `cardinality_parent_min` int([...]

MySQL said: Documentation
#1054 - Unknown column 'tmp_field' in 'DEFAULT'

Any help would be gratefully appreciated.

[Minesh]

I just checked on my local server phpMyAdmin and the same create table script works.

Can you please share admin access details and let me try to create table.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

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