Copied to clipboard

Flag this post as spam?

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


  • Bradley Kronson 63 posts 114 karma points
    May 26, 2014 @ 06:03
    Bradley Kronson
    0

    Updating from 6.1.6 to 6.20 fails with database timeout

    I have a huge Umbraco install (>300 000 nodes) on version 6.1.6

    I've tried to update to 6.20 several times now - it keeps failing with the error below.

    The database configuration failed with the following message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')

    Las few lines in the log file are below:

    2014-05-26 03:18:26,970 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Determining hash of code files on disk
    2014-05-26 03:18:26,993 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Hash determined (took 15ms)
    2014-05-26 03:18:26,996 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of umbraco.interfaces.IApplicationStartupHandler
    2014-05-26 03:18:27,214 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 35 (took 218ms)
    2014-05-26 03:18:27,219 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter
    2014-05-26 03:18:27,244 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 12 (took 25ms)
    2014-05-26 03:18:27,244 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.PropertyEditors.IPropertyValueConverter
    2014-05-26 03:18:27,257 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyValueConverter, found 11 (took 12ms)
    2014-05-26 03:18:27,275 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Web.Mvc.SurfaceController
    2014-05-26 03:18:27,283 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 13 (took 7ms)
    2014-05-26 03:18:27,283 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Web.WebApi.UmbracoApiController
    2014-05-26 03:18:27,291 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.WebApi.UmbracoApiController, found 17 (took 7ms)
    2014-05-26 03:18:27,294 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.Media.IThumbnailProvider
    2014-05-26 03:18:27,304 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 10ms)
    2014-05-26 03:18:27,304 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Starting resolution types of Umbraco.Core.Media.IImageUrlProvider
    2014-05-26 03:18:27,315 [15] INFO  Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 2 (took 10ms)
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,376 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,381 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,381 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,381 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,381 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,384 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,384 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,385 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,387 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,387 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,387 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,387 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,747 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,753 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:27,756 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:29,475 [15] INFO  Umbraco.Core.ApplicationContext - [Thread 10] CurrentVersion different from configStatus: '6.2.0','6.1.6'
    2014-05-26 03:18:29,475 [15] INFO  Umbraco.Web.UI.Install.InstallerRestService - [Thread 10] Running 'Upgrade' service
    2014-05-26 03:18:29,499 [15] INFO  Umbraco.Core.DatabaseContext - [Thread 10] Database upgrade started
    2014-05-26 03:18:38,798 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Initializing database migrations
    2014-05-26 03:18:38,818 [15] INFO  Umbraco.Core.PluginManager - [Thread 10] Starting resolution types of Umbraco.Core.Persistence.Migrations.IMigration
    2014-05-26 03:18:38,896 [15] INFO  Umbraco.Core.PluginManager - [Thread 10] Completed resolution of types of Umbraco.Core.Persistence.Migrations.IMigration, found 20 (took 77ms)
    2014-05-26 03:18:38,964 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys' to context
    2014-05-26 03:18:38,965 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Added UPGRADE migration 'AssignMissingPrimaryForMySqlKeys2' to context
    2014-05-26 03:18:38,995 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Added UPGRADE migration 'AdditionalIndexesAndKeys' to context
    2014-05-26 03:18:38,999 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Added UPGRADE migration 'ChangePasswordColumn' to context
    2014-05-26 03:18:39,001 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Added UPGRADE migration 'AddChangeDocumentTypePermission' to context
    2014-05-26 03:18:39,001 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Added UPGRADE migration 'UpdateToNewMemberPropertyAliases' to context
    2014-05-26 03:18:39,077 [15] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 10] Executing sql statement 1: ALTER TABLE [umbracoUser] ALTER COLUMN [userPassword] NVARCHAR(500) NOT NULL
    2014-05-26 03:19:24,843 [15] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 10]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery()
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
    2014-05-26 03:19:24,872 [15] INFO  Umbraco.Core.DatabaseContext - [Thread 10] Database configuration failed with the following error and stack trace: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery()
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.<ExecuteNonQueryWithRetry>b__0()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
       at Umbraco.Web.Strategies.Migrations.ClearMediaXmlCacheForDeletedItemsAfterUpgrade.MigrationRunner_Migrated(MigrationRunner sender, MigrationEventArgs e)
       at Umbraco.Core.Events.TypedEventHandler`2.Invoke(TSender sender, TEventArgs e)
       at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)
       at Umbraco.Core.DatabaseContext.UpgradeSchemaAndData()
    2014-05-26 03:19:24,879 [15] INFO  Umbraco.Core.DatabaseContext - [Thread 10] The database schema validation produced the following summary:
    The following tables were found in the database, but are not in the current schema:
    BrandReportSummary,QuickMonitorUnmatchedImport,vAVE,vBrand,vCategory,vMembers,vModel,vOnline,vPrint,vRadio,vRange,QuickFleetBookingData,vSocial,QuickFleetData,vSocialItems,QuickFleetHistoryData,vTV,uShareAuthorizations,uShareServiceProviders,VehicleImport,WG2KFormSubmisions,qfVehicleBooking,qfBookingRequest,CMSImportCustomRelation,CMSImportMediaRelation,CMSImportRelation,CMSImportScheduledItems,CMSImportScheduledTask,CMSImportState,NodeAccess,vMediaOwner,vNodeRelatedMedia,vSiteMedia,lNodeRelatedMedia,lSiteMedia,ELMAH_Error,qfReport,qfVehicleHistory,qfVehicles,qmMailJob,qmMailQueue,qmMailQueueAudit,qmtranbackup2,FleetVehicleImport,qmTransactions,qmtransactionsbackup,qpViewLog,QuickMonitorData,BrandReportData
     
    The following columns were found in the database, but are not in the current schema:
    BrandReportSummary,iPKTransaction,BrandReportSummary,iFKCategory,BrandReportSummary,Category,BrandReportSummary,iPositive,BrandReportSummary,iNuetral,BrandReportSummary,iNegative,BrandReportSummary,sMediaType,BrandReportSummary,iFKMediaType,BrandReportSummary,iFKBrand,QuickMonitorUnmatchedImport,sMediaType,QuickMonitorUnmatchedImport,Medium,QuickMonitorUnmatchedImport,Journalist,QuickMonitorUnmatchedImport,AVEType,QuickMonitorUnmatchedImport,Product,QuickMonitorUnmatchedImport,Brand,QuickMonitorUnmatchedImport,Range,QuickMonitorUnmatchedImport,Model,QuickMonitorUnmatchedImport,sArticleTitle,QuickMonitorUnmatchedImport,dArticleDate,QuickMonitorUnmatchedImport,dCaptureDate,QuickMonitorUnmatchedImport,iPositive,QuickMonitorUnmatchedImport,iNuetral,QuickMonitorUnmatchedImport,iNegative,QuickMonitorUnmatchedImport,sPositiveComment,QuickMonitorUnmatchedImport,sNuetralComment,QuickMonitorUnmatchedImport,sNegativeComment,QuickMonitorUnmatchedImport,iPageNo,QuickMonitorUnmatchedImport,dDuration,QuickMonitorUnmatchedImport,cMediumAVE,QuickMonitorUnmatchedImport,cArticleAVE,QuickMonitorUnmatchedImport,iCoverage,QuickMonitorUnmatchedImport,sArticleURL,QuickMonitorUnmatchedImport,sArticleMediaFilePath,QuickMonitorUnmatchedImport,guidArticleMediaGUI,QuickMonitorUnmatchedImport,iCreditibility,QuickMonitorUnmatchedImport,iFKCategory,QuickMonitorUnmatchedImport,iFKMediumAVE,QuickMonitorUnmatchedImport,iFKMediaType,QuickMonitorUnmatchedImport,iFKMedium,QuickMonitorUnmatchedImport,iFKJournalist,QuickMonitorUnmatchedImport,iPKTransaction,QuickMonitorUnmatchedImport,iFKProduct,QuickMonitorUnmatchedImport,iFKBrand,QuickMonitorUnmatchedImport,iFKRange,QuickMonitorUnmatchedImport,iFKModel,QuickMonitorUnmatchedImport,bImported,QuickMonitorUnmatchedImport,sJournalist_import,QuickMonitorUnmatchedImport,sMedium_import,QuickMonitorUnmatchedImport,sBrand_import,QuickMonitorUnmatchedImport,sRange_import,QuickMonitorUnmatchedImport,iImportID,QuickMonitorUnmatchedImport,iJournalistImportID,QuickMonitorUnmatchedImport,iBrandImportID,QuickMonitorUnmatchedImport,iRangeImportID,QuickMonitorUnmatchedImport,sFKMediaType,vAVE,iPKAVE,vAVE,iFKMedium,vAVE,AVEType,vBrand,iPKBrand,vBrand,Brand,vCategory,iPKCategory,vCategory,Category,vMembers,id,vMembers,text,vMembers,Email,vModel,iPKModel,vModel,iFKRange,vModel,Model,vOnline,iPKMedium,vOnline,Online,vOnline,iFKMediaOwner,vPrint,iPKMedium,vPrint,Print,vPrint,iFKMediaOwner,vRadio,iPKMedium,vRadio,Radio,vRadio,iFKMediaOwner,vRange,iPKRange,vRange,iFKBrand,vRange,Range,QuickFleetBookingData,BrandId,QuickFleetBookingData,RangeId,QuickFleetBookingData,ModelId,QuickFleetBookingData,Registration,QuickFleetBookingData,VIN,QuickFleetBookingData,Colour,QuickFleetBookingData,FleetCategoryId,QuickFleetBookingData,RequestDate,QuickFleetBookingData,FirstName,QuickFleetBookingData,Surname,QuickFleetBookingData,Email,QuickFleetBookingData,Cell,QuickFleetBookingData,Telephone,QuickFleetBookingData,Company,QuickFleetBookingData,MediaId,QuickFleetBookingData,StartDate,QuickFleetBookingData,EndDate,QuickFleetBookingData,RegionId,QuickFleetBookingData,Reason,QuickFleetBookingData,BookedUserId,QuickFleetBookingData,BrandName,QuickFleetBookingData,RangeName,QuickFleetBookingData,ModelName,QuickFleetBookingData,RegionName,QuickFleetBookingData,MediaName,QuickFleetBookingData,FleetCategory,QuickFleetBookingData,VehicleBookingId,QuickFleetBookingData,BookingRequestId,vSocial,iPKMedium,vSocial,Social,QuickFleetData,VehicleId,QuickFleetData,BrandId,QuickFleetData,RangeId,QuickFleetData,ModelId,QuickFleetData,Registration,QuickFleetData,VIN,QuickFleetData,Colour,QuickFleetData,FleetCategoryId,QuickFleetData,HistoryDate,QuickFleetData,Mileage,QuickFleetData,Notes,QuickFleetData,PetrolLitres,QuickFleetData,PetrolCost,QuickFleetData,CleanCost,QuickFleetData,OtherCost,QuickFleetData,OtherCostNote,QuickFleetData,RequestDate,QuickFleetData,FirstName,QuickFleetData,Surname,QuickFleetData,Email,QuickFleetData,Cell,QuickFleetData,Telephone,QuickFleetData,Company,QuickFleetData,MediaId,QuickFleetData,StartDate,QuickFleetData,EndDate,QuickFleetData,RegionId,QuickFleetData,Reason,QuickFleetData,BookedUserId,QuickFleetData,BrandName,QuickFleetData,RangeName,QuickFleetData,ModelName,QuickFleetData,RegionName,QuickFleetData,MediaName,QuickFleetData,FleetCategory,QuickFleetData,VehicleBookingId,QuickFleetData,BookingRequestId,vSocialItems,iPKMedium,vSocialItems,iPKSocial,vSocialItems,Social,vSocialItems,SocialItems,QuickFleetHistoryData,RangeName,QuickFleetHistoryData,BrandName,QuickFleetHistoryData,ModelName,QuickFleetHistoryData,RegionId,QuickFleetHistoryData,BrandId,QuickFleetHistoryData,RangeId,QuickFleetHistoryData,ModelId,QuickFleetHistoryData,Registration,QuickFleetHistoryData,Colour,QuickFleetHistoryData,VIN,QuickFleetHistoryData,FleetCategoryId,QuickFleetHistoryData,OtherCostNote,QuickFleetHistoryData,OtherCost,QuickFleetHistoryData,CleanCost,QuickFleetHistoryData,PetrolCost,QuickFleetHistoryData,PetrolLitres,QuickFleetHistoryData,Notes,QuickFleetHistoryData,Mileage,QuickFleetHistoryData,HistoryDate,QuickFleetHistoryData,VehicleId,QuickFleetHistoryData,VehicleBookingId,vTV,iPKMedium,vTV,TV,vTV,iFKMediaOwner,uShareAuthorizations,Id,uShareAuthorizations,ServiceProviderId,uShareAuthorizations,UmbracoUserId,uShareAuthorizations,AccessTokenValue1,uShareAuthorizations,AccessTokenValue2,uShareServiceProviders,Id,uShareServiceProviders,Name,VehicleImport,id,VehicleImport,brand,VehicleImport,range,VehicleImport,model,VehicleImport,thumbnail1,VehicleImport,largeImage1,VehicleImport,thumbnail2,VehicleImport,largeImage2,VehicleImport,thumbnail3,VehicleImport,largeImage3,VehicleImport,rangemodel,VehicleImport,brandrangemodel,VehicleImport,status,VehicleImport,limitededition,VehicleImport,duoportarecordID,VehicleImport,picID1,VehicleImport,picID2,VehicleImport,picID3,VehicleImport,introdate,VehicleImport,rangeintrodateSouthAfrica,VehicleImport,enddate,VehicleImport,priceexclemissionstax,VehicleImport,emissionstaxincludedinprice,VehicleImport,price,VehicleImport,pricedate,VehicleImport,paymentestimate10deposit5years11,VehicleImport,segment,VehicleImport,doors,VehicleImport,bodyshape,VehicleImport,enginepositionlocation,VehicleImport,enginecapacitycc,VehicleImport,enginesizelitre,VehicleImport,enginedetailshort,VehicleImport,enginedetail,VehicleImport,cylinderlayout,VehicleImport,cylinders,VehicleImport,cylinderlayoutquantity,VehicleImport,valvespercylinder,VehicleImport,fueltype,VehicleImport,supercharger,VehicleImport,turbocharger,VehicleImport,hybrid,VehicleImport,engineautoStopStartidlestopecostop,VehicleImport,powermaximum,VehicleImport,powermaximumtotal,VehicleImport,powerpeakrevs,VehicleImport,torquemaximum,VehicleImport,torquepeakrevs,VehicleImport,torquemaximumtotal,VehicleImport,torquemaximumdetail,VehicleImport,torqueoverboost,VehicleImport,torqueoverboostpeakrevs,VehicleImport,fuelconsumptionurban,VehicleImport,fuelconsumptionextraurban,VehicleImport,fuelconsumptionaverage,VehicleImport,CO2emissionsaverage,VehicleImport,fuelrangeaverage,VehicleImport,acceleration0100kmh,VehicleImport,maximumtopspeed,VehicleImport,drivenwheels,VehicleImport,drivenwheelsquantity,VehicleImport,gearratiosquantity,VehicleImport,lowrange,VehicleImport,gearshift,VehicleImport,transmissiontype,VehicleImport,transmissionname,VehicleImport,gearshiftpaddles,VehicleImport,antilockbrakingsystemABS,VehicleImport,electronicbrakedistributionEBD,VehicleImport,brakeassistBASEBA,VehicleImport,electromechanicalparkingbrake,VehicleImport,hillstartassisthillholder,VehicleImport,limitedslipdiff,VehicleImport,difflockfront,VehicleImport,difflockcentre,VehicleImport,difflockrear,VehicleImport,tractioncontrol,VehicleImport,stabilitycontrol,VehicleImport,hilldescentcontroldownhillbrakecontrol,VehicleImport,alloywheelsrims,VehicleImport,fronttyres,VehicleImport,reartyres,VehicleImport,tyrepressuresensormonitordeflationdetectionsystem,VehicleImport,driverairbag,VehicleImport,frontpassengerairbag,VehicleImport,driverkneeairbag,VehicleImport,passengerkneeairbag,VehicleImport,frontsideairbags,VehicleImport,rearsideairbags,VehicleImport,curtainairbags,VehicleImport,airbagquantity,VehicleImport,safetyratingoverallEuroNCAP,VehicleImport,airconditioning,VehicleImport,climatecontrolautomaticairconditioning,VehicleImport,powersteering,VehicleImport,multifunctionsteeringwheelcontrols,VehicleImport,lanedeparturewarning,VehicleImport,lanechangeblindspotwarningassistmonitor,VehicleImport,attentionassistrestassistbreakalert,VehicleImport,headupdisplay,VehicleImport,nightvision,VehicleImport,onboardcomputermultiinformationdisplay,VehicleImport,navigation,VehicleImport,cruisecontrol,VehicleImport,activeadaptivecruisecontrol,VehicleImport,Bluetoothconnectivity,VehicleImport,voicecontrol,VehicleImport,CDplayer,VehicleImport,TVtelevision,VehicleImport,auxinauxiliaryinput,VehicleImport,USBport,VehicleImport,remotecentrallocking,VehicleImport,keylessaccessstarthandsfreekey,VehicleImport,electricwindows,VehicleImport,rainsensorautowipers,VehicleImport,autodiminteriormirror,VehicleImport,electricadjustmirrors,VehicleImport,autodimexteriormirrors,VehicleImport,electricfoldretractablemirrors,VehicleImport,sunroof,VehicleImport,panoramicroof,VehicleImport,foldingroof,VehicleImport,vinylupholstery,VehicleImport,clothupholstery,VehicleImport,Alcantaraupholstery,VehicleImport,leatherupholstery,VehicleImport,seatsquantity,VehicleImport,lumbarsupportadjustment,VehicleImport,electricseatadjustmentdriver,VehicleImport,electricseatadjustmentfrontpassenger,VehicleImport,rearseatelectricadjustment,VehicleImport,splitrearseat,VehicleImport,foldingrearseat,VehicleImport,heatedseatsfront,VehicleImport,ventilatedseatsfront,VehicleImport,massagingseatsfront,VehicleImport,heatedseatsrear,VehicleImport,ventilatedseatsrear,VehicleImport,massagingseatsrear,VehicleImport,ISOFIXchildseatmountings,VehicleImport,daytimedrivingrunninglights,VehicleImport,lightsensorautoonofflights,VehicleImport,xenonheadlights,VehicleImport,LEDheadlights,VehicleImport,adaptiveheadlightsvaryinglightdistribution,VehicleImport,highbeamassist,VehicleImport,frontfoglampslights,VehicleImport,highlevel3rdbrakelight,VehicleImport,emergencybrakehazardlights,VehicleImport,LEDtaillights,VehicleImport,parkdistancecontrolPDCfront,VehicleImport,parkdistancecontrolPDCrear,VehicleImport,cameraforparkdistancecontrol,VehicleImport,parkassistselfparking,VehicleImport,rearspoiler,VehicleImport,towbartrailerhitch,VehicleImport,length,VehicleImport,widthexclmirrorsinclmirrors,VehicleImport,height,VehicleImport,wheelbase,VehicleImport,groundclearanceminimummaximum,VehicleImport,turningcirclewheelsbody,VehicleImport,approachangle,VehicleImport,gradientinclineangle,VehicleImport,breakoverrampangle,VehicleImport,rollovertiltanglelateralinclinationslope,VehicleImport,departureangle,VehicleImport,wadingfordingwatercrossingdepth,VehicleImport,loadvolumecapacity,VehicleImport,unladentarekerbweightmin,VehicleImport,loadcarryingcapacitypayload,VehicleImport,grossweightGVM,VehicleImport,towingcapacityunbraked,VehicleImport,towingcapacitybraked,VehicleImport,grosscombinationmasscombinedweightGCM,VehicleImport,fueltankcapacityinclreserve,VehicleImport,warrantytimeyears,VehicleImport,warrantydistance,VehicleImport,servicemaintenanceplan,VehicleImport,serviceplantimeyears,VehicleImport,serviceplandistance,VehicleImport,maintenanceplantimeyears,VehicleImport,maintenanceplandistance,VehicleImport,serviceintervaldistance,VehicleImport,serviceintervaltime,WG2KFormSubmisions,Pk_Id,WG2KFormSubmisions,DateCreated,WG2KFormSubmisions,FormId,WG2KFormSubmisions,FormData,WG2KFormSubmisions,IsClosed,WG2KFormSubmisions,FormComment,WG2KFormSubmisions,FormSubGuid,WG2KFormSubmisions,RemoteUser,WG2KFormSubmisions,ConnectID,WG2KFormSubmisions,IPAddress,WG2KFormSubmisions,SessionID,qfVehicleBooking,VehicleBookingId,qfVehicleBooking,BookingRequestId,qfVehicleBooking,BookedUserId,qfVehicleBooking,VehicleId,qfVehicleBooking,StartDate,qfVehicleBooking,EndDate,qfVehicleBooking,Notes,qfVehicleBooking,IsApproved,qfVehicleBooking,QuickPicId,qfBookingRequest,BookingRequestId,qfBookingRequest,UserId,qfBookingRequest,ModelId,qfBookingRequest,RequestDate,qfBookingRequest,StartDate,qfBookingRequest,EndDate,qfBookingRequest,BookingRequestStatusId,qfBookingRequest,Reason,qfBookingRequest,FirstName,qfBookingRequest,Surname,qfBookingRequest,Email,qfBookingRequest,Telephone,qfBookingRequest,Cell,qfBookingRequest,Company,qfBookingRequest,MediaId,qfBookingRequest,RegionId,qfBookingRequest,QuickPicId,CMSImportCustomRelation,CustomRelationId,CMSImportCustomRelation,UmbracoId,CMSImportCustomRelation,Alias,CMSImportCustomRelation,DataSourceKey,CMSImportCustomRelation,RelatedId,CMSImportMediaRelation,Id,CMSImportMediaRelation,UmbracoMediaId,CMSImportMediaRelation,SourceUrl,CMSImportRelation,Id,CMSImportRelation,UmbracoID,CMSImportRelation,UmbracoParentId,CMSImportRelation,DataSourceKey,CMSImportScheduledItems,ScheduledItemId,CMSImportScheduledItems,ScheduleldTaskId,CMSImportScheduledItems,ScheduledOn,CMSImportScheduledItems,ExecutedOn,CMSImportScheduledItems,InProgress,CMSImportScheduledTask,ScheduleId,CMSImportScheduledTask,ScheduleGUID,CMSImportScheduledTask,ImportStateGUID,CMSImportScheduledTask,ScheduledTaskName,CMSImportScheduledTask,NotifyEmailAddress,CMSImportScheduledTask,ExecuteEvery,CMSImportScheduledTask,ExecuteDays,CMSImportScheduledTask,ExecuteHour,CMSImportScheduledTask,ExecuteMinute,CMSImportScheduledTask,ImportAsUser,CMSImportState,Id,CMSImportState,UniqueIdentifier,CMSImportState,Name,CMSImportState,ImportType,CMSImportState,ImportState,CMSImportState,Recursive,CMSImportState,Parent,NodeAccess,pk,NodeAccess,nodeId,NodeAccess,memberGroupId,vMediaOwner,iPKMediaOwners,vMediaOwner,MediaOwner,vMediaOwner,level,vMediaOwner,path,vMediaOwner,sortOrder,vNodeRelatedMedia,TypeId,vNodeRelatedMedia,NodeId,vNodeRelatedMedia,trashed,vNodeRelatedMedia,parentID,vNodeRelatedMedia,path,vNodeRelatedMedia,sortOrder,vNodeRelatedMedia,uniqueID,vNodeRelatedMedia,NodeText,vNodeRelatedMedia,createDate,vNodeRelatedMedia,TypeText,vNodeRelatedMedia,relatedMediaId,vNodeRelatedMedia,updateDate,vNodeRelatedMedia,propertytypeid,vNodeRelatedMedia,hasRelatedMediaID,vSiteMedia,TypeId,vSiteMedia,NodeId,vSiteMedia,parentID,vSiteMedia,path,vSiteMedia,sortOrder,vSiteMedia,uniqueID,vSiteMedia,NodeText,vSiteMedia,createDate,vSiteMedia,TypeText,vSiteMedia,umbracoExtension,lNodeRelatedMedia,pk,lNodeRelatedMedia,NodeId,lNodeRelatedMedia,parentID,lNodeRelatedMedia,path,lNodeRelatedMedia,sortOrder,lNodeRelatedMedia,nodeName,lNodeRelatedMedia,createDate,lNodeRelatedMedia,nodeAlias,lNodeRelatedMedia,relatedMediaId,lNodeRelatedMedia,updateDate,lNodeRelatedMedia,hasRelatedMediaID,lNodeRelatedMedia,HideFromNews,lSiteMedia,pk,lSiteMedia,NodeTypeId,lSiteMedia,NodeId,lSiteMedia,parentID,lSiteMedia,path,lSiteMedia,sortOrder,lSiteMedia,nodeName,lSiteMedia,createDate,lSiteMedia,TypeText,lSiteMedia,umbracoExtension,ELMAH_Error,ErrorId,ELMAH_Error,Application,ELMAH_Error,Host,ELMAH_Error,Type,ELMAH_Error,Source,ELMAH_Error,Message,ELMAH_Error,User,ELMAH_Error,StatusCode,ELMAH_Error,TimeUtc,ELMAH_Error,Sequence,ELMAH_Error,AllXml,qfReport,ReportId,qfReport,BrandId,qfReport,Guid,qfReport,ReportDate,qfReport,ReportTypeId,qfVehicleHistory,VehicleHistoryId,qfVehicleHistory,VehicleBookingId,qfVehicleHistory,VehicleId,qfVehicleHistory,UserId,qfVehicleHistory,HistoryDate,qfVehicleHistory,Mileage,qfVehicleHistory,Notes,qfVehicleHistory,PetrolLitres,qfVehicleHistory,PetrolCost,qfVehicleHistory,CleanCost,qfVehicleHistory,OtherCost,qfVehicleHistory,OtherCostNote,qfVehicleHistory,QuickPicId,qfVehicles,VehicleId,qfVehicles,TransmissionId,qfVehicles,UserId,qfVehicles,RegionId,qfVehicles,BrandId,qfVehicles,RangeId,qfVehicles,ModelId,qfVehicles,DefaultDays,qfVehicles,Registration,qfVehicles,VIN,qfVehicles,Colour,qfVehicles,SpecFile,qfVehicles,FleetCategoryId,qfVehicles,IsPreProd,qfVehicles,IsDeleted,qfVehicles,IsActive,qfVehicles,QuickPicId,qmMailJob,MailJobId,qmMailJob,CampaignId,qmMailJob,TemplateId,qmMailJob,DateAdded,qmMailJob,Status,qmMailQueue,MailQueueId,qmMailQueue,MailJobId,qmMailQueue,MemberId,qmMailQueue,Status,qmMailQueueAudit,MailQueueAuditId,qmMailQueueAudit,DateAdded,qmMailQueueAudit,CampaignId,qmMailQueueAudit,TemplateId,qmMailQueueAudit,MemberId,qmMailQueueAudit,Email,qmMailQueueAudit,Content,qmMailQueueAudit,Status,qmMailQueueAudit,Message,qmMailQueueAudit,IsDelivered,qmMailQueueAudit,IsBounce,qmMailQueueAudit,MessageId,qmtranbackup2,iPKTransaction,qmtranbackup2,iFKMediaType,qmtranbackup2,sMediaType,qmtranbackup2,iFKMedium,qmtranbackup2,iFKJournalist,qmtranbackup2,sArticleTitle,qmtranbackup2,dArticleDate,qmtranbackup2,dCaptureDate,qmtranbackup2,iPositive,qmtranbackup2,iNuetral,qmtranbackup2,iNegative,qmtranbackup2,sPositiveComment,qmtranbackup2,sNuetralComment,qmtranbackup2,sNegativeComment,qmtranbackup2,iPageNo,qmtranbackup2,dDuration,qmtranbackup2,iFKMediumAVE,qmtranbackup2,cMediumAVE,qmtranbackup2,cArticleAVE,qmtranbackup2,iCoverage,qmtranbackup2,sArticleURL,qmtranbackup2,sArticleMediaFilePath,qmtranbackup2,guidArticleMediaGUI,qmtranbackup2,iFKProduct,qmtranbackup2,iFKBrand,qmtranbackup2,iFKRange,qmtranbackup2,iFKModel,qmtranbackup2,iCreditibility,qmtranbackup2,iFKCategory,qmtranbackup2,bImported,qmtranbackup2,sJournalist_import,qmtranbackup2,sMedium_import,qmtranbackup2,sBrand_import,qmtranbackup2,sRange_import,qmtranbackup2,iImportID,qmtranbackup2,iJournalistImportID,qmtranbackup2,iBrandImportID,qmtranbackup2,iRangeImportID,qmtranbackup2,iFKCapturedBy,qmtranbackup2,sCapturedContextUrl,FleetVehicleImport,VehicleID,FleetVehicleImport,ManufacturerID,FleetVehicleImport,Manufacturer,FleetVehicleImport,NewManID,FleetVehicleImport,RangeID,FleetVehicleImport,RangeName,FleetVehicleImport,NewRangeId,FleetVehicleImport,ModelID,FleetVehicleImport,ModelName,FleetVehicleImport,NewModelId,FleetVehicleImport,Registration,FleetVehicleImport,IsActive,FleetVehicleImport,TransmissionID,FleetVehicleImport,UserID,FleetVehicleImport,DefaultDays,FleetVehicleImport,VIN,FleetVehicleImport,Colour,FleetVehicleImport,SpecFile,FleetVehicleImport,RegionID,FleetVehicleImport,Region,FleetVehicleImport,NewRegionId,FleetVehicleImport,FleetCategoryID,FleetVehicleImport,FleetCategory,FleetVehicleImport,NewFleetId,FleetVehicleImport,IsPreProd,FleetVehicleImport,DeletedInd,qmTransactions,iPKTransaction,qmTransactions,iFKMediaType,qmTransactions,sMediaType,qmTransactions,iFKMedium,qmTransactions,iFKJournalist,qmTransactions,sArticleTitle,qmTransactions,dArticleDate,qmTransactions,dCaptureDate,qmTransactions,iPositive,qmTransactions,iNuetral,qmTransactions,iNegative,qmTransactions,sPositiveComment,qmTransactions,sNuetralComment,qmTransactions,sNegativeComment,qmTransactions,iPageNo,qmTransactions,dDuration,qmTransactions,iFKMediumAVE,qmTransactions,cMediumAVE,qmTransactions,cArticleAVE,qmTransactions,iCoverage,qmTransactions,sArticleURL,qmTransactions,sArticleMediaFilePath,qmTransactions,guidArticleMediaGUI,qmTransactions,iFKProduct,qmTransactions,iFKBrand,qmTransactions,iFKRange,qmTransactions,iFKModel,qmTransactions,iCreditibility,qmTransactions,iFKCategory,qmTransactions,bImported,qmTransactions,sJournalist_import,qmTransactions,sMedium_import,qmTransactions,sBrand_import,qmTransactions,sRange_import,qmTransactions,iImportID,qmTransactions,iJournalistImportID,qmTransactions,iBrandImportID,qmTransactions,iRangeImportID,qmTransactions,iFKCapturedBy,qmTransactions,sCapturedContextUrl,qmTransactions,iFKMultiplier,qmTransactions,fMultVal1,qmTransactions,fMultVal2,qmtransactionsbackup,iPKTransaction,qmtransactionsbackup,iFKMediaType,qmtransactionsbackup,sMediaType,qmtransactionsbackup,iFKMedium,qmtransactionsbackup,iFKJournalist,qmtransactionsbackup,sArticleTitle,qmtransactionsbackup,dArticleDate,qmtransactionsbackup,dCaptureDate,qmtransactionsbackup,iPositive,qmtransactionsbackup,iNuetral,qmtransactionsbackup,iNegative,qmtransactionsbackup,sPositiveComment,qmtransactionsbackup,sNuetralComment,qmtransactionsbackup,sNegativeComment,qmtransactionsbackup,iPageNo,qmtransactionsbackup,dDuration,qmtransactionsbackup,iFKMediumAVE,qmtransactionsbackup,cMediumAVE,qmtransactionsbackup,cArticleAVE,qmtransactionsbackup,iCoverage,qmtransactionsbackup,sArticleURL,qmtransactionsbackup,sArticleMediaFilePath,qmtransactionsbackup,guidArticleMediaGUI,qmtransactionsbackup,iFKProduct,qmtransactionsbackup,iFKBrand,qmtransactionsbackup,iFKRange,qmtransactionsbackup,iFKModel,qmtransactionsbackup,iCreditibility,qmtransactionsbackup,iFKCategory,qmtransactionsbackup,bImported,qmtransactionsbackup,sJournalist_import,qmtransactionsbackup,sMedium_import,qmtransactionsbackup,sBrand_import,qmtransactionsbackup,sRange_import,qmtransactionsbackup,iImportID,qmtransactionsbackup,iJournalistImportID,qmtransactionsbackup,iBrandImportID,qmtransactionsbackup,iRangeImportID,qmtransactionsbackup,iFKCapturedBy,qmtransactionsbackup,sCapturedContextUrl,qpViewLog,ViewLogId,qpViewLog,DateViewed,qpViewLog,MemberId,qpViewLog,ContentId,qpViewLog,ViewTypeId,qpViewLog,IPAddress,qpViewLog,Description,QuickMonitorData,iPKTransaction,QuickMonitorData,sMediaType,QuickMonitorData,Medium,QuickMonitorData,MediumParent,QuickMonitorData,iPKMediumParent,QuickMonitorData,Journalist,QuickMonitorData,AVEType,QuickMonitorData,Product,QuickMonitorData,Brand,QuickMonitorData,Range,QuickMonitorData,Model,QuickMonitorData,sArticleTitle,QuickMonitorData,dArticleDate,QuickMonitorData,dCaptureDate,QuickMonitorData,iPositive,QuickMonitorData,iNuetral,QuickMonitorData,iNegative,QuickMonitorData,sPositiveComment,QuickMonitorData,sNuetralComment,QuickMonitorData,sNegativeComment,QuickMonitorData,iPageNo,QuickMonitorData,dDuration,QuickMonitorData,cMediumAVE,QuickMonitorData,cArticleAVE,QuickMonitorData,iCoverage,QuickMonitorData,sArticleURL,QuickMonitorData,sArticleMediaFilePath,QuickMonitorData,guidArticleMediaGUI,QuickMonitorData,iCreditibility,QuickMonitorData,iFKCategory,QuickMonitorData,iFKMediumAVE,QuickMonitorData,iFKMediaType,QuickMonitorData,iFKMedium,QuickMonitorData,iFKJournalist,QuickMonitorData,iFKProduct,QuickMonitorData,iFKBrand,QuickMonitorData,iFKRange,QuickMonitorData,iFKModel,QuickMonitorData,bImported,QuickMonitorData,iFKCapturedBy,QuickMonitorData,sCapturedContextUrl,QuickMonitorData,CapturedBy,QuickMonitorData,Category,QuickMonitorData,iFKMultiplier,QuickMonitorData,Multiplier,QuickMonitorData,fMultVal1,QuickMonitorData,fMultVal2,BrandReportData,iPKTransaction,BrandReportData,Brand,BrandReportData,iFKMedium,BrandReportData,iFKBrand,BrandReportData,sPositiveComment,BrandReportData,sNuetralComment,BrandReportData,sNegativeComment,BrandReportData,iNegative,BrandReportData,iNuetral,BrandReportData,iPositive,BrandReportData,dCaptureDate,BrandReportData,iPageNo,BrandReportData,iCoverage,BrandReportData,cArticleAVE,BrandReportData,sArticleMediaFilePath,BrandReportData,Medium,BrandReportData,sMediaType,BrandReportData,iFKMediaType,BrandReportData,sArticleTitle,BrandReportData,Category,BrandReportData,iFKCategory,BrandReportData,sArticleURL,BrandReportData,Journalist,BrandReportData,MediumParent
     
    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
    FK_uShareAuthorizations_umbracoUser,FK_uShareAuthorizations_uShareServiceProviders,PK_CMSImportCustomRelation,PK_CMSImportMediaRelation,PK_CMSImportRelation,PK_CMSImportScheduledItems,PK_CMSImportScheduledTask,PK_CMSImportState,PK_cmsPreviewXml,PK_ELMAH_Error,PK_lSiteMedia,PK_lSiteMedia_1,PK_NodeAccess,PK_qfBookingRequest,PK_qfReport,PK_qfVehicleBooking,PK_qfVehicleHistory,PK_qfVehicles,PK_qmMailJob,PK_qmMailQueue,PK_qmMailQueueAudit,PK_qmTransactions,PK_qpViewLog,PK_uShareAuthorizations,PK_uShareServiceProviders,PK_cmsContentPreviewXml,IX_umbracoNodeTrashed,IX_umbracoNodeParentId,IX_umbracoNodeObjectType,IX_cmsTemplate_nodeId,IX_cmsContent,IX_cmsContentVersion_ContentId,IX_cmsContentVersion_VersionId,IX_cmsDocument,IX_cmsDocument_published,IX_cmsDocument_newest,IX_cmsContentType,IX_cmsContentType_icon,IX_cmsDataType_nodeId,IX_cmsDictionary_id,IX_umbracoLanguage_languageISOCode,IX_umbracoLog,IX_cmsPropertyData,IX_cmsPropertyData_1,IX_cmsPropertyData_2,IX_cmsPropertyData_3,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_ELMAH_Error_App_Time_Seq
     

    2014-05-26 03:40:19,755 [15] INFO  Umbraco.Core.UmbracoApplicationBase - [Thread 28] Application shutdown. Reason: HostingEnvironment

    Does anyone have any ideas why this would happen - is there a way I can manually update to 6.20 without using the installer - perhaps running the calls through SQL Server Management Studio instead of using the installer would prevent the fail ?

  • Torben Rahbek Koch 4 posts 25 karma points
    Apr 09, 2015 @ 16:00
    Torben Rahbek Koch
    0

    Did you ever figure this out?

  • Bradley Kronson 63 posts 114 karma points
    Apr 09, 2015 @ 16:09
    Bradley Kronson
    0

    I changed the object type GUID of the members/media in the database prior to the database to something else, ran the update and then restored the GUID to what is was originally (I have a very large number of these in the database)

  • Torben Rahbek Koch 4 posts 25 karma points
    Apr 10, 2015 @ 10:53
    Torben Rahbek Koch
    0

    Interesting approach ;)

    I upgraded from 6.2.5 to 7.2.4 and used this before the upgrade:

    update umbracoNode set nodeObjectType = 'B796F64C-1F99-4FFB-B886-4BF4BC011A9D' where nodeObjectType = 'B796F64C-1F99-4FFB-B886-4BF4BC011A9C'

    and this after the upgrade:

    update umbracoNode set nodeObjectType = 'B796F64C-1F99-4FFB-B886-4BF4BC011A9C' where nodeObjectType = 'B796F64C-1F99-4FFB-B886-4BF4BC011A9D'

    This makes the installation fly right through.

  • Bradley Kronson 63 posts 114 karma points
    Apr 10, 2015 @ 11:38
    Bradley Kronson
    0

    Yup that's it ;)

  • Bradley Kronson 63 posts 114 karma points
    Apr 10, 2015 @ 12:11
    Bradley Kronson
    0

    PS discussion on http://issues.umbraco.org with Shannon about this issue

    http://issues.umbraco.org/issue/U4-5055

     

  • 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