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.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

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, 5 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.