Hi,
I'm trying to install dotnetnuke 4 onto a shared web hosting service. Everything seems to be okay except the fact that they are not able to have my user login as db_owner for my database. I tried to install the app anyways and it encountered some errors during installation. However, I was still able to access the website. Would this cause me problems later on? I have attached the installation logs below as reference.
Thanks!!
Installing DotNetNukeVersion: 04.03.05
Installation Status Report00:00:00.187 - Installing Version: 3.1.0
00:00:00.218 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.375 - Installing Script: DotNetNuke.Schema.SqlDataProvider Success
00:00:02.375 - Installing Script: DotNetNuke.Data.SqlDataProvider Success
00:00:06.640 - Installing MemberRole Provider:
00:00:06.640 - Executing InstallCommon.sql
00:00:06.875 - Executing InstallMembership.sql
00:00:07.187 - Executing InstallProfile.sql
00:00:07.328 - Executing InstallRoles.sql
Error!
00:00:07.797 - Upgrading to Version: 3.1.1 Success
00:00:08.968 - Upgrading to Version: 3.2.0 Success
00:00:09.125 - Upgrading to Version: 3.2.1 Success
00:00:09.187 - Upgrading to Version: 3.2.2 Success
00:00:10.000 - Upgrading to Version: 3.2.3 Error! (seeD:\Webs\know49\portal\Providers\DataProviders\SqlDataProvider\03.02.03.log for more information)
00:00:11.844 - Upgrading to Version: 3.2.4 Success
00:00:11.906 - Upgrading to Version: 3.2.5 Success
00:00:11.953 - Upgrading to Version: 3.2.6 Success
00:00:12.000 - Upgrading to Version: 3.2.7 Success
00:00:12.031 - Upgrading to Version: 3.3.0 Success
00:00:12.062 - Upgrading to Version: 3.3.1 Success
00:00:12.109 - Upgrading to Version: 3.3.2 Success
00:00:12.187 - Upgrading to Version: 3.3.3 Success
00:00:12.344 - Upgrading to Version: 4.0.0 Success
00:00:12.500 - Upgrading to Version: 4.0.1 Success
00:00:12.578 - Upgrading to Version: 4.0.2 Success
00:00:12.594 - Upgrading to Version: 4.0.3 Success
00:00:12.625 - Upgrading to Version: 4.0.4 Success
00:00:13.328 - Upgrading to Version: 4.0.5 Success
00:00:13.344 - Upgrading to Version: 4.0.6 Success
00:00:13.422 - Upgrading to Version: 4.0.7 Success
00:00:13.531 - Upgrading to Version: 4.3.0 Success
00:00:13.562 - Upgrading to Version: 4.3.1 Success
00:00:13.594 - Upgrading to Version: 4.3.2 Success
00:00:13.656 - Upgrading to Version: 4.3.3 Success
00:00:13.797 - Upgrading to Version: 4.3.4 Success
00:00:13.812 - Upgrading to Version: 4.3.5 Success
00:00:13.969 - Performing General Upgrades
00:00:14.359 - Loading Host Settings:
00:00:14.719 - Configuring SuperUser:
00:00:15.562 - Installing Modules:
00:00:15.656 - Executing Additional Scripts:
00:00:15.656 - Creating Portal: My Website
00:00:24.578 - Successfully Installed Portal 0:
00:00:24.578 - Installing Optional Resources:
Installation Complete*****************************************
03.02.03.log
System.Data.SqlClient.SqlException: There is already an object named 'GetProfilePropertyDefinitionID' 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)
/* Add GetProfilePropertyDefinitionID Function */
/***********************************************/
CREATE FUNCTION know49.[GetProfilePropertyDefinitionID]
(
@PortalID int,
@PropertyName nvarchar(50)
)
RETURNS int
AS
BEGIN
DECLARE @DefinitionID int
SELECT @DefinitionID = -1
IF @PropertyName IS NULL
OR LEN(@PropertyName) = 0
RETURN -1
IF @PortalID IS NULL
SET @POrtalID = -1
SET @DefinitionID = (SELECT PropertyDefinitionID
FROM ProfilePropertyDefinition
WHERE PortalID = @PortalID
AND PropertyName = @PropertyName
)
RETURN @DefinitionID
END
System.Data.SqlClient.SqlException: There is already an object named 'GetProfileElement' 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)
/* Add GetProfileElement Function */
/**********************************/
CREATE FUNCTION know49.[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 = know49.getelement(1,@fieldNameToken,':')
SET @valueLength = know49.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
System.Data.SqlClient.SqlException: There is already an object named 'GetElement' 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)
/* Add GetElement Function */
/***************************/
CREATE FUNCTION know49.[GetElement]
(
@ord AS INT,
@str AS VARCHAR(8000),
@delim AS VARCHAR(1)
)
RETURNS INT
AS
BEGIN
-- If input is invalid, return null.
IF @str IS NULL
OR LEN(@str) = 0
OR @ord IS NULL
OR @ord < 1
-- @ord > [is the] expression that calculates the number of elements.
OR @ord > LEN(@str) - LEN(REPLACE(@str, @delim, '')) + 1
RETURN NULL
DECLARE @pos AS INT, @curord AS INT
SELECT @pos = 1, @curord = 1
-- Find next element's start position and increment index.
WHILE @curord < @ord
SELECT
@pos = CHARINDEX(@delim, @str, @pos) + 1,
@curord = @curord + 1
RETURN CAST(SUBSTRING(@str, @pos, CHARINDEX(@delim, @str + @delim, @pos) - @pos) AS INT)
END
System.Data.SqlClient.SqlException: SELECT permission denied on object 'aspnet_Users', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Profile', database 'know49', owner 'dbo'.
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)
--Extract from Profile Blob to Temp Table
INSERT INTO FlatProfile
SELECT
users.userid,
userportals.portalid,
users.username,
users.firstname,
users.lastname,
know49.GetProfileElement('Street',PropertyNames,PropertyValuesString) Street,
know49.GetProfileElement('Unit',PropertyNames,PropertyValuesString) Unit,
know49.GetProfileElement('City',PropertyNames,PropertyValuesString) City,
know49.GetProfileElement('Country',PropertyNames,PropertyValuesString) Country,
know49.GetProfileElement('Region',PropertyNames,PropertyValuesString) Region,
know49.GetProfileElement('PostalCode',PropertyNames,PropertyValuesString) PostalCode,
know49.GetProfileElement('Telephone',PropertyNames,PropertyValuesString) Telephone,
know49.GetProfileElement('Cell',PropertyNames,PropertyValuesString) Cell,
know49.GetProfileElement('Fax',PropertyNames,PropertyValuesString) Fax,
know49.GetProfileElement('Website',PropertyNames,PropertyValuesString) Website,
know49.GetProfileElement('IM',PropertyNames,PropertyValuesString) IM,
know49.GetProfileElement('PreferredLocale',PropertyNames,PropertyValuesString) PreferredLocale,
know49.GetProfileElement('TimeZone',PropertyNames,PropertyValuesString) TimeZone,
aspnet_profile.LastUpdatedDate
FROM Users
inner join userportals on users.userid = userportals.userid
inner join aspnet_users on users.username = aspnet_users.username
inner join aspnet_profile on aspnet_profile.userid = aspnet_users.userid
where userportals.portalid = PortalID
System.Data.SqlClient.SqlException: SELECT permission denied on object 'aspnet_Applications', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Applications', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Applications', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Membership', database 'know49', owner 'dbo'.
UPDATE permission denied on object 'aspnet_Membership', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Applications', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Users', database 'know49', owner 'dbo'.
UPDATE permission denied on object 'aspnet_Users', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Applications', database 'know49', owner 'dbo'.
SELECT permission denied on object 'aspnet_Users', database 'know49', owner 'dbo'.
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)
--Declare Variables
DECLARE @PortalID int
-- Transfer Super Users
EXECUTE TransferUsersToSameContext N'DotNetNuke', NULL
--Iterate through Portals to transfer users
SELECT @PortalID = min(PortalID)
FROM know49.Portals
WHILE @PortalID IS NOT NULL
BEGIN
-- Transfer Portal Users
EXECUTE TransferUsersToSameContext N'DotNetNuke', @PortalID
SELECT @PortalID = min(PortalID)
FROM know49.Portals
WHERE PortalID > @PortalID
END
|