error in hot fix sql update kentico 13

lawrence whittemore asked on October 15, 2024 14:56

(1 row affected)
Msg 4901, Level 16, State 1, Line 2321
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'CategoryAllowAllTypes' cannot be added to non-empty table 'CMS_Category' because it does not satisfy these conditions.

what is the recomended way to complete this now?

Correct Answer

Juraj Ondrus answered on October 15, 2024 15:05

I would recommend checking the bug tracker for the already known and fixed issues. So, in this case the best way would be applying the latest hotfix no. 165:

Hotfix - Category-related errors when hotfixing projects with version 13.0.141 or older When updating a project from version 13.0.141 or older directly to 13.0.161 or newer, an error occurred during the hotfix procedure if the project's data contained one or more categories (defined in the Categories application). Such projects weren't updated correctly, and various category-related errors could occur.

0 votesVote for this answer Unmark Correct answer

Recent Answers


Angel Velazquez answered on March 26, 2025 21:36 (last edited on March 26, 2025 21:41)

Hi Juraj!

So once you are facing this issue, there is no way to fix it unless you do a rollback?

We are currently facing something pretty similar... we updated the Hotfix from 13.0.135 to 13.0.178 and after that, everytime we head to Categories and create a new one, the Form Control is not rendering correctly into "Allowed page types" tab.

I think it should be a programmatic way to fix, don't you think?

Following is a brief segment of our Event detail:

Description:Message: Form control '' not found.

Exception type: System.InvalidOperationException

Stack trace: at CMS.FormEngine.Web.UI.EditingFormControl.CreateControl(FormFieldInfo ffi)

Event URL:/Admin/CMSModules/Categories/Pages/Administration/Category_List.aspx?siteId=

URL referrer:https://mxl690-pf40ve0x.ipgphotonics.com/Admin/CMSModules/Categories/Pages/Administration/Category_List.aspx?siteId=

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on March 27, 2025 05:03

Well, there is always a way how to fix. But, there is the but - I would need to know the steps how to reproduce it to see what went wrong and how to fix it. And, we can't tell whether this is the only thing which went wrong or not. This indicates that the hotfix was not applied correctly and something else could be off too - and just may error out later on. So, the best and recommended way would be rolling back the backups and applying the hotfix again following the instructions.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.