Copied to clipboard

Flag this post as spam?

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


  • Bruno Olsen 75 posts 316 karma points
    Jul 15, 2016 @ 07:47
    Bruno Olsen
    0

    Database "clean up"

    Hi

    I was wondering. I sometimes have to do some database "clean up" on some Umbraco sites by deleting old data in the umbracoLog table to save database storage space.

    Can I do something similar with the nsEmailTrackingItems and nsTrackingItems tables, or do I risk breaking Newsletter Studio?

    Kind regards, Bruno

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 15, 2016 @ 07:49
    Markus Johansson
    0

    Hi!

    If you delete an email the needed items in these tables will be removed as well.

    If you want to keep the statics for the e-mails you can't remove these items as they are the statics =D

    / m

  • Bruno Olsen 75 posts 316 karma points
    Jul 15, 2016 @ 07:54
    Bruno Olsen
    0

    Hi Markus

    So, if I don't need the statistics for say two year old newsletters, I won't break Newsletter Studio by removing rows in those tables, correct? :)

    Kind regards, Bruno

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Jul 15, 2016 @ 08:15
    Markus Johansson
    100

    Hi!

    Probably not =D

    If you want to "do it right" you should remove everything from the UI.

    If you want to try to do it with a sql-statement make sure to remove the actual newsletters as well (nsNewsletters) so that your users don't click on them in the UI and get errors due to the fact that the tracking items are gone.

    // M

  • Bruno Olsen 75 posts 316 karma points
    Jul 15, 2016 @ 08:26
    Bruno Olsen
    0

    Hi Markus

    Ok, thanks. I think I'd better have them delete the old newsletters they don't need anymore themselves then ;)

    Kind regards, Bruno

Please Sign in or register to post replies

Write your reply to:

Draft