Copied to clipboard

Flag this post as spam?

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


  • Daniel 44 posts 187 karma points
    Jan 13, 2014 @ 11:35
    Daniel
    0

    Invalid column name 'startMediaId' - Umbraco 7 install

    Hi,

    I was so stoked on Umbraco 7, but I've already crashed into a wall. I installed Umbraco 7.0.1 from NuGet and ran the site from VS 2012 in debug mode. The install page came up as usual and everything went fine with installing the database (which is located on a remote server). But moving on to next step "4 - Create user" I get the error: Invalid column name 'startMediaId'.

    I haven't done anything but downloading Umbraco and running it. 

    I'm running .Net Framework 4 (tried changing to 4.5 with no success)

    I've set up the database and connected to it with a sysadmin user

    The initial data insertion seems to have worked well, the tables are in place and there's an admin user with id 0 in the umbracoUser table.

    This seems like a pretty serious bug to me. Or have I missed something in the installation process?

    Grateful for help or pointers.

    /Daniel

  • Jeroen Breuer 4908 posts 12265 karma points MVP 4x admin c-trib
    Jan 13, 2014 @ 12:04
    Jeroen Breuer
    0

    Hello,

    Do you also get this bug if you try to use a default install without nuget?

    Jeroen

  • Daniel 44 posts 187 karma points
    Jan 13, 2014 @ 14:13
    Daniel
    100

    Thanks for you reply Jeroen. I found out what the problem was though.

    The database needs to be set to case insensitive (that's any collation with _CI in it). Peter McKenzie-Jones also noticed this. Setting it to your local variant is fine (Finnish_Swedish for me) as long as it's set to case insensitive.

    Issue solved.

Please Sign in or register to post replies

Write your reply to:

Draft