Error message: Error while executing query: SELECT * FROM (SELECT tbl.id,ROW_NUMBER() OVER (ORDER BY NEWID() ) AS ROW FROM ecmProducts AS tbl WHERE p.Published=1 and p.Num1<=0) AS TR WHERE ROW BETWEEN 1 AND 8
Url: https://goorganic.gr/skin.aspx?lang=en&itemtype=Product&itemid=000054A9&action=view&
Message: Error while executing query: SELECT * FROM (SELECT tbl.id,ROW_NUMBER() OVER (ORDER BY NEWID() ) AS ROW FROM ecmProducts AS tbl WHERE p.Published=1 and p.Num1<=0) AS TR WHERE ROW BETWEEN 1 AND 8
at Bone.DBConnection.Execute(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 83
at Bone.BONE.Execute(String sql) in C:\Bone\Bone\src\BONE.cs:line 1474
at Bone.BONE.Select[T](String where, String order, String innerjoinexpression, Nullable`1 offset, Nullable`1 limit, Boolean checkpermissions, Boolean nocache, Boolean nocacheifzerocount, String tableQueryAlias) in C:\Bone\Bone\src\BONE.cs:line 3658
at Bone.BONE.Select[T](String where, String order, String innerjoinexpression, Nullable`1 offset, Nullable`1 limit, Boolean checkpermissions, Boolean nocache, Boolean nocacheifzerocount) in C:\Bone\Bone\src\BONE.cs:line 3572
at Bone.BONE.Select[T](String where, String order, Nullable`1 offset, Nullable`1 limit) in C:\Bone\Bone\src\BONE.cs:line 3529
at Bone.DBAbstractItem`1.Select(String where, String order, Nullable`1 offset, Nullable`1 limit) in C:\Bone\Bone\src\EngineDB\DBItem.cs:line 31
at ASP.tpl_product_view_tpl_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in c:\inetpub\wwwroot\tpl\Product.View.tpl.ascx:line 350
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
at System.Web.UI.Control.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
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 330
at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
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.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Message: The multi-part identifier "p.Published" could not be bound.
The multi-part identifier "p.Num1" could not be bound.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Bone.DBConnection.Execute(String sql) in C:\Bone\Bone\src\EngineDB\DBEngine.cs:line 77