DotNetNuke

Re: Betreft: Re: Betreft: Re: 3.2.2 Runtime error

muqueca — Tue, 25 Apr 2006 05:36:01 GMT

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?

Re: Betreft: Re: Betreft: Re: 3.2.2 Runtime error

jlojko — Wed, 05 Apr 2006 02:33:54 GMT

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

Re: Betreft: Re: Betreft: Re: 3.2.2 Runtime error

dawoe — Sun, 12 Mar 2006 09:28:29 GMT

I'm glad that it helped you out.

Betreft: Re: Betreft: Re: 3.2.2 Runtime error

JosRichters — Fri, 10 Mar 2006 17:12:37 GMT

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

CREATE procedure dbo.GetFiles

@PortalId int,

@Folder nvarchar(200)

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

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.

Betreft: Re: Betreft: Re: 3.2.2 Runtime error

JosRichters — Fri, 10 Mar 2006 16:31:57 GMT

This is the stored procedure in my DNN 3.2.2.

CREATE procedure dbo.GetFiles

@PortalId int,

@Folder nvarchar(200)

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

I can't see anything strange at it.

Thanks,

Jos

Re: Betreft: Re: 3.2.2 Runtime error

dawoe — Fri, 10 Mar 2006 14:11:13 GMT

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.

Betreft: Re: 3.2.2 Runtime error

JosRichters — Fri, 10 Mar 2006 11:21:12 GMT

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

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

Jos

Re: 3.2.2 Runtime error

ecktwo — Sun, 19 Feb 2006 18:17:18 GMT

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.

Re: 3.2.2 Runtime error

liorlustig — Sun, 19 Feb 2006 08:13:52 GMT

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.

Re: 3.2.2 Runtime error

liorlustig — Sat, 18 Feb 2006 22:43:45 GMT

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 ?

Re: 3.2.2 Runtime error

liorlustig — Fri, 17 Feb 2006 14:04:01 GMT

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 ?

Re: 3.2.2 Runtime error

patk — Sun, 01 Jan 2006 07:20:52 GMT

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 ---

3.2.2 Runtime error

patk — Sat, 31 Dec 2005 19:37:28 GMT

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