Hi All
Recently upgarded to 3.2.2.  now i have a slight problem, all my existing child sites are working fine but i have just setup a new one, I go to site settings i am presented with "Server Error in '/' Application"  this also happens when ever i go to module settings
the DNN app is hosted with WH4L

can anyone shed some light on this one?
Thanks

Pat

Just A Follow up this is happening across all my sites but only since i upgarded to 3.2.2 everything was working fine before the upgrade have included error info can anyone help to decode this error

Thanks

Pat

AssemblyVersion: 03.02.02
Method: System.Data.Common.FieldNameLookup.GetOrdinal
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID: 9
PortalName: **********
UserID: 1
UserName: host
ActiveTabID: 358
ActiveTabName: Site Settings
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer:
ExceptionGUID: c4073e69-53dc-43b2-9557-92a77d112a2b
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Unhandled Error:
Message: System.Exception: Unhandled Error: ---> DotNetNuke.Services.Exceptions.PageLoadException: An error has occurred. ---> DotNetNuke.Services.Exceptions.ModuleLoadException: An error has occurred. ---> System.IndexOutOfRangeException: Folder at System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at DotNetNuke.Common.Globals.GetFileList(Int32 PortalId, String strExtensions, Boolean NoneSpecified, String Folder, Boolean includeHidden) at DotNetNuke.UI.UserControls.UrlControl.GetFileList(String strExtensions, Boolean NoneSpecified, String Folder) at DotNetNuke.UI.UserControls.UrlControl.ShowControls() at DotNetNuke.UI.UserControls.UrlControl.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, Control UserCtrl, Exception exc) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control UserCtrl, Exception exc) at DotNetNuke.UI.UserControls.UrlControl.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) at DotNetNuke.Framework.PageBase.Page_Error(Object Source, EventArgs e) at System.Web.UI.TemplateControl.OnError(EventArgs e) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---

Hi
I have the exact same problem. After upgrading to DNN 3.2.2 form DNN 3.1.1 I get an error on the FIle Upload module in Admin Settings and in inner modules.

An error has occurred.
DotNetNuke.Services.Exceptions.ModuleLoadException: Folder ---> System.IndexOutOfRangeException: Folder at System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at DotNetNuke.Common.Globals.GetFileList(Int32 PortalId, String strExtensions, Boolean NoneSpecified, String Folder, Boolean includeHidden) at DotNetNuke.UI.UserControls.UrlControl.GetFileList(String strExtensions, Boolean NoneSpecified, String Folder) at DotNetNuke.UI.UserControls.UrlControl.ShowControls() at DotNetNuke.UI.UserControls.UrlControl.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Any one have a solution ? I already saw 2 posts about this so I am not alone in this. Doesnt the core team careqa about this issue ? I saw that no one have answered to the 2 other guys with this problem.
Dont you care ?

Any one can help on this ?
There are menu users that have an upgrade problems to DNN 3.2.2.
Can someone offer a fix ?

What is happening with the DNN community ?
In the past each issue was taken seriously, and now there is a DNN core problem and no one says he will take a look ?
The hands of the end users are tide. We can't do anything. We need to wait for someone from the core to hopely take a look. Maybe you should consider special treatment for users with your benefactor program if this is the only way left to get any help from the DNN core team.

Make sure you have used the new web.config file and transfer over settings from your old web.config.  There were new config stuff added that fixed the file upload error.

You are NOT alone!
I have this problem too! It happend after an upgrade of the Gooddogs repositry module.
The log says: " Page Load Exception

AssemblyVersion: 03.02.02
Method: System.Data.Common.FieldNameLookup.GetOrdinal
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID: 1
PortalName: Het Windmolenbroek
UserID: 1
UserName: host
ActiveTabID: 144
ActiveTabName: FotoCompetitie
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.in-almelo.com/FotoCompetitie/tabid/144/ctl/Module/ModuleId/763/Default.aspx
ExceptionGUID: 06b53e08-15c4-4c8f-bb6f-5dabfa30cce3
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
InnerException: Folder
Message: DotNetNuke.Services.Exceptions.PageLoadException: Folder ---> System.IndexOutOfRangeException: Folder at System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName) at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) at System.Data.SqlClient.SqlDataReader.get_Item(String name) at DotNetNuke.Common.Globals.GetFileList(Int32 PortalId, String strExtensions, Boolean NoneSpecified, String Folder, Boolean includeHidden) at DotNetNuke.UI.UserControls.UrlControl.GetFileList(String strExtensions, Boolean NoneSpecified, String Folder) at DotNetNuke.UI.UserControls.UrlControl.cboFolders_SelectedIndexChanged(Object sender, EventArgs e) at System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e) at System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent() at System.Web.UI.Page.RaiseChangedEvents() at System.Web.UI.Page.ProcessRequestMain() --- End of inner exception stack trace ---
StackTrace:
Source:
Server Naam: DEDI374

I too posted this error some time ago, and NO-ONE came to rescue...

Jos

It seems all the errors occur after a dnn upgrade.

This error says the field 'Folder' isn't in the datareader. Check the the stored procedure GetFiles. It should return the Folder as last column. If not the upgrade failed. So
check the upgrade log files for errors. They can be found in the folder Providers\DataProviders\SQLDataprovider

But then it's still strange that this error occurs, because i don't see the field Folder get called in the UrlControl code.

This is the stored procedure in my DNN 3.2.2.

CREATE procedure dbo.GetFiles

@PortalId int,

@Folder nvarchar(200)

as

select FileId,

PortalId,

FileName,

Extension,

Size,

WIdth,

Height,

ContentType

from Files

where ((PortalId = @PortalId AND Folder=@Folder) or (@PortalId is null and PortalId is null AND Folder=@Folder))

order by FileName

GO

I can't see anything strange at it.

Thanks,

Jos

I got it!

Just run this SQL script in your SQL manager in the host menu:

if exists (select * from dbo.sysobjects where id = object_id(N'GetFiles') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure GetFiles

GO

CREATE procedure dbo.GetFiles

@PortalId int,

@Folder nvarchar(200)

as

select FileId,

PortalId,

FileName,

Extension,

Size,

WIdth,

Height,

ContentType,

Folder

from Files

where ((PortalId = @PortalId AND Folder=@Folder) or (@PortalId is null and PortalId is null AND Folder=@Folder))

order by FileName

GO

and you should be fine. (But first in your testenvironment!)

I ran a test in my TESTDNN by deleting the 'Folder' line and deleting the , behind the ContentType, to ferify that this caused the error, wich it did.

Then I ran the SQL script and checked the outcome. This was OK, so I did the same in my production portal.

Eureka!

Thanks for your help.

Jos.

I'm glad that it helped you out.

Jos.

Thank you for your solution.  This was a great help and I am very thankful for your assistance.  I seems to have worked fine with one of my installations.  I will now go to the others.

Again, thanks

Jack

 

Jos,

Is the solution for the 3.2.2 upgrade from 3.1.1? How can I apply this if the site is not working?