Error message: Error while executing query: SELECT Max(CASE WHEN (p.Discount=0) THEN p.NetPrice WHEN (p.Discount>0 AND p.DiscountType=0) THEN (p.NetPrice-(p.NetPrice * p.Discount/100)) WHEN (p.Discount>0 AND p.DiscountType=1) THEN (p.NetPrice- p.Discount) END) FROM ecmProducts p WHERE p.Published=1 AND p.DateCreated>='2024-11-25 17:24:55' AND (p.Text5 IS NULL OR p.Text5='' OR p.Text5=p.Code)

Url: https://kopanos-store.gr/skin.aspx?lang=en&action=actionnewarrivals&000003E8=A48C3DC0‡3B6343B0‡AC7A958C‡6CAF497D‡B4DC6EFF‡61DD02FB‡DAC3B2E0‡A5347BEB‡4DD4E07F‡0C51140D‡D523E29A&594B0C57=B61225EF‡1CEFAD0F‡3DE4CA3A‡74E8F4B1‡A50F3419‡211042A1‡DAFEEEF5‡13E9E5B9‡4E9C9C59‡AEA49AC8&splitter_products_offset=0

Message: Error while executing query: SELECT Max(CASE WHEN (p.Discount=0) THEN p.NetPrice WHEN (p.Discount>0 AND p.DiscountType=0) THEN (p.NetPrice-(p.NetPrice * p.Discount/100)) WHEN (p.Discount>0 AND p.DiscountType=1) THEN (p.NetPrice- p.Discount) END) FROM ecmProducts p WHERE p.Published=1 AND p.DateCreated>='2024-11-25 17:24:55' AND (p.Text5 IS NULL OR p.Text5='' OR p.Text5=p.Code)

   at Bone.DBConnection.ExecuteScalar(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 236
   at Bone.BONE.ExecuteScalar(String sql) in C:\Bone\Bone\src\BONE.cs:line 1676
   at Ecommerce.ProductsControl.Render(TextWriter w) in C:\Bone\Ecommerce\src\Controls\ProductsControl.cs:line 900
   at Bone.UIControl.ToString() in C:\Bone\Bone\src\EngineUI\_Control.cs:line 30
   at System.IO.TextWriter.Write(Object value)
   at ASP.tpl_actionnewarrivals_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\kopanos\tpl\ActionNewArrivals.tpl.ascx:line 109
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at Bone.Action.RenderContent(TextWriter w) in C:\Bone\Bone\src\Actions\_Action.cs:line 409
   at Bone.Action.ToString() in C:\Bone\Bone\src\Actions\_Action.cs:line 526
   at Bone.Base.get_Content() in C:\Bone\Bone\src\Classes\Base.cs:line 81
   at ASP.skin_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\kopanos\skin.aspx:line 330
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Page.Render(HtmlTextWriter writer)
   at Bone.Asp.RenderSkin(TextWriter w) in C:\Bone\Bone\src\Classes\Asp.cs:line 71
   at Bone.ModalAction.RenderPage(TextWriter w) in C:\Bone\Bone\src\Actions\Modal.cs:line 81
   at Bone.Asp.Render(HtmlTextWriter w) in C:\Bone\Bone\src\Classes\Asp.cs:line 82
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Message: Transaction (Process ID 77) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Bone.DBConnection.ExecuteScalar(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 222