Rank Math SEO does not import All in One SEO post/pages SEO (post meta) data - Support

Resolved Ivaylo Tinchev
8 months ago

Rank Math free

I turned off the All in One SEO plugin I used before and tried to import all the settings and SEO post meta data from it to Rank Math SEO. The process took some time the first time and it seemed that something was transferring for all posts/pages but at the end I see that the SEO title, SEO description, etc. are not imported. I do not see them in the Preview or when I press the Edit Snippet button. Now, when I try to import the setting and data from the other plugin again, it takes short time and nothing changes. I am getting the following:

[19:49:48] Import started…
[19:49:48] Importing settings
[19:49:50] Settings imported successfully.
[19:49:50] Importing postmeta
[19:49:52] Imported post meta for posts 1 – 10 out of 10
[19:49:52] Importing usermeta
[19:49:55] Imported user meta for users 1 – 1 out of 1
[19:49:55] Starting SEO score recalculation
[19:49:57] No posts found without SEO score.
[19:49:57] Import finished.

The real number of items is 476 posts and 144 pages. They are not processed.

Viewing 13 replies - 16 through 28 (of 28 total)

← 1 2

Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

… wrong suggestion I suppose.

Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

Concerning the post ID 528, there is nothing for Rank Math SEO in the postmeta table:
https://prnt.sc/vOCQZNKLBzFx

Nicholas
7 months, 2 weeks ago

Hello,

Looks like AIO SEO is misconfigured on your site as trying to import from other SEO plugin shows two instances of AIO settings, in the drop down select.

One of these instances works and the other throws a fatal error.

We were able to fix this by importing from the correct instance and confirmed that the post metas are identical eg for homepage at;

Thank you.

Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

Hello,

Thank you. Those are records from different versions – aioseop_ is the old one, aioseo_ is the new one, and yoast_ is from trying the other product.

I did not want to share publicaly any info that will identify which is the website that needs help due to security reasons. Please delete the screenshot.

Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

PS: You have imported the wrong data from an old version of AIOSEO.

Nicholas
7 months, 2 weeks ago

Hello,

I have deleted the screenshot, also other SEO plugins are only able to import the old data.

Thank you.

Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

So, there is no way for me to import the current AIOSEO data starting with aioseo_ in the postmeta table, which is different from the old one that you have imported in some way and it starts with aioseop_?
Nicholas
7 months, 2 weeks ago
Hello,

AIO SEO also stores their data in {$wpdb->prefix}aioseo_posts including the SEO title and description
and this is where RankMath imports from. When you update the AIO SEO version they should have autonmatically migrated the data and deleted ( cleared ) the old one.

It also looks like you do not have any post meta with a meta key starting with aioseo_ only aioseop_ ,

Please try this query code and see the results.
```
 global $wpdb;
    $sql = "
        SELECT * FROM {$wpdb->prefix}postmeta
            WHERE post_id = 528 
            AND ( meta_key LIKE '%seo%'
            OR meta_key LIKE '%rank_math%' )
    LIMIT 5000
    ";

    dump($wpdb->get_results( $sql, ARRAY_A ));
```
Thank you.
Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

Hello,

I have updated the sensitive data as requested. Can you please check further?
It seems that the home page SEO has not moved the data to the new version from aioseop_ to aioseo_. However other pages have their SEO data moved to the new version.

Thank you.

Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

I have decided that I will just check a few titles and descriptions, compare them and move the right ones to the new version. But you may try to find out what might be the problem for imports of other customers in future. Thank you for importing the values from aioseop_*. Please close the ticket.
Nicholas
7 months, 2 weeks ago
Hello,

The entries in the {$wpdb->prefix}aioseo_posts has NULL values for title and description attributes which we import from.

I would share a screenshot, but you didn’t want that last time, here’s some query code, you may run to verify this.( This is what we import from ).
```
global $wpdb;
    $sql = "
        SELECT * FROM {$wpdb->prefix}aioseo_posts
            WHERE title IS NOT NULL 
    LIMIT 5000
    ";

    dump($wpdb->get_results( $sql, ARRAY_A ));
```
Thank you
Ivaylo Tinchev
7 months, 2 weeks ago

Rank Math free

Now I see what you mean. Unfortunately there is nothing in the {prefix}_aioseo_posts table. The data is in the {prefix}_postmeta table where the data is in the aioseop_* or aioseo_* SEO fields. Unfortunately I don’t know where they should be in the newest versions but it works fine this way in the old website. So the data is transferred now. I’ve changed around 20-30 fields and will keep the data in this way. Let’s hope there is not big change after the transfer.

Thank you very much for your help. You may close the ticket.

Princess
7 months, 1 week ago

Hello,

Glad that helped.

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

We are here to help.

Thank you.

RankBot
6 months, 1 week ago

Hello,

Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

Thank you.

Viewing 13 replies - 16 through 28 (of 28 total)

← 1 2

The ticket ‘Rank Math SEO does not import All in One SEO post/pages SEO (post meta) data’ is closed to new replies.