Copied to clipboard

Flag this post as spam?

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


  • [email protected] 12 posts 25 karma points
    Jul 19, 2009 @ 15:01
    kitmip@gmail.com
    0

    How to clean up the database

    Hi

    Having used trial and error for a while, i still get the possibility to choose some of the properties from deleted doctypes, when I want to insert a value on a page. It seems that Umbraco gets confused when it can choose between "content" from several doctypes, when the content has the same names. How do you clean out all of the data from deleted doctypes?

    I have looked into the SQL-database, but it is not obvious where to look for this.

    Regards

    Kim 

  • Sebastiaan Janssen 5061 posts 15544 karma points MVP admin hq
    Jul 19, 2009 @ 15:04
    Sebastiaan Janssen
    0

    I had this problem a while back, but the properties seemed to disappear after I'd done a recycle of the application pool.

  • [email protected] 12 posts 25 karma points
    Jul 19, 2009 @ 22:14
    kitmip@gmail.com
    0

    Ahh - that sounds nice. How do you do that?

    Kim

  • Sebastiaan Janssen 5061 posts 15544 karma points MVP admin hq
    Jul 19, 2009 @ 22:18
    Sebastiaan Janssen
    1

    Start > Run > inetmgr

    You should've defined an application pool yourself here already.
    If you can't find it, the easy other way is to add a space somewhere in your web.config file, a recycle will then always be forced.

  • [email protected] 12 posts 25 karma points
    Jul 20, 2009 @ 20:05
    kitmip@gmail.com
    0

    Brilliant! Thank you.

    Kim

  • Ranjith 11 posts 31 karma points
    May 22, 2010 @ 06:41
    Ranjith
    0

    Hi to all,

    I am just trying to clean up my Umbraco database, but I think I am not on the right path to do that..  I have tried the possible ways that I got from forum.. Can anyone please bare your patience and say me how to clean up the database..............

  • Hendy Racher 863 posts 3849 karma points MVP 2x admin c-trib
    May 22, 2010 @ 10:13
    Hendy Racher
    1

    Hi Ranjith,

    What parts of the database are you trying to clean ? Does this schema diagram help ?

    The good news is that v4.1 database will have additional foreign key constraints, so better enforcing data integrity.

  • 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.

Please Sign in or register to post replies