Executing the following in the SQL page under the Host menu would help us troubleshoot.  You'll have to execute the following two SQL blocks independetly and then if you don't feel comfortable pasting the results here, send them to me at don along with the @ symbol and itcrossing.com.

SELECT PortalId, BlogID, UserID, Title, [Public], LastEntry FROM {databaseOwner}{objectQualifier}Blog_Blogs

and then also execute

SELECT BlogId, EntryId, Title, AddedDate,Published, Permalink FROM {databaseOwner}{objectQualifier}Blog_Entries

Thanks,

Don

OK, Can you execute a different version of the second query:

SELECT * FROM {databaseOwner}{objectQualifier}Blog_Entries

Everything looked great from the results you sent.  I looked at the code and if there is a failure when loading the entry page, it just redirects back to the main blog listing.  So, we'll need to find out what's causing the failure to load the entry page.

Thanks,

Don

Did you get this fixed?  I am having the same problem with 4.08.04