Copied to clipboard

Flag this post as spam?

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


  • Simon Dingley 1474 posts 3431 karma points c-trib
    Jan 28, 2010 @ 12:30
    Simon Dingley
    0

    Removing Umbraco Stats Package in Umbraco v3

    It's been so long since I worked with v3 could anyone please point me in the right direction to remove an installed package. The package in question is Umbraco Stats and has a bug that is causing the server to return a "Server too busy" error on a regular basis.

    Simon

  • Douglas Robar 3570 posts 4711 karma points MVP ∞ admin c-trib
    Jan 28, 2010 @ 13:26
    Douglas Robar
    1

    First thing to do is disable stats. You can do that with a setting in the web.config file. That will (or should) stop stats from collecting any more ...ummmm... stats.

    That should be enough to get your server back.

    Then you can go about removing stats itself. I don't recall the steps but will see if I can dig them up. But short of uninstalling you can at least disable it (above), remove stats from all the umbraco users so no one will see it any more (in the users section of umbraco), and even prune the database tables of their data. I'd leave the tables (empty) until you formally remove the stats package, but at this point it should be neutered and doing nothing.

    cheers,
    doug.

  • Seth Niemuth 275 posts 397 karma points
    Jan 28, 2010 @ 13:27
    Seth Niemuth
    0

    In umbraco 3...there is no really easy way to remove a package, you have to figure out where it did things and then remove it manually.

  • Niels Hartvig 1951 posts 2391 karma points c-trib
    Jan 28, 2010 @ 13:27
  • Niels Hartvig 1951 posts 2391 karma points c-trib
    Jan 28, 2010 @ 13:29
    Niels Hartvig
    0

    w00t - three replies in 46 seconds. This community rocks! But you all knew that, didn't you ;-)

  • Douglas Robar 3570 posts 4711 karma points MVP ∞ admin c-trib
    Jan 28, 2010 @ 13:34
    Douglas Robar
    0

    Thanks, @niels... those were the instructions to use. They worked perfectly for me on that v3 site. (now I don't have to go find the link!)

    yes, the community rocks!

    cheers,
    doug.

  • Douglas Robar 3570 posts 4711 karma points MVP ∞ admin c-trib
    Jan 28, 2010 @ 13:46
    Douglas Robar
    0

    To keep it all together on the new forum... here are the steps:

     

    - Remove the umbracoStats and blong assemblies from the /bin folder
    - Remove the contents of the umbracoStats folder in /umbraco/plugin
    - Delete stats entries from UmbracoAppTree (first) and UmbracoApp (second)
    - Update your web.config and disable collecting stats data (to avoid db grow nuts)

    And then delete old data from the database if you wish to:

    delete from umbracoAppTree where appAlias='umbracoStats'

    -- in
    Users section of umbraco admin ui, deselect [umbracoStats] from all
    users; or...
    delete from umbracoUser2app where app='umbracoStats'

    delete
    from umbracoApp where appAlias='umbracoStats'

    drop table
    umbracoStatEntry

    drop table umbracoStatSession

    cheers,
    doug.

  • Simon Dingley 1474 posts 3431 karma points c-trib
    Jan 28, 2010 @ 15:23
    Simon Dingley
    0

    Thanks Doug, one thing I would say is that the web.config for the site in question does not currently have any references that I can see which relate to this package. Do you have an example of what should have been in there?

    Thanks, Simon

  • Simon Dingley 1474 posts 3431 karma points c-trib
    Jan 28, 2010 @ 15:57
    Simon Dingley
    0

    There is one step missing from the above in order to remove all of the old data because there is a foregin key constraint on umbracoAppTree that will cause the original to fail. Please see below for all of the required SQL statements in order:

    delete from umbracoUser2app where app='umbracoStats'
    
    delete from umbracoAppTree where appAlias='umbracoStats'
    
    delete from umbracoApp where appAlias='umbracoStats'
    
    drop table umbracoStatEntry
    
    drop table umbracoStatSession
Please Sign in or register to post replies

Write your reply to:

Draft