Yoast SEO Translation Errors

Vidocq24601 commented 6 years ago

Hi Patrick,

After most recent update, it appears there are translation errors again associated with Yoast. Do not believe this most recent update's issue has been reported yet.

Disabling Yoast Removes the Following Errors

Warnings displayed upon viewing the parent "Pages" and "Posts" pages from dashboard.

Warning: preg_replace(): Compilation failed: missing ) at offset 248 in D:\home\site\wwwroot\wp-includes\translations.php on line 1483

Warning: preg_replace(): Compilation failed: missing ) at offset 249 in D:\home\site\wwwroot\wp-includes\translations.php on line 1483

Warning: preg_replace(): Compilation failed: missing ) at offset 250 in D:\home\site\wwwroot\wp-includes\translations.php on line 1483

Vidocq24601 commented 6 years ago

Front-end impact:

Errors are thrown when attempting to view sitemap (generates 404)

Vidocq24601 commented 6 years ago

Fix

Referencing #169

folder: wp-includes file: fields_map.parsed_types.php

Cleared map of Yoast references, removed and reactivated Yoast, issue resolved.

NoralK commented 5 years ago

See fix in #313

Vidocq24601 commented 5 years ago

Yoast Translation Errors (11.x)

Upon reviewing translate.log, the following entry is continuously repeated whenever page/post dashboard is accessed (primary impact is authenticated user performance):

2019-08-01 19:46:12 Error Code: 102 -- Begin get_var translation attempt:

                SELECT COUNT( 1 )
                FROM wp_2_postmeta
                WHERE post_id IN( SELECT ID FROM wp_2_posts WHERE post_type = 'page' ) &&
                meta_value = "1" AND meta_key = '_yoast_wpseo_is_cornerstone'

2019-08-01 19:46:12 -- Translation result:
SELECT COUNT( 1 ) as Computed 
                FROM wp_2_postmeta
                WHERE post_id IN( SELECT ID FROM wp_2_posts WHERE post_type = 'page' ) &&
                meta_value = "1" AND meta_key = '_yoast_wpseo_is_cornerstone'

2019-08-01 19:46:21 Error Code: 102 -- Begin get_var translation attempt:

            SELECT ID
              FROM wp_2_posts AS posts
         LEFT JOIN wp_2_yoast_seo_meta AS yoast_meta
                ON yoast_meta.object_id = posts.ID
             WHERE posts.post_status = "publish"
               AND posts.post_type IN ( "post", "page" )
               AND yoast_meta.internal_link_count IS NULL
             LIMIT 1
2019-08-01 19:46:21 -- Translation result:
SELECT TOP 1 ID
              FROM wp_2_posts AS posts
         LEFT JOIN wp_2_yoast_seo_meta AS yoast_meta
                ON yoast_meta.object_id = posts.ID
             WHERE posts.post_status = "publish"
               AND posts.post_type IN ( "post", "page" )
               AND yoast_meta.internal_link_count IS NULL

2019-08-01 19:46:21 Error Code: 102 -- Begin get_var translation attempt:

                SELECT COUNT( 1 )
                FROM wp_2_postmeta
                WHERE post_id IN( SELECT ID FROM wp_2_posts WHERE post_type = 'post' ) &&
                meta_value = "1" AND meta_key = '_yoast_wpseo_is_cornerstone'

2019-08-01 19:46:21 -- Translation result:
SELECT COUNT( 1 ) as Computed 
                FROM wp_2_postmeta
                WHERE post_id IN( SELECT ID FROM wp_2_posts WHERE post_type = 'post' ) &&
                meta_value = "1" AND meta_key = '_yoast_wpseo_is_cornerstone'

Deactivating plugin and reactivating plugin throws errors previously described:


Warning: preg_replace(): Compilation failed: missing ) at offset 248 in D:\home\site\wwwroot\wp-includes\translations.php on line 1489

Warning: preg_replace(): Compilation failed: missing ) at offset 249 in D:\home\site\wwwroot\wp-includes\translations.php on line 1489

If the parsed fields map file is deleted, these visible errors will no longer display, however the performance issues associated with logging noise will remain.

Unfortunately the fix in #313 no longer resolves issue (previous assistance is greatly appreciated Noral, thank you).

Re-opening issue in the meantime.

RehanSaeed commented 4 years ago

Are there any new workarounds?

patrickebates commented 4 years ago

Nothing from us yet.

MediaMaquina commented 4 years ago

What does this store? "_yoast_wpseo_is_cornerstone"

ProjectNami / projectnami

Yoast SEO Translation Errors #284