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


  • MTEV 6 posts 26 karma points
    Apr 30, 2014 @ 11:51
    MTEV
    0

    Error when creating a document type

    Hey guys,

    I have downloaded and installed Umbraco, everything works fine, until I try to create a document type.
    The following error shows up:

    Server Error in '/' Application.

    Invalid column name 'propertyEditorAlias'.

    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 'propertyEditorAlias'.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace: 

    [SqlException (0x80131904): Invalid column name 'propertyEditorAlias'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61
   System.Data.SqlClient.SqlDataReader.get_MetaData() +90
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1406
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +134
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +81
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +147
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +37
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +82

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +202
   umbraco.cms.businesslogic.datatype.DataTypeDefinition.setupNode() +108
   umbraco.cms.businesslogic.CMSNode..ctor(Guid uniqueID) +179
   umbraco.cms.businesslogic.datatype.<>c__DisplayClass6.<GetDataTypeDefinition>b__5() +79
   Umbraco.Core.Cache.<>c__DisplayClass8`1.<GetCacheItem>b__7() +10
   Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func`1 getCacheItem, Nullable`1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, CacheDependency dependency) +247
   Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func`1 getCacheItem) +112
   Umbraco.Core.Cache.CacheProviderExtensions.GetCacheItem(ICacheProvider provider, String cacheKey, Func`1 getCacheItem) +115
   umbraco.cms.businesslogic.datatype.DataTypeDefinition.GetDataTypeDefinition(Guid id) +203
   umbraco.cms.businesslogic.datatype.DataTypeDefinition.GetAll() +146
   umbraco.controls.ContentTypeControlNew.BindDataGenericProperties(Boolean refresh) +111
   umbraco.controls.ContentTypeControlNew.SetupGenericPropertiesPane() +75
   umbraco.controls.ContentTypeControlNew.OnInit(EventArgs e) +74
   System.Web.UI.Control.InitRecursive(Control namingContainer) +134
   System.Web.UI.Control.InitRecursive(Control namingContainer) +290
   System.Web.UI.Control.InitRecursive(Control namingContainer) +290
   System.Web.UI.Control.InitRecursive(Control namingContainer) +290
   System.Web.UI.<InitRecursiveAsync>d__0.MoveNext() +277
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +93
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +52
   System.Web.Util.WithinCancellableCallbackTaskAwaiter.GetResult() +30
   System.Web.UI.<ProcessRequestMainAsync>d__14.MoveNext() +2353


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18447

    Any help would be highly appreciated!

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Apr 30, 2014 @ 15:26
    Jan Skovgaard
    0

    Hi MTEV and welcome to our :)

    What approach did you take installing Umbraco? Did you consult the documentation?

    What webserver and database are you using?

    Please provide as much information as possible as it will be much easier to help you out then.

    Cheers, Jan

    Copy Link
  • MTEV 6 posts 26 karma points
    Apr 30, 2014 @ 17:27
    MTEV
    0

    Hi Jan,


    Thank you for your reply!
    I first installed Umbraco locally, which worked fine (I don't get the error there).
    I then copied all the files to (shared Windows) webserver and restored the database (MSSQL).
    Does that help, or do you need any additional information?
    I also tried importing the DocumentType (from the local one) and got a NULL value error.

    Thanks again,
    Maikel

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Apr 30, 2014 @ 17:47
    Jan Skovgaard
    0

    Hi Maikel

    Ok, did you remember to change the connection string in your web.config on the server then?

    /Jan

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Apr 30, 2014 @ 17:49
    Jan Skovgaard
    0

    ...also be aware that files in the /App_Data/TEMP/* folder should not be copied over - so you can delete all files from the underlying directories. Just don't delete any folders but just the files - however this has nothing to do with your initial issue - just a reminder for when we get your install up and running on your server.

    Cheers, Jan

    Copy Link
  • MTEV 6 posts 26 karma points
    Apr 30, 2014 @ 18:26
    MTEV
    0

    Yes, I did change the connection string.
    I wanted to try to connect to the remote database locally and see if I got the same error, but it seems the server is down at the moment :(

    I'll try this later and let you know how it turns out, thanks for the help so far Jan!

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Apr 30, 2014 @ 20:06
    Jan Skovgaard
    0

    Hi MTEV

    You're welcome...ok the server being down could be the issue, no? :)

    Looking forward to hearing from you.

    /Jan

    Copy Link
  • MTEV 6 posts 26 karma points
    May 02, 2014 @ 11:07
    MTEV
    0

    Hey Jan,

    The problem is solved, it turned out to be a server problem after all ;)
    Thank you for your time and help!

    Regards,
    Maikel

     

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    May 02, 2014 @ 11:49
    Jan Skovgaard
    0

    Hi Maikel

    Thanks for getting back to me - Happy to hear you got it solved :)

    What was the specific issue? Care to share so others might learn if they see the same issue?

    /Jan

    Copy Link
  • MTEV 6 posts 26 karma points
    May 02, 2014 @ 11:56
    MTEV
    0

    Hey Jan,

    I would be happy to, only problem is that I don't really know what went wrong.
    The server went down (due to problems on the host's side), afterwards they performed a database restore and everything was working fine.
    That and the fact that I couldn't find the exact error message anywhere online, makes me believe that the database was either corrupt or incomplete, but I might wrong here.

    That's the best I can do, I hope it helps!

    Thanks again,
    Maikel

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    May 02, 2014 @ 12:29
    Jan Skovgaard
    0

    Hi Maikel

    Aaah, did not realise it was a hosted solution. What host are you using? Just curious :)

    /Jan

    Copy Link
  • MTEV 6 posts 26 karma points
    May 02, 2014 @ 12:49
    MTEV
    0

    I (or rather the customer) is using ECS webhosting.
    I have another question for you as well if that's ok (or should I open a new topic)? ;)

    The checkbox for "hide in navigation" doesn't seem to change the Visible property (it remains true).
    @foreach (var subpage in page.Children.Where("Visible")) <- Show all pages (including hidden)


    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft