
Update AIO Seo titles after Update from 3.x to 4.x
SQL Query
Moves titles from wp_postmeta
to new table wp_aioseo_posts
UPDATE `wp_aioseo_posts` AIO, `wp_postmeta` WP
SET AIO.title = WP.meta_value
WHERE AIO.post_id = WP.post_id AND WP.meta_key = '_aioseop_title';