Title: sakshi's Replies | WordPress.org

---

# wordpressbeta

  [  ](https://wordpress.org/support/users/wordpressbeta/)

 *   [Profile](https://wordpress.org/support/users/wordpressbeta/)
 *   [Topics Started](https://wordpress.org/support/users/wordpressbeta/topics/)
 *   [Replies Created](https://wordpress.org/support/users/wordpressbeta/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/wordpressbeta/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/wordpressbeta/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/wordpressbeta/engagements/)
 *   [Favorites](https://wordpress.org/support/users/wordpressbeta/favorites/)

 Search replies:

## Forum Replies Created

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

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [WordPress database error after updated to 4.8.2](https://wordpress.org/support/topic/wordpress-database-error-after-updated-to-4-8-2/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-after-updated-to-4-8-2/#post-9513082)
 * 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
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Yoast SEO - Advanced SEO with real-time guidance and built-in AI] WP Database error (SQL Syntax)](https://wordpress.org/support/topic/wp-database-error-sql-syntax/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/wp-database-error-sql-syntax/#post-9513053)
 * 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
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Yoast SEO - Advanced SEO with real-time guidance and built-in AI] Database error after translation update](https://wordpress.org/support/topic/database-error-after-translation-update/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 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
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Yoast SEO - Advanced SEO with real-time guidance and built-in AI] Database error after translation update](https://wordpress.org/support/topic/database-error-after-translation-update/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 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
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Yoast SEO - Advanced SEO with real-time guidance and built-in AI] Database Error Notice on “All posts” admin pages](https://wordpress.org/support/topic/database-error-notice-on-all-posts-admin-pages/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/database-error-notice-on-all-posts-admin-pages/#post-9512884)
 * Hi,
 * I also got same error and solved this by doing changes in code.
 * Try This in 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 );
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Yoast SEO - Advanced SEO with real-time guidance and built-in AI] Database Error caused by Yoast](https://wordpress.org/support/topic/database-error-caused-by-yoast/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/database-error-caused-by-yoast/#post-9512879)
 * Hi,
 * Try This in 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 will help you.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Yoast SEO - Advanced SEO with real-time guidance and built-in AI] WP Database error (SQL Syntax)](https://wordpress.org/support/topic/wp-database-error-sql-syntax/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/wp-database-error-sql-syntax/#post-9512867)
 * Hi,
 * Try This in 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
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [WordPress database error after updated to 4.8.2](https://wordpress.org/support/topic/wordpress-database-error-after-updated-to-4-8-2/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-after-updated-to-4-8-2/#post-9512709)
 * Hi,
 * 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
    -  This reply was modified 8 years, 8 months ago by [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/).
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Database error after the WordPress automatically updated to 4.8.2](https://wordpress.org/support/topic/database-error-after-the-wordpress-automatically-updated-to-4-8-2/)
 *  [wordpressbeta](https://wordpress.org/support/users/wordpressbeta/)
 * (@wordpressbeta)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/database-error-after-the-wordpress-automatically-updated-to-4-8-2/#post-9512125)
 * Hi,
 * Try This in 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.

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