We have a load-balanced setup, with dev and live environments.
Currently, we only use SEO Checker for handling 404's.
Is there a way to disable the background validation in SEO Checker? (We use server roles.) The problem is that SQL profiling shows constant calls to SEOChecker_Queue from
(1) our dev server and our developer's machines - which is not needed at all
(2) every server behind the load balancer - should only be the master/admin server and
(3) we don't use SEO Checker for SEO anyway, only for 404 tracking and redirects
I think you have some orphan nodes in the SEOChecker tables that can't be deleted in the database. Delete records in SEOChecker tables that don't exists in umbracoNode table.
But to disable you can remove the seochecker modules in web.config.
Delete records in SEOChecker tables that don't exists in umbracoNode table.
I don't have any such records - these queries return 0 rows:
select * from SEOChecker_URLHistory where nodeid not in (select id from umbraconode)
select documentid from SEOChecker_PageNotFound where DocumentID not in (select id from umbraconode) and DocumentID > 0
select * from SEOChecker_ValidationIssues where DocumentID not in (select id from umbraconode)
I am also seeing this run thousands of time just opening the front end - note the userId of 0
exec sp_executesql N'DELETE umbracoUser2app FROM umbracoUser2app WHERE [user] = @UserId AND app = @AppName',N'@UserId int,@AppName nvarchar(10)',@UserId=24,@AppName=N'seochecker'
go
exec sp_reset_connection
go
exec sp_executesql N'INSERT INTO umbracoUser2app ([user], app) Values (@UserId, @AppName)',N'@UserId int,@AppName nvarchar(10)',@UserId=0,@AppName=N'seochecker'
go
I think this is because your configured version is not set correctly. Make sure /umbraco/plugins/seochecher/config/seochecker.config version is set to the version number you are using. Otherwise the installer will run every time on app_start.
How to disable SEO Checker Queue?
We have a load-balanced setup, with dev and live environments. Currently, we only use SEO Checker for handling 404's.
Is there a way to disable the background validation in SEO Checker? (We use server roles.) The problem is that SQL profiling shows constant calls to SEOChecker_Queue from
(1) our dev server and our developer's machines - which is not needed at all (2) every server behind the load balancer - should only be the master/admin server and (3) we don't use SEO Checker for SEO anyway, only for 404 tracking and redirects
Hi David,
I think you have some orphan nodes in the SEOChecker tables that can't be deleted in the database. Delete records in SEOChecker tables that don't exists in umbracoNode table.
But to disable you can remove the seochecker modules in web.config.
Hope this helps. Best,
Richard
I don't have any such records - these queries return 0 rows:
This doesn't work because we still need the 404 functionality and we have SEO Checker Property type in some documents.
What I need is a way to disable the background queue with a configuration value in web.config or for SEO Checker to only run on the master server.
I think this is essential for SEO Checker to be supported by any load-balanced setup.
You can disable that by only removing the validationqueue module from web.config. The rest will still work then.
Doesn't work. SEO Checker added it back to web.config within a second of me removing it.
I am also seeing this run thousands of time just opening the front end - note the userId of 0
Hi David,
I think this is because your configured version is not set correctly. Make sure /umbraco/plugins/seochecher/config/seochecker.config version is set to the version number you are using. Otherwise the installer will run every time on app_start.
Best,
Richard
is working on a reply...