Title: spman's Replies | WordPress.org

---

# spman

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

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

 Search replies:

## Forum Replies Created

Viewing 1 replies (of 1 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Database error after 1.5 -> 2.0 upgrade: SELECT COUNT(DISTINCT ID) FROM](https://wordpress.org/support/topic/database-error-after-15-gt-20-upgrade-select-countdistinct-id-from/)
 *  [spman](https://wordpress.org/support/users/spman/)
 * (@spman)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-error-after-15-gt-20-upgrade-select-countdistinct-id-from/page/2/#post-392058)
 * Well none of them didn’t work for me. So I edited template like this…
    I found
   the code piece(it varies from template to template): ` if ( !$max_page ) { if(
   isset($max_num_pages) ) $max_page = $max_num_pages; else { preg_match('#FROM\
   s(.*)\sGROUP BY#siU', $request, $matches); $fromwhere = $matches[1]; $numposts
   = $wpdb->get_var("SELECT COUNT(DISTINCT ID) FROM $fromwhere"); $max_page = $max_num_pages
   = ceil($numposts / $posts_per_page); } }..........  and replaced it by  <div 
   class="navigation"> <div class="alignleft"><?php next_posts_link('« Previous 
   Entries') ?></div> <div class="alignright"><?php previous_posts_link('Next Entries»')?
   ></div> </div>  found in default wordpress template. Now pagination is working
   normally and there is no any more errors.

Viewing 1 replies (of 1 total)