Upgrading Kentico from version 7 to 8

santhoshkumar budhihal asked on July 18, 2016 12:29

Hi Folks,

Hope all fine,

I have a query on upgrading kentico from version 7 to version 8, I have been following some of the online documentation available but this is most cumbersome process by any yardstick, given the risk it involves, be it loosing configurations, etc.

However, my question is , let's say if I have installed kentico in the C Drive of my computer and have the Kentico version 7 project in D drive

1) should the upgrade-7_0_8_0.exe file be first installed in C:\Program Files (x86)\Kentico\8.0 ? it is happening so by default , is that fine ?

2) Now that if I double click on updgrade.exe present in the above mentioned folder, it asks me for the target folder , does this mean the 7th version kentico project that I have in D drive ?

3) I am getting so many errors after having followed the procedures, can you please answer the questions i have asked above and help me with the remaining procedures ?

Thank you

kentico 8 upgrade 8.0

Recent Answers

Brenden Kehren answered on July 18, 2016 14:33

You can have the program of Kentico installed on any drive you'd like, it really doesn't matter. Performing your upgrade can either be done using the Kentico Installation Manager (KIM) or the upgrade.exe (as you have mentioned). Both will direct you to look for your physical installation of Kentico on a hard drive (doesn't matter what local hard drive). From there it will review your web.config file and start performing your upgrade.

Regarding your errors, since you have not specified what errors you have received, we cannot help you with those. What would be helpful is to state if you have any custom code, what development model you chose, and if you've customized the web.config at all.

0 votesVote for this answer Mark as a Correct answer

santhoshkumar budhihal answered on July 18, 2016 15:01 (last edited on July 18, 2016 16:19)

[2016-07-18 18:12:38] Failed to run SQLscript: Invalid column name 'ElementType'. Invalid column name 'ElementProperties'. Invalid column name 'ElementIconClass'. Invalid column name 'ElementAccessCondition'. Invalid column name 'ElementVisibilityCondition'.Message: Invalid column name 'ElementType'. Invalid column name 'ElementProperties'. Invalid column name 'ElementIconClass'. Invalid column name 'ElementAccessCondition'. Invalid column name 'ElementVisibilityCondition'. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Hotfix.HotfixHelper.RunSQLScript(String fileName, String connString, String defaultUICulture, IMessageLog messageLog)

[2016-07-18 18:12:39] DECLARE @elementParentID int; SET @elementParentID = (SELECT TOP 1 [ElementID] FROM [CMS_UIElement] WHERE [ElementGUID] = '43ea4f2b-554e-40f3-a602-90ef5e1e1d4f') IF @elementParentID <>0 BEGIN

DECLARE @elementPageTemplateID int; SET @elementPageTemplateID = (SELECT TOP 1 [PageTemplateID] FROM [CMS_PageTemplate] WHERE [PageTemplateGUID] = 'df52ca8a-ad10-4b67-8dfb-a1311d571615') IF @elementPageTemplateID <>0 BEGIN

DECLARE @elementResourceID int; SET @elementResourceID = (SELECT TOP 1 [ResourceID] FROM [CMS_Resource] WHERE [ResourceGUID] = 'c408448c-9373-42b0-950d-812d5c95f57b') IF @elementResourceID <>0 BEGIN

UPDATE [CMS_UIElement] SET [ElementCaption] = NULL, [ElementTargetURL] = NULL, [ElementDescription] = NULL, [ElementType] = 'PageTemplate', [ElementProperties] = '', [ElementIconClass] = '', [ElementAccessCondition] = NULL, [ElementVisibilityCondition] = NULL WHERE [ElementGUID] = 'bff609cc-757d-4216-9162-330d9b1802eb'

END

[2016-07-18 18:12:40] Failed to run SQLscript: Invalid column name 'ElementType'. Invalid column name 'ElementProperties'. Invalid column name 'ElementIconClass'. Invalid column name 'ElementCheckModuleReadPermission'. Invalid column name 'ElementAccessCondition'. Invalid column name 'ElementVisibilityCondition'.Message: Invalid column name 'ElementType'. Invalid column name 'ElementProperties'. Invalid column name 'ElementIconClass'. Invalid column name 'ElementCheckModuleReadPermission'. Invalid column name 'ElementAccessCondition'. Invalid column name 'ElementVisibilityCondition'. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Hotfix.HotfixHelper.RunSQLScript(String fileName, String connString, String defaultUICulture, IMessageLog messageLog)

[2016-07-18 18:12:42] DECLARE @elementParentID int; SET @elementParentID = (SELECT TOP 1 [ElementID] FROM [CMS_UIElement] WHERE [ElementGUID] = 'd0e14612-8361-404c-8f07-33e3e865f081') IF @elementParentID <>0 BEGIN

DECLARE @elementResourceID int; SET @elementResourceID = (SELECT TOP 1 [ResourceID] FROM [CMS_Resource] WHERE [ResourceGUID] = 'b755e8fc-a06f-421a-b749-f2d31d1f2570') IF @elementResourceID <>0 BEGIN

UPDATE [CMS_UIElement] SET [ElementTargetURL] = NULL, [ElementDescription] = NULL, [ElementType] = 'PageTemplate', [ElementProperties] = '', [ElementIconClass] = '', [ElementCheckModuleReadPermission] = 1, [ElementAccessCondition] = NULL, [ElementVisibilityCondition] = NULL WHERE [ElementGUID] = '75e6ad5c-2763-4bff-95b3-f8d2fbc183a7'

END

[2016-07-18 18:12:43] Failed to run SQLscript: Invalid column name 'ElementProperties'.Message: Invalid column name 'ElementProperties'. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Hotfix.HotfixHelper.RunSQLScript(String fileName, String connString, String defaultUICulture, IMessageLog messageLog)

[2016-07-18 18:12:44] DECLARE @elementParentID int; SET @elementParentID = (SELECT TOP 1 [ElementID] FROM [CMS_UIElement] WHERE [ElementGUID] = 'cc744db0-dc8c-45de-ab30-bd36f67b2eb9') IF @elementParentID <>0 BEGIN

DECLARE @elementPageTemplateID int; SET @elementPageTemplateID = NULL BEGIN

DECLARE @elementResourceID int; SET @elementResourceID = (SELECT TOP 1 [ResourceID] FROM [CMS_Resource] WHERE [ResourceGUID] = '98c6ee00-230a-4207-a6d3-03677b83b245') IF @elementResourceID <>0 BEGIN

UPDATE [CMS_UIElement] SET [ElementProperties] = '' WHERE [ElementGUID] = 'aa1f8f8b-46ff-4e62-ad3d-b3c6e46e7d96'

END

[2016-07-18 18:12:45] Failed to run SQLscript: Invalid column name 'ElementType'. Invalid column name 'ElementPageTemplateID'.Message: Invalid column name 'ElementType'. Invalid column name 'ElementPageTemplateID'. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Hotfix.HotfixHelper.RunSQLScript(String fileName, String connString, String defaultUICulture, IMessageLog messageLog)

[2016-07-18 18:12:45] UPDATE [CMS_UIElement] SET [ElementType] = N'PageTemplate' WHERE [ElementType] = N'Url' AND [ElementPageTemplateID] > 0 AND ISNULL([ElementTargetURL], '') = '' UPDATE [CMS_UIElement] SET [ElementType] = N'Url' WHERE [ElementType] = N'0' UPDATE [CMS_UIElement] SET [ElementType] = N'PageTemplate' WHERE [ElementType] = N'1' UPDATE [CMS_UIElement] SET [ElementType] = N'UserControl' WHERE [ElementType] = N'2' UPDATE [CMS_UIElement] SET [ElementType] = N'Javascript' WHERE [ElementType] = N'3' UPDATE [CMS_UIElement] SET [ElementType] = N'Url' WHERE ISNULL([ElementType], '') = '' AND ISNULL([ElementTargetURL], '') != ''

[2016-07-18 18:12:45] SQL script applied.

while doing via KIM on 8.2 to 9

[2016-07-18 19:45:36] SQL script applied. [2016-07-18 19:45:37] Invalid URI: The hostname could not be parsed.Message: Invalid URI: The hostname could not be parsed. Stack Trace: at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind) at Hotfix.HotfixInstaller.ApplyUpgrade(HotFixItemsEnum items, BackgroundWorker worker, DoWorkEventArgs e)

While after this if i run the project I get an error saying that

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

For this error I tried clearing the OBJ folder/ Debug but no joy

I appreciate your time in analyzing this issue, thanks in advance

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on July 18, 2016 17:04

Seems the problem is with some of the modules. Can you confirm or deny there were changes to any of the modules out of the box? I've run across this exact issue in my last upgrade from 7 -> 9.

0 votesVote for this answer Mark as a Correct answer

santhoshkumar budhihal answered on July 19, 2016 07:50

Hi Brenden, Thank you for the response

How would i know that ? am sorry my client just gave me this project and I started upgrading this

Thanks

0 votesVote for this answer Mark as a Correct answer

santhoshkumar budhihal answered on July 19, 2016 09:19 (last edited on July 19, 2016 09:27)

when doing this in localhost, what options do you suggest me to choose about app_offline.htm ? does it matter ?

0 votesVote for this answer Mark as a Correct answer

santhoshkumar budhihal answered on July 19, 2016 09:34

Third question is

Why it is creating .new extension file when there is nothing new as compared to the previous file

Previous file has xyz and the .new extension file also has same xyz ...

there is nothing to worry, right ?

if I should be doing something, please tell me how to proceed with the .new

0 votesVote for this answer Mark as a Correct answer