Jose Luis Rodriguez

Forum Replies Created

Viewing 1 replies (of 1 total)

  • For alll that have the same problem, and try to use the MSSQL as database engine, I rewrite some of the code in the query.php file, so you can use without error.
    I explain :
    In the Paging code :

    // Paging
    if ( empty($q[‘nopaging’]) && !$this->is_singular ) {
    $page = absint($q[‘paged’]);
    if ( !$page )
    $page = 1;

    if ( empty($q[‘offset’]) ) {
    $pgstrt = ($page – 1) * $q[‘posts_per_page’] . ‘ ROWS FETCH NEXT ‘;
    } else { // we’re ignoring $page and using ‘offset’
    $q[‘offset’] = absint($q[‘offset’]);
    $pgstrt = $q[‘offset’] . ‘ ROWS FETCH NEXT ‘;
    }
    $limits = ‘OFFSET ‘ . $pgstrt . $q[‘posts_per_page’] . ‘ ROWS ONLY’;
    }
    And in the search OrderBY :
    /**
    * Filter the ORDER BY used when ordering search results.
    *
    * @since 3.7.0
    *
    * @param string $search_orderby The ORDER BY clause.
    * @param WP_Query $this The current WP_Query instance.
    */
    $search_orderby = apply_filters( ‘posts_search_orderby’, $search_orderby, $this );
    if ( $search_orderby )
    $orderby = $orderby ;
    }

Viewing 1 replies (of 1 total)