[Resolved] Relationship links have dissapeared

[Author]

Posts

[Minesh]

Well - the file you shared shows 39 GB. That is too big file to download.

When you create a duplicator - please exclude media files and then try to create duplicator package even when you try to create All-in-One WP Migration package please try to exclude image/media files and then build a package and send me link to download.

If you do not know how to do it - please let me know and I will try to create duplicator package from the staging stie you create. I hope that makes sence.

[dennisN-2]

Even without the media files, Duplicator will not let me create a copy of the website. Apparently it's still too large for the free version and I don't want to pay for the pro version.

Yes, please make a copy through the staging site. Login as before: hidden link

[Minesh]

I've installed the duplicator pro and able to create duplicator package.

Then I've downalod that duplicator package almost 3GB (after excluding images and files) and then I've installed on my local machine:

This is the problem page you mentioned:
- hidden link

But as soon as I try to access that on my local machine I can see the post-relationships are available with all associated items on the above edit page on my local machine. You can check the following video:
- hidden link

In order to fix this either you can contact your SQL server administrator to fix this and set the following:

SQL_BIG_SELECTS=1
MAX_JOIN_SIZE=18446744073709551615

For now, I've added the following code to your current theme's functions.php file at top of the file:

///// toolset fix: SQL_BIG_SELECTS
global $wpdb;

if ( isset( $wpdb ) && isset( $wpdb->dbh ) ) {

    @mysqli_query(
        $wpdb->dbh,
        "SET SESSION SQL_BIG_SELECTS=1"
    );

    @mysqli_query(
        $wpdb->dbh,
        "SET SESSION MAX_JOIN_SIZE=18446744073709551615"
    );
}

Can you please confirm it works as expected now.

[dennisN-2]

Thank you for your help. Yes, now everything works as expected.

So the issue is a wrong PHP setting? Can you explain it to me?