I am trying to: Database upgrade
Link to a page where the issue can be seen:
I expected to see:
Instead, I got: an error occurred
Here is the verbose output "technical information" window :
> The upgrade process is starting...
> Precondition "correct database layer mode"... OK
> Precondition "toolset_associations table exists"... OK
> Precondition "toolset_associations_old table is not yet present (indicates manual database manipulation)"... OK
> Precondition "toolset_associations_new table is not yet present (indicates interrupted upgrade process)"... OK
> Precondition "toolset_connected_elements table is not yet present"... OK
> Precondition "able to create a new database table"... OK
> Precondition "able to delete a database table"... OK
> Precondition "WPML not active or in a good version (4.4.0 or above)"... OK
> Temporary migration tables have been removed if they existed.
> Clearing persisted migration state if it exists from previous attempts.
> Unable to create table "wp_toolset_associations_new".; Unable to create table "wp_toolset_connected_elements".
> The backup association table "wp_toolset_associations_old" doesn't exist, unable to perform rollback.
> Retrying the database upgrade...
> Precondition "correct database layer mode"... OK
> Precondition "toolset_associations table exists"... OK
> Precondition "toolset_associations_old table is not yet present (indicates manual database manipulation)"... OK
> Precondition "toolset_associations_new table is not yet present (indicates interrupted upgrade process)"... OK
> Precondition "toolset_connected_elements table is not yet present"... OK
> Precondition "able to create a new database table"... OK
> Precondition "able to delete a database table"... OK
> Precondition "WPML not active or in a good version (4.4.0 or above)"... OK
> Temporary migration tables have been removed if they existed.
> Clearing persisted migration state if it exists from previous attempts.
> Unable to create table "wp_toolset_associations_new".; Unable to create table "wp_toolset_connected_elements".
> The backup association table "wp_toolset_associations_old" doesn't exist, unable to perform rollback.
Hi,
Thank you for contacting us and I'd be happy to assist.
An error like this can be faced if the database user assigned to WordPress, doesn't have permission to make changes to the website's tables.
You can consult your hosting support team to make sure that this user has full permission to make changes to the database tables. If the server/hosting doesn't allow this, you can clone your website and temporarily transfer it to a different server.
( it can be any server including a localhost )
On that clone website, you can complete the relationship migration process and once completed, transfer it back to the original server.
Officially we use and recommend the following two plugins to migrate/clone websites safely:
1. Duplicator – WordPress Migration Plugin
https://wordpress.org/plugins/duplicator/
2. All-in-One WP Migration
https://wordpress.org/plugins/all-in-one-wp-migration/
I hope this helps and please let me know if you need further assistance.
regards,
Waqar