The stored procedure it is complaining as missing should have been created by one of the blog upgrade scripts.
You can manually run this from sql query analyzer to create it, hopefully there are not others missing:
CREATE PROCEDURE [dbo].[mp_Blogs_SelectAttachmentsForPage]
-- Author: Joe Audette
-- Created: 2012-09-17
-- Last Modified: 2012-12-06
@ModuleID int,
@BeginDate datetime,
@CurrentTime datetime,
@PageNumber int,
@PageSize int
AS
DECLARE @PageLowerBound int
DECLARE @PageUpperBound int
SET @PageLowerBound = (@PageSize * @PageNumber) - @PageSize
SET @PageUpperBound = @PageLowerBound + @PageSize + 1
CREATE TABLE #PageIndex
(
IndexID int IDENTITY (1, 1) NOT NULL,
BlogGuid uniqueidentifier,
ShowDownloadLink bit
)
BEGIN
INSERT INTO #PageIndex (
BlogGuid, ShowDownloadLink
)
SELECT
BlogGuid,
ShowDownloadLink
FROM
[dbo].[mp_Blogs]
WHERE
(ModuleID = @ModuleID)
and (@BeginDate >= StartDate)
and IsPublished = 1
and StartDate <= @CurrentTime
AND (EndDate IS NULL OR EndDate > @CurrentTime)
ORDER BY
StartDate DESC
END
SELECT bic.*,
t2.ShowDownloadLink
FROM
[dbo].[mp_FileAttachment] bic
JOIN #PageIndex t2
ON
bic.[ItemGuid] = t2.BlogGuid
WHERE
t2.IndexID > @PageLowerBound
AND t2.IndexID < @PageUpperBound
ORDER BY t2.IndexID
DROP TABLE #PageIndex
GO