All of a sudden, site isn't working

rated by 0 users
Answered (Verified) This post has 1 verified answer | 11 Replies | 3 Followers

Top 75 Contributor
254 Posts
Points 1,385
dotnetdiva posted on Fri, Oct 10 2008 11:07 AM

My site was working just fine when I went to bed, but today it is not working. Here's my error:

 

[NullReferenceException: Object reference not set to an instance of an object.]
   CommunityServer.Components.Navigation.DeserializeNavigationItems(String serializedNavigationItems, String linkPrefix, String[] filterByRoles) +589
   CommunityServer.Components.Navigation.GetNavigationLinks(ThemeConfigurationData themeData, String navigationPropertyName, String[] filterByRoles) +139
   CommunityServer.Components.Navigation.GetNavigationLinks(ThemeConfigurationData themeData, String navigationPropertyName) +495
   CommunityServer.Controls.NavigationList.get_DataSource() +297
   CommunityServer.Controls.NavigationList.OnLoad(EventArgs e) +15
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

- Angela
www.DSLRCommunity.com
EQDiva.com Bards of Everquest - CS 2007.1 (recently updated from 2002 version!)

  • | Post Points: 5

Answered (Verified) Verified Answer

Top 10 Contributor
4,034 Posts
Points 61,125
TelligentSupportTeam
Verified by dotnetdiva

It is stored in the cs_ThemeConfigurationData table in the database.

If you have trouble translating the data in that table, I suggest you just rename the ThemeName of the relevant theme (so you have a backup copy of the settings in the database) which will force CS to use the default configuration and that should fix your site theme (n.b. you may have to restart your website by touching web.config or another way before this change will take effect).

  • | Post Points: 35

All Replies

Top 75 Contributor
254 Posts
Points 1,385

It has something to do with the database, as when I pointed another working CS site to this database, I get the same error.

The only new thing I did last night was add a new link via the Admin (a sublink under forums), which worked for at least an hour after I made the change.

Where is that data stored so I can delete it?

- Angela
www.DSLRCommunity.com
EQDiva.com Bards of Everquest - CS 2007.1 (recently updated from 2002 version!)

  • | Post Points: 5
Top 75 Contributor
254 Posts
Points 1,385

Looking into the themes table in the database.

- Angela
www.DSLRCommunity.com
EQDiva.com Bards of Everquest - CS 2007.1 (recently updated from 2002 version!)

  • | Post Points: 20
Top 10 Contributor
4,034 Posts
Points 61,125
TelligentSupportTeam

Can you get into control panel.  THe navigation entry list has corrupted somehow.  You may be able to edit them to correct them directly in the Site Themes section of Control Panel.  If you're unable to correct them, I suggest you reset you backup your current theme settings (export them from Control Panel) and then reset the defaults.  If you open the exported xml, find the section where navigation is controlled and remove it.  Then reimport your theme and you should solve your problems.

  • | Post Points: 20
Top 75 Contributor
254 Posts
Points 1,385

No, I'm unable to get into the control panel at all. Just gives me the same error.

Are the settings in the database?

- Angela
www.DSLRCommunity.com
EQDiva.com Bards of Everquest - CS 2007.1 (recently updated from 2002 version!)

  • | Post Points: 20
Top 10 Contributor
4,034 Posts
Points 61,125
TelligentSupportTeam
Verified by dotnetdiva

It is stored in the cs_ThemeConfigurationData table in the database.

If you have trouble translating the data in that table, I suggest you just rename the ThemeName of the relevant theme (so you have a backup copy of the settings in the database) which will force CS to use the default configuration and that should fix your site theme (n.b. you may have to restart your website by touching web.config or another way before this change will take effect).

  • | Post Points: 35
Top 75 Contributor
254 Posts
Points 1,385

Thank you thank you thank you Alex!!!

Between this and assisting getting the "old school" forum layout out, you're an angel!

http://www.dslrcommunity.com/forums/

- Angela
www.DSLRCommunity.com
EQDiva.com Bards of Everquest - CS 2007.1 (recently updated from 2002 version!)

  • | Post Points: 5
Top 75 Contributor
254 Posts
Points 1,385

Ugh, I ran into this bug again!

Admin - Header - Navigation Bar

Add new menus for Registered Users only. I added them as submenus under forums.

That will screw up my default "Hawaii" theme.

If I figure out more, I will post and update.

- Angela
www.DSLRCommunity.com
EQDiva.com Bards of Everquest - CS 2007.1 (recently updated from 2002 version!)

  • | Post Points: 20
Top 75 Contributor
254 Posts
Points 1,385

Here's what I think happened.

I tried to add a menu item, and didn't add the right Role. I either left it blank, mistyped "Registered Users".

- Angela
www.DSLRCommunity.com
EQDiva.com Bards of Everquest - CS 2007.1 (recently updated from 2002 version!)

  • | Post Points: 5
Top 10 Contributor
4,034 Posts
Points 61,125
TelligentSupportTeam

I'll pass your issue on.

In the meantime, I suggest you fix everything in your theme APART from the custom navigation, and then export your theme configuration as a backup.  You can then start fiddling with the navigation and can restore your backup if needs be.

  • | Post Points: 5
Not Ranked
14 Posts
Points 190

Hello Alex,

I am having this exact problem and I understand what to do but I cannot edit the table in Management Studio. I'm kind of a newbie to SQL, though I've built a lot of Access Databases,  can you help me understand this?

                        Error Source: .Net SqlClient Data Provider

                        Error Message: String or binary data would be truncated.

Is this about dependencies? Connections? I've stopped the site and the App pool. How do I drop connections, is that the issue?

  • | Post Points: 20
Page 1 of 1 (12 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com