sql error in version 2

David Peck 615 posts 1646 karma points c-trib

Oct 19, 2018 @ 08:45

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 3875 posts 12037 karma points MVP

Oct 22, 2018 @ 05:55

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 615 posts 1646 karma points c-trib

Oct 22, 2018 @ 13:12

Wonderful. Thanks Richard

Copy Link

is working on a reply...

This forum is in read-only mode while we transition to the new forum.

You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Flag this post as spam?

SQL error in version 2