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?
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.
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
Hello,
Do you also get this bug if you try to use a default install without nuget?
Jeroen
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.
is working on a reply...