Copied to clipboard

Flag this post as spam?

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


  • Nigel Wilson 945 posts 2077 karma points
    Oct 18, 2016 @ 07:15
    Nigel Wilson
    0

    Umbraco Upgrade 7.4.3 - 7.5.3 Failed

    Hi there

    I upgraded my dev site with no problems at all.

    Then copied the updated files (bin/config/umbraco/umbraco_client) and synced the web.config

    However when running the install on the live site it failed.

    The error is as follows (sorry so big):

    Error Number:2797,State:1,Class:16
     2016-10-18 19:51:52,825 [P11944/D6/T46] INFO  Umbraco.Core.DatabaseContext - The database schema validation produced the following summary: 
    The following tables were found in the database, but are not in the current schema:
    cmsStylesheetProperty,Redirects,cmsStylesheet,umbracoRedirectUrl
    
    The following columns were found in the database, but are not in the current schema:
    cmsStylesheetProperty,nodeId,cmsStylesheetProperty,stylesheetPropertyEditor,cmsStylesheetProperty,stylesheetPropertyAlias,cmsStylesheetProperty,stylesheetPropertyValue,Redirects,Id,Redirects,OldUrl,Redirects,NewUrl,Redirects,LastUpdated,Redirects,Notes,cmsStylesheet,nodeId,cmsStylesheet,filename,cmsStylesheet,content,umbracoRedirectUrl,id,umbracoRedirectUrl,contentKey,umbracoRedirectUrl,createDateUtc,umbracoRedirectUrl,url,umbracoRedirectUrl,urlHash
    
    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    FK_cmsStylesheet_umbracoNode_id,FK_umbracoRedirectUrl_umbracoNode_uniqueID,PK_cmsStylesheet,PK_cmsStylesheetProperty,PK_Redirects,PK_umbracoRedirectUrl,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_cmsPropertyTypeGroupUniqueID,IX_cmsPropertyTypeUniqueID,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,IX_cmsTags,IX_umbracoUser_userLogin,IX_cmsTaskType_alias,IX_computerName,IX_umbracoServer_isActive,IX_umbracoAccess_nodeId,IX_umbracoAccessRule,IX_umbracoMigration,IX_umbracoDeployChecksum,IX_umbracoRedirectUrl
    
    The following indexes were found in the database, but are not in the current schema:
    IX_umbracoRedirectUrl
    

    Any suggestions please ?

    Thanks, Nigel

  • Nigel Wilson 945 posts 2077 karma points
    Oct 18, 2016 @ 07:42
    Nigel Wilson
    0

    And further back in the log file is the following:

    Error Number:2797,State:1,Class:16
     2016-10-18 19:51:52,825 [P11944/D6/T46] ERROR Umbraco.Core.DatabaseContext - Database configuration failed
    System.Data.SqlClient.SqlException (0x80131904): The default schema does not exist.
    

    Do these errors point to a dB permissions issue ?

    Thanks, Nigel

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies