Sign in Register
Go to solution
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 690 posts 1896 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?

    Copy Link
  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    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

    Copy Link
  • David Peck 690 posts 1896 karma points c-trib
    Oct 22, 2018 @ 13:12
    David Peck
    0

    Wonderful. Thanks Richard

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft