Error while creating a new site in Kentico 13

Hashmat ali asked on January 17, 2022 12:13

I am gettting below error while creating a new site in using version 13. Please let me know how to resolve the issue. It seems, it is looking for the column in "ClassSearchIndexDataSource" which is not present in CMS_Class. Is this column supposed to be present in kentico 13?

Error during import process ERROR: Error during import process Message: Column 'ClassSearchIndexDataSource' does not belong to table cms_class.

Exception type: System.ArgumentException Stack trace: at CMS.DocumentEngine.DocumentTypeImport.SetClassSearchDataSource(DataSet data) at CMS.DocumentEngine.DocumentTypeImport.GetImportData_After(Object sender, ImportGetDataEventArgs e) at CMS.Base.AbstractHandler.CallEventHandler[TArgs](EventHandler1 h, TArgs e) at CMS.Base.AbstractHandler.Raise[TArgs](String partName, List1 list, TArgs e, Boolean important) at CMS.Base.AdvancedHandler2.RaiseAfter(TArgs e) at CMS.Base.AdvancedHandler2.RaiseAfter(TArgs e) at CMS.Base.AdvancedHandler2.Finish() at CMS.CMSImportExport.ImportProvider.LoadObjects(SiteImportSettings settings, String objectType, Boolean siteObjects, Boolean selectionOnly, Boolean forceXMLStructure) at CMS.CMSImportExport.ImportProvider.ImportObjectType(SiteImportSettings settings, String objectType, Boolean siteObject, TranslationHelper th, ProcessObjectEnum processType, List1 importedParentIds) at CMS.CMSImportExport.ImportProvider.ImportObjectsDataInternal(SiteImportSettings settings)

site creation kentico 13

Correct Answer

Juraj Ondrus answered on January 17, 2022 14:15

When was the project installed and what installer are you using? This seems like the project was installed some time ago and the installer is newer - e.g. the installer is for some Refresh release. What is the exact project and DB version you are using and then did you downloaded the installer? Or, you would try downloading the latest hotfix and apply it also on the setup files. So you have both project and setup files with the same version.

1 votesVote for this answer Unmark Correct answer

Recent Answers

Hashmat ali answered on January 17, 2022 15:52 (last edited on January 17, 2022 16:16)

Thank you for your comment. We have recently upgraded the project from Kentico 12 to Kentico 13 which doesn't have the above column (ClassSearchIndexDataSource in CMS_Class). But, When we install kentico 13.0.56 as a fresh instance, the column is present in the CMS_Class table.

The current project version is on 13.0.56 and the CMS version is also 13.0.56 after migration from kentico 12.

Please refer the images

Let me know in case upgrading to 13.0.58 is the only option.

1 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on January 18, 2022 05:31

From the image you sent the DB has not been hotfixed at all. The SQL query returned 0 for the hotfix version. So, this is the issue. To unify the hotfix numbers I would recommend applying the latest hotfix on the admin app + DB, front end app and also to the setup files as explained in the above link I posted previously.

1 votesVote for this answer Mark as a Correct answer

Hashmat ali answered on January 19, 2022 09:01

Thank you for the response. I have marked your previous comments as answer.

1 votesVote for this answer Mark as a Correct answer