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 944 posts 2076 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 944 posts 2076 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

Please Sign in or register to post replies

Write your reply to:

Draft