Sorry but those do not help as my collation is already properly set. I was able to get that error message to go away by executing the following:
update CMS_Query
set QueryText = 'UPDATE CMS_Transformation
SET
[TransformationName] = @TransformationName,
[TransformationCode] = @TransformationCode,
[TransformationType] = @TransformationType,
[TransformationClassID] = @TransformationClassID,
[TransformationVersionGUID] = @TransformationVersionGUID,
[TransformationGUID] = @TransformationGUID,
[TransformationLastModified] = @TransformationLastModified,
[TransformationIsHierarchical] = @TransformationIsHierarchical,
[TransformationHierarchicalXML] = @TransformationHierarchicalXML,
[TransformationCSS] = @TransformationCSS
WHERE [TransformationID] = @TransformationID'
where ClassID = 162 and QueryName = 'update'
However, now when I attempt to create a new site, it fails with the following:
ERROR: Error during import process
Message: [DataConnection.HandleError]: Query: INSERT INTO CMS_PageTemplate ([PageTemplateDisplayName], [PageTemplateCodeName], [PageTemplateDescription], [PageTemplateIsPortal], [PageTemplateCategoryID], [PageTemplateLayoutID], [PageTemplateWebParts], [PageTemplateIsReusable], [PageTemplateShowAsMasterTemplate], [PageTemplateInheritPageLevels], [PageTemplateLayout], [PageTemplateLayoutCheckedOutFileName], [PageTemplateLayoutCheckedOutByUserID], [PageTemplateLayoutCheckedOutMachineName], [PageTemplateVersionGUID], [PageTemplateHeader], [PageTemplateGUID], [PageTemplateLastModified], [PageTemplateSiteID], [PageTemplateForAllPages], [PageTemplateType], [PageTemplateLayoutType], [PageTemplateCSS], [PageTemplateFile] ) VALUES ( @PageTemplateDisplayName, @PageTemplateCodeName, @PageTemplateDescription, @PageTemplateIsPortal, @PageTemplateCategoryID, @PageTemplateLayoutID, @PageTemplateWebParts, @PageTemplateIsReusable, @PageTemplateShowAsMasterTemplate, @PageTemplateInheritPageLevels, @PageTemplateLayout, @PageTemplateLayoutCheckedOutFileName, @PageTemplateLayoutCheckedOutByUserID, @PageTemplateLayoutCheckedOutMachineName, @PageTemplateVersionGUID, @PageTemplateHeader, @PageTemplateGUID, @PageTemplateLastModified, @PageTemplateSiteID, @PageTemplateForAllPages, @PageTemplateType, @PageTemplateLayoutType, @PageTemplateCSS, @PageTemplateFile); SELECT SCOPE_IDENTITY() AS [PageTemplateID]: caused exception: Must declare the scalar variable "@PageTemplateLayoutCheckedOutFileName". Stack Trace: at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Dictionary`2 importedParentIDs)
at CMS.CMSImportExport.ImportProvider.ImportObjectType(SiteImportSettings settings, String objectType, Boolean siteObject, TranslationHelper th, ProcessObjectEnum process, Dictionary`2 importedParentIDs)
at CMS.CMSImportExport.ImportProvider.ImportObjectsData(SiteImportSettings settings) Must declare the scalar variable "@PageTemplateLayoutCheckedOutFileName". 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.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at CMS.DataProviderSQL.DataConnection.ExecuteScalar(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
Again, my version 6 installation works fine. But whenever I upgrade to 7, these are the errors that come up. It appears something is not right somewhere.