I Have installed the 4.3.5 “Install” kit on my ISP’s server sever times no and get this error. The system works ok, I can populate my default portal. After I have created a child or two, I get DoNetNuke yellow screen of death suggesting that I use my own custom error page. I have to rebuild the MS SQL database and reinstall the kit to start again!
What is the best way to trouble shoot a problem like this?
What is the best way to backup your portal(s)? I have tried exporting portals and restoring them by making a new portal using the saved “template”. This has problems with photos and other items not included in the saved template. I saved my main portal, but it seems that one can’t recreate it using “create portal”, son I have had to re-enter the data 4 times by hand now.
Installing DotNetNuke
Version: 04.03.05
Installation Status Report
00:00:00.062 - Installing Version: 3.1.0
00:00:00.062 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.171 - Installing Script: DotNetNuke.Schema.SqlDataProvider Success
00:00:03.078 - Installing Script: DotNetNuke.Data.SqlDataProvider Success
00:00:05.718 - Installing MemberRole Provider:
00:00:05.718 - Executing InstallCommon.sql
00:00:06.093 - Executing InstallMembership.sql
00:00:06.422 - Executing InstallProfile.sql
00:00:06.609 - Executing InstallRoles.sql
Success
00:00:07.609 - Upgrading to Version: 3.1.1 Success
00:00:09.937 - Upgrading to Version: 3.2.0 Success
00:00:10.094 - Upgrading to Version: 3.2.1 Success
00:00:10.187 - Upgrading to Version: 3.2.2 Success
00:00:10.187 - Upgrading to Version: 3.2.3 Success
00:00:11.609 - Upgrading to Version: 3.2.4 Success
00:00:11.750 - Upgrading to Version: 3.2.5 Success
00:00:11.812 - Upgrading to Version: 3.2.6 Success
00:00:11.875 - Upgrading to Version: 3.2.7 Success
00:00:11.906 - Upgrading to Version: 3.3.0 Success
00:00:12.000 - Upgrading to Version: 3.3.1 Success
00:00:12.047 - Upgrading to Version: 3.3.2 Success
00:00:12.172 - Upgrading to Version: 3.3.3 Success
00:00:12.391 - Upgrading to Version: 4.0.0 Error! (seed:\hosting\dotti\dnn\Providers\DataProviders\SqlDataProvider\04.00.00.log for more information)
00:00:12.656 - Upgrading to Version: 4.0.1 Success
00:00:12.781 - Upgrading to Version: 4.0.2 Success
00:00:12.812 - Upgrading to Version: 4.0.3 Success
00:00:12.859 - Upgrading to Version: 4.0.4 Success
00:00:13.547 - Upgrading to Version: 4.0.5 Success
00:00:13.562 - Upgrading to Version: 4.0.6 Success
00:00:13.578 - Upgrading to Version: 4.0.7 Success
00:00:13.609 - Upgrading to Version: 4.3.0 Success
00:00:13.641 - Upgrading to Version: 4.3.1 Success
00:00:13.703 - Upgrading to Version: 4.3.2 Success
00:00:13.781 - Upgrading to Version: 4.3.3 Success
00:00:14.031 - Upgrading to Version: 4.3.4 Success
00:00:14.078 - Upgrading to Version: 4.3.5 Success
00:00:14.375 - Performing General Upgrades
00:00:14.953 - Loading Host Settings:
00:00:15.234 - Configuring SuperUser:
00:00:16.875 - Installing Modules:
00:00:16.922 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Announcements_03.03.04_Install.zip: Success
00:00:18.234 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Blog_3.02.00_Install.zip: Success
00:00:20.547 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Contacts_3.1_Install.zip: Success
00:00:21.016 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Documents_03.01.05_Install.zip: Success
00:00:21.610 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Events_3.2_Install.zip: Success
00:00:24.485 - Installing Module File d:\hosting\dotti\dnn\Install\Module\FAQs_3.1_Install.zip: Success
00:00:24.891 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Feedback_03.02.01_Install.zip: Success
00:00:25.313 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Forum_3.20.08_Install.zip: Success
00:00:33.329 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Gallery_3.0.12_Install.zip: Success
00:00:36.344 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Help_2.0.4_Install.zip: Success
00:00:37.876 - Installing Module File d:\hosting\dotti\dnn\Install\Module\HTML_3.3.0_Install.zip: Success
00:00:38.329 - Installing Module File d:\hosting\dotti\dnn\Install\Module\IFrame_3.2_Install.zip: Success
00:00:38.798 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Links_3.3_Install.zip: Success
00:00:39.595 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Media_03.02.02_Install.zip: Success
00:00:40.329 - Installing Module File d:\hosting\dotti\dnn\Install\Module\NewsFeeds_3.1.1_Install.zip: Success
00:00:40.923 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Reports_4.3.1_Source.zip: Error!
00:00:41.110 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Repository_3.1.10_Install.zip: Success
00:00:46.767 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Store_01.00.01_Install.zip: Success
00:00:50.407 - Installing Module File d:\hosting\dotti\dnn\Install\Module\Survey_3.3_Install.zip: Success
00:00:51.907 - Installing Module File d:\hosting\dotti\dnn\Install\Module\UserDefinedTable_3.03.03_Install.zip: Success
00:00:54.986 - Installing Module File d:\hosting\dotti\dnn\Install\Module\UsersOnline_3.1_Install.zip: Success
00:00:55.314 - Installing Module File d:\hosting\dotti\dnn\Install\Module\WhatsNew_3.3_Install.zip: Success
00:00:55.439 - Installing Module File d:\hosting\dotti\dnn\Install\Module\XML_3.1_Install.zip: Success
00:00:55.658 - Executing Additional Scripts:
00:00:55.658 - Creating Portal: My Website
00:01:13.892 - Successfully Installed Portal 0:
00:01:13.892 - Installing Optional Resources:
Installation Complete
04.00.00.log Follows
System.Data.SqlClient.SqlException: There is already an object named 'aspnet_AnyDataInTables' 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 PROCEDURE [dbo].aspnet_AnyDataInTables
@TablesToCheck int
AS
BEGIN
-- Check Membership table if (@TablesToCheck & 1) is set
IF ((@TablesToCheck & 1) <> 0 AND
(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_MembershipUsers') AND (type = 'V'))))
BEGIN
IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Membership))
BEGIN
SELECT N'aspnet_Membership'
RETURN
END
END
-- Check aspnet_Roles table if (@TablesToCheck & 2) is set
IF ((@TablesToCheck & 2) <> 0 AND
(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_Roles') AND (type = 'V'))) )
BEGIN
IF (EXISTS(SELECT TOP 1 RoleId FROM dbo.aspnet_Roles))
BEGIN
SELECT N'aspnet_Roles'
RETURN
END
END
-- Check aspnet_Profile table if (@TablesToCheck & 4) is set
IF ((@TablesToCheck & 4) <> 0 AND
(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_Profiles') AND (type = 'V'))) )
BEGIN
IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Profile))
BEGIN
SELECT N'aspnet_Profile'
RETURN
END
END
-- Check aspnet_PersonalizationPerUser table if (@TablesToCheck & 8) is set
IF ((@TablesToCheck & 8) <> 0 AND
(EXISTS (SELECT name FROM sysobjects WHERE (name = N'vw_aspnet_WebPartState_User') AND (type = 'V'))) )
BEGIN
IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_PersonalizationPerUser))
BEGIN
SELECT N'aspnet_PersonalizationPerUser'
RETURN
END
END
-- Check aspnet_PersonalizationPerUser table if (@TablesToCheck & 16) is set
IF ((@TablesToCheck & 16) <> 0 AND
(EXISTS (SELECT name FROM sysobjects WHERE (name = N'aspnet_WebEvent_LogEvent') AND (type = 'P'))) )
BEGIN
IF (EXISTS(SELECT TOP 1 * FROM dbo.aspnet_WebEvent_Events))
BEGIN
SELECT N'aspnet_WebEvent_Events'
RETURN
END
END
-- Check aspnet_Users table if (@TablesToCheck & 1,2,4 & 8) are all set
IF ((@TablesToCheck & 1) <> 0 AND
(@TablesToCheck & 2) <> 0 AND
(@TablesToCheck & 4) <> 0 AND
(@TablesToCheck & 8) <> 0 AND
(@TablesToCheck & 32) <> 0 AND
(@TablesToCheck & 128) <> 0 AND
(@TablesToCheck & 256) <> 0 AND
(@TablesToCheck & 512) <> 0 AND
(@TablesToCheck & 1024) <> 0)
BEGIN
IF (EXISTS(SELECT TOP 1 UserId FROM dbo.aspnet_Users))
BEGIN
SELECT N'aspnet_Users'
RETURN
END
IF (EXISTS(SELECT TOP 1 ApplicationId FROM dbo.aspnet_Applications))
BEGIN
SELECT N'aspnet_Applications'
RETURN
END
END
END