Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • tolga gülcan 1 post 21 karma points
    Nov 05, 2010 @ 11:28
    tolga gülcan
    0

    can't add new content

    Installing umbraco

    when try to add new content I get the error message Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'Nodeid'.

    Server Error in '/' Application.

    Invalid column name 'Nodeid'.

     

    Is this related permissions. thank you.

     

     

    Copy Link
  • Ali Erdoğan 3 posts 23 karma points
    Dec 09, 2010 @ 10:10
    Ali Erdoğan
    0

    I tried both 4.5.2 and 4.6 alfa. I always get that error when i try to add a new content. Isnt there a solution?

    Copy Link
  • Matt Brailsford 4124 posts 22215 karma points MVP 9x c-trib
    Dec 09, 2010 @ 10:13
    Matt Brailsford
    0

    Hi Ali,

    Can you give us a litle information on your system setup? Operating System? MySQL/MS SQL? Which version of IIS?

    Off the top of my head, it could be a corrupt database, as it sounds like a column from one of the tables is missing. Can you confirm the DB installed successfully?

    Matt

    Copy Link
  • Ali Erdoğan 3 posts 23 karma points
    Dec 09, 2010 @ 21:32
    Ali Erdoğan
    0

    I use IIS 7.0 on win 7.0 and Sql Server 2008 Express edition. I tried to install the application a lot of times by droping and creating the database again and again. It says that installed successfully but it does not work properly. How can i manually install the database?

    Copy Link
  • Gurol Gurkan 3 posts 38 karma points
    Dec 10, 2010 @ 00:30
    Gurol Gurkan
    0

    Hi Ali 

    check your database and server collation. if collation is Turkishxxxx this error will apair.  you must change the collation of database.

    Copy Link
  • Ali Erdoğan 3 posts 23 karma points
    Dec 10, 2010 @ 11:38
    Ali Erdoğan
    0

    Thanks for your reply Mr Gurkan

     

    What is the best collation for the database? I tried "latin1_general_bin" but it did not work.

    Copy Link
  • Matt Brailsford 4124 posts 22215 karma points MVP 9x c-trib
    Dec 10, 2010 @ 11:46
    Matt Brailsford
    0

    Hi Ali,

    Mine are set to Latin1_General_CI_AS if that helps.

    Matt

    Copy Link
  • Dincer M. 35 posts 97 karma points
    Feb 10, 2011 @ 05:04
    Dincer M.
    0

    I had the same problem..

    Changing the collation solved it..

     

    ALTER DATABASE umbraco SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    ALTER DATABASE umbraco COLLATE Latin1_General_CI_AS

    ALTER DATABASE umbraco SET MULTI_USER

    Copy Link
  • ufuk KARAHAN 1 post 21 karma points
    Jun 18, 2011 @ 14:50
    ufuk KARAHAN
    0

    Thank your reply Dincer M.

    I solved Too

     

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft