Hello

On this website (Dnn5.2.3) i have a Blog (v.4.0.0) module and a Tag list. If i click on one of the tags logged in as a host i get this error:

DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.Blog_GetTag' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.Blog_GetTag' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.GetTag(Int32 TagID) at DotNetNuke.Modules.Blog.Business.TagController.GetTag(Int32 TagID) at DotNetNuke.Modules.Blog.ViewBlog.Page_Load(Object sender, EventArgs e) ---

If i look at a link to one of the blogentries, it looks like this: http://njhvidberg.dk/Bloggen/tabid/213/EntryId/12/Harzen-klatring-i-weekenden-22-5-til-24-5.aspx
You can see there is a .../EntryId/12/... in it.
If i look at one of the taglinks, it looks like this: http://njhvidberg.dk/Bloggen/tabid/213/tagid/56/Harzen.aspx
You can see it has a .../tagid/56/... in it.

Why is the taglinks not working? I have tried to 'fumble around' with SEO and cache settings and tried to delete the taglist and create a new one.

---

Niels-Jørgen Hvidberg http://newcomtech.dk http://njhvidberg.dk

Aha!
yes, i tried to install the Blog 4.0.0 again, but there was not any dbo.Blog_GetTag StoredProcedure installed. So i traced the file "04.00.00.SqlDataProvider" from the DesktopModules\Blog\_Installation\SQL library.

In the bottom i found this sql script:

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Blog_GetTag') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}Blog_GetTag
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}Blog_GetTag
    @TagID int
AS
select t.*
from {databaseOwner}{objectQualifier}Blog_tags t
where t.TagID = @TagID
GO

By some unknown reason this code does not work, so i rewrote it and ran this script, which created the StoredProcedure and the tag links work fine now.

CREATE PROCEDURE dbo.Blog_GetTag
    @TagID int
AS
select t.*
from dbo.Blog_tags t
where t.TagID = @TagID
GO

Thanks for your 'eagle eyes' that spotted the error :-)

---

Niels-Jørgen Hvidberg http://newcomtech.dk http://njhvidberg.dk