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

    (@llbbl)

    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

    (@llbbl)

    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.