I'm trying to upgrade a module. When I do so I'm confronted with the following sql error.Query:DECLARE @NewPrefix VARCHAR(450); DECLARE @OldLevel INT; DECLARE @NewLevel INT; SET @NewPrefix = (SELEC...
Whenever we restart the CMS's SQL database server to apply security patches on the OS level, the SQL Server comes online after restarting, the app (hosted on IIS 10 with .NET Core) doesn't automati...
Hi,I am using Kentico 13, dotnet core application. I wanted to update multiple products to cart in a single database call.Currently I am looping through all products and updating one by one which i...
Can we no longer use sql to set up fields like dropdowns in forms anymore? What is a good workaround to have a form email multiple people based on a dropdown?
Hello:I've been playing around with the Xperience demo and everything was going well until a few days ago when I was getting an @LocalDB parent instance version invalid: MSSQL13E.LOCALDB@ error. A...
I'm getting this SQL ErrorThe application could not connect to the database, please check the connection string in the web.config file and SQL server availability.Original error: Instance failure.I...
https://www.nuget.org/packages/Kentico.Libraries/ - Migrated from Kentico.Libraries 11 to Kentico.Libraries 12.0.99 - since the migration seeing a lot of SQL connection errors after 12-24 hours of ...
Running Kentico v10 successfully @ happily for the past 4 years. Web server and DB server hosted on Azure.Suddenly, for the past days, page editors cannot save pages (create new versions).System.Ou...
I am trying to set a data source as SQL in a widget for multiple choice. Is a way to know that the data returned any results. I am trying to check the field's value length but it returns 0 even wh...
I'm having a really strange issue happen where my ##WHERE## clause is being removed randomly along with the WHERE in the SQL query itself. This started happening after I upgraded from K8.2 to K12 ...