Hi, I successfully upgraded from CS 2007 to CS 2008 SP1 (4.0.30619.63). At first the upgrade was failing in Step 6, when for some reason it could not create the folder called "filestorage" which I manually did after which the upgrade was successful.
Note, I restored the database and the webapp back to the original CS 2007 state before running the update the second time.
The upgrade itself as I said was successful, but when I try and browse to the web application on my local machine I get an error about EnableAutoDelete and the Index being out of range. When I restore the site back to CS 2007 from the backup on the local machine everything works well.
I restarted SQL, IIS and cleared the browser cache and cookies but nothing helped. Any idea what is wrong and where? Can it be related to the upgrade failure - even thoug all the files and the db were restored to a "clean" CS 2007 state?
Below is the complete stack trace: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.IndexOutOfRangeException: EnableAutoDeleteSource 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: [IndexOutOfRangeException: EnableAutoDelete] System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +1433771 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +102 System.Data.SqlClient.SqlDataReader.get_Item(String name) +12 CommunityServer.Components.CommonDataProvider.PopulateSectionFromIDataRecord(IDataRecord dr, Section s) +1319 CommunityServer.Blogs.Components.WeblogDataProvider.PopulateWeblogData(IDataReader dr, Weblog w) +16 CommunityServer.Data.WeblogSqlDataProvider.GetWeblogs() +225 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(CSContext csContext, Boolean ignorePermissions, Boolean cacheable, Boolean flush, Boolean ignoreLanguageFilter) +362 CommunityServer.Blogs.Components.Weblogs.GetWeblogsByGroupID(Int32 groupID, Boolean cacheable, Boolean ignorePermissions, Boolean flush) +97 CommunityServer.Blogs.Components.WeblogGroups.GetWeblogGroups(CSContext csContext, Boolean cacheable, Boolean ignorePermissions, Boolean flush) +545 CommunityServer.Blogs.Components.WeblogGroups.GetWeblogGroups(Boolean cacheable, Boolean ignorePermissions, Boolean flush) +95 CommunityServer.Blogs.Controls.GroupList.get_DataSource() +161 System.Web.UI.WebControls.Repeater.ConnectToDataSourceView() +261 System.Web.UI.WebControls.Repeater.OnLoad(EventArgs e) +16 CommunityServer.Controls.PreTemplatedWrappedRepeaterBase.OnLoad(EventArgs e) +9 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.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436 Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434 Thanks, Amit.
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.
[IndexOutOfRangeException: EnableAutoDelete] System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +1433771 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +102 System.Data.SqlClient.SqlDataReader.get_Item(String name) +12 CommunityServer.Components.CommonDataProvider.PopulateSectionFromIDataRecord(IDataRecord dr, Section s) +1319 CommunityServer.Blogs.Components.WeblogDataProvider.PopulateWeblogData(IDataReader dr, Weblog w) +16 CommunityServer.Data.WeblogSqlDataProvider.GetWeblogs() +225 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(CSContext csContext, Boolean ignorePermissions, Boolean cacheable, Boolean flush, Boolean ignoreLanguageFilter) +362 CommunityServer.Blogs.Components.Weblogs.GetWeblogsByGroupID(Int32 groupID, Boolean cacheable, Boolean ignorePermissions, Boolean flush) +97 CommunityServer.Blogs.Components.WeblogGroups.GetWeblogGroups(CSContext csContext, Boolean cacheable, Boolean ignorePermissions, Boolean flush) +545 CommunityServer.Blogs.Components.WeblogGroups.GetWeblogGroups(Boolean cacheable, Boolean ignorePermissions, Boolean flush) +95 CommunityServer.Blogs.Controls.GroupList.get_DataSource() +161 System.Web.UI.WebControls.Repeater.ConnectToDataSourceView() +261 System.Web.UI.WebControls.Repeater.OnLoad(EventArgs e) +16 CommunityServer.Controls.PreTemplatedWrappedRepeaterBase.OnLoad(EventArgs e) +9 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.Control.LoadRecursive() +131 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434
Thanks,
Amit.
Hey Amit,
This is most likely theme related. As a test, rename the ~/Themes folder to something like ~/Themes.old and then copy the entire ~/Themes folder from the installation files over to your installation. This will give you only the themes that CS2008 comes with. If that works, then at least one of the themes that you were using does not work as-is under CS2008. In fact, most CS2007 and earlier themes do not work.
Take it easy,Bill
WGB Enterprises - Freelance Community Server and other DevelopmentopenSourceC.org
Hi Bill,
Thanks for that - it certainly helped moved forward and it does confirm that issue is Theme related. After I deleted the old Theme folder (for CS 2007) and copied the new one I get the following error:
Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /blog/themes/telista/blogs/postlist.aspx
Is there a simple solution to this? Should I go back to my original backup and change the theme to something that will get upgraded to CS 2008?
This is coming up for two reasons. First, you haven't set a default blog theme for the site, and secondly because the specified blog theme no longer exists. Go to the Control Panel and specify a default blog theme to correct the first issue. Then manage each blog and make sure that it has a valid theme defined. If it doesn't, just select one from the list. Once this is done all of your theme related issues should be taken care of.
Hi,
I am still struggling with this and I still get the EnableAutoDelete error. Here is what I did:
Here is the error again:
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.IndexOutOfRangeException: EnableAutoDeleteSource 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: [IndexOutOfRangeException: EnableAutoDelete] System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +1433771 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +102 System.Data.SqlClient.SqlDataReader.get_Item(String name) +12 CommunityServer.Components.CommonDataProvider.PopulateSectionFromIDataRecord(IDataRecord dr, Section s) +1319 CommunityServer.Blogs.Components.WeblogDataProvider.PopulateWeblogData(IDataReader dr, Weblog w) +16 CommunityServer.Data.WeblogSqlDataProvider.GetWeblogs() +225 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(CSContext csContext, Boolean ignorePermissions, Boolean cacheable, Boolean flush, Boolean ignoreLanguageFilter) +362 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(Boolean cacheable, Boolean ignorePermissions, Boolean flush, Boolean filterByAggregate) +97 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(Boolean cacheable, Boolean ignorePermissions, Boolean flush) +25 CommunityServer.ControlPanel.Setup.DataBind() +476 CommunityServer.ControlPanel.Setup.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) +1436
[IndexOutOfRangeException: EnableAutoDelete] System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +1433771 System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +102 System.Data.SqlClient.SqlDataReader.get_Item(String name) +12 CommunityServer.Components.CommonDataProvider.PopulateSectionFromIDataRecord(IDataRecord dr, Section s) +1319 CommunityServer.Blogs.Components.WeblogDataProvider.PopulateWeblogData(IDataReader dr, Weblog w) +16 CommunityServer.Data.WeblogSqlDataProvider.GetWeblogs() +225 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(CSContext csContext, Boolean ignorePermissions, Boolean cacheable, Boolean flush, Boolean ignoreLanguageFilter) +362 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(Boolean cacheable, Boolean ignorePermissions, Boolean flush, Boolean filterByAggregate) +97 CommunityServer.Blogs.Components.Weblogs.GetWeblogs(Boolean cacheable, Boolean ignorePermissions, Boolean flush) +25 CommunityServer.ControlPanel.Setup.DataBind() +476 CommunityServer.ControlPanel.Setup.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) +1436
There is something obvious missing, but I don't know what and I just can't get this working. I tried various combinations of Themes and No Themes and each time I get the same error.
The Lean and Green themes may be broken. Try using Hawaii as the default and for all themes. We've been finding that almost all of the CS2007 and prior themes do not work on CS2008 as-is.
I'm not convinced this is a theme error. Looking at the stack trace, the error is occuring in the GetWeblogs method of the DataProvider. This would suggest that something's not quite right in the database.
Do have a backup of your database from CS2007. If so could you try restoring such a backup to a test site, upgrade that to CS2008 again and see if you get the same problem.
Community Server Documentation please rate articles you read
Nintendo Wiikly | My Blog
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com