Copied to clipboard

Flag this post as spam?

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


  • Søren Kottal 488 posts 3203 karma points MVP 2x c-trib
    Jan 27, 2015 @ 13:05
    Søren Kottal
    0

    Error when upgrading from 7.2.0b to 7.2.1

    I get this error:

    The view at '/umbraco/install/views/index.cshtml' must derive from WebViewPage, or WebViewPage<TModel>

    when trying to access my site, after upgrading to 7.2.1.

    What can I do?

  • Jan Skovgaard 11257 posts 23497 karma points MVP 7x admin c-trib
    Jan 27, 2015 @ 13:08
    Jan Skovgaard
    0

    Hi Søren

    What happens if you remove the install folder?

    Have you tried clearing your browser cache as well btw?

    /Jan

  • Søren Kottal 488 posts 3203 karma points MVP 2x c-trib
    Jan 27, 2015 @ 13:14
    Søren Kottal
    0

     

    The view '/umbraco/install/views/index.cshtml' or its master was not found or no view engine supports the searched locations. The following locations were searched:

    /umbraco/install/views/index.cshtml

     

    Shouldn't it go through the installer to update DB and stuff?

  • Jan Skovgaard 11257 posts 23497 karma points MVP 7x admin c-trib
    Jan 27, 2015 @ 13:25
    Jan Skovgaard
    0

    Hi Søren

    Yup indeed, read it as you already had run the update but now was not able to login.

    Did you upgrade using nuget or manually? If using nuget...could you then please overwrite /bin, /umbraco and /umbraco_client manually and see if it works? :)

    /Jan

  • Søren Kottal 488 posts 3203 karma points MVP 2x c-trib
    Jan 27, 2015 @ 14:42
    Søren Kottal
    0

    Okay, got into the installer :)

     

    Now I get this

    The database failed to upgrade. ERROR: The database configuration failed with the following message: Table 'umbracoNode' does not have the identity property. Cannot perform SET operation. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

     

    I'm not sure where to look in the tracelog. Theres an entry, saying pretty much the same as above.

    2015-01-27 14:37:51,214 [9] ERROR Umbraco.Web.Install.Controllers.InstallApiController - [Thread 16] Installation step DatabaseUpgrade failed.
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Table 'umbracoNode' does not have the identity property. Cannot perform SET operation.
     Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
       at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
       at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)
    2015-01-27 14:37:51,214 [9] INFO  Umbraco.Web.Install.Controllers.InstallApiController - [Thread 16] Step completed (took 21ms)
    2015-01-27 14:37:51,214 [9] ERROR Umbraco.Web.Install.Controllers.InstallApiController - [Thread 16] An error occurred during installation step DatabaseUpgrade
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Table 'umbracoNode' does not have the identity property. Cannot perform SET operation.
     Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
       at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction)
       at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)

    And an entry with a lot of things found in the database, that isn't in the schema (uCommerce is installed).

    2015-01-27 14:37:51,214 [9] INFO  Umbraco.Core.DatabaseContext - [Thread 16] The database schema validation produced the following summary: 
    The following tables were found in the database, but are not in the current schema:
    icUrlTracker,masterProduct,masterProductProp,scanOrtoLog,sessionId,shoppinglist,shoppinglistProduct,uCommerce_Address,uCommerce_AdminPage,uCommerce_AdminTab,uCommerce_AmountOffOrderLinesAward,uCommerce_AmountOffOrderTotalAward,uCommerce_AmountOffUnitAward,uCommerce_Award,uCommerce_Campaign,uCommerce_CampaignItem,uCommerce_CampaignItemProperty,uCommerce_Category,uCommerce_CategoryDescription,uCommerce_CategoryProductRelation,uCommerce_CategoryProperty,uCommerce_CategoryTarget,uCommerce_Country,uCommerce_Currency,uCommerce_Customer,uCommerce_DataType,uCommerce_DataTypeEnum,uCommerce_DataTypeEnumDescription,uCommerce_Definition,uCommerce_DefinitionField,uCommerce_DefinitionFieldDescription,uCommerce_DefinitionType,uCommerce_DefinitionTypeDescription,uCommerce_Discount,uCommerce_DiscountSpecificOrderLineAward,uCommerce_DynamicOrderPropertyTarget,uCommerce_EmailContent,uCommerce_EmailParameter,uCommerce_EmailProfile,uCommerce_EmailProfileInformation,uCommerce_EmailType,uCommerce_EmailTypeParameter,uCommerce_EntityUi,uCommerce_EntityUiDescription,uCommerce_FreeGiftAward,uCommerce_OrderAddress,uCommerce_OrderAmountTarget,uCommerce_OrderLine,uCommerce_OrderLineDiscountRelation,uCommerce_OrderNumberSerie,uCommerce_OrderProperty,uCommerce_OrderStatus,uCommerce_OrderStatusAudit,uCommerce_OrderStatusDescription,uCommerce_Payment,uCommerce_PaymentMethod,uCommerce_PaymentMethodCountry,uCommerce_PaymentMethodDescription,uCommerce_PaymentMethodFee,uCommerce_PaymentMethodProperty,uCommerce_PaymentProperty,uCommerce_PaymentStatus,uCommerce_PercentOffOrderLinesAward,uCommerce_PercentOffOrderTotalAward,uCommerce_PercentOffShippingTotalAward,uCommerce_Permission,uCommerce_PriceGroup,uCommerce_PriceGroupPrice,uCommerce_PriceGroupTarget,uCommerce_Product,uCommerce_ProductCatalog,uCommerce_ProductCatalogDescription,uCommerce_ProductCatalogGroup,uCommerce_ProductCatalogGroupCampaignRelation,uCommerce_ProductCatalogGroupPaymentMethodMap,uCommerce_ProductCatalogGroupShippingMethodMap,uCommerce_ProductCatalogGroupTarget,uCommerce_ProductCatalogPriceGroupRelation,uCommerce_ProductCatalogTarget,uCommerce_ProductDefinition,uCommerce_ProductDefinitionField,uCommerce_ProductDefinitionFieldDescription,uCommerce_ProductDescription,uCommerce_ProductDescriptionProperty,uCommerce_ProductProperty,uCommerce_ProductRelation,uCommerce_ProductRelationType,uCommerce_ProductReview,uCommerce_ProductReviewComment,uCommerce_ProductReviewStatus,uCommerce_ProductTarget,uCommerce_PurchaseOrder,uCommerce_QuantityTarget,uCommerce_Role,uCommerce_Shipment,uCommerce_ShipmentDiscountRelation,uCommerce_ShippingMethod,uCommerce_ShippingMethodCountry,uCommerce_ShippingMethodDescription,uCommerce_ShippingMethodPaymentMethods,uCommerce_ShippingMethodPrice,uCommerce_ShippingMethodsTarget,uCommerce_SystemVersion,uCommerce_Target,uCommerce_User,uCommerce_VoucherCode,uCommerce_VoucherTarget
    
    The following columns were found in the database, but are not in the current schema:
    icUrlTracker,Id,icUrlTracker,OldUrl,icUrlTracker,OldUrlQueryString,icUrlTracker,OldRegex,icUrlTracker,RedirectRootNodeId,icUrlTracker,RedirectNodeId,icUrlTracker,RedirectUrl,icUrlTracker,RedirectHttpCode,icUrlTracker,RedirectPassThroughQueryString,icUrlTracker,Notes,icUrlTracker,Is404,icUrlTracker,Referrer,icUrlTracker,Inserted,icUrlTracker,ForceRedirect,masterProduct,id,masterProduct,sku,masterProduct,productName,masterProduct,divisionId,masterProduct,divisionName,masterProduct,displayOnSite,masterProduct,displayOnSiteCategory,masterProductProp,id,masterProductProp,masterProductId,masterProductProp,propertyType,masterProductProp,propertyValue,scanOrtoLog,id,scanOrtoLog,levelState,scanOrtoLog,dateInUtc,scanOrtoLog,shortExceptionMessage,scanOrtoLog,fullExceptionMessage,scanOrtoLog,commentAll,scanOrtoLog,methodFrom,scanOrtoLog,sourceError,sessionId,id,sessionId,sessionId,sessionId,databaseName,shoppinglist,id,shoppinglist,name,shoppinglist,createdDate,shoppinglist,modifiedDate,shoppinglist,cardCode,shoppinglistProduct,id,shoppinglistProduct,shoppinglistId,shoppinglistProduct,sku,shoppinglistProduct,quantity,shoppinglistProduct,masterSku,uCommerce_Address,AddressId,uCommerce_Address,Line1,uCommerce_Address,Line2,uCommerce_Address,PostalCode,uCommerce_Address,City,uCommerce_Address,State,uCommerce_Address,CountryId,uCommerce_Address,Attention,uCommerce_Address,CustomerId,uCommerce_Address,CompanyName,uCommerce_Address,AddressName,uCommerce_Address,FirstName,uCommerce_Address,LastName,uCommerce_Address,EmailAddress,uCommerce_Address,PhoneNumber,uCommerce_Address,MobilePhoneNumber,uCommerce_AdminPage,AdminPageId,uCommerce_AdminPage,FullName,uCommerce_AdminPage,ActiveTab,uCommerce_AdminTab,AdminTabId,uCommerce_AdminTab,VirtualPath,uCommerce_AdminTab,AdminPageId,uCommerce_AdminTab,SortOrder,uCommerce_AdminTab,MultiLingual,uCommerce_AdminTab,ResouceKey,uCommerce_AdminTab,HasSaveButton,uCommerce_AdminTab,HasDeleteButton,uCommerce_AdminTab,Enabled,uCommerce_AmountOffOrderLinesAward,AmountOffOrderLinesAwardId,uCommerce_AmountOffOrderLinesAward,AmountOff,uCommerce_AmountOffOrderTotalAward,AmountOffOrderTotalAwardId,uCommerce_AmountOffOrderTotalAward,AmountOff,uCommerce_AmountOffUnitAward,AmountOffUnitAwardId,uCommerce_AmountOffUnitAward,AmountOff,uCommerce_Award,AwardId,uCommerce_Award,CampaignItemId,uCommerce_Award,Name,uCommerce_Campaign,CampaignId,uCommerce_Campaign,Name,uCommerce_Campaign,StartsOn,uCommerce_Campaign,EndsOn,uCommerce_Campaign,Enabled,uCommerce_Campaign,Priority,uCommerce_Campaign,Deleted,uCommerce_Campaign,CreatedBy,uCommerce_Campaign,ModifiedBy,uCommerce_Campaign,CreatedOn,uCommerce_Campaign,ModifiedOn,uCommerce_CampaignItem,CampaignItemId,uCommerce_CampaignItem,CampaignId,uCommerce_CampaignItem,DefinitionId,uCommerce_CampaignItem,Name,uCommerce_CampaignItem,Enabled,uCommerce_CampaignItem,Priority,uCommerce_CampaignItem,AllowNextCampaignItems,uCommerce_CampaignItem,CreatedBy,uCommerce_CampaignItem,ModifiedBy,uCommerce_CampaignItem,CreatedOn,uCommerce_CampaignItem,ModifiedOn,uCommerce_CampaignItem,Deleted,uCommerce_CampaignItemProperty,CampaignItemPropertyId,uCommerce_CampaignItemProperty,Value,uCommerce_CampaignItemProperty,DefinitionFieldId,uCommerce_CampaignItemProperty,CultureCode,uCommerce_CampaignItemProperty,CampaignItemId,uCommerce_Category,CategoryId,uCommerce_Category,Name,uCommerce_Category,ImageMediaId,uCommerce_Category,DisplayOnSite,uCommerce_Category,CreatedOn,uCommerce_Category,ParentCategoryId,uCommerce_Category,ProductCatalogId,uCommerce_Category,ModifiedOn,uCommerce_Category,ModifiedBy,uCommerce_Category,Deleted,uCommerce_Category,SortOrder,uCommerce_Category,CreatedBy,uCommerce_Category,DefinitionId,uCommerce_CategoryDescription,CategoryDescriptionId,uCommerce_CategoryDescription,CategoryId,uCommerce_CategoryDescription,DisplayName,uCommerce_CategoryDescription,Description,uCommerce_CategoryDescription,CultureCode,uCommerce_CategoryDescription,ContentId,uCommerce_CategoryDescription,RenderAsContent,uCommerce_CategoryProductRelation,CategoryProductRelationId,uCommerce_CategoryProductRelation,ProductId,uCommerce_CategoryProductRelation,CategoryId,uCommerce_CategoryProductRelation,SortOrder,uCommerce_CategoryProperty,CategoryPropertyId,uCommerce_CategoryProperty,Value,uCommerce_CategoryProperty,DefinitionFieldId,uCommerce_CategoryProperty,CultureCode,uCommerce_CategoryProperty,CategoryId,uCommerce_CategoryTarget,CategoryTargetId,uCommerce_CategoryTarget,Name,uCommerce_Country,CountryId,uCommerce_Country,Name,uCommerce_Country,Culture,uCommerce_Country,Deleted,uCommerce_Currency,CurrencyId,uCommerce_Currency,ISOCode,uCommerce_Currency,ExchangeRate,uCommerce_Currency,Deleted,uCommerce_Customer,CustomerId,uCommerce_Customer,FirstName,uCommerce_Customer,LastName,uCommerce_Customer,EmailAddress,uCommerce_Customer,PhoneNumber,uCommerce_Customer,MobilePhoneNumber,uCommerce_Customer,MemberId,uCommerce_DataType,DataTypeId,uCommerce_DataType,TypeName,uCommerce_DataType,Nullable,uCommerce_DataType,ValidationExpression,uCommerce_DataType,BuiltIn,uCommerce_DataType,DefinitionName,uCommerce_DataType,Deleted,uCommerce_DataType,Guid,uCommerce_DataTypeEnum,DataTypeEnumId,uCommerce_DataTypeEnum,DataTypeId,uCommerce_DataTypeEnum,Value,uCommerce_DataTypeEnum,Deleted,uCommerce_DataTypeEnumDescription,DataTypeEnumDescriptionId,uCommerce_DataTypeEnumDescription,DataTypeEnumId,uCommerce_DataTypeEnumDescription,CultureCode,uCommerce_DataTypeEnumDescription,DisplayName,uCommerce_DataTypeEnumDescription,Description,uCommerce_Definition,DefinitionId,uCommerce_Definition,Name,uCommerce_Definition,DefinitionTypeId,uCommerce_Definition,Description,uCommerce_Definition,Deleted,uCommerce_Definition,SortOrder,uCommerce_Definition,Guid,uCommerce_Definition,BuiltIn,uCommerce_DefinitionField,DefinitionFieldId,uCommerce_DefinitionField,DataTypeId,uCommerce_DefinitionField,DefinitionId,uCommerce_DefinitionField,Name,uCommerce_DefinitionField,DisplayOnSite,uCommerce_DefinitionField,Multilingual,uCommerce_DefinitionField,RenderInEditor,uCommerce_DefinitionField,Searchable,uCommerce_DefinitionField,SortOrder,uCommerce_DefinitionField,Deleted,uCommerce_DefinitionField,BuiltIn,uCommerce_DefinitionField,DefaultValue,uCommerce_DefinitionFieldDescription,DefinitionFieldDescriptionId,uCommerce_DefinitionFieldDescription,CultureCode,uCommerce_DefinitionFieldDescription,DisplayName,uCommerce_DefinitionFieldDescription,Description,uCommerce_DefinitionFieldDescription,DefinitionFieldId,uCommerce_DefinitionType,DefinitionTypeId,uCommerce_DefinitionType,Name,uCommerce_DefinitionType,Deleted,uCommerce_DefinitionType,SortOrder,uCommerce_DefinitionTypeDescription,DefinitionTypeDescriptionId,uCommerce_DefinitionTypeDescription,DefinitionTypeId,uCommerce_DefinitionTypeDescription,DisplayName,uCommerce_DefinitionTypeDescription,Description,uCommerce_DefinitionTypeDescription,CultureCode,uCommerce_Discount,DiscountId,uCommerce_Discount,OrderId,uCommerce_Discount,CampaignName,uCommerce_Discount,CampaignItemName,uCommerce_Discount,Description,uCommerce_Discount,AmountOffTotal,uCommerce_Discount,CreatedOn,uCommerce_Discount,ModifiedOn,uCommerce_Discount,CreatedBy,uCommerce_Discount,ModifiedBy,uCommerce_DiscountSpecificOrderLineAward,DiscountSpecificOrderLineAwardId,uCommerce_DiscountSpecificOrderLineAward,AmountOff,uCommerce_DiscountSpecificOrderLineAward,AmountType,uCommerce_DiscountSpecificOrderLineAward,DiscountTarget,uCommerce_DiscountSpecificOrderLineAward,Sku,uCommerce_DiscountSpecificOrderLineAward,VariantSku,uCommerce_DynamicOrderPropertyTarget,DynamicOrderPropertyTargetId,uCommerce_DynamicOrderPropertyTarget,Key,uCommerce_DynamicOrderPropertyTarget,Value,uCommerce_DynamicOrderPropertyTarget,CompareMode,uCommerce_DynamicOrderPropertyTarget,TargetOrderLine,uCommerce_EmailContent,EmailContentId,uCommerce_EmailContent,EmailProfileId,uCommerce_EmailContent,EmailTypeId,uCommerce_EmailContent,CultureCode,uCommerce_EmailContent,Subject,uCommerce_EmailContent,ContentId,uCommerce_EmailParameter,EmailParameterId,uCommerce_EmailParameter,Name,uCommerce_EmailParameter,GlobalResourceKey,uCommerce_EmailParameter,QueryStringKey,uCommerce_EmailProfile,EmailProfileId,uCommerce_EmailProfile,Name,uCommerce_EmailProfile,ModifiedOn,uCommerce_EmailProfile,ModifiedBy,uCommerce_EmailProfile,CreatedOn,uCommerce_EmailProfile,CreatedBy,uCommerce_EmailProfile,Deleted,uCommerce_EmailProfileInformation,EmailProfileInformationId,uCommerce_EmailProfileInformation,EmailProfileId,uCommerce_EmailProfileInformation,EmailTypeId,uCommerce_EmailProfileInformation,FromName,uCommerce_EmailProfileInformation,FromAddress,uCommerce_EmailProfileInformation,CcAddress,uCommerce_EmailProfileInformation,BccAddress,uCommerce_EmailType,EmailTypeId,uCommerce_EmailType,Name,uCommerce_EmailType,Description,uCommerce_EmailType,CreatedOn,uCommerce_EmailType,CreatedBy,uCommerce_EmailType,ModifiedOn,uCommerce_EmailType,ModifiedBy,uCommerce_EmailType,Deleted,uCommerce_EmailTypeParameter,EmailTypeId,uCommerce_EmailTypeParameter,EmailParameterId,uCommerce_EntityUi,EntityUiId,uCommerce_EntityUi,Type,uCommerce_EntityUi,VirtualPathUi,uCommerce_EntityUi,SortOrder,uCommerce_EntityUiDescription,EntityUiDescriptionId,uCommerce_EntityUiDescription,EntityUiId,uCommerce_EntityUiDescription,DisplayName,uCommerce_EntityUiDescription,Description,uCommerce_EntityUiDescription,CultureCode,uCommerce_FreeGiftAward,FreeGiftAwardId,uCommerce_FreeGiftAward,Sku,uCommerce_FreeGiftAward,VariantSku,uCommerce_OrderAddress,OrderAddressId,uCommerce_OrderAddress,FirstName,uCommerce_OrderAddress,LastName,uCommerce_OrderAddress,EmailAddress,uCommerce_OrderAddress,PhoneNumber,uCommerce_OrderAddress,MobilePhoneNumber,uCommerce_OrderAddress,Line1,uCommerce_OrderAddress,Line2,uCommerce_OrderAddress,PostalCode,uCommerce_OrderAddress,City,uCommerce_OrderAddress,State,uCommerce_OrderAddress,CountryId,uCommerce_OrderAddress,Attention,uCommerce_OrderAddress,CompanyName,uCommerce_OrderAddress,AddressName,uCommerce_OrderAddress,OrderId,uCommerce_OrderAmountTarget,OrderAmountTargetId,uCommerce_OrderAmountTarget,MinAmount,uCommerce_OrderLine,OrderLineId,uCommerce_OrderLine,OrderId,uCommerce_OrderLine,Sku,uCommerce_OrderLine,ProductName,uCommerce_OrderLine,Price,uCommerce_OrderLine,Quantity,uCommerce_OrderLine,CreatedOn,uCommerce_OrderLine,Discount,uCommerce_OrderLine,VAT,uCommerce_OrderLine,Total,uCommerce_OrderLine,VATRate,uCommerce_OrderLine,VariantSku,uCommerce_OrderLine,ShipmentId,uCommerce_OrderLine,UnitDiscount,uCommerce_OrderLine,CreatedBy,uCommerce_OrderLineDiscountRelation,OrderLineDiscountRelationId,uCommerce_OrderLineDiscountRelation,DiscountId,uCommerce_OrderLineDiscountRelation,OrderLineId,uCommerce_OrderNumberSerie,OrderNumberId,uCommerce_OrderNumberSerie,OrderNumberName,uCommerce_OrderNumberSerie,Prefix,uCommerce_OrderNumberSerie,Postfix,uCommerce_OrderNumberSerie,Increment,uCommerce_OrderNumberSerie,CurrentNumber,uCommerce_OrderNumberSerie,Deleted,uCommerce_OrderProperty,OrderPropertyId,uCommerce_OrderProperty,OrderId,uCommerce_OrderProperty,OrderLineId,uCommerce_OrderProperty,Key,uCommerce_OrderProperty,Value,uCommerce_OrderStatus,OrderStatusId,uCommerce_OrderStatus,Name,uCommerce_OrderStatus,Sort,uCommerce_OrderStatus,RenderChildren,uCommerce_OrderStatus,RenderInMenu,uCommerce_OrderStatus,NextOrderStatusId,uCommerce_OrderStatus,ExternalId,uCommerce_OrderStatus,IncludeInAuditTrail,uCommerce_OrderStatus,Order,uCommerce_OrderStatus,AllowUpdate,uCommerce_OrderStatus,AlwaysAvailable,uCommerce_OrderStatus,Pipeline,uCommerce_OrderStatus,AllowOrderEdit,uCommerce_OrderStatusAudit,OrderStatusAuditId,uCommerce_OrderStatusAudit,NewOrderStatusId,uCommerce_OrderStatusAudit,CreatedOn,uCommerce_OrderStatusAudit,CreatedBy,uCommerce_OrderStatusAudit,OrderId,uCommerce_OrderStatusAudit,Message,uCommerce_OrderStatusDescription,OrderStatusId,uCommerce_OrderStatusDescription,DisplayName,uCommerce_OrderStatusDescription,Description,uCommerce_OrderStatusDescription,CultureCode,uCommerce_Payment,PaymentId,uCommerce_Payment,TransactionId,uCommerce_Payment,PaymentMethodName,uCommerce_Payment,Created,uCommerce_Payment,PaymentMethodId,uCommerce_Payment,Fee,uCommerce_Payment,FeePercentage,uCommerce_Payment,PaymentStatusId,uCommerce_Payment,Amount,uCommerce_Payment,OrderId,uCommerce_Payment,FeeTotal,uCommerce_Payment,ReferenceId,uCommerce_PaymentMethod,PaymentMethodId,uCommerce_PaymentMethod,Name,uCommerce_PaymentMethod,FeePercent,uCommerce_PaymentMethod,ImageMediaId,uCommerce_PaymentMethod,PaymentMethodServiceName,uCommerce_PaymentMethod,Enabled,uCommerce_PaymentMethod,Deleted,uCommerce_PaymentMethod,ModifiedOn,uCommerce_PaymentMethod,ModifiedBy,uCommerce_PaymentMethod,Pipeline,uCommerce_PaymentMethod,DefinitionId,uCommerce_PaymentMethodCountry,PaymentMethodId,uCommerce_PaymentMethodCountry,CountryId,uCommerce_PaymentMethodDescription,PaymentMethodDescriptionId,uCommerce_PaymentMethodDescription,PaymentMethodId,uCommerce_PaymentMethodDescription,CultureCode,uCommerce_PaymentMethodDescription,DisplayName,uCommerce_PaymentMethodDescription,Description,uCommerce_PaymentMethodFee,PaymentMethodFeeId,uCommerce_PaymentMethodFee,PaymentMethodId,uCommerce_PaymentMethodFee,CurrencyId,uCommerce_PaymentMethodFee,PriceGroupId,uCommerce_PaymentMethodFee,Fee,uCommerce_PaymentMethodProperty,PaymentMethodPropertyId,uCommerce_PaymentMethodProperty,DefinitionFieldId,uCommerce_PaymentMethodProperty,Value,uCommerce_PaymentMethodProperty,CultureCode,uCommerce_PaymentMethodProperty,PaymentMethodId,uCommerce_PaymentProperty,PaymentPropertyId,uCommerce_PaymentProperty,PaymentId,uCommerce_PaymentProperty,Key,uCommerce_PaymentProperty,Value,uCommerce_PaymentStatus,PaymentStatusId,uCommerce_PaymentStatus,Name,uCommerce_PercentOffOrderLinesAward,PercentOffOrderLinesAwardId,uCommerce_PercentOffOrderLinesAward,PercentOff,uCommerce_PercentOffOrderTotalAward,PercentOffOrderTotalAwardId,uCommerce_PercentOffOrderTotalAward,PercentOff,uCommerce_PercentOffShippingTotalAward,PercentOffShippingTotalAwardId,uCommerce_PercentOffShippingTotalAward,PercentOff,uCommerce_Permission,PermissionId,uCommerce_Permission,UserId,uCommerce_Permission,RoleId,uCommerce_PriceGroup,PriceGroupId,uCommerce_PriceGroup,Name,uCommerce_PriceGroup,CurrencyId,uCommerce_PriceGroup,VATRate,uCommerce_PriceGroup,Description,uCommerce_PriceGroup,CreatedOn,uCommerce_PriceGroup,CreatedBy,uCommerce_PriceGroup,ModifiedOn,uCommerce_PriceGroup,ModifiedBy,uCommerce_PriceGroup,Deleted,uCommerce_PriceGroupPrice,PriceGroupPriceId,uCommerce_PriceGroupPrice,ProductId,uCommerce_PriceGroupPrice,Price,uCommerce_PriceGroupPrice,DiscountPrice,uCommerce_PriceGroupPrice,PriceGroupId,uCommerce_PriceGroupTarget,PriceGroupTargetId,uCommerce_PriceGroupTarget,PriceGroupName,uCommerce_Product,ProductId,uCommerce_Product,ParentProductId,uCommerce_Product,Sku,uCommerce_Product,VariantSku,uCommerce_Product,Name,uCommerce_Product,DisplayOnSite,uCommerce_Product,ThumbnailImageMediaId,uCommerce_Product,PrimaryImageMediaId,uCommerce_Product,Weight,uCommerce_Product,ProductDefinitionId,uCommerce_Product,AllowOrdering,uCommerce_Product,ModifiedBy,uCommerce_Product,ModifiedOn,uCommerce_Product,CreatedOn,uCommerce_Product,CreatedBy,uCommerce_Product,Rating,uCommerce_ProductCatalog,ProductCatalogId,uCommerce_ProductCatalog,ProductCatalogGroupId,uCommerce_ProductCatalog,Name,uCommerce_ProductCatalog,PriceGroupId,uCommerce_ProductCatalog,ShowPricesIncludingVAT,uCommerce_ProductCatalog,IsVirtual,uCommerce_ProductCatalog,DisplayOnWebSite,uCommerce_ProductCatalog,LimitedAccess,uCommerce_ProductCatalog,Deleted,uCommerce_ProductCatalog,CreatedOn,uCommerce_ProductCatalog,ModifiedOn,uCommerce_ProductCatalog,CreatedBy,uCommerce_ProductCatalog,ModifiedBy,uCommerce_ProductCatalog,SortOrder,uCommerce_ProductCatalogDescription,ProductCatalogDescriptionId,uCommerce_ProductCatalogDescription,ProductCatalogId,uCommerce_ProductCatalogDescription,CultureCode,uCommerce_ProductCatalogDescription,DisplayName,uCommerce_ProductCatalogGroup,ProductCatalogGroupId,uCommerce_ProductCatalogGroup,Name,uCommerce_ProductCatalogGroup,Description,uCommerce_ProductCatalogGroup,EmailProfileId,uCommerce_ProductCatalogGroup,CurrencyId,uCommerce_ProductCatalogGroup,DomainId,uCommerce_ProductCatalogGroup,OrderNumberId,uCommerce_ProductCatalogGroup,Deleted,uCommerce_ProductCatalogGroup,CreateCustomersAsMembers,uCommerce_ProductCatalogGroup,MemberGroupId,uCommerce_ProductCatalogGroup,MemberTypeId,uCommerce_ProductCatalogGroup,ProductReviewsRequireApproval,uCommerce_ProductCatalogGroupCampaignRelation,ProductCatalogGroupCampaignRelationId,uCommerce_ProductCatalogGroupCampaignRelation,CampaignId,uCommerce_ProductCatalogGroupCampaignRelation,ProductCatalogGroupId,uCommerce_ProductCatalogGroupPaymentMethodMap,ProductCatalogGroupId,uCommerce_ProductCatalogGroupPaymentMethodMap,PaymentMethodId,uCommerce_ProductCatalogGroupShippingMethodMap,ProductCatalogGroupId,uCommerce_ProductCatalogGroupShippingMethodMap,ShippingMethodId,uCommerce_ProductCatalogGroupTarget,ProductCatalogGroupTargetId,uCommerce_ProductCatalogGroupTarget,Name,uCommerce_ProductCatalogPriceGroupRelation,ProductCatalogPriceGroupRelationId,uCommerce_ProductCatalogPriceGroupRelation,ProductCatalogId,uCommerce_ProductCatalogPriceGroupRelation,PriceGroupId,uCommerce_ProductCatalogPriceGroupRelation,SortOrder,uCommerce_ProductCatalogTarget,ProductCatalogTargetId,uCommerce_ProductCatalogTarget,Name,uCommerce_ProductDefinition,ProductDefinitionId,uCommerce_ProductDefinition,Name,uCommerce_ProductDefinition,Description,uCommerce_ProductDefinition,Deleted,uCommerce_ProductDefinition,SortOrder,uCommerce_ProductDefinition,Guid,uCommerce_ProductDefinitionField,ProductDefinitionFieldId,uCommerce_ProductDefinitionField,DataTypeId,uCommerce_ProductDefinitionField,ProductDefinitionId,uCommerce_ProductDefinitionField,Name,uCommerce_ProductDefinitionField,DisplayOnSite,uCommerce_ProductDefinitionField,IsVariantProperty,uCommerce_ProductDefinitionField,Multilingual,uCommerce_ProductDefinitionField,RenderInEditor,uCommerce_ProductDefinitionField,Searchable,uCommerce_ProductDefinitionField,Deleted,uCommerce_ProductDefinitionField,SortOrder,uCommerce_ProductDefinitionField,Facet,uCommerce_ProductDefinitionFieldDescription,ProductDefinitionFieldDescriptionId,uCommerce_ProductDefinitionFieldDescription,CultureCode,uCommerce_ProductDefinitionFieldDescription,DisplayName,uCommerce_ProductDefinitionFieldDescription,ProductDefinitionFieldId,uCommerce_ProductDefinitionFieldDescription,Description,uCommerce_ProductDescription,ProductDescriptionId,uCommerce_ProductDescription,ProductId,uCommerce_ProductDescription,DisplayName,uCommerce_ProductDescription,ShortDescription,uCommerce_ProductDescription,LongDescription,uCommerce_ProductDescription,CultureCode,uCommerce_ProductDescriptionProperty,ProductDescriptionPropertyId,uCommerce_ProductDescriptionProperty,ProductDescriptionId,uCommerce_ProductDescriptionProperty,ProductDefinitionFieldId,uCommerce_ProductDescriptionProperty,Value,uCommerce_ProductProperty,ProductPropertyId,uCommerce_ProductProperty,Value,uCommerce_ProductProperty,ProductDefinitionFieldId,uCommerce_ProductProperty,ProductId,uCommerce_ProductRelation,ProductRelationId,uCommerce_ProductRelation,ProductId,uCommerce_ProductRelation,RelatedProductId,uCommerce_ProductRelation,ProductRelationTypeId,uCommerce_ProductRelationType,ProductRelationTypeId,uCommerce_ProductRelationType,Name,uCommerce_ProductRelationType,Description,uCommerce_ProductRelationType,CreatedOn,uCommerce_ProductRelationType,CreatedBy,uCommerce_ProductRelationType,ModifiedOn,uCommerce_ProductRelationType,ModifiedBy,uCommerce_ProductReview,ProductReviewId,uCommerce_ProductReview,Rating,uCommerce_ProductReview,CustomerId,uCommerce_ProductReview,ProductCatalogGroupId,uCommerce_ProductReview,CreatedOn,uCommerce_ProductReview,ModifiedOn,uCommerce_ProductReview,ModifiedBy,uCommerce_ProductReview,CultureCode,uCommerce_ProductReview,ReviewHeadline,uCommerce_ProductReview,ReviewText,uCommerce_ProductReview,ProductId,uCommerce_ProductReview,Ip,uCommerce_ProductReview,ProductReviewStatusId,uCommerce_ProductReviewComment,ProductReviewCommentId,uCommerce_ProductReviewComment,ProductReviewId,uCommerce_ProductReviewComment,CustomerId,uCommerce_ProductReviewComment,CreatedOn,uCommerce_ProductReviewComment,ModifiedOn,uCommerce_ProductReviewComment,ModifiedBy,uCommerce_ProductReviewComment,CultureCode,uCommerce_ProductReviewComment,Comment,uCommerce_ProductReviewComment,Helpful,uCommerce_ProductReviewComment,Unhelpful,uCommerce_ProductReviewComment,Ip,uCommerce_ProductReviewComment,ProductReviewStatusId,uCommerce_ProductReviewStatus,ProductReviewStatusId,uCommerce_ProductReviewStatus,Name,uCommerce_ProductReviewStatus,Deleted,uCommerce_ProductTarget,ProductTargetId,uCommerce_ProductTarget,Sku,uCommerce_ProductTarget,VariantSku,uCommerce_PurchaseOrder,OrderId,uCommerce_PurchaseOrder,OrderNumber,uCommerce_PurchaseOrder,CustomerId,uCommerce_PurchaseOrder,OrderStatusId,uCommerce_PurchaseOrder,CreatedDate,uCommerce_PurchaseOrder,CompletedDate,uCommerce_PurchaseOrder,CurrencyId,uCommerce_PurchaseOrder,ProductCatalogGroupId,uCommerce_PurchaseOrder,BillingAddressId,uCommerce_PurchaseOrder,Note,uCommerce_PurchaseOrder,BasketId,uCommerce_PurchaseOrder,VAT,uCommerce_PurchaseOrder,OrderTotal,uCommerce_PurchaseOrder,ShippingTotal,uCommerce_PurchaseOrder,PaymentTotal,uCommerce_PurchaseOrder,TaxTotal,uCommerce_PurchaseOrder,SubTotal,uCommerce_PurchaseOrder,OrderGuid,uCommerce_PurchaseOrder,ModifiedOn,uCommerce_PurchaseOrder,CultureCode,uCommerce_PurchaseOrder,Discount,uCommerce_PurchaseOrder,DiscountTotal,uCommerce_QuantityTarget,QuantityTargetId,uCommerce_QuantityTarget,MinQuantity,uCommerce_Role,RoleId,uCommerce_Role,Name,uCommerce_Role,ProductCatalogGroupId,uCommerce_Role,ProductCatalogId,uCommerce_Role,CultureCode,uCommerce_Role,PriceGroupId,uCommerce_Role,RoleType,uCommerce_Role,ParentRoleId,uCommerce_Shipment,ShipmentId,uCommerce_Shipment,ShipmentName,uCommerce_Shipment,CreatedOn,uCommerce_Shipment,ShipmentPrice,uCommerce_Shipment,ShippingMethodId,uCommerce_Shipment,ShipmentAddressId,uCommerce_Shipment,DeliveryNote,uCommerce_Shipment,OrderId,uCommerce_Shipment,TrackAndTrace,uCommerce_Shipment,CreatedBy,uCommerce_Shipment,Tax,uCommerce_Shipment,TaxRate,uCommerce_Shipment,ShipmentTotal,uCommerce_Shipment,ShipmentDiscount,uCommerce_ShipmentDiscountRelation,ShipmentDiscountRelationId,uCommerce_ShipmentDiscountRelation,ShipmentId,uCommerce_ShipmentDiscountRelation,DiscountId,uCommerce_ShippingMethod,ShippingMethodId,uCommerce_ShippingMethod,Name,uCommerce_ShippingMethod,ImageMediaId,uCommerce_ShippingMethod,PaymentMethodId,uCommerce_ShippingMethod,ServiceName,uCommerce_ShippingMethod,Deleted,uCommerce_ShippingMethodCountry,ShippingMethodId,uCommerce_ShippingMethodCountry,CountryId,uCommerce_ShippingMethodDescription,ShippingMethodDescriptionId,uCommerce_ShippingMethodDescription,ShippingMethodId,uCommerce_ShippingMethodDescription,DisplayName,uCommerce_ShippingMethodDescription,Description,uCommerce_ShippingMethodDescription,DeliveryText,uCommerce_ShippingMethodDescription,CultureCode,uCommerce_ShippingMethodPaymentMethods,ShippingMethodId,uCommerce_ShippingMethodPaymentMethods,PaymentMethodId,uCommerce_ShippingMethodPrice,ShippingMethodPriceId,uCommerce_ShippingMethodPrice,ShippingMethodId,uCommerce_ShippingMethodPrice,PriceGroupId,uCommerce_ShippingMethodPrice,Price,uCommerce_ShippingMethodPrice,CurrencyId,uCommerce_ShippingMethodsTarget,ShippingMethodsTargetId,uCommerce_ShippingMethodsTarget,ShippingMethodsIdsList,uCommerce_SystemVersion,SystemVersionId,uCommerce_SystemVersion,SchemaVersion,uCommerce_Target,TargetId,uCommerce_Target,CampaignItemId,uCommerce_Target,EnabledForDisplay,uCommerce_Target,EnabledForApply,uCommerce_User,UserId,uCommerce_User,ExternalId,uCommerce_VoucherCode,VoucherCodeId,uCommerce_VoucherCode,TargetId,uCommerce_VoucherCode,NumberUsed,uCommerce_VoucherCode,MaxUses,uCommerce_VoucherCode,Code,uCommerce_VoucherTarget,VoucherTargetId,uCommerce_VoucherTarget,Name
    
    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    FK_umbracoNode_umbracoNode_id,FK_cmsContentType_umbracoNode_id,FK_cmsTemplate_umbracoNode,FK_cmsTemplate_cmsTemplate,FK_cmsContent_umbracoNode_id,FK_cmsContent_cmsContentType_nodeId,FK_cmsContentVersion_cmsContent_nodeId,FK_cmsDocument_cmsContent_nodeId,FK_cmsDocument_umbracoNode_id,FK_cmsDocument_cmsTemplate_nodeId,FK_cmsDocumentType_umbracoNode_id,FK_cmsDocumentType_cmsContentType_nodeId,FK_cmsDocumentType_cmsTemplate_nodeId,FK_cmsDataType_umbracoNode_id,FK_cmsDataTypePreValues_cmsDataType_nodeId,FK_cmsLanguageText_cmsDictionary_id,FK_umbracoDomains_umbracoNode_id,FK_cmsMacroProperty_cmsMacro_id,FK_cmsMemberType_umbracoNode_id,FK_cmsMemberType_cmsContentType_nodeId,FK_cmsMember_cmsContent_nodeId,FK_cmsMember_umbracoNode_id,FK_cmsMember2MemberGroup_cmsMember_nodeId,FK_cmsMember2MemberGroup_umbracoNode_id,FK_cmsContentXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContent_nodeId,FK_cmsPreviewXml_cmsContentVersion_VersionId,FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup_id,FK_cmsPropertyTypeGroup_cmsContentType_nodeId,FK_cmsPropertyType_cmsDataType_nodeId,FK_cmsPropertyType_cmsContentType_nodeId,FK_cmsPropertyType_cmsPropertyTypeGroup_id,FK_cmsPropertyData_umbracoNode_id,FK_cmsPropertyData_cmsPropertyType_id,FK_umbracoRelation_umbracoNode,FK_umbracoRelation_umbracoNode1,FK_umbracoRelation_umbracoRelationType_id,FK_cmsStylesheet_umbracoNode_id,FK_cmsTags_cmsTags,FK_cmsTagRelationship_cmsContent,FK_cmsTagRelationship_cmsTags_id,FK_cmsTagRelationship_cmsPropertyType,FK_umbracoUser_umbracoUserType_id,FK_cmsTask_cmsTaskType_id,FK_cmsTask_umbracoNode_id,FK_cmsTask_umbracoUser,FK_cmsTask_umbracoUser1,FK_cmsContentType2ContentType_umbracoNode_parent,FK_cmsContentType2ContentType_umbracoNode_child,FK_cmsContentTypeAllowedContentType_cmsContentType,FK_cmsContentTypeAllowedContentType_cmsContentType1,FK_umbracoUser2app_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoUser_id,FK_umbracoUser2NodeNotify_umbracoNode_id,FK_umbracoUser2NodePermission_umbracoUser_id,FK_umbracoUser2NodePermission_umbracoNode_id,PK_structure,PK_cmsContentType,PK_cmsTemplate,PK_cmsContent,PK_cmsContentVersion,PK_cmsDocument,PK_cmsDocumentType,PK_cmsDataType,PK_cmsDataTypePreValues,PK_cmsDictionary,PK_cmsLanguageText,PK_umbracoLanguage,PK_umbracoDomains,PK_umbracoLog,PK_cmsMacro,PK_cmsMacroProperty,PK_cmsMemberType,PK_cmsMember,PK_cmsMember2MemberGroup,PK_cmsContentXml,PK_cmsContentPreviewXml,PK_cmsPropertyTypeGroup,PK_cmsPropertyType,PK_cmsPropertyData,PK_umbracoRelationType,PK_umbracoRelation,PK_cmsStylesheet,PK_cmsStylesheetProperty,PK_cmsTags,PK_cmsTagRelationship,PK_umbracoUserType,PK_user,PK_cmsTaskType,PK_cmsTask,PK_cmsContentType2ContentType,PK_cmsContentTypeAllowedContentType,PK_user2app,PK_umbracoUser2NodeNotify,PK_umbracoUser2NodePermission,PK_umbracoServer,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodeUniqueID,IX_umbracoNodeObjectType,IX_cmsContentType,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTags,IX_umbracoUserLogins_Index,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive
    
    The following indexes were found in the database, but are not in the current schema:
    IX_icUrlTracker,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodeUniqueID,IX_umbracoNodeObjectType,IX_cmsContentType,IX_cmsContentType_icon,IX_cmsTemplate_nodeId,IX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsMacroPropertyAlias,IX_cmsMacroProperty_Alias,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTags,IX_umbracoUserLogins_Index,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive
     
  • Søren Kottal 488 posts 3203 karma points MVP 2x c-trib
    Jan 29, 2015 @ 12:32
    Søren Kottal
    100

    Turns out my local backup of the db was wrong.

  • Jan Skovgaard 11257 posts 23497 karma points MVP 7x admin c-trib
    Jan 29, 2015 @ 17:53
    Jan Skovgaard
    0

    Hi Søren

    Ok, that makes much more sense then :) - Thanks for sharing!

    /Jan

  • Heather Floyd 522 posts 755 karma points MVP 2x c-trib
    Jul 01, 2020 @ 21:03
Please Sign in or register to post replies

Write your reply to:

Draft