this sounds very weird, I am not aware of issue with the database, which default language do you use for the SQL Server user?

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

I just did a clean install of version 8.0.4.207 on my local machine and received the same exact issue. No custom modules or skins. Using SQL Server: SQL 2012 Express.

The site loads using the Cavalier skin, but as soon as you login you get the following error:

http://dnn804a/Default.aspx?tabid=59&error=Conversion+failed+when+converting+the+nvarchar+value+%27%2fSigma%2fUse%27+to+data+type+int.&content=0

Exception Table:

Conversion failed when converting the nvarchar value '/Sigma/Use' to data type int.
at System.Data.SqlClient.SqlConnection. (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.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at DotNetNuke.Common.Utilities.CBO.CreateObjectFromReader(Type objType, IDataReader dr, Boolean closeReader)
at DotNetNuke.Common.Utilities.CBO.FillObject[TObject](IDataReader dr)
at DotNetNuke.Entities.Modules.ModuleController.GetModuleByDefinition(Int32 portalId, String definitionName)
at DotNetNuke.UI.ControlPanels.ControlBar.GetTabURL(List`1 additionalParams, String toolName, Boolean isHostTool, String moduleFriendlyName, String controlKey, Boolean showAsPopUp)
at DotNetNuke.UI.ControlPanels.ControlBar.BuildToolUrl(String toolName, Boolean isHostTool, String moduleFriendlyName, String controlKey, String navigateUrl, Boolean showAsPopUp)
at ASP.admin_controlpanel_controlbar_ascx.__RenderControlPanel(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at ASP.admin_controlpanel_controlbar_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
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.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at DotNetNuke.Framework.PageBase.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

When executing the GetModuleByDefinition Sproc using the following:

EXEC @return_value = [dbo].[GetModuleByDefinition]
@PortalId = 0,
@DefinitionName = N'User Accounts'

SELECT 'Return Value' = @return_value

GO

I'm able to duplicate the error.

Msg 245, Level 16, State 1, Procedure GetModuleByDefinition, Line 5
Conversion failed when converting the nvarchar value '/Sigma/Use' to data type int.

I then tried the other Module Definition names listed in the listed in the ModuleDefinitions table. I'm able to duplicate the issue using each of the Definition Names below:

Security Roles
Site Settings
User Accounts
Recycle Bin
Log Viewer
Search Admin
Site Wizard
Lists
Extensions
Languages
Sitemap
Digital Asset Management
DNN Site Redirection Management
DNN Device Preview Management

Each had their own conversion error. The value seems to be truncated after the first 8 characters of the IconFile, with the offending part of the message being the next 10 characters. There's a few more which I didn't test, but I think you get the idea.

FYI - To fix this issue comment out the following inside the view vw.Modules select statement:

-- Case when tm.IconFile LIKE 'fileid=%'
-- then (SELECT IsNull(Folder, '') + [FileName] FROM dbo.[vw_Files]
-- WHERE fileid = CAST(SUBSTRING(tm.IconFile, 8, 10) AS Int))
-- else Coalesce(tm.IconFile,'')
-- end as IconFile,

When you dissect that statement, it fails when trying to do the following:

CAST(SUBSTRING(tm.IconFile, 8, 10) AS Int)

Because the substring that it's utilizing is the file location of the IconFile column, it cannot convert or cast the text string to a number. It would be different if it were trying to convert a text value which is a number.

Instead, replace it with the following: (Taken from DNN 7.4)

dbo.FilePath(TM.IconFile) AS IconFile,

That will fix the issue and allow DNN 8 to run using SQL express 2012. I haven't confirmed if you need to do this for SQL Server 2012, but I suspect the same issue will arise.