Control Panel Woes

Reply

hkasturi Posted: Thu, Aug 3 2006 3:13 PM

rated by 0 users

My control panel is out of commision

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] CommunityServer.Data.FileGallerySqlDataProvider.GetFolders(Boolean mergePermissions) +365 CommunityServer.Files.Components.Folders.GetFolders(CSContext csContext, Int32 userID, Boolean ignorePermissions, Boolean cacheable, Boolean flush) +340 CommunityServer.Files.Components.Folders.GetFolders(Int32 userID, Boolean ignorePermissions, Boolean cacheable, Boolean flush) +90 CommunityServer.Files.Components.Folders.GetFolders(Boolean cacheable, Boolean flush) +45 CommunityServer.ControlPanel.ControlPanelHomePage.GetFolder() +206 CommunityServer.ControlPanel.ControlPanelHomePage.DataBind() +2801 CommunityServer.ControlPanel.ControlPanelHomePage.Page_Load(Object sender, EventArgs e) +72 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 thanks - curt

Reply

Jose Lema replied on Thu, Aug 3 2006 6:04 PM

rated by 0 users

It looks like you've got potentially bad data in the File Gallery. Have you recently added a folder? Can you access /controlpanel/files/ ?

Thanks.

Reply

hkasturi replied on Thu, Aug 3 2006 11:24 PM

rated by 0 users

I added a folder under /files as a file archive. I then linked files in that directory  to My Files in CS

that bad? When I tried to upload the files (50MB+) via CS it would time out but could ftp the files.

Curt

Reply

hkasturi replied on Thu, Aug 3 2006 11:36 PM

rated by 0 users

To answer the question better - no. I cannot access My Files.

I went ahead and deleted the files since I do not need them

Reply

Jose Lema replied on Thu, Aug 3 2006 11:39 PM

rated by 0 users

hkasturi:

I added a folder under /files as a file archive. I then linked files in that directory  to My Files in CS

that bad? When I tried to upload the files (50MB+) via CS it would time out but could ftp the files.

When you say you added a folder, do you mean a CS "folder" or you created a physical folder on your hard drive inside of /files?

Reply

hkasturi replied on Thu, Aug 3 2006 11:43 PM

rated by 0 users

A physical folder under %domain%/files called archive

Once I FTP the files to that folder, I used CS to add the Files to My Files by URL

Reply

Ben Tiedt replied on Fri, Aug 4 2006 8:45 AM

rated by 0 users

Could you execute the following queries on your CS database?

select *
from cs_Sections
where ApplicationType = 6
 and ApplicationKey is null

select *
from aspnet_Roles
where RoleName is null

Do either of these queries return results?

Reply

hkasturi replied on Fri, Aug 4 2006 10:08 AM

rated by 0 users

Let me figure that one out.

My site is hosted and I never had to do a remote query

-curt

Reply

Ben Tiedt replied on Fri, Aug 4 2006 11:01 AM

rated by 0 users

You should have had no resultes for either query.  Run the following query and restart the CS application (or wait10 to 15 minutes).  This should solve your problem (though I'm not sure how it occured). 

update cs_Sections
set ApplicationKey = 'folder' + convert(varchar, SectionID)
where ApplicationType = 6
 and ApplicationKey is null

Reply

hkasturi replied on Fri, Aug 4 2006 11:12 AM

rated by 0 users

All better 

You're the best!!!!

Thanks

- curt

Reply

nkleinjan replied on Tue, Mar 27 2007 8:13 PM

rated by 0 users

I had this same error described here in a brand new installation of CS 2.1 I was trying out. I read this post and running the update query helped my out and fixed the problem. I could not access the control panel at all without getting this error.

What got me in this mess was:

1. I was setting up File Folders, using the tree view, everything is great, making a nice looking structure
2. I didn't like some names, so I went back and changed around a couple folder names
3. I wanted the real url Folder to match the new, modified folder name
4. So, I deleted the folder part of the URL, expecting it to rebuild it, with underscores, after hitting save, just like when you add a new one.
5. But after hitting save with a Blank folder URL, this error came up, and I could no longer access the control panel!

Not sure what exactly the update query did to fix it, but the first select query above returned results, the second select above did not. So, I ran the update query and it fixed the problem.

Hopefully outlining what caused this for me will help you fix/enhance this problem of inputting a blank folder name in the URL field. I won't do that again.

Thanks

Reply

Bill Bosacker replied on Tue, Mar 27 2007 10:11 PM

rated by 0 users

nkleinjan:

So, I deleted the folder part of the URL, expecting it to rebuild it, with underscores, after hitting save, just like when you add a new one.

I've made that mistake before in other sections.  AFAIK, the auto-creation of these values is a one time only thing at the initial creation of the object.