i am trying to upgrade DNN 3.1.1
according to http://www.dnnsoftware.com/Resources/Wiki/Page/Suggested_Upgrade_Path.aspx suggested upgrade path
first i upgraded to DNN 3.1.1 to DNN 3.2.2
Upgrading DotNetNuke
Current Assembly Version: 03.02.02
Current Database Version: 03.01.01
Upgrade Status Report
00:00:00.046 - Upgrading to Version: 3.2.0
00:00:00.421 - Upgrading to Version: 3.2.1
00:00:00.655 - Upgrading to Version: 3.2.2
00:00:00.670 - Performing General Upgrades
00:00:01.606 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Announcements_3.1_Install.zip:
00:00:02.246 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Contacts_3.1_Install.zip:
00:00:02.262 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Discussions_3.1_Install.zip:
00:00:02.277 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Documents_3.1_Install.zip:
00:00:02.293 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Events_3.1_Install.zip:
00:00:02.308 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\FAQs_3.1_Install.zip:
00:00:02.324 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Feedback_3.1_Install.zip:
00:00:02.340 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\HTML_3.1_Install.zip:
00:00:02.355 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\IFrame_3.1_Install.zip:
00:00:02.355 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Image_3.1_Install.zip:
00:00:02.371 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Links_3.1_Install.zip:
00:00:02.386 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\NewsFeeds_3.1_Install.zip:
00:00:02.402 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\Survey_3.1_Install.zip:
00:00:02.418 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\UserDefinedTable_3.1_Install.zip:
00:00:02.433 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\UsersOnline_3.1_Install.zip:
00:00:02.449 - Installing Module File C:\inetpub\wwwroot\kznhousing_internet\Install\Module\XML_3.1_Install.zip:
Upgrade Complete
now when i am trying to upgrade DNN 3.2.2 to DNN 4.3.7
its giving the upgrade errors
Upgrading DotNetNuke
Current Assembly Version: 04.03.07
Current Database Version: 03.02.02
00:00:00.015 - Executing Script: C:\inetpub\wwwroot\kznhousing_internet\Providers\DataProviders\SqlDataProvider\Upgrade.SqlDataProvider
Upgrade Status Report
00:00:00.171 - Upgrading to Version: 3.2.3 Error! (seeC:\inetpub\wwwroot\kznhousing_internet\Providers\DataProviders\SqlDataProvider\03.02.03.log for more information)
00:00:03.338 - Upgrading to Version: 3.2.4 Success
00:00:03.369 - Upgrading to Version: 3.2.5 Success
00:00:03.385 - Upgrading to Version: 3.2.6 Success
00:00:03.416 - Upgrading to Version: 3.2.7 Success
00:00:03.432 - Upgrading to Version: 3.3.0 Success
00:00:03.447 - Upgrading to Version: 3.3.1 Error! (seeC:\inetpub\wwwroot\kznhousing_internet\Providers\DataProviders\SqlDataProvider\03.03.01.log for more information)
00:00:03.510 - Upgrading to Version: 3.3.2 Success
00:00:03.572 - Upgrading to Version: 3.3.3 Success
00:00:03.681 - Upgrading to Version: 4.0.0 Success
00:00:03.915 - Upgrading to Version: 4.0.1 Success
00:00:03.978 - Upgrading to Version: 4.0.2 Success
00:00:03.993 - Upgrading to Version: 4.0.3 Success
00:00:04.009 - Upgrading to Version: 4.0.4 Success
00:00:04.898 - Upgrading to Version: 4.0.5 Success
00:00:04.914 - Upgrading to Version: 4.0.6 Success
00:00:04.914 - Upgrading to Version: 4.0.7 Success
00:00:04.929 - Upgrading to Version: 4.3.0 Success
00:00:04.945 - Upgrading to Version: 4.3.1 Error! (seeC:\inetpub\wwwroot\kznhousing_internet\Providers\DataProviders\SqlDataProvider\04.03.01.log for more information)
00:00:04.992 - Upgrading to Version: 4.3.2 Success
00:00:05.023 - Upgrading to Version: 4.3.3 Success
00:00:05.132 - Upgrading to Version: 4.3.4 Success
00:00:05.163 - Upgrading to Version: 4.3.5 Success
00:00:05.272 - Upgrading to Version: 4.3.6 Success
00:00:05.350 - Upgrading to Version: 4.3.7 Success
00:00:05.428 - Performing General Upgrades
Upgrade Complete
the errors are
03.02.03
System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "housing", table "dbo.Folders", column 'FolderID'.
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
--------
03. 03.01
System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "housing", table "dbo.Folders", column 'FolderID'.
/* This sets all cache root folders to protected */
/*************************************************/
UPDATE Folders
SET IsProtected = 1
WHERE
FolderPath = 'Cache/'
/* This tries to apply a foreign key on the files/folders tables */
/*****************************************************************/
IF NOT EXISTS ( SELECT * FROM sysobjects WHERE id = object_id(N'FK_Files_Folders') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
BEGIN
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
END
----------
4.3.1
System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Folders". The conflict occurred in database "housing", table "dbo.Folders", column 'FolderID'.
/* This tries to apply a foreign key on the files/folders tables */
/*****************************************************************/
IF NOT EXISTS ( SELECT * FROM sysobjects WHERE id = object_id(N'FK_Files_Folders') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
BEGIN
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
END