U4-5641 - Publish At and Remove At fail with SQL errors, dependent on SQLServer Lang

Created by Martin Griffiths 14 Oct 2014, 16:37:28 Updated by Shannon Deminick 26 Jun 2017, 06:40:03

Relates to: U4-4159

What did you do? User publishes an item with a remove at date and time in the future

What did you expect to happen? Item unpublishes at date and time

What actually happened? Item fails with SQL error in log

If SQL server default language is set to English (US) and login the same on SQL 2012/IIS8 the problem goes away.

See the following post



Shannon Deminick 15 Oct 2014, 04:29:02

I Suspect this is fixed in 6.2.3 since proper SQL parameters are used. It would be worth a test to see if that's the case.

Shannon Deminick 26 Jun 2017, 06:40:03

Closing issue due to inactivity - see blog post for details https://umbraco.com/blog/issue-tracker-cleanup/

Priority: Major

Type: Bug

State: Closed

Assignee: Shannon Deminick

Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions: 6.1.6, 6.2.2

Due in version:


Story Points: