locked
Errors again. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-867221238 posted
    I was recommended to try the jeremy wadsworth  version.  Well I uploaded it to my site and added the tables to my database and this is what comes up.  I checked the database and the checkschemaversion is there.so how do i fix this?  I am using 1and1.com to host my site.

    Server Error in '/' Application.

    Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

    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: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

    Source Error: 

    Line 5:  	Sub Application_Start(ByVal sender As [Object], ByVal e As EventArgs)
Line 6:  		AddHandler SiteMap.SiteMapResolve, AddressOf Me.AppendQueryString
Line 7:  		If (Roles.RoleExists("Administrators") = False) Then
Line 8:  			Roles.CreateRole("Administrators")
Line 9:  		End If

    Source File: E:\kunden\homepages\5\d205327401\global.asax    Line: 7

    Stack Trace: 

    [SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857466
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735078
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
   System.Web.Util.SecUtility.CheckSchemaVersion(ProviderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +367
   System.Web.Security.SqlRoleProvider.CheckSchemaVersion(SqlConnection connection) +65
   System.Web.Security.SqlRoleProvider.RoleExists(String roleName) +482
   System.Web.Security.Roles.RoleExists(String roleName) +242
   ASP.global_asax.Application_Start(Object sender, EventArgs e) in E:\kunden\homepages\5\d205327401\global.asax:7

     

     

    Thanks for the help :)

    Sunday, May 20, 2007 11:06 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-867221238 posted

    OK I've fixed the original error now I'm getting this error.

     

    Server Error in '/' Application.

    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: 

    Line 138:
Line 139:	Public Shared Function GetSiteSettings() As SiteSettings
Line 140:		Using connection As New SqlConnection(ConfigurationManager.ConnectionStrings("Personal").ConnectionString)
Line 141:			Using command As New SqlCommand("site_GetSiteSettings", connection)
Line 142:				command.CommandType = CommandType.StoredProcedure

    Source File: E:\kunden\homepages\5\d205327401\App_Code\SiteSettingsManager.vb    Line: 140

    Stack Trace: 

    [NullReferenceException: Object reference not set to an instance of an object.]
   SiteSettingsManager.GetSiteSettings() in E:\kunden\homepages\5\d205327401\App_Code\SiteSettingsManager.vb:140
   PageBase.Page_PreInit(Object sender, EventArgs e) in E:\kunden\homepages\5\d205327401\App_Code\PageBase.vb:10
   System.Web.UI.Page.OnPreInit(EventArgs e) +2012220
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +521

    Sunday, May 20, 2007 4:19 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User595806616 posted

    The error you're receiving now, indicates that you don't have a connection string named Personal in your web.config. This also indicates that you may not be using the web.config that was a part of my kit you downloaded.

    In order to use my kit, you'll need to either use the database that came with my kit, or make sure you copy all the tables to the new database you create. You should also use the web.config or copy all custom settings that I have added.

     

    Sunday, May 20, 2007 5:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1705717250 posted

    Take a look at this post, as it has all the steps you need.

    http://forums.asp.net/t/1110595.aspx

    Hope it helps

    Monday, May 21, 2007 4:06 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-867221238 posted

    OK the site is up and running. I only have one problem at this point.  The "Black" theme won't work.  The top and bottom of the are black but the center is in the defaut theme style and you can't see any of the text when it's like that.   I have reinstalled new themes but I am still getting the problem. www.shadowstalkersguild.net

    Wednesday, May 30, 2007 12:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1705717250 posted

    Fixed: Removed the theme line from the web.config lefted from testing sorry.

    Wednesday, May 30, 2007 5:23 PM