Forums Community

These forums are dedicated to the discussion of our DotNetNuke products, such as Ultimate DNN Blog Module - SunBlogNuke & GalleryPlus.

For the benefit of the community and to keep information here helpful to everyone who visits, please observe the following posting guidelines:

  • If you are reporting a bug and strange issue please tell us which version of DNN and SunBlogNuke and share some event logs from "Admin/Event Viewer".
  • Site Moderators have the final word on approving/removing a thread or post or comment.
  • English language posting only, please.
Home/Ultimate DNN Blog Module :: SunBlogNuke/Support Issues/Failed installation
PreviousNext
New Post
2/9/2017 9:37 AM
 
Hi. I tried to install Sunblog 8.05 on my DNN 8.04 website and got the error code below. Please could you help me out here


StartJob
Starting Installation
Info Starting Installation - SunBlog
Info Starting Installation - Script
Info Begin Sql execution
Info Created - Installation\Scripts\07.00.05.SqlDataProvider
Info Executing 07.00.05.SqlDataProvider
Info Start Sql execution: 07.00.05.SqlDataProvider file
Info End Sql execution: 07.00.05.SqlDataProvider file
Info Created - Installation\Scripts\08.00.05.SqlDataProvider
Info Executing 08.00.05.SqlDataProvider
Info Start Sql execution: 08.00.05.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ce1c2c9f-5ecf-4c2e-bab9-689aa2477c0d Error Number:207,State:1,Class:16 CREATE VIEW dbo.[easycgi_dnn_vw_SunBlog_Tags] AS SELECT T.[ID] AS TagID, --B.PortalID, B.BlogID, E.EntryID, (E.Approved & E.Published) AS Visible, E.PublishedOnDate AS AddedDate, T.Tag FROM dbo.[easycgi_dnn_vw_SunBlog_Entries] E INNER JOIN dbo.easycgi_dnn_SunBlog_Blogs B ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.easycgi_dnn_SunBlog_Tags T ON T.[EntryID] = E.[EntryID]
Info End Sql execution: 08.00.05.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - SunBlog
Info Starting Installation - SunBlog - Widget Wrapper
Info Starting Installation - Module
Info Module registered successfully - SunBlog - Widget Wrapper
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - SunBlog - Widget Wrapper
Info Deleted temporary install folder
EndJob Installation Failed


New Post
2/9/2017 9:45 AM
 

Try to execute the sql script in the Host/SQL page:

IF (SELECT COLUMNPROPERTY(OBJECT_ID('{databaseOwner}[{objectQualifier}SunBlog_Tags]'),'ID','')) IS NULL 
BEGIN
    ALTER TABLE {databaseOwner}[{objectQualifier}SunBlog_Tags] 
        ADD [ID] int identity(1,1)

    ALTER TABLE {databaseOwner}{objectQualifier}SunBlog_Tags ADD 
        CONSTRAINT [PK_{objectQualifier}SunBlog_Tags] PRIMARY KEY  CLUSTERED 
        (
            [ID]
        )
END
GO

Ultimate DNN Blog Module - SunBlogNuke
New Post
2/10/2017 6:41 AM
 

Thanks. After I did that I am now unable to see the blog full blog entry, just the summary. Here is the error below

AbsoluteURL:/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:f74fabe0-1511-4ab2-a409-6d1db5eedee4

AssemblyVersion:8.0.4

PortalId:0

UserId:1

TabId:142

RawUrl:/HealingNotes/tabid/142/entryid/41/-popcorn-seasoned-with-recipes-made-easy-seasoning-blend.aspx

Referrer:https://www.healingvineyard.com/HealingNotes/tabid/142/Default.aspx

UserAgent:Mozilla/5.0 (Windows NT 10.0; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0

ExceptionHash:shnnCQiQx4DCRJb4AcidxQ==

Message:Parameter '@EntryID' specified but none of the passed arguments have a property with this name (in 'SELECT [easycgi_dnn_SunBlog_Diggs].[DiggID], [easycgi_dnn_SunBlog_Diggs].[EntryID], [easycgi_dnn_SunBlog_Diggs].[UserID], [easycgi_dnn_SunBlog_Diggs].[DiggType] FROM [easycgi_dnn_SunBlog_Diggs] WHERE [EntryID] = @EntryID AND [UserID] = @UserID')

StackTrace:

InnerMessage:Parameter '@EntryID' specified but none of the passed arguments have a property with this name (in 'SELECT [easycgi_dnn_SunBlog_Diggs].[DiggID], [easycgi_dnn_SunBlog_Diggs].[EntryID], [easycgi_dnn_SunBlog_Diggs].[UserID], [easycgi_dnn_SunBlog_Diggs].[DiggType] FROM [easycgi_dnn_SunBlog_Diggs] WHERE [EntryID] = @EntryID AND [UserID] = @UserID')

InnerStackTrace:

at PetaPoco.Internal.ParametersHelper.<>c_DisplayClass1.b_0(Match m) at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat) at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator, Int32 count, Int32 startat) at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator) at PetaPoco.Internal.ParametersHelper.ProcessParams(String sql, Object[] args_src, List1 args_dest) at PetaPoco.Database.CreateCommand(IDbConnection connection, String sql, Object[] args) at PetaPoco.Database.d__21.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at PetaPoco.Database.Fetch[T](String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoRepository1.Find(String sqlCondition, Object[] args) at SunBlogNuke.Services.Data.RepositoryImpl1.Find(String sqlCondition, Object[] args) at SunBlogNuke.Services.Data.RepositoryImpl1.Single(String sqlCondition, Object[] args) at SunBlogNuke.Toolkit.UserControls.Vote.VerifyDigg() at ASP.desktopmodules_sunblog_themes_customized_vote_ascx._Render_control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.desktopmodules_sunblog_themes_customized_detailview_ascx._Render_control1(HtmlTextWriter _w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at DotNetNuke.UI.Modules.ModuleHost.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.portals_default_skins_20073_unlimitedcolorspack_055_insidepage_ascx._Render_control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at DotNetNuke.Framework.PageBase.Render(HtmlTextWriter writer) at DotNetNuke.Framework.DefaultPage.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

New Post
2/13/2017 7:42 PM
 

I just checked out this blog post and it can be access with view for me. So did you resolve it yourself? Thanks.

New Post
2/15/2017 6:58 AM
 

Hi. Not yet. I can see the blog entry when I am logged out, but when logged in as an admin or host it does not work. I get a critical error.

New Post
2/15/2017 5:38 PM
 

So could you send us one host account to check it out? Thanks a lot. Just send it to support(at)sunblognuke.com or dnnsun(at)gmail.com.

New Post
4/19/2017 1:08 AM
 

I will send the credentials again to you because it was never fixed. Current results

AbsoluteURL:/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:72d55bb8-ddfa-403a-b3ed-cdd515e2544d

AssemblyVersion:8.0.4

PortalId:0

UserId:2

TabId:142

RawUrl:/HealingNotes/tabid/142/entryid/40/Boosting-your-immune-system-for-the-flu-season-Vitamin-C.aspx

Referrer:https://www.healingvineyard.com/HealingNotes/tabid/142/Default.aspx

UserAgent:Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0

ExceptionHash:R/E8oSS6H34JUwwewrNYmQ==

Message:Parameter '@EntryID' specified but none of the passed arguments have a property with this name (in 'SELECT [easycgi_dnn_SunBlog_Diggs].[DiggID], [easycgi_dnn_SunBlog_Diggs].[EntryID], [easycgi_dnn_SunBlog_Diggs].[UserID], [easycgi_dnn_SunBlog_Diggs].[DiggType] FROM [easycgi_dnn_SunBlog_Diggs] WHERE [EntryID] = @EntryID AND [UserID] = @UserID')

StackTrace:

InnerMessage:Parameter '@EntryID' specified but none of the passed arguments have a property with this name (in 'SELECT [easycgi_dnn_SunBlog_Diggs].[DiggID], [easycgi_dnn_SunBlog_Diggs].[EntryID], [easycgi_dnn_SunBlog_Diggs].[UserID], [easycgi_dnn_SunBlog_Diggs].[DiggType] FROM [easycgi_dnn_SunBlog_Diggs] WHERE [EntryID] = @EntryID AND [UserID] = @UserID')

InnerStackTrace:

at PetaPoco.Internal.ParametersHelper.<>c_DisplayClass1.b_0(Match m)
1 args_dest)
1.MoveNext()
1..ctor(IEnumerable1 collection)
1 source)
1.Find(String sqlCondition, Object[] args)
1.Find(String sqlCondition, Object[] args)
1.Single(String sqlCondition, Object[] args)
Render_control1(HtmlTextWriter __w, Control parameterContainer)
Render_control1(HtmlTextWriter _w, Control parameterContainer)
_default_skins_20073_unlimitedcolorspack_055_insidepage_ascx._Render_control1(HtmlTextWriter __w, Control parameterContainer)

Source:

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:

Server Name: GENERIC163

PreviousNext
Home/Ultimate DNN Blog Module :: SunBlogNuke/Support Issues/Failed installation
Copyright © 2009-2018 Ultimate DNN Blog Module - SunBlogNuke Powered by SunBlogNuke Corp