projectnami
projectnami copied to clipboard
ProjectNami
Yoast SEO Translation Errors
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 249 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
Warning: preg_replace(): Compilation failed: missing ) at offset 250 in D:\home\site\wwwroot\wp-includes\translations.php on line 1483
Front-end impact:
Errors are thrown when attempting to view sitemap (generates 404)
Fix
Referencing #169
folder: wp-includes file: fields_map.parsed_types.php
Cleared map of Yoast references, removed and reactivated Yoast, issue resolved.
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.
