[Resolved] upgrading Toolset data structures

[Author]

Posts

[garyF-3]

Added new Types 3.0

Got this 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:

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 'db_dom25784.wp_toolset_relationships' doesn't exist Table 'db_dom25784.wp_toolset_relationships' doesn't exist Table 'db_dom25784.wp_toolset_relationships' doesn't exist Table 'db_dom25784.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.

[Luo Yang]

Hello,

In the debug logs you provided above:

Table  'db_dom25784.wp_toolset_relationships' doesn't exist.

That database table "wp_toolset_relationships" is required for the Types 3.0, it seems the the mysql user account of your website is not able to create the new table, please try this:
1) Create a new mysql user, and grant all privilege to your database "db_dom25784"
https://stackoverflow.com/questions/1720244/create-new-user-in-mysql-and-give-it-full-access-to-one-database

2) Edit the file "wp-config.php" in your website root folder, and change the MySQL database username and password, then test again
https://codex.wordpress.org/Editing_wp-config.php#Set_Database_User

[garyF-3]

I have checked with my hosting service and they have confirmed that the current user does indeed have access to the database. They are saying this isn't the issue.

Please advice.

[garyF-3]

I have the same problem now on another site where I have upgraded to Types 3.0

[garyF-3]

Hi, just seen this thread which highlights the same issue - https://toolset.com/forums/topic/problem-with-update-toolset-types/

[Luo Yang]

It is a known issue of Types plugin, I have escalated this thread to our 2nd tier supporters, will update this thread if there is anything news.

[Luo Yang]

Thanks for the details, it is a known problem, I have escalated this thread to our 2nd tier supporters, our developers will take care it, it should be fixed soon, I will update this thread if there is anything news.

[Nigel]

Hi Gary

Can I jump in here to ask if it is okay for one of the developers to go into your site backend and "nose around a bit".

It looks like this is a site in development rather than a live production site.

Naturally they won't be doing anything to break your site, but you should have a current backup in any case.

Please let me know.

[garyF-3]

Yes go ahead

[Luo Yang]

Thanks, our developers are working on it, I will update this thread if there is anything news.

[garyF-3]

Hi, it seems that your developers have solved the problem. Can you let me know how because this affected other sites of mine.

[Luo Yang]

I have checked it in our to-do list, it is in the to-do list of Types plugin 3.0.1, which is not released yet.

And our Developer finalized a Beta version of Toolset Types that should solve this issue.
You can grab it here:
hidden link

Please acknowledge that this is a beta version, that is not suggested to be used on any kind of live site or important site but only, and solely, on test or beta installs.