Cannot import data from All In One SEO

Hello,

In this case, we might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

Please do take a complete backup of your website before sharing the information with us.

It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

https://wordpress.org/plugins/temporary-login-without-password/

You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

https://wordpress.org/plugins/wp-security-audit-log/

We really look forward to helping you.

Hello,

Sorry for the delay in response as the messages you sent here in the ticket were all pending moderation and as such didn’t enter the queue of tickets.

We have gone ahead and approved your reply so our team can see your ticket in the queue.

Back to your issue, we will forward this ticket to our development team to further check the issue, so can you please extend the Temporary admin URL for another 3 days?

Looking forward to helping you on this one.

Hello,

It looks like some entries in the wp_aioseo_posts table are empty, the reason for the issue. Not sure why this happened, but AIO SEO filters updates that table, with the SEO details on post save.

I tried to manually update post https://aluboats.co.za/wp-admin/post.php?post=196&action=edit, when AIO SEO was active, and the entries in the wp_aioseo_posts table were updated as expected, meaning this one could import as expected.

Could you please try that, and let us know how things turn out.

Thank you.

Hello,

Yes, could it be possible you recently imported this data ?
maybe something failed the reason for the empty values and re importing the same ( data ) would fix that without the need to manually update.

Thank you.

Hello,

The admin login has expired, could you please renew it, so we may debug further.

Thank you.

Hello,

To fix this issue, we have edited the file /seo-by-rank-math/includes/traits/class-meta.php and added below code after line 50;

/**
      * Filter to include the meta value from somewhere else.
         *
         * @param string $value The meta value.
         * @param string $key   The meta key.
         */
        $value = apply_filters( 'rank_math/import_meta/aioseo', $value, $key, $object_id, $object_type );

Then added a Code snippet titled Sync RM and AIO SEO postmeta data during import with the code below to include the missing data from the postmeta table, but I ran into a timeout error, when I try to import the data, even though this error was not happening the last time I tried.

add_filter( "rank_math/import_meta/aioseo", function ( $value, $key, $object_id, $object_type ) {
    $rm_metas = [
        'rank_math_description'  => '_aioseo_description',
        'rank_math_title'  => '_aioseo_title',
        'rank_math_focus_keywords' => '_aioseo_keywords'
    ];
    if ( 'post' === $object_type && empty( $value ) && in_array( $key, array_keys( $rm_metas ) ) ) {
        $aio_seo = new \RankMath\Admin\Importers\AIOSEO('all-in-one-seo-pack/all_in_one_seo_pack.php');
        $new_value = get_post_meta( $object_id, $rm_metas[ $key ], true );
        return $aio_seo->convert_variables( $new_value );
    }

    return $value;
}, 10, 5 );

Also the initial attempts to deactivate Advanced Database Cleaner PRO plugin, throws this error and I’m not sure what has changed, could you try turning off maintenance mode and re-import the data while the Code snippet plugin is active and let us know how things turn out.

Thank you.

Hello,

Glad that everything has been sorted out.

Please feel free to reach out to us again in case you need any other assistance.

We are here to help.

Thank you.