Skip Navigation

[Resolved] Error Creating new temporary database tables (database migration)

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
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Karachi (GMT+05:00)

This topic contains 1 reply, has 2 voices.

Last updated by Waqar 1 year, 8 months ago.

Assisted by: Waqar.

Author
Posts
#2667729
Screenshot from 2023-11-23 16-34-28.png

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.

#2667793

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