Error message: Error while executing query: SELECT TOP 1 COUNT(p.id) OVER () AS count FROM ecmProducts p WHERE p.Published=1 AND (p.idMainCategory IN (3) OR EXISTS (SELECT DISTINCT cp.idProduct FROM ecmCategoryProducts cp WHERE cp.idCategory IN (3) AND cp.idProduct=p.id) ) AND p.id IN (SELECT idObject FROM cmsObjectTags WHERE idOption IN (10060329) AND ObjectType=N'Product') AND p.id IN (SELECT idObject FROM cmsObjectTags WHERE idOption IN (20000012) AND ObjectType=N'Product') AND p.id IN (SELECT idObject FROM cmsObjectTags WHERE idOption IN (10150143,10150128,10150142,10150157) AND ObjectType=N'Product') GROUP BY p.id
Url: https://gnosi.eu/skin.aspx?lang=el&itemtype=ProductCategory&itemid=00000003&action=view&000003EE=00998229&000007D0=01312D0C&00000875=009AE0FF‡009AE0F0‡009AE0FE‡009AE10D&pagesize=128&sortby=datecdesc&splitter_products_offset=0
Message: Error while executing query: SELECT TOP 1 COUNT(p.id) OVER () AS count FROM ecmProducts p WHERE p.Published=1 AND (p.idMainCategory IN (3) OR EXISTS (SELECT DISTINCT cp.idProduct FROM ecmCategoryProducts cp WHERE cp.idCategory IN (3) AND cp.idProduct=p.id) ) AND p.id IN (SELECT idObject FROM cmsObjectTags WHERE idOption IN (10060329) AND ObjectType=N'Product') AND p.id IN (SELECT idObject FROM cmsObjectTags WHERE idOption IN (20000012) AND ObjectType=N'Product') AND p.id IN (SELECT idObject FROM cmsObjectTags WHERE idOption IN (10150143,10150128,10150142,10150157) AND ObjectType=N'Product') GROUP BY p.id
at Bone.DBConnection.ExecuteScalar(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 268
at Bone.BONE.ExecuteScalar(String sql) in C:\Bone\Bone\src\BONE.cs:line 1551
at Ecommerce.ProductsControl.Render(TextWriter w) in C:\Bone\Ecommerce\src\Controls\ProductsControl.cs:line 1153
at Bone.UIControl.ToString() in C:\Bone\Bone\src\EngineUI\_Control.cs:line 30
at System.IO.TextWriter.Write(Object value)
at ASP.tpl_productcategory_view_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\tpl\ProductCategory.View.tpl.ascx:line 116
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at Bone.ActionView.Render(TextWriter w) in C:\Bone\Bone\src\Actions\DBActions\ActionView.cs:line 161
at Bone.Action.RenderContent(TextWriter w) in C:\Bone\Bone\src\Actions\_Action.cs:line 394
at Bone.Action.ToString() in C:\Bone\Bone\src\Actions\_Action.cs:line 518
at Bone.Base.get_Content() in C:\Bone\Bone\src\Classes\Base.cs:line 80
at ASP.skin_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\skin.aspx:line 241
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 53) was deadlocked on lock | communication buffer 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 263