Link to a page where the issue can be seen: hidden link
I expected to see: Sucessful migration
Instead, I got: The following message:
> Post relationships migration started.
> Maintenance mode enabled.
> No tables had to be dropped.
> Unable to create table ebD3I56_toolset_associations due to a MySQL Error:
> Unable to create table ebD3I56_toolset_relationships due to a MySQL Error:
> Unable to create table ebD3I56_toolset_type_sets due to a MySQL Error:
> Maintenance mode disabled.
Hello. Thank you for contacting the Toolset support.
Well - to debug this issue further, I need access details and also could you please make sure that on your database server there is enough permissions set so the migration request can create the required tables on your database server. Could you please confirm there is ALL permissions set on your database server. If yes:
*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.
I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).
I have set the next reply to private which means only you and I have access to it.
Well - I think you missed to share your confirmation on database server permission. Is there enough permissions so a migration request can create new database tables on your database server. Could you please confirm.
Of course, the user has granted all permissions for the WordPress database. Indeed, is the same user that I used to install WordPress and all the plugins as well (Toolset included).
No I didn't. I was trying to setup the (first) relationships when I found a message requesting me to run the migration process before starting that setup. That message doesn´t allow me just to skip it, and I'm not able to create any relationships without running the migration.
So, I know that there are no relatioships to be migrated, butn I can't create relationships because the plugin is requesting me to run the migration before... And when I run the migration I get an error message instead of a successful one (something similar to: "No relationships have to be migrated. Process finished successfully...")
The error message from the plugin is self-explanatory: "No tables had to be dropped". But the process can't create new tables that, presumably, are necessary to store the relationships.
Now - when I click on button to run the migration I got this error message:
> Post relationships migration started.
> Couldn't write to the ".maintenance" file.
The file ".maintenance" is a feature of WordPress core, when you do the relationship migration, it will change your website into maintenance mode.
According to the error message, seems it can not create the file ".maintenance" in the wordpress root folder, please try to change the permission of wordpress root folder to writable, and test again
I know what is ".maintenance" file. The error you saw was due to a temporary backup process, but it wasn't the cause of my support ticket. Indeed you can see the screenshot I uploaded at the begining of your "support", where the file could be created and deleted.
The original error message is still beeing thrown whenever I try the migration process, and it is not due to missing permissions on the database, as I explained you before.
