Title: posts_nav_link broken
Last modified: August 18, 2016

---

# posts_nav_link broken

 *  [llbbl](https://wordpress.org/support/users/llbbl/)
 * (@llbbl)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/posts_nav_link-broken/)
 * After upgrading from 1.5 to 2.0.1 I discovered that the only thing not working
   was the posts_nav_link() function in the wp-includes/template-functions-link.
   php file.
 * It gives me this error:
    WordPress database error: [You have an error in your
   SQL syntax. Check the manual that corresponds to your MySQL server version for
   the right syntax to use near ” at line 1] SELECT COUNT(DISTINCT ID) FROM
 * It can not find the right database name apparently. I tried uploading the old
   template-functions-link.php file and that didn’t work. I think something got 
   screwed up when wordpress did it’s database upgrade.
 * Anyone know what’s going on?
 * I will let know what I figure out. I am sure I will have a solution in the next
   day or so.

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

 *  Thread Starter [llbbl](https://wordpress.org/support/users/llbbl/)
 * (@llbbl)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/posts_nav_link-broken/#post-330927)
 * Ok here is the complete code for the function. I fixed the problem. 😀
 * `
    function posts_nav_link($sep=' — ', $prelabel='« Previous Page', $nxtlabel
   ='Next Page »') { global $request, $posts_per_page, $wpdb, $max_num_pages;
 *  if ( !is_single() ) {
 *  if ( 'posts' == get_query_var('what_to_show') ) {
    if ( !isset($max_num_pages)){
   preg_match('#FROM (.*) GROUP BY#', $request, $matches); $fromwhere = $matches[
   1];
 *  if (empty($fromwhere))
    $fromwhere = $wpdb->posts;
 *  $numposts = $wpdb->get_var("SELECT COUNT(DISTINCT ID) FROM $fromwhere");
    $max_num_pages
   = ceil($numposts / $posts_per_page); } } else { $max_num_pages = 999999; }
 *  if ( $max_num_pages > 1 ) {
    previous_posts_link($prelabel); echo preg_replace('/&([
   ^#])(?![a-z]{1,8};)/', '&$1', $sep); next_posts_link($nxtlabel, $max_page); }}}
 * Here is the snippet of code that fixed the problem that I was having.
 * `
    if (empty($fromwhere)) $fromwhere = $wpdb->posts;
 * Bascially it was searching the variable $results for the database name and not
   finding it so my code says if that variable ($fromwhere) is empty then set it
   equal to the database where I store all my posts. (ssssh don’t tell anyone :P)
 *  Thread Starter [llbbl](https://wordpress.org/support/users/llbbl/)
 * (@llbbl)
 * [20 years, 4 months ago](https://wordpress.org/support/topic/posts_nav_link-broken/#post-331042)
 * I didn’t follow the upgrading instructions exactly. 😀 . The part that I forgot
   to do was deactivate all the plugins. I also didn’t delete the old wordpress 
   files. I just overwrote them with the new ones. Oh well. It is working now. I
   doubt that this problem I was having had anything to do with the plugins issue,
   but it might have have have something to do with the old files.

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

The topic ‘posts_nav_link broken’ is closed to new replies.

## Tags

 * [posts_nav_link](https://wordpress.org/support/topic-tag/posts_nav_link/)
 * [upgrade](https://wordpress.org/support/topic-tag/upgrade/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 1 participant
 * Last reply from: [llbbl](https://wordpress.org/support/users/llbbl/)
 * Last activity: [20 years, 4 months ago](https://wordpress.org/support/topic/posts_nav_link-broken/#post-331042)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics