There is nothing in the admin section to fix this by default. Since this is a bug though I wrote up a quick script that you can place in your admin section and call when you need to do so:

Code
<?

// Require the library
require ("../includes/main.inc.php");
require ("$thispath/languages/{$myprefs['language']}/admin/generic.php");

$query = "
    SELECT Bo_Keyword
    FROM {$config['tbprefix']}Boards
";
$sth = $dbh->do_query($query);
while(list($board) = $dbh->fetch_array($sth)) {
    $board_q = addslashes($board);
  

    $query = "
        SELECT B_Number,B_Main,B_Posterid,B_Posted
        FROM {$config['tbprefix']}Posts
        WHERE B_Board='$board_q'
        AND B_Topic='1'
        ORDER BY B_Posted DESC
        LIMIT 1
    ";
    $sti = $dbh->do_query($query);
    list($blastnum,$bnum,$blastposterid,$blast) = $dbh->fetch_array($sti);
    $query = "                                                
        UPDATE {$config['tbprefix']}Boards                    
        SET Bo_LastNumber='$blastnum',                        
        Bo_LastMain = '$bnum',                                
        Bo_Posterid = '$blastposterid',                       
        Bo_Last='$blast'                                      
        WHERE Bo_Keyword='$board_q'                           
    ";                                                        
    $dbh->do_query($query);                                   
    echo "Fixing Board ID $board_q<br>";
}   
echo "Done";

Last edited by Rick Baker; 04/30/2006 8:42 PM.