Today i upgraded my website from dnn 4.0.3 to 4.3.5 and during setup some errors arised:
Upgrading DotNetNuke
Current Assembly Version: 04.03.05
Current Database Version: 04.00.03
00:00:00.015 - Executing Script: c:\hosting\webhost4life\member\mamasita\Providers\DataProviders\SqlDataProvider\Upgrade.SqlDataProvider
Upgrade Status Report
00:00:00.234 - Upgrading to Version: 4.0.4 Error! (seec:\hosting\webhost4life\member\mamasita\Providers\DataProviders\SqlDataProvider\04.00.04.log for more information)
00:00:32.703 - Upgrading to Version: 4.0.5 Success
00:00:32.734 - Upgrading to Version: 4.0.6 Success
00:00:32.765 - Upgrading to Version: 4.0.7 Success
00:00:32.781 - Upgrading to Version: 4.3.0 Success
00:00:32.843 - Upgrading to Version: 4.3.1 Error! (seec:\hosting\webhost4life\member\mamasita\Providers\DataProviders\SqlDataProvider\04.03.01.log for more information)
00:00:32.890 - Upgrading to Version: 4.3.2 Success
00:00:33.078 - Upgrading to Version: 4.3.3 Success
00:00:33.593 - Upgrading to Version: 4.3.4 Success
00:00:33.625 - Upgrading to Version: 4.3.5 Success
00:00:33.843 - Performing General Upgrades
00:00:35.437 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Announcements_03.03.04_Install.zip: Success
00:00:37.203 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Blog_3.02.00_Install.zip: Success
00:00:40.546 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Contacts_3.1_Install.zip: Success
00:00:40.843 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Documents_03.01.05_Install.zip: Success
00:00:41.750 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Events_3.2_Install.zip: Success
00:00:43.125 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\FAQs_3.1_Install.zip: Success
00:00:43.265 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Feedback_03.02.01_Install.zip: Success
00:00:43.687 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Forum_3.20.08_Install.zip: Success
00:00:57.562 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Gallery_3.0.12_Install.zip: Success
00:01:06.343 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Help_2.0.4_Install.zip: Success
00:01:08.625 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\HTML_3.3.0_Install.zip: Success
00:01:09.375 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\IFrame_3.2_Install.zip: Success
00:01:10.421 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Links_3.3_Install.zip: Success
00:01:11.750 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Media_03.02.02_Install.zip: Success
00:01:13.609 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\NewsFeeds_3.1.1_Install.zip: Success
00:01:14.468 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Reports_4.3.1_Source.zip: Success
00:01:15.859 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Repository_3.1.10_Install.zip: Success
00:01:33.031 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Store_01.00.01_Install.zip: Error!
00:01:35.390 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\Survey_3.3_Install.zip: Success
00:01:36.578 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\UserDefinedTable_3.03.03_Install.zip: Success
00:01:38.484 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\UsersOnline_3.1_Install.zip: Success
00:01:38.812 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\WhatsNew_3.3_Install.zip: Success
00:01:38.890 - Installing Module File c:\hosting\webhost4life\member\mamasita\Install\Module\XML_3.1_Install.zip: Success
Upgrade Complete
All seemed well up to a point. Now when entering my portal different errors keep rising. Like when a user wants to log on i get:
Server Error in '/' Application.
Method not found: 'Void DotNetNuke.Entities.Users.UserController.SynchronizeUsers(Int32)'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.MissingMethodException: Method not found: 'Void DotNetNuke.Entities.Users.UserController.SynchronizeUsers(Int32)'.
What does this error mean? And what can i do? Some users can logon. Some can't. All users are in the user database.
the following stood In the log files mentioned during setup :
System.Data.SqlClient.SqlException: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Files_Folders'. The conflict occurred in database 'advance', table 'Folders', column 'FolderID'.
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)
/* 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
System.Data.SqlClient.SqlException: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Files_Folders'. The conflict occurred in database 'advance', table 'Folders', column 'FolderID'.
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)
If (SELECT dbo.fn_GetVersion(3,2,3)) = 0
BEGIN
ALTER TABLE dbo.Files ADD CONSTRAINT
FK_Files_Folders FOREIGN KEY
(
FolderID
) REFERENCES dbo.Folders
(
FolderID
)
END