Invalid object name 'SiteSettings' error

Last post 10-02-2008 12:43 PM by neon0107. 2 replies.

Sort Posts:

  • Invalid object name 'SiteSettings' error

    07-23-2008, 5:33 PM
    • Loading...
    • rlarzen
    • Joined on 07-23-2008, 9:22 PM
    • Posts 2

    I am trying to get the Club Starter Kit Extended working on VS2005. I am using SQL Server 2005. I have got the asp schema stuff setup and working. And, I ran club-add.sql without a hitch. However, I am now getting the following error:

    Invalid object name 'SiteSettings'.
    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 object name 'SiteSettings'.

    Source Error:


    Line 2186:            this.Adapter.SelectCommand = this.CommandCollection[0];
    Line 2187:            DataSet.SiteSettingsDataTable dataTable = new DataSet.SiteSettingsDataTable();
    Line 2188:            this.Adapter.Fill(dataTable);
    Line 2189:            return dataTable;
    Line 2190:        }

    Source File: App_Code.uviwbnep.9.cs    Line: 2188

     Can anyone offer me some insight as to how to fix this?

  • Re: Invalid object name 'SiteSettings' error

    07-23-2008, 6:03 PM
    • Loading...
    • rlarzen
    • Joined on 07-23-2008, 9:22 PM
    • Posts 2

    I just discovered the problem. Apparently two tables: SiteSettings and SiteThemes are not included in club-add.sql that came in the Extended zip file. I added them myself using an older version; ran ok.

  • Re: Invalid object name 'SiteSettings' error

    10-02-2008, 12:43 PM
    • Loading...
    • neon0107
    • Joined on 09-25-2008, 8:07 PM
    • Posts 6

    I think I am having the same problem.  Do you now where i can get the sql code to add the sitesettings and sitethemes tables?

     

    Thanks

Page 1 of 1 (3 items)
Microsoft Communities
Page view counter