I upgraded from a prior version of DNN 3.x to 03.03.04. I did not realize it at the time, but I had Upgrade log errors for Versions 03.02.03 and 03.03.01. I have now found those logs but I have not been able to find in the forum what to do to correct these errors. I would like to upgrade to 04.06.02 but not until I solve these issues. I don’t want to compound my problems any more.
What do I need to do to correct these problems? I am working in a shared hosting environment. I am stuck with Godaddy for now, but I would still like to get this problem resolved before I move to another host. I know, there are many problems with Godaddy and DotNetNuke.
Below are the Upgrade log files for version 03.02.03 and 03.03.01.
Thanks for taking a look.
Bruce
======Upgrade Log for Version 03.02.03===============
System.Data.SqlClient.SqlException: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Files_Folders'. The conflict occurred in database 'DB_37784', table 'Folders', column 'FolderID'.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
System.Data.SqlClient.SqlException: SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
SELECT permission denied on object 'COLUMNS', database 'master', owner 'INFORMATION_SCHEMA'.
SELECT permission denied on object 'spt_datatype_info', database 'master', owner 'dbo'.
Line 1: Incorrect syntax near 'LastUpdated'.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
--Move to UserProfile Table
EXECUTE TransferUsersFromFlatProfile N'FirstName'
EXECUTE TransferUsersFromFlatProfile N'LastName'
EXECUTE TransferUsersFromFlatProfile N'Unit'
EXECUTE TransferUsersFromFlatProfile N'Street'
EXECUTE TransferUsersFromFlatProfile N'City'
EXECUTE TransferUsersFromFlatProfile N'Region'
EXECUTE TransferUsersFromFlatProfile N'PostalCode'
EXECUTE TransferUsersFromFlatProfile N'Country'
EXECUTE TransferUsersFromFlatProfile N'Telephone'
EXECUTE TransferUsersFromFlatProfile N'Fax'
EXECUTE TransferUsersFromFlatProfile N'Cell'
EXECUTE TransferUsersFromFlatProfile N'Website'
EXECUTE TransferUsersFromFlatProfile N'IM'
EXECUTE TransferUsersFromFlatProfile N'TimeZone'
EXECUTE TransferUsersFromFlatProfile N'PreferredLocale'
===========Upgrade Log for Version 03.03.01========
System.Data.SqlClient.SqlException: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Files_Folders'. The conflict occurred in database 'DB_37784', table 'Folders', column 'FolderID'.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* 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