Skip Navigation

[Resolved] Post Relationship Migration failing and breaking existing Relationships

This support ticket is created 6 years, 7 months ago. There's a good chance that you are reading advice that it now obsolete.

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
- 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 7:00 – 14:00 -
- 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 15:00 – 16:00 -

Supporter timezone: Europe/London (GMT+00:00)

This topic contains 4 replies, has 2 voices.

Last updated by Philipp 6 years, 6 months ago.

Assisted by: Nigel.

Author
Posts
#919053
Relationships ‹ Ferienwohnungen Cuxhaven — WordPress 2018-06-28 17-15-03.png

I am trying to: migrate the Post Relationships

I expected to see: a successful migration

Instead, I got: errors and the existing post relations have been broken.

Error Log:
> Post relationships migration started.
> Maintenance mode enabled.
> Dropped table "wp_toolset_associations".
> Dropped table "wp_toolset_relationships".
> Dropped table "wp_toolset_type_sets".
> The toolset_associations, toolset_relationships and toolset_post_type_sets tables have been created.
> Relationship "obj_preis" between post types "obj" and "preis" was created.
> Relationship definitions migrated.
> Cannot return the number of found rows because the query was not instructed to obtain them.
> Cannot return the number of found rows because the query was not instructed to obtain them.
> Cannot return the number of found rows because the query was not instructed to obtain them.
> Cannot return the number of found rows because the query was not instructed to obtain them.
> Cannot return the number of found rows because the query was not instructed to obtain them.
> Cannot return the number of found rows because the query was not instructed to obtain them.
.....
> Associations processed.
> The migration process is complete.
> Maintenance mode disabled.

#919152

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Philipp

I have another report with a similar issue, and it depended on some specific circumstances, and it would be useful to know if your situation is the same.

In particular, I can see that you are running the current plugin versions, but what I would like to know is what versions of Types and Views and Toolset Forms (then CRED) you were using before updating to Types 3 etc.

Also, the above log suggests that this is not the first time you have run the migration wizard, because the custom relationship tables already existed, and yet you cannot normally run the migration more than once, if you could clarify.

Lastly, do you have a backup of the site from before you tried to run the migration if we need it?

#919443

Hi,

we have been using Toolset for quite some time (multiple years) and have this relationship setup since then. We tried to migrate before on a testspace which worked ok. We have created a backup to which we have gone back after the upgrade failed. Please instruct how to go forward.

Philipp

#919942

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

Hi Philipp

Can I get a copy of the site from before the update?

It sounds like the migration worked on your test server, but not on the production server, is that right?

hidden link

I've marked your next reply as private.

#920805

Nigel
Supporter

Languages: English (English ) Spanish (Español )

Timezone: Europe/London (GMT+00:00)

I tried to import that SQL file (I had to significantly increase the available resources in php.ini to allow for such a large SQL file) but the import failed because numerous errors.

Could you please provide an actual duplicate of the site using Duplicator as described here: hidden link