Copied to clipboard

Flag this post as spam?

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


  • Gal Nitzan 50 posts 164 karma points
    Jul 29, 2010 @ 19:43
    Gal Nitzan
    0

    Missing entry in umbracoNode table after upgrade to 4.5.x with MySQL

    There seems to be a missing entry in the table unmbracoNode for the media "Recycle Bin" id=-21 when upgrading to 4.5 and 4.5.1 and MySQL database is used.

    The result is a NullReference exception in the event viewer and a missing media tree after upgrade.

    I have made the upgrade on my laptop which uses sql express without any problems and the entry does exist in the table.

    Any quick solution? like INSERT INTO ?

    Thanks,

    Gal

  • Gal Nitzan 50 posts 164 karma points
    Aug 01, 2010 @ 15:19
    Gal Nitzan
    0

    Anyone from Umbraco???? Any clue???? Any Help?????

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Aug 01, 2010 @ 15:30
    Sebastiaan Janssen
    0

    Have you tried just inserting the row in mysql?

  • Gal Nitzan 50 posts 164 karma points
    Aug 01, 2010 @ 16:17
    Gal Nitzan
    0

    I can run the command, however I dont know the correct values for the columns, and I know that one of the columns is keyed to another table and I'm not sure which.

    I was kind of hopping someone from umbraco would paste here the correct insert into... for a quick solutions.

     

    Regards,

    Gal.

  • Matt Brailsford 4125 posts 22222 karma points MVP 9x c-trib
    Aug 01, 2010 @ 16:37
    Matt Brailsford
    0

    These are the vaues from my SQL server DB. Just checked all the other tables, and couldn't find any other reference to id -20

    id    trashed    parentID    nodeUser    level    path    sortOrder    uniqueID    text    nodeObjectType    createDate
    -21    0    -1    0    0    -1,-21    0    BF7C7CBC-952F-4518-97A2-69E9C7B33842    Recycle Bin    CF3D8E34-1C1C-41E9-AE56-878B57B32113    2010-07-28 18:05:18.327

    I'd try backing up your DB, and adding the above values and see if that fixes it for you.

    Matt

Please Sign in or register to post replies

Write your reply to:

Draft