Hello, last night I upgraded from 4.3.0 to 4.3.6. I am having troubles with the following since the upgrade:

- Cannot access File Manager
- I get a repeated error on the Site settings page
- I can't upload photos to my Simple Gallery (a ventrian.com module)
- Probably more things, but thats what I have found so far.

 In some of the errors it is saying that it can't find a stored proceedure called GetFolderByFolderPath. I looked into the Stored Procedures folder on MSSQL2000, and there is not a Stored Procedure by that name. Could it be that something happened in the upgrade that deleted this Stored Procedure?

Please help a brother out!  This is happening on all my portals.

Thanks.

Here is the error that shows up on the Site Settings Page:

An error has occurred. DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.GetFolderByFolderPath' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.GetFolderByFolderPath' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetFolder(Int32 PortalID, String FolderPath) at DotNetNuke.Services.FileSystem.FolderController.GetFolder(Int32 PortalID, String FolderPath) at DotNetNuke.Common.Utilities.FileSystemUtils.GetFolder(Int32 PortalID, String FolderPath) at DotNetNuke.Common.Globals.GetFileList(Int32 PortalId, String strExtensions, Boolean NoneSpecified, String Folder, Boolean includeHidden) at DotNetNuke.UI.UserControls.UrlControl.GetFileList(Boolean NoneSpecified) at DotNetNuke.UI.UserControls.UrlControl.ShowControls() at DotNetNuke.UI.UserControls.UrlControl.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

In the Log Viewer I get several errors:

Module Load Exception:
ModuleId: -1
ModuleDefId: -1
FriendlyName:
ModuleControlSource:
AssemblyVersion: 04.03.06
PortalID: 3
PortalName: Mission on the Border - Anapra Mexico
UserID: 1
UserName: host
ActiveTabID: 98
ActiveTabName: Site Settings
RawURL: /Admin/SiteSettings/tabid/98/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c4d5e10a-7757-44fa-b729-06cf18f3ae22
InnerException: The stored procedure 'dbo.GetFolderByFolderPath' doesn't exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.GetFolderByFolderPath' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.GetFolderByFolderPath' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.GetFolder(Int32 PortalID, String FolderPath) at DotNetNuke.Services.FileSystem.FolderController.GetFolder(Int32 PortalID, String FolderPath) at DotNetNuke.Common.Utilities.FileSystemUtils.GetFolder(Int32 PortalID, String FolderPath) at DotNetNuke.Common.Globals.GetFileList(Int32 PortalId, String strExtensions, Boolean NoneSpecified, String Folder, Boolean includeHidden) at DotNetNuke.UI.UserControls.UrlControl.GetFileList(Boolean NoneSpecified) at DotNetNuke.UI.UserControls.UrlControl.ShowControls() at DotNetNuke.UI.UserControls.UrlControl.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:

And Page Load Exception:
AssemblyVersion: 04.03.06
PortalID: 3
PortalName: Mission on the Border - Anapra Mexico
UserID: 1
UserName: host
ActiveTabID: 19
ActiveTabName: File Manager
RawURL: /Default.aspx?tabid=19&error=Object+reference+not+set+to+an+instance+of+an+object.&content=0
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: f74193f2-344e-43e4-a528-2a9569a21e2a
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: DotNetNuke.Security.Permissions.Controls.FolderPermissionsGrid.SaveViewState
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Security.Permissions.Controls.FolderPermissionsGrid.SaveViewState() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Control.SaveViewStateRecursive() at System.Web.UI.Page.SaveAllState() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: WEBSERVER

Ok, I fixed it!

It all started when I couldn't find any instructions to upgrade from 4.x to 4.x, so I started searching around on the Dotnetnuke site. I found a set of instructions for upgrading, they were really the only instructions I could find for upgrading within the same main version (version 4) as there are no instructions for this in the official documentation, one of the steps in these instructions was to set the AutoUpgrade to False in the web.config file. This was my problem, I figured out that the files in the site was upgraded to 4.3.6, but the database was still at 4.3.0. This is where all my problems were coming from. As soon as I changed the setting to true in the web.config, it upgraded the database, and everything is fine now.