|
|
| Author |
Messages |
|
jamie edwards
Gold Membership
Nuke Addict
Posts:77
 |
| 11/29/2006 2:32 PM |
|
Hello Everyone,
Last night I upgraded from DNN 4.3.0 to 4.3.6. Since then I can't upload photos to simple gallery anymore.
I have had a look in the Stored Procedures in MSSQL on my server, and I don't see a stored proceedure called GetFolderByFolderPath. But I have no idea how it would have gone missing, I didnt touch it.
If anyone can help, I would greatly appreciate it, othewise I suppose I will have to revert back to 4.3.0, and then my Property Manager won't work, but at least I can upload photos.
Here is what shows up on the page when I try to upload a photo:
Error: Add New Photo is currently unavailable.
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 DnnForge.SimpleGallery.EditPhoto.UploadFile(Stream& stream, String name) at DnnForge.SimpleGallery.EditPhoto.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Here is the error I get from the Log Viewer:
ModuleId: 564
ModuleDefId: 127
FriendlyName: Add New Photo
ModuleControlSource: DesktopModules/SimpleGallery/EditPhoto.ascx
AssemblyVersion: 04.03.06
PortalID: 3
PortalName: Mission on the Border - Anapra Mexico
UserID: 1
UserName: host
ActiveTabID: 114
ActiveTabName: Photo Gallery
RawURL: /PhotoGallery/tabid/114/ctl/Edit/mid/564/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.missionontheborder.org/PhotoGallery/tabid/114/ctl/Edit/mid/564/Default.aspx
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: 601b6c63-cd7c-4e69-ba23-e7193386fd00
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 DnnForge.SimpleGallery.EditPhoto.UploadFile(Stream& stream, String name) at DnnForge.SimpleGallery.EditPhoto.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace --- |
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12450
|
| 11/29/2006 3:24 PM |
|
| Were there any issues in the upgrade? This proc should be there, can you upload documents via the documents module? |
|
Scott McCulloch
Site Administrator |
|
|
jamie edwards
Gold Membership
Nuke Addict
Posts:77
|
| 11/29/2006 3:32 PM |
|
Thanks for the reply Scott,
There were no visible issues with the upgrade. I didn't get any errors that I saw. I have been poking around and I can't get into the file manager under the admin menu either, it gives me an error. Also on the site setting page (admin menu) I get these errors under the body background, and logo areas:
 |
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 --- |
|
|
|
|
|
DNN Professor
Gold Membership
Nuke Master
Posts:743
|
| 11/29/2006 9:36 PM |
|
Can you get the FileManager page to open at all? I had the same problem on the upgrade. I had drilled down to a folder, other than the root, and checked recursive and then did the sync. It did the trick bringing FileManager back.
Worth a try  |
|
Buck Anderson
DNNprofessor.com
www.dnnprofessor.com
JustNorth Outdoors
www.justnorth.com
Jive Media
www.jivemg.com |
|
|
jamie edwards
Gold Membership
Nuke Addict
Posts:77
|
| 11/29/2006 9:40 PM |
|
Thanks for the reply Buck,
No, I can't get to the File Manage page at all.
Could you explain what you mean on how you fixed it. I am not sure what you mean by "checked recursive and did the sync".
Thanks very much for your help, this is driving me crazy! :P
Jamie |
|
|
|
|
jamie edwards
Gold Membership
Nuke Addict
Posts:77
|
| 11/29/2006 11:03 PM |
|
| Ok, I figured out what I did wrong. 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), 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 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, it upgraded the database, and everything is fine now. |
|
|
|
|
DNN Professor
Gold Membership
Nuke Master
Posts:743
|
| 12/04/2006 8:26 PM |
|
Glad to here you figured it out.
FYI - When you download the install version of DNN, there is a documents forlder that has all the DNN pdfs including installation procedures. |
|
Buck Anderson
DNNprofessor.com
www.dnnprofessor.com
JustNorth Outdoors
www.justnorth.com
Jive Media
www.jivemg.com |
|
|
jamie edwards
Gold Membership
Nuke Addict
Posts:77
|
| 12/04/2006 8:52 PM |
|
Hi Buck,
Correct, there is a documents folder with install instructions, there is also upgrade instructions, but only for upgrading from 3.x to 4.x. That was my issue, there was nothing in any of the official documentation that I could find to explain the steps for upgrading from 4.x to a 4.x (in my case 4.3.0 to 4.3.6).
I had searched on the Dotnetnuke forums, and found someone that had posted some instructions for this, but one of the steps was bad information. So it didnt upgrade my database to match the new files.
Jamie |
|
|
|
|
Scott McCulloch
Administrators
Nuke Master
Posts:12450
|
| 12/04/2006 9:41 PM |
|
Oh, that setting must have been the auto-upgrade setting ?
I wrote about that in the book, plus it's in the install documentation, but probably not spelled out too well. |
|
Scott McCulloch
Site Administrator |
|
|
jamie edwards
Gold Membership
Nuke Addict
Posts:77
|
| 12/04/2006 9:44 PM |
|
| Yes, it was the auto-upgrade setting! :( It is in the install documentation? I read throught the whole Upgrade section of the install instructions and couldnt find anything for upgrading within the same version, i must be blind! :P |
|
|
|
|
Jack Hoelz
Gold Membership
Nuke Master
Posts:810
|
| 12/04/2006 10:27 PM |
|
| Odd, I have done dozens of upgrades since 1.x and upgraded all the way through with 4.x and never touched the "AutoUpgrade". Does anyone know why that would make the difference? |
|
Get The Net!!
Jack Hoelz |
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|