Title: Database error after translation update
Last modified: September 20, 2017

---

# Database error after translation update

 *  Resolved [ItzCookie](https://wordpress.org/support/users/sawsainis/)
 * (@sawsainis)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-translation-update/)
 * I’m getting this error inside the Pages back-end section. This happened after
   SEO Yoast update and a Translation update for English (UK).
 * [http://screenshot.co/#!/90fcfe5481](http://screenshot.co/#!/90fcfe5481)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-translation-update/#post-9512897)
 * Hi,
    Please try this in Yoast SEO Plugin’s file wordpress-seo\admin\links\class-
   link-column-count.php in function name get_results().
 * Please change the following query.
 * Before Changing query:
 * $results = $wpdb->get_results(
    $wpdb->prepare( ‘ SELECT internal_link_count,
   incoming_link_count, object_id FROM ‘ . $storage->get_table_name() . ‘ WHERE 
   object_id IN ( %1$s )’, implode( ‘,’, $post_ids ) ), ARRAY_A );
 * After Changing query:
 * $imploded_post_ids = implode( ‘,’, $post_ids );
    $results = $wpdb->get_results(‘
   SELECT internal_link_count, incoming_link_count, object_id FROM ‘ . $storage-
   >get_table_name() . ‘ WHERE object_id IN ( ‘.$imploded_post_ids.’)’,ARRAY_A );
   and check. This solved my problem. Thanks
 *  Thread Starter [ItzCookie](https://wordpress.org/support/users/sawsainis/)
 * (@sawsainis)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-translation-update/#post-9512957)
 * You removed wpdb->prepare which is unsafe. With “prepare” you set the query to
   be safely executed. I’m not going to use this method and neither should you.
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-translation-update/#post-9513047)
 * Hi,
 * You can also try this in File wordpress-seo\admin\links\class-link-column-count.
   php in function name get_results().
 * $no_strings = count($post_ids);
    $ids_placeholders = array_fill(0, $no_strings,“%
   d”); $format = implode(‘, ‘, $ids_placeholders); $results = $wpdb->get_results(
   $wpdb->prepare ( ‘SELECT internal_link_count, incoming_link_count, object_id 
   FROM ‘ . $storage->get_table_name() . ‘ WHERE object_id IN (‘.$format.’)’, $post_ids),
   ARRAY_A ); This too solved your problem. Thanks
 *  [marcanor](https://wordpress.org/support/users/marcanor/)
 * (@marcanor)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-translation-update/#post-9513587)
 * Hello,
    This issue has been fixed in the latest release of the Yoast plugin. 
   Please update to Yoast SEO 5.4.1.
 * Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Database error after translation update’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [marcanor](https://wordpress.org/support/users/marcanor/)
 * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/database-error-after-translation-update/#post-9513587)
 * Status: resolved