Site Urls Error

Last post 07-10-2008 9:14 AM by Robert Nash. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next
  • 07-07-2008 7:11 PM

    • shakes
    • Top 25 Contributor
    • Joined on 07-08-2008
    • Posts 5

    Site Urls Error

     I just did the install on my local test site and have Site Urls Error.

    Critical Error: SiteUrls.Config

    The file containing the SiteUrl Data could not be loaded.

    Please contact your CommunityServer administrator. A technical explanation of why this error is caused is below.

     


    Community Server expects to find a valid XML file containing all of the links for a community. By default, this file is located at the root of the with the name SiteUrls.config. 

    A common error is to included unescaped XML characters, such as "&" when defining a querystring.

    If available, the location of the error will be listed below:

    Could not find the requested node /SiteUrls/navigation/link[@name='controlpanel']


    For more information you can also visit http://CommunityServer.Org the home of the CommunityServer Forums development team.

     

  • 07-08-2008 3:54 AM In reply to

    Re: Site Urls Error

    Hi Shakes,

       Is the test server the same as your community site?  the error is quite odd, did you have a siteUrls_override.config already?  It may be that the application installer did not merge into this quite correctly.  Please send me the file and I will take a look.

    Regards,
    Rob 

  • 07-08-2008 6:55 PM In reply to

    • shakes
    • Top 25 Contributor
    • Joined on 07-08-2008
    • Posts 5

    Re: Site Urls Error

    No i did not have a siteUrls_override.config already...i commented out the offending parts however im not sure what that section was for and what kind of ill effects it might yield.

      <!--<Override xpath="/SiteUrls/navigation/link[@name='controlpanel']" mode="update" Product="FourRoads.Shop">

        <link name="Shops" resourceUrl="shops_Home" text="Shop" />

        <link name="controlpanel" resourceUrl="controlpanel" resourceName="controlpanel" roles="SystemAdministrator,BlogAdministrator,ForumsAdministrator,Moderator,GalleryAdministrator,FileAdministrator,ReaderAdministrator,MembershipAdministrator,Shop Administrator" />

      </Override>-->

    Im rather sure the install did not run correctly though as I have found quite a few sql errors. I ran the InstallShopSchema and InsertStartingData Manualy and that seemed to solve most of them.

    I am getting an error still on Show All Items:

    Server Error in '/CarolinaPulse' Application.


    Invalid column name 'ReturnInCategoryList'.

    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.Data.SqlClient.SqlException: Invalid column name 'ReturnInCategoryList'.

    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:

     

    [SqlException (0x80131904): Invalid column name 'ReturnInCategoryList'.]

       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466

       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118

       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186

       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932

       System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +126

       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1623

       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31

       System.Data.SqlClient.SqlDataReader.get_MetaData() +62

       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297

       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005

       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132

       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32

       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122

       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62

       FourRoads.CsShop.SqlProvider.ShopSQLDataProvider.GetItems(ShopItemsQuery query, Int32 settingsID, DataReaderDelegate readerDelegate, BaseThreadQueryBuilder qb) +641

       FourRoads.CsShop.SqlProvider.ShopSQLDataProvider.GetItems(ShopItemsQuery query, DataReaderDelegate readerDelegate) +71

       FourRoads.CsShop.Core.Items.EnumerateShops(Int32 settingsID, Int32& currentItems) +202

       FourRoads.CsShop.Core.Items.EnumerateSites(ICollection sites, Int32& currentItems) +106

       FourRoads.CsShop.Core.Items.CurrentItemCount(Boolean useCache) +138

       FourRoads.CsShop.Core.Items.HasExceededMaxLicensedItemCount(Boolean useCache) +85

       FourRoads.CsShop.Core.Components.ShopPostCRUD.GetItems(ShopItemsQuery query, Boolean cacheable) +221

       FourRoads.CsShop.Web.ControlPanel.ShopAdmin.ItemListControl.buildGrid() +260

       FourRoads.CsShop.Web.ControlPanel.ShopAdmin.ItemListControl.Page_Load(Object sender, EventArgs e) +90

       System.Web.UI.Control.OnLoad(EventArgs e) +99

       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.Control.LoadRecursive() +131

       System.Web.UI.Control.LoadRecursive() +131

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

     

    There could be others I will just have to see after I play around a bit. I should also note that I am running 2007.1 sp1 with some minor tweeks to the sdk adding some properties to the user profile.

    My goal is to use your software to charge my business users a fee to be a member of my site on a yearly or monthly basis. I think the subscription feature will work for that….

  • 07-08-2008 8:08 PM In reply to

    • shakes
    • Top 25 Contributor
    • Joined on 07-08-2008
    • Posts 5

    Re: Site Urls Error

     All items throws an error too...

    Server Error in '/CarolinaPulse' Application.

    Invalid column name 'ReturnInCategoryList'.

    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.Data.SqlClient.SqlException: Invalid column name 'ReturnInCategoryList'.

    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:

    [SqlException (0x80131904): Invalid column name 'ReturnInCategoryList'.]
    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
    System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +126
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1623
    System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
    System.Data.SqlClient.SqlDataReader.get_MetaData() +62
    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62
    FourRoads.CsShop.SqlProvider.ShopSQLDataProvider.GetItems(ShopItemsQuery query, Int32 settingsID, DataReaderDelegate readerDelegate, BaseThreadQueryBuilder qb) +640
    FourRoads.CsShop.SqlProvider.ShopSQLDataProvider.GetItems(ShopItemsQuery query, DataReaderDelegate readerDelegate) +73
    FourRoads.CsShop.Core.Items.EnumerateShops(Int32 settingsID, Int32& currentItems) +202
    FourRoads.CsShop.Core.Items.EnumerateSites(ICollection sites, Int32& currentItems) +106
    FourRoads.CsShop.Core.Items.CurrentItemCount(Boolean useCache) +138
    FourRoads.CsShop.Core.Items.HasExceededMaxLicensedItemCount(Boolean useCache) +85
    FourRoads.CsShop.Core.Components.ShopPostCRUD.GetItems(ShopItemsQuery query, Boolean cacheable) +221
    FourRoads.CsShop.Web.ControlPanel.Shops.ItemListControl.buildGrid() +149
    FourRoads.CsShop.Web.ControlPanel.Shops.ItemListControl.Page_Load(Object sender, EventArgs e) +223
    System.Web.UI.Control.OnLoad(EventArgs e) +99
    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.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 

  • 07-08-2008 8:21 PM In reply to

    • shakes
    • Top 25 Contributor
    • Joined on 07-08-2008
    • Posts 5

    Re: Site Urls Error

     Just noticed that those are the same two errors...I get an error in the "all coments" section however that is the same one as well...

  • 07-09-2008 1:59 AM In reply to

    Re: Site Urls Error

    OK let start with the easy issue

    shakes:

    No i did not have a siteUrls_override.config already...i commented out the offending parts however im not sure what that section was for and what kind of ill effects it might yield.

      <!--<Override xpath="/SiteUrls/navigation/link[@name='controlpanel']" mode="update" Product="FourRoads.Shop">

        <link name="Shops" resourceUrl="shops_Home" text="Shop" />

        <link name="controlpanel" resourceUrl="controlpanel" resourceName="controlpanel" roles="SystemAdministrator,BlogAdministrator,ForumsAdministrator,Moderator,GalleryAdministrator,FileAdministrator,ReaderAdministrator,MembershipAdministrator,Shop Administrator" />

      </Override>-->

    Im rather sure the install did not run correctly though as I have found quite a few sql errors. I ran the InstallShopSchema and InsertStartingData Manualy and that seemed to solve most of them.

    I am getting an error still on Show All Items:

     

     

    I'm pretty sure the reason that this has failed is because the orginal SiteUrls file has been customized, by commenting out the above lines it should have minimal impact on the site.

    The second issue is a bit more of a problem and I am at a loss to see why the SQL schema has not installed correctly, can you give me a full blow by blow log of what actions you performed and which version on CS you started with etc so I can investigate it further.

    The attached zip contains the patches that should have been executed during install of the addon, please use SQL management studio or command line to run these scripts in the order : Patch 1.1 to 1.2.sql , Patch 1.2 to 1.3.sql, Patch 1.3.1.sql and then send me the error logs.  This should bring the DB schema upto date and your site should be working.

    Cheers,
    Rob

  • 07-09-2008 6:18 PM In reply to

    • shakes
    • Top 25 Contributor
    • Joined on 07-08-2008
    • Posts 5

    Re: Site Urls Error

     Running those other scripts seems to have been the way to go..as for the install i followed the pdf and am running a slightly modified 2007.1 sp1 install..on my home laptop..windows vista home premium...sql2005..nothing i ever do runs smooth so i wouldnt loose to much sleep over it...another question that may have already been answered...is or will the sdk be available?

  • 07-10-2008 9:14 AM In reply to

    Re: Site Urls Error

     Hi Shakes,

      I'm glad we've got you up and running, I'm still a little perplexed why the update scripts didn't run.  Currently we have no plans to produce a SDK, we have made a distinct effort to make the core product extensible without the need to alter the internals.  We are working on producing documentation etc to aid in development.  However if you have specific questions post a message on here and one of us will answer.

    Cheers,
    Rob 

Page 1 of 1 (8 items)