DrLightman

You may follow these steps to replicate the “bug”/”misbehaviour”:

1. create a page “foo”
2. settings>reading, Front page displays as “A static page” and select “foo”.
3. permalinks settings I use the typical “/%year%/%monthnum%/%day%/%postname%/”
4. go to yourdomain/ and u see the front page as static page (OK)
5. go to yourdomain/page/2/ and u should see a 404 (BUG?)

Hi, as I described before, I’m not querying posts (from wp_posts) but companies from a custom table “companies”, so I’m using the generic $wpdb->get_results(“select…”) method.

But I think the problem is that the frontpage cannot be paginated if set to a static page.

How is possibile that my get_comments function looks like this:

/**
 * Retrieve a list of comments.
 *
 * The comment list can be for the blog as a whole or for an individual post.
 *
 * The list of comment arguments are 'status', 'orderby', 'comment_date_gmt',
 * 'order', 'number', 'offset', and 'post_id'.
 *
 * @since 2.7.0
 * @uses $wpdb
 *
 * @param mixed $args Optional. Array or string of options to override defaults.
 * @return array List of comments.
 */
function get_comments( $args = '' ) {
	global $wpdb;

	$defaults = array('status' => '', 'orderby' => 'comment_date_gmt', 'order' => 'DESC', 'number' => '', 'offset' => '', 'post_id' => 0);

	$args = wp_parse_args( $args, $defaults );
	extract( $args, EXTR_SKIP );

	// $args can be whatever, only use the args defined in defaults to compute the key
	$key = md5( serialize( compact(array_keys($defaults)) )  );
	$last_changed = wp_cache_get('last_changed', 'comment');
	if ( !$last_changed ) {
		$last_changed = time();
		wp_cache_set('last_changed', $last_changed, 'comment');
	}
	$cache_key = "get_comments:$key:$last_changed";

	if ( $cache = wp_cache_get( $cache_key, 'comment' ) ) {
		return $cache;
	}

	$post_id = absint($post_id);

	if ( 'hold' == $status )
		$approved = "comment_approved = '0'";
	elseif ( 'approve' == $status )
		$approved = "comment_approved = '1'";
	elseif ( 'spam' == $status )
		$approved = "comment_approved = 'spam'";
	elseif ( 'trash' == $status )
		$approved = "comment_approved = 'trash'";
	else
		$approved = "( comment_approved = '0' OR comment_approved = '1' )";

	$order = ( 'ASC' == $order ) ? 'ASC' : 'DESC';

	$orderby = 'comment_date_gmt';  // Hard code for now

	$number = absint($number);
	$offset = absint($offset);

	if ( !empty($number) ) {
		if ( $offset )
			$number = 'LIMIT ' . $offset . ',' . $number;
		else
			$number = 'LIMIT ' . $number;

	} else {
		$number = '';
	}

	if ( ! empty($post_id) )
		$post_where = $wpdb->prepare( 'comment_post_ID = %d AND', $post_id );
	else
		$post_where = '';

	$comments = $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE $post_where $approved ORDER BY $orderby $order $number" );
	wp_cache_add( $cache_key, $comments, 'comment' );

	return $comments;
}

Not even similiar to the one you linked. I thought it was dued to the fact I’m referring to MU but on WP 2.9.2 also I have that. (wp-includes/comment.php) around line 185.

Another thing I would suggest the plugin author, is not to use wp_die() on modules if main plugin is not installed. I think a flash message warning would be enough (“Fan Box need the sfc plugin to be activated first”)

This because wp_die broke a blog activation in a wpmu installation while using an Auto Activation Tool, since the order of activation was not the one needed by sfc modules. SO every latter plugin were not activated.