Copied to clipboard

Flag this post as spam?

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


  • David Veksler 81 posts 166 karma points
    Mar 25, 2016 @ 15:22
    David Veksler
    0

    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

    enter image description here

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Mar 28, 2016 @ 05:46
    Richard Soeteman
    0

    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

  • David Veksler 81 posts 166 karma points
    Mar 28, 2016 @ 17:35
    David Veksler
    0

    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)
    
  • David Veksler 81 posts 166 karma points
    Mar 28, 2016 @ 15:19
    David Veksler
    0

    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.

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Mar 29, 2016 @ 06:32
    Richard Soeteman
    0

    You can disable that by only removing the validationqueue module from web.config. The rest will still work then.

  • David Veksler 81 posts 166 karma points
    Mar 30, 2016 @ 17:57
    David Veksler
    0

    You can disable that by only removing the validationqueue module from web.config.

    Doesn't work. SEO Checker added it back to web.config within a second of me removing it.

  • David Veksler 81 posts 166 karma points
    Mar 30, 2016 @ 17:56
    David Veksler
    0

    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
    
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Mar 31, 2016 @ 05:13
    Richard Soeteman
    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

Please Sign in or register to post replies

Write your reply to:

Draft