[Resolved] MySQL errors while migrating posts relationships

[Author]

Posts

[frasco]

I am trying to: Do the migration process

Link to a page where the issue can be seen: hidden link

I expected to see: A successful migration

Instead, I got: The following error:

> 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.

[Nigel]

Hi there

Before I go much further, can I ask if there are any more details of the errors in your debug or server logs?

I may need to take a copy of your site to install locally and test myself, but I'll wait to hear if you find anything in the logs first.

[frasco]

Hi Nigel,

Thank you very much for your quick response.

Sorry but I couldn't manage to find further information in server logs. Indeed, I have manually deleted the tables involved, and then I have tried again the migration process. The error message is then thrown again, but the tables are created though. So, no MySQL error seems to be happening (in creating tables, at least) and the error message shown by the plugin doesn't seem to be accurate.

[Nigel]

In that case, could I get a copy of your site to install locally and try the migration myself?

hidden link

I'll mark your next reply as private to get details.

[Nigel]

Can I check the history of this site?

I don't see any existing relationships when I check your settings for the custom post type you registered.

I performed a quick search in the database for any evidence that there are existing related posts, and found none.

So I'm wondering why you need to run the migration wizard at all.

I know why you are trying to run the migration, because if you go to Toolset > Relationships it tells you to, but I don't see why it is doing that, instead of just letting you set up new relationships.

So, can you give me some background as to how and when this site was created?

[frasco]

Thats the point. Why is the plugin requesting me to do a migration if there is nothing to be migrated?

The site has just been created and I'm only trying to set up the framework to start the project. As you can see is not a production site at all.

[Nigel]

I'm not sure how that happened, something appears to have gone wrong in the installation, though I've not seen anything like it before.

On my local copy of your site I fixed the problem by

- disabling Types
- using phpMyAdmin to edit the options table and deleting the option shown in the screenshot
- re-activate Types

Then when I visited Toolset > Relationships I saw the expected screen to create a new relationship, no sign of the migration wizard.

Can you try the same?