Skip Navigation

[Resolved] Problem with update Toolset Types – table wp_toolset_relationships doesn’t exist

This thread is resolved. Here is a description of the problem and solution.

Problem: I am trying to update to Types 3.0 but I'm seeing an error message that the wp_toolset_relationships table doesn't exist.

Solution: Update to Types 3.0.1

This support ticket is created 6 years, 5 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)

Tagged: 

This topic contains 10 replies, has 3 voices.

Last updated by johnB-37 6 years, 4 months ago.

Assisted by: Christian Cox.

Author
Posts
#908529

Hi there,
I'm receiving a similar error message. I deactivated all plugins except Types 3.0 and changed my theme to 2017 but I still see the same error message.

Changed type of wp_toolset_type_sets.id from bigint(20) unsigned to BIGINT(20) UNSIGNED Changed type of wp_toolset_type_sets.set_id from bigint(20) unsigned to BIGINT(20) UNSIGNED Changed type of wp_toolset_type_sets.type from varchar(20) to VARCHAR(20) Table 'pantheon.wp_toolset_relationships' doesn't exist Table 'pantheon.wp_toolset_relationships' doesn't exist Table 'pantheon.wp_toolset_relationships' doesn't exist Table 'pantheon.wp_toolset_relationships' doesn't exist Duplicate column name 'relationship_id' Can't DROP 'relationship'; check that column/key exists Duplicate key name 'relationship_id' The m2m-v1 database structure upgrade to m2m-v2 seems to have failed.
#908531

Hi, I split your issue into a separate ticket so we can discuss it in more detail. I need to escalate this problem to my 2nd tier support team, so I'd like to log in to your wp-admin area and create a clone of the site. If that's okay, please provide login credentials in the private reply fields here and I will take a look.

#909021

Okay thank you, can you tell me if you had any post relationships set up before you updated to Types 3? It appears not - I do not see any information in the database that uses the legacy relationship method, but I wanted to confirm.

#909027

I didn't used any post relationships set up before I updated.

#909034

Thank you. @johnB-37, can you provide the same information?

#909039

I did not have any relationships set up.

#909138

Thank you, our developers are aware of the issue and working towards releasing a fix. I will keep you updated here and let you know when the final version is available. If you want you can try testing the fix with this version of Types: hidden link

Please note this hasn't gone through full testing yet, so I don't recommend using it on a live production site, only for testing. If you want to install it you should make sure you have a full backup prior first in case you find anything goes wrong.

#909362

Our developers have released an erratum post here: https://toolset.com/errata/error-notice-after-upgrading-to-types-3-0/

I'll update you here when a new release is available.

#911819

Hi, Types 3.0.1 is now available for download at https://toolset.com/account/downloads

Please install the latest version of the plugin and let me know if the issue is not fully resolved.

#912179

Hi
The issue seems to be fully resolved 🙂

Thanks for help.

Best regards!
Zbigniew

#913571

This is working for me, thank you.