Hello,
I have just downloaded and installed the latest version of DUD on my DNN installation but I received a number of errors while the install was completing.
The errors are as following. Can anyone help please?
StartJob
Starting Installation
StartJob
Reading files
Info
Loading GroupRadioButton.dll
Info
File GroupRadioButton.dll read successfully
Info
Loading DataSprings.DNN.Modules.DynamicUserDirectory.SqlDataProvider.dll
Info
File DataSprings.DNN.Modules.DynamicUserDirectory.SqlDataProvider.dll read successfully
Info
Loading DataSprings.DNN.Modules.DynamicUserDirectory.dll
Info
File DataSprings.DNN.Modules.DynamicUserDirectory.dll read successfully
Info
Loading ManageSearch.ascx
Info
File ManageSearch.ascx read successfully
Info
Loading Settings.ascx
Info
File Settings.ascx read successfully
Info
Loading DynamicUserDirectoryEdit.ascx
Info
File DynamicUserDirectoryEdit.ascx read successfully
Info
Loading FilterRow.ascx
Info
File FilterRow.ascx read successfully
Info
Loading 01.00.00.SqlDataProvider
Info
File 01.00.00.SqlDataProvider read successfully
Info
Loading 01.00.10.SqlDataProvider
Info
File 01.00.10.SqlDataProvider read successfully
Info
Loading 01.00.11.SqlDataProvider
Info
File 01.00.11.SqlDataProvider read successfully
Info
Loading 01.10.00.SqlDataProvider
Info
File 01.10.00.SqlDataProvider read successfully
Info
Loading 01.20.10.SqlDataProvider
Info
File 01.20.10.SqlDataProvider read successfully
Info
Loading Uninstall.SqlDataProvider
Info
File Uninstall.SqlDataProvider read successfully
Info
Loading DynamicUserDirectory.ascx.resx
Info
File DynamicUserDirectory.ascx.resx read successfully
Info
Loading DynamicUserDirectoryEdit.ascx.resx
Info
File DynamicUserDirectoryEdit.ascx.resx read successfully
Info
Loading ManageSearch.ascx.resx
Info
File ManageSearch.ascx.resx read successfully
Info
Loading Settings.ascx.resx
Info
File Settings.ascx.resx read successfully
Info
Loading 01.20.20.SqlDataProvider
Info
File 01.20.20.SqlDataProvider read successfully
Info
Loading DynamicUserDirectory 02.60.00.dnn
Info
File DynamicUserDirectory 02.60.00.dnn read successfully
Info
Loading 02.20.10.SqlDataProvider
Info
File 02.20.10.SqlDataProvider read successfully
Info
Loading checkboxicon.gif
Info
File checkboxicon.gif read successfully
Info
Loading icon2.gif
Info
File icon2.gif read successfully
Info
Loading 02.30.00.SqlDataProvider
Info
File 02.30.00.SqlDataProvider read successfully
Info
Loading 02.40.00.SqlDataProvider
Info
File 02.40.00.SqlDataProvider read successfully
Info
Loading 02.40.20.SqlDataProvider
Info
File 02.40.20.SqlDataProvider read successfully
Info
Loading 02.50.00.SqlDataProvider
Info
File 02.50.00.SqlDataProvider read successfully
Info
Loading _ControlPanel.ascx
Info
File _ControlPanel.ascx read successfully
Info
Loading _ControlPanel.ascx.resx
Info
File _ControlPanel.ascx.resx read successfully
Info
Loading DynamicUserDirectory_Resources.zip
Info
File DynamicUserDirectory_Resources.zip read successfully
Info
Loading excelexport.gif
Info
File excelexport.gif read successfully
Info
Loading Progress.gif
Info
File Progress.gif read successfully
Info
Loading 02.50.60.SqlDataProvider
Info
File 02.50.60.SqlDataProvider read successfully
Info
Loading Instructions for Installing Dynamic User Directory 2.60.00.txt
Info
File Instructions for Installing Dynamic User Directory 2.60.00.txt read successfully
Info
Loading DynamicUserDirectory.ascx
Info
File DynamicUserDirectory.ascx read successfully
Info
Loading 03.10.00.SqlDataProvider
Info
File 03.10.00.SqlDataProvider read successfully
Info
Loading DataSpringsLicense.ascx
Info
File DataSpringsLicense.ascx read successfully
Info
Loading ViewScheduleHistory.ascx
Info
File ViewScheduleHistory.ascx read successfully
EndJob
Reading files done.
StartJob
Reading DNN file
Info
DNN file is in valid 3.0 format.
Info
xml loaded.
Info
Loading files info
Info
Loading Modules info
Info
Loading Control info for 'Dynamic User Directory' module
EndJob
Dnn load finished successfully
StartJob
Begin Sql execution
Info
Executing 01.00.00.SqlDataProvider
StartJob
Start Sql execution: 01.00.00.SqlDataProvider file
EndJob
End Sql execution: 01.00.00.SqlDataProvider file
Info
Executing 01.00.10.SqlDataProvider
StartJob
Start Sql execution: 01.00.10.SqlDataProvider file
EndJob
End Sql execution: 01.00.10.SqlDataProvider file
Info
Executing 01.00.11.SqlDataProvider
StartJob
Start Sql execution: 01.00.11.SqlDataProvider file
EndJob
End Sql execution: 01.00.11.SqlDataProvider file
Info
Executing 01.10.00.SqlDataProvider
StartJob
Start Sql execution: 01.10.00.SqlDataProvider file
EndJob
End Sql execution: 01.10.00.SqlDataProvider file
Info
Executing 01.20.10.SqlDataProvider
StartJob
Start Sql execution: 01.20.10.SqlDataProvider file
EndJob
End Sql execution: 01.20.10.SqlDataProvider file
Info
Executing 01.20.20.SqlDataProvider
StartJob
Start Sql execution: 01.20.20.SqlDataProvider file
EndJob
End Sql execution: 01.20.20.SqlDataProvider file
Info
Executing 02.20.10.SqlDataProvider
StartJob
Start Sql execution: 02.20.10.SqlDataProvider file
EndJob
End Sql execution: 02.20.10.SqlDataProvider file
Info
Executing 02.30.00.SqlDataProvider
StartJob
Start Sql execution: 02.30.00.SqlDataProvider file
EndJob
End Sql execution: 02.30.00.SqlDataProvider file
Info
Executing 02.40.00.SqlDataProvider
StartJob
Start Sql execution: 02.40.00.SqlDataProvider file
EndJob
End Sql execution: 02.40.00.SqlDataProvider file
Info
Executing 02.40.20.SqlDataProvider
StartJob
Start Sql execution: 02.40.20.SqlDataProvider file
EndJob
End Sql execution: 02.40.20.SqlDataProvider file
Info
Executing 02.50.00.SqlDataProvider
StartJob
Start Sql execution: 02.50.00.SqlDataProvider file
EndJob
End Sql execution: 02.50.00.SqlDataProvider file
Info
Executing 02.50.60.SqlDataProvider
StartJob
Start Sql execution: 02.50.60.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near ',['. Incorrect syntax near '@columns'. 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 Procedure dbo.[DataSprings_RetrieveDNNUserProfileData3a] AS BEGIN DECLARE @columns VARCHAR(8000) SELECT @columns = COALESCE(@columns ',[' cast(propertyname as varchar) ']', '[' cast(propertyname as varchar) ']') FROM dbo.tempDUDProfile GROUP BY propertyname DECLARE @query VARCHAR(8000) SET @query = ' SELECT * INTO dbo.tempDUDPIVOT FROM dbo.tempDUDProfile PIVOT ( MAX(propertyvalue) FOR [propertyname] IN (' @columns ') ) AS p ' EXECUTE(@query) END
EndJob
End Sql execution: 02.50.60.SqlDataProvider file
Info
Executing 03.10.00.SqlDataProvider
StartJob
Start Sql execution: 03.10.00.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'DataSprings_DUD_GetUserRoles' in the database. 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 dbo.[DataSprings_DUD_GetUserRoles] (@UserID int) RETURNS nvarchar(2000) AS BEGIN Declare @UserRoles nvarchar(2000) declare @RoleName nvarchar(500) declare RoleList cursor for Select B.RoleName from dbo.[Userroles] A Inner Join dbo.[Roles] B on A.RoleID = B.RoleID Where (UserID = @UserID) AND (ExpiryDate >= GetDate() OR ExpiryDate Is Null) AND (EffectiveDate ' FETCH NEXT FROM RoleList INTO @RoleName END CLOSE RoleList DEALLOCATE RoleList Return @UserRoles END
EndJob
End Sql execution: 03.10.00.SqlDataProvider file
EndJob
Finished Sql execution
StartJob
Creating files
StartJob
Expanding Resource file
EndJob
Resource Files created
StartJob
Expanding Resource file
EndJob
Resource Files created
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\DynamicUserDirectory.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\ViewScheduleHistory.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\DataSpringsLicense.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\DynamicUserDirectoryEdit.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Settings.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\_ControlPanel.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\FilterRow.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\ManageSearch.ascx
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\bin\DataSprings.DNN.Modules.DynamicUserDirectory.dll
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\bin\DataSprings.DNN.Modules.DynamicUserDirectory.SqlDataProvider.dll
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\bin\GroupRadioButton.dll
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\01.00.10.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\01.00.11.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\01.10.00.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\01.20.10.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\01.20.20.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\02.20.10.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\02.30.00.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\02.40.00.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\02.40.20.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\02.50.00.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\02.50.60.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Providers\DataProviders\SqlDataProvider\03.10.00.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\Uninstall.SqlDataProvider
Info
Created e:\domains\i\ibbd-fasthosts.co.uk\user\htdocs\DesktopModules\Dynamic User Directory\DynamicUserDirectory 02.60.00.dnn.config
EndJob
Files created
StartJob
Registering DesktopModule
Info
Registering Definitions
Info
Registering Controls
EndJob
Registering finished
EndJob
Installation successful.
v