I am trying to: activate the plugins after just purchasing it.
Link to a page where the issue can be seen: hidden link
I expected to see:
An activated plugin
Instead, I got:
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:
Unable to create table Vfj82U_toolset_associations due to a MySQL Error: Unable to create table Vfj82U_toolset_relationships due to a MySQL Error: Unable to create table Vfj82U_toolset_type_sets due to a MySQL Error: Changed type of Vfj82U_toolset_type_sets.id from bigint unsigned to BIGINT(20) UNSIGNED Changed type of Vfj82U_toolset_type_sets.set_id from bigint unsigned to BIGINT(20) UNSIGNED Changed type of Vfj82U_toolset_type_sets.type from varchar(20) to VARCHAR(20) Unknown column 'display_name' in 'vfj82u_toolset_relationships' Can't DROP 'extra'; check that column/key exists Duplicate key name 'is_active' 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.
If you want to go into the site and have a look I have created a user.
UN toolsetu8Xn
PW ^weHD8$5J#CHySu8Xn
It is a development site so no harm can be done to data.
For testing, I did change the wp-config to use mysql root but this didn't resolve it. This has now been reverted!
The server is Windows Essential Server 2012, running mysql, and the version of PHP is 7.4.11
If you need any other information please get in touch.
Regards
Paul Tunnicliffe
Hello,
Thanks for the details, I can see the problem in your website.
And you are using uppercase in the database table prefix "Vfj82U_", according to mysql document:
hidden link
To avoid problems caused by such differences, it is best to adopt a consistent convention, such as always creating and referring to databases and tables using lowercase names.
...
Table names are stored in lowercase on disk and name comparisons are not case-sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.
I suggest you try these:
Find and edit the wp-config.php of your website root folder, replace this line from:
$table_prefix = 'Vfj82U_';
With:
$table_prefix = 'vfj82u_';
And test again
