Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • David Peck 587 posts 1554 karma points c-trib
    Oct 19, 2018 @ 08:45
    David Peck
    0

    SQL error in version 2

    We installed v2.0 and upgraded to v2.1. I've now noticed lots of error log entries:

    2018-10-19 09:34:03,267 [P4444/D2/T141] ERROR SEOChecker.HttpModules.UrlModule - SEOChecker: SEOChecker: Error in PageNotFound Module
    System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'WildCard'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteScalar()
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass11_0.<ExecuteScalarWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco)
       at Umbraco.Core.Persistence.Database.Save(String tableName, String primaryKeyName, Object poco)
       at SEOChecker.Core.Repository.PageNotFound.PageNotFoundRepository.Insert(Uri uri, Uri referer, Int32 documentId, String redirect, Boolean isNotFound, ContentTypeEnum contentType, Boolean storeDomain, Boolean wildCard, Boolean storeQueryString)
       at SEOChecker.Core.Repository.PageNotFound.PageNotFoundRepository.Insert(Uri uri, Uri referer, ContentTypeEnum contentType)
       at SEOChecker.HttpModules.UrlModule.(Object , EventArgs )
    

    ClientConnectionId:19ee434e-ba05-4cea-92c5-35d9dde794b2 Error Number:207,State:1,Class:16 ```

    It's possibly related to MVC custom routes, but it sounds more like a missing column name.

    My next step is either to uninstall and re-install, but analyse the DB from a clean SEOChecker install in a new Umbraco install. However perhaps you're able to steer me more accurately to the root of the problem?

  • Richard Soeteman 3642 posts 11097 karma points MVP
    Oct 22, 2018 @ 05:55
    Richard Soeteman
    100

    Hi David,

    This was a bug in an older version of SEOChecker indeed. If you drop the SEOCheckerPageNotFound table and create again with the following script all should be good,

    CREATE TABLE [dbo].[SEOChecker_PageNotFound](
    [NotFoundId] [int] IDENTITY(1,1) NOT NULL,
    [Url] [nvarchar](255) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [Ignore] [bit] NOT NULL,
    [TimesAccessed] [int] NOT NULL,
    [LastTimeAccessed] [datetime] NULL,
    [RedirectUrl] [nvarchar](255) NOT NULL,
    [Referer] [nvarchar](255) NULL,
    [ContentType] [nvarchar](255) NOT NULL,
    [Domain] [nvarchar](255) NOT NULL,
    [QueryString] [nvarchar](255) NOT NULL,
    [WildCard] [bit] NOT NULL,
    
    
    CONSTRAINT [PK_SEOChecker_PageNotFound] PRIMARY KEY CLUSTERED 
    (
        [NotFoundId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    

    Hope this helps,

    Richard

  • David Peck 587 posts 1554 karma points c-trib
    Oct 22, 2018 @ 13:12
    David Peck
    0

    Wonderful. Thanks Richard

Please Sign in or register to post replies

Write your reply to:

Draft