U4-6609 - SQL Exception when trying to delete a template that isn't assigned to any doc type

Created by Dan Booth 11 May 2015, 12:28:44 Updated by Simon Steed 12 May 2015, 08:07:49

If you try and delete a template via the UI that isn't assigned to any doc type (but was previously) then an SQL exception is generated in the data layer.

What did you expect to happen?

The template should be deleted

What actually happened?

An SQL exception was raised. However, if you assign the template to any doc type and then try and delete it, this works.

This is detailed more in U4-2356 and U4-1516 and happens across seemingly all versions of Umbraco from 6 to latest version of 7.


Simon Steed 11 May 2015, 12:39:35

I concur this does happen on 7.2.1, not tried later versions.

Shannon Deminick 12 May 2015, 07:59:48

YAY, i can reproduce. Have fixed in rev: 3a36513307cbcb05272099d6b5dce5bc5da57915

Note, that this is already fixed in 7.2.3 because the new service layer is complete and the legacy business logic is no longer used (which is where this bug is)

Simon Steed 12 May 2015, 08:07:49

Excellent well done Shannon

Priority: Normal

Type: Bug

State: Fixed


Difficulty: Normal

Category: Architecture

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.0.4, 7.1.1, 7.2.0, 7.1.2, 7.1.3, 6.2.1, 7.1.4, 7.1.5, 6.2.2, 7.1.6, 7.1.7, 6.2.3, 7.1.8, 6.2.4, 7.1.9, 7.2.1, 6.2.5, 7.2.2, 7.2.3, 7.2.4

Due in version: 7.2.5


Story Points: