julia77

Hello @tahmidulkarim,

, otherwise, there will be issues with the functionalities of the plugin

Could you be more specific on what functionalities you′re referring? I′m a free version user with no integrations added.

Regards,

Julia

Hello @priscillamc,

Yoast is confusing users like me by showing a wrong message, suggesting to actively run a process that is forced anyway (as it′s automatically started since v14.0) and informing an “optimization” that duplicates data in db tables (since is not a migration but a copy).

Finally, once this indexation is finished, is Yoast removing old data in wp_options and wp_postmeta? Or users will have to delete it?

Hello @tahmidulkarim,

Is WP Manage Ninja′s ticket system support available for free version users?
I′m using the free version and need to adjust my website requirements.

Regads,

Julia

Hello @tahmidulkarim,

Messages can′t be predicted in my form. My suggestion is adding conditional logic if inputs are validated just as an ordinary message.

Regards,

Julia

There′re still in db:

In wp_postmeta these meta_key:

_yoast_wpseo_primary_category
_yoast_wpseo_focuskw
_yoast_wpseo_linkdex
_yoast_wpseo_focuskw
_yoast_wpseo_metadesc
_yoast_wpseo_meta-robots-noindex
_yoast_wpseo_opengraph-title
_yoast_wpseo_opengraph-description
_yoast_wpseo_opengraph-image
_yoast_wpseo_opengraph-image-id
_yoast_wpseo_twitter-title
_yoast_wpseo_twitter-description
_yoast_wpseo_twitter-image
_yoast_wpseo_twitter-image-id
_yoast_wpseo_schema_page_type

In wp_options these option_name:

wpseo
wpseo_titles
wpseo_social
wpseo_taxonomy_meta
wpseo-gsc-refresh_token
wpseo-gsc-access_token
wpseo-gsc
wpseo_gsc_issues_counts
wpseo_gsc_last_fetch
wpseo_ryte
yoast_migrations_free
+ transients …

@otto42,

I don′t want to delete the entire meta_value, just part of it as @joyously understood. Is there a function to extract the key array ([image_meta]? I′ve found this:

`function maybe_unserialize( $data ) {
if ( is_serialized( $data ) ) {
return @unserialize( trim( $data ) );
}

return $data;
}`

What do you think?

@joyously,

Yes, I′ve seen the function. But I don′t know a safe query to run in db for already stored metadata. If you read my first post in this topic, there′s a filter but previous data is already serialized.

Hello @suascat_wp,

What happens to previously stored metadata in wp_postmeta? It′s been migrated, not copied, right?

Hi @mikes41720

In db, I see the same 6 tables as always:

– wp_yoast_indexable
– wp_yoast_indexable_hierarchy
– wp_yoast_migrations
– wp_yoast_primary_terms
– wp_yoast_seo_links
– wp_yoast_seo_meta

#1 Which is the new table since v14.0? I have updated the plugin then and after (not the last one), so data′s been already transferred. But where?

I return to my first question in this thread: #2 my permanent links had not been changed at all, so why Yoast suggestion? And now: if migration has already been made, #3 why re-running the optimization? This cannot be an update since data is automatically updated when we change phrases, titles, etc.

I′ve visited your link and didn′t find any plugin related with images metadata, even the pros versions (just attachments as a whole, not differentiating arrays).

Do you know why doing it manually is not recommended in WP db?

Yes, you can read this thread:

My question is: what happens to previously stored metadata? I want to confirm if this is about a migration, that is, transferring (not copying) old metadata from previous storage location to the new table created specifically for these data.

@maybellyne That is a migration, not a copy, right?

@devnihil I have not previously performed the SEO data optimization. Anyway, documentation also says this optimization is done even if plugin users don′t actively performe the process. My question is: what happens to previously stored metadata? I want to confirm if this is about a migration, that is, transferring (not copying) old metadata from previous storage location to the new table created specifically for these data.

Previously stored metadata is migrated to a new table, right?

Hello Topher,

Thanks for the filter. It′s working.

Images metadata are stored in wp_postmeta meta_key=’_wp_attachment_metadata’ and serialized.

I′ve found this query to unserialize it but I don′t know if it′s safe to run it.

`# replace ‘file’ with the array key you want to extract
SELECT
SUBSTRING_INDEX(
SUBSTRING_INDEX(
SUBSTRING(pm.meta_value, ( INSTR( pm.meta_value, CONCAT( ‘file’, ‘”;’ ) ) + CHAR_LENGTH( ‘file’) + 1 ) ),
‘”‘, 2 ),
‘”‘, -1 ) as attachment_file
FROM wp_posts p
INNER JOIN wp_postmeta pm
ON p.ID = pm.post_id
AND pm.meta_key = ‘_wp_attachment_metadata’
WHERE post_type = ‘attachment’`

Do you have a safe way to unserialize and delete it?

Regards,

Julia