Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation of DNN 5 failedInstallation of DNN 5 failed
Previous
 
Next
New Post
1/20/2009 8:53 AM
 

 

Installing DotNetNuke
Version: 05.00.00
========================================================
 
Installation Status Report
00:00:00.046 - Installing Version: 5.0.0
00:00:00.046 -   Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log for more information)
00:00:08.156 -   Executing Script: DotNetNuke.Data.SqlDataProvider Success
00:00:13.609 - Installing MemberRole Provider:
00:00:13.609 -   Executing Script: InstallCommon
00:00:14.609 -   Executing Script: InstallMembership
00:00:15.343 -   Executing Script: InstallProfile
00:00:15.890 -   Executing Script: InstallRoles
00:00:16.578 - Upgrading to Version: 5.0.0
00:00:16.593 - Performing General Upgrades
00:00:18.140 - Loading Host Settings:
00:00:18.578 - Configuring SuperUser:
00:00:19.312 - Synchronizing Host Files:
00: - Executing Additional Scripts:
00: - Installing Optional Modules:
00:00:20.015 -   Installing Package File Adsense_01.00.01_Install: Success
00:00:21.218 -   Installing Package File HTML_04.08.01_Install: Success
00:00:24.765 -   Installing Package File Links_04.00.01_Install: Success
00:00:27.015 - Installing Optional Skins:
00:00:27.031 - Installing Optional Containers:
00:00:27.031 - Installing Optional Languages:
00:00:27.031 - Installing Optional Providers:
00:00:27.062 -   Installing Package File AspNetMembershipProvider_05.00.00_Install: Success
00:00:27.187 -   Installing Package File DatabaseLoggingProvider_05.00.00_Install: Success
00:00:27.250 -   Installing Package File DNNMembershipProvider_05.00.00_Install: Success
00:00:27.328 -   Installing Package File DNNMenuNavigationProvider_05.00.00_Install: Success
00:00:27.500 -   Installing Package File DNNTreeNavigationProvider_05.00.00_Install: Success
00:00:27.687 -   Installing Package File FckHtmlEditorProvider_02.00.02_Install: Success
00:00:29.796 -   Installing Package File FileBasedCachingProvider_05.00.00_Install: Success
00:00:29.859 -   Installing Package File SchedulingProvider_05.00.00_Install: Success
00:00:30.187 -   Installing Package File SearchIndexProvider_05.00.00_Install: Success
00:00:30.234 -   Installing Package File SearchProvider_05.00.00_Install: Success
00:00:30.312 -   Installing Package File SolpartMenuNavigationProvider_05.00.00_Install: Success
00:00:30.390 - Installing Optional AuthSystems:
00:00:30.390 -   Installing Package File LiveID_01.00.01_Install: Success
00:00:30.468 -   Installing Package File OpenID_02.00.00_Install: Success
00:00:30.593 - Installing Optional Packages:
00:00:30.593 -   Creating Portal: My Website
00:00:30.765 -   Error: Error creating Profile Definitions
00:00:30.765 -   Portal failed to install:Error!
 
Installation Complete
 
 
 
 
DotNetNuke.Schema.log contains following error:
====================================================================================================================
System.Data.SqlClient.SqlException: 'GetListParentKey' is not a recognized built-in function name.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
 

I want to install DNN5 on a IIS 6 (Windows 2003) Server. At the same host, in a different directory DNN 04.08.04 ist installed and runs without problems.

But if i want to install DNN5 InstallWizzard failes in all 3 Modes.

In Mode automatic the output is following:

Does anyone know why? Please help!!

 
New Post
9/25/2009 5:02 PM
 

I'm having the same problem, with version 5.01.02.

I just downloaded it, unzipped, added an existing website to my solution in visual studio.

Then I set the DNN website as the main project for my solution and hit CTRL+F5 to run without debugging.

The installation wizard appears, all tests pass, but when runnig the scripts I get:

 

Installing Database - Version 05.00.00...FAILURE ERROR: See C:\Users\ecruz\Documents\Visual Studio 2008\Projects\Sistema Clickvan\Clickvan.Site\Providers\DataProviders\SqlDataProvider\05.00.00.log for more information
 

 

But the referenced file doesn't exist. However, I found some info on the DotNetNuke.Schema.log in the same folder. Here are the full contents of the file:

 

System.Data.SqlClient.SqlException: 'ddn_GetListParentKey' is not a recognized built-in function name.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)




CREATE FUNCTION [ddn_GetListParentKey]
(
    @ParentID AS int,
    @ListName as nvarchar(50),
    @Type as nvarchar(50),
    @Count as int
)
RETURNS nvarchar(2000)

AS
    BEGIN
        DECLARE @KeyValue nvarchar(2000)
        DECLARE @ListValue nvarchar(2000)
        DECLARE @TextValue nvarchar(2000)
        DECLARE @ReturnValue nvarchar(2000)
        DECLARE @Key nvarchar(2000)
       
        IF @ParentID = 0
            IF @Count = 0
                SET @ReturnValue = ''
            ELSE
                SET @ReturnValue = @ListName
        ELSE
            BEGIN
                SELECT    @KeyValue = ListName + '.' + [Value],
                        @TextValue = ListName + '.' + [Text],
                        @ListValue = ListName,
                        @ParentID = ParentID 
                    FROM ddn_Lists
                    WHERE EntryID = @ParentID
                If @Type = 'ParentKey' Or (@Type = 'ParentList' AND @Count > 0)
                    SET @ReturnValue = @KeyValue
                ELSE
                    IF @Type = 'ParentList'
                        SET @ReturnValue = @ListValue
                    ELSE
                        SET @ReturnValue = @TextValue
                IF @Count > 0
                    If @Count = 1 AND @Type = 'ParentList'
                        SET @ReturnValue = @ReturnValue + ':' + @ListName
                    ELSE
                        SET @ReturnValue = @ReturnValue + '.' + @ListName
                SET @ReturnValue = ddn_GetListParentKey(@ParentID, @ReturnValue, @Type, @Count+1)
            END

        RETURN    @ReturnValue
    END


System.Data.SqlClient.SqlException: 'ddn_GetListParentKey' is not a recognized built-in function name.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'AS'.
Incorrect syntax near the keyword 'AS'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)




CREATE VIEW [ddn_vw_Lists]
AS
    SELECT    
        EntryID,
        ListName,
        Value,
        Text,
        [Level],
        SortOrder,
        DefinitionID,
        ParentID,
        Description,
        PortalID,
        SystemList,
        ddn_GetListParentKey(ParentID, ListName, N'ParentKey', 0) AS ParentKey,
        ddn_GetListParentKey(ParentID, ListName, N'Parent', 0) AS Parent,
        ddn_GetListParentKey(ParentID, ListName, N'ParentList', 0) AS ParentList,
        (SELECT MAX(SortOrder) FROM [ddn_Lists] WHERE (ListName = L.ListName) AND (ParentID = L.ParentID)) AS MaxSortOrder,
        (SELECT COUNT(EntryID) FROM [ddn_Lists] AS ddn_Lists_1 WHERE (ListName = L.ListName) AND (ParentID = L.ParentID)) AS EntryCount,
        (SELECT COUNT(DISTINCT ParentID) FROM [ddn_Lists] AS ddn_Lists_2 WHERE (ParentID = L.EntryID)) AS HasChildren
    FROM  [ddn_Lists] AS L



System.Data.SqlClient.SqlException: 'ddn_getelement' is not a recognized built-in function name.
'ddn_getelement' is not a recognized built-in function name.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)




CREATE FUNCTION [ddn_GetProfileElement]
(
    @fieldName AS NVARCHAR(100),
    @fields AS NVARCHAR(4000),
    @values AS NVARCHAR(4000)
)

RETURNS NVARCHAR(4000)

AS

BEGIN

    -- If input is invalid, return null.
    IF  @fieldName IS NULL
        OR LEN(@fieldName) = 0
        OR @fields IS NULL
        OR LEN(@fields) = 0
        OR @values IS NULL
        OR LEN(@values) = 0
        RETURN NULL

    -- locate FieldName in Fields
    DECLARE @fieldNameToken AS NVARCHAR(20)
    DECLARE @fieldNameStart AS INTEGER, @valueStart AS INTEGER, @valueLength AS INTEGER

    -- Only handle string type fields (:S:)
    SET @fieldNameStart = CHARINDEX(@fieldName + ':S',@Fields,0)

    -- If field is not found, return null
    IF @fieldNameStart = 0 RETURN NULL
    SET @fieldNameStart = @fieldNameStart + LEN(@fieldName) + 3

    -- Get the field token which I've defined as the start of the field offset to the end of the length
    SET @fieldNameToken =
    SUBSTRING(@Fields,@fieldNameStart,LEN(@Fields)-@fieldNameStart)

    -- Get the values for the offset and length
    SET @valueStart = ddn_getelement(1,@fieldNameToken,':')
    SET @valueLength = ddn_getelement(2,@fieldNameToken,':')

    -- Check for sane values, 0 length means the profile item was stored, just no data
    IF @valueLength = 0 RETURN ''

    -- Return the string
    RETURN SUBSTRING(@values, @valueStart+1, @valueLength)
END





 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Installation of DNN 5 failedInstallation of DNN 5 failed


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out