[F] Find user posts - not displaying new posts (when hitting limit) [R]

[Ryan Gordon]

Official fix. Open search.php and find:

PHP Code:

$tids = array();
$pids = array();
// Make sure the posts we're viewing we have permission to view.
$query = $db->simple_select("posts", "pid, tid", "pid IN(".$db->escape_string($search['posts']).") AND {$p_unapproved_where} {$limitsql}"); 


replace with

PHP Code:

$post_cache_options = array('limit' => intval($mybb->settings['searchhardlimit']));
if(strpos($sortfield, 'p.') !== false)
{
    $post_cache_options['order_by'] = str_replace('p.', '', $sortfield);
    $post_cache_options['order_dir'] = $order;
}

$tids = array();
$pids = array();
// Make sure the posts we're viewing we have permission to view.
$query = $db->simple_select("posts", "pid, tid", "pid IN(".$db->escape_string($search['posts']).") AND {$p_unapproved_where}", $post_cache_options); 


Also find both instances of:

PHP Code:

$pids = '';
$comma = '';
$query = $db->simple_select("posts", "pid", "{$where_sql} {$limitsql}"); 


replace with

PHP Code:

$options = array(
    'limit' => intval($mybb->settings['searchhardlimit']),
    'order_by' => 'dateline',
    'order_dir' => 'desc',
);
    
$pids = '';
$comma = '';
$query = $db->simple_select("posts", "pid", "{$where_sql}", $options); 


A developer may commit this fix at their convenience.

[Tomm M]

Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

With regards,
MyBB Group