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
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 ?
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)
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.
Las few lines in the log file are below:
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 ?
Did you ever figure this out?
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)
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.
Yup that's it ;)
PS discussion on http://issues.umbraco.org with Shannon about this issue
http://issues.umbraco.org/issue/U4-5055
is working on a reply...