Everyone,
Went to install a fresh copy of DNN 4.4.1 on a VPS with Sql Express and used the install copy. Did NOT make a virtual directory but set up a default "WebsiteAAA" under Web Sites and set it up just like it would be under a virtual server. After fighting with the SQL Server Express a few times and using Micheal F's DNN database clearing script(Thanks Mike) i sort of got a clean install. (Sort of)
This was the page part
Installing DotNetNuke
Version: 04.04.01
Installation Status Report
00:00:00.062 - Installing Version: 4.4.0
00:00:00.062 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.125 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeC:\websites\fantasyquest\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:05.437 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeC:\websites\fantasyquest\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:07.437 - Installing MemberRole Provider:
00:00:07.437 - Installing Script: InstallCommon.sql
00:00:08.390 - Installing Script: InstallMembership.sql
00:00:08.828 - Installing Script: InstallProfile.sql
00:00:09.047 - Installing Script: InstallRoles.sql
00:00:09.890 - Upgrading to Version: 4.4.1 Success
00:00:10.031 - Performing General Upgrades
00:00:10.312 - Loading Host Settings:
00:00:10.406 - Configuring SuperUser:
00:00:10.937 - Installing Modules:
00:00:10.968 - Executing Additional Scripts:
00:00:10.968 - Creating Portal: My Website
00:00:14.203 - Successfully Installed Portal 0:
00:00:14.203 - Installing Optional Resources:
Installation Complete
Now, looking at hte DotNetNuke.Data.log was empty and the DotNetNuke.Schema.Log stated that a few of the
pieces already existed, Here is a partial copy of one.
----------------------------------
System.Data.SqlClient.SqlException: There is already an object named 'DNN_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)
CREATE FUNCTION dbo.[DNN_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 DNN_ProfilePropertyDefinition
WHERE PortalID = @PortalID
AND PropertyName = @PropertyName
)
RETURN @DefinitionID
END
-------------------------
Knowing my luck it is something important and the reason for my cascading error but when i "Clicked here to access my portal" I get a blank page with only the header and footer and none of the clean install "meat" that talks about the host and admin id's and passwords.
Should i deattach the database and delete it and reattach it fresh and do another install? I presume i will have to cheal out the file that states what version it is on. (or is it better to deattach the database, save a copy of web.config, unzip the install copy, reattach the database, resotre the saved web.config and just do the install again?
Thoughts? (Don't worry, i will only recreate an hour if needed, done the install half a dozen times due to improper SQL Express settings)
Thank you,
Dean