Catch Entries: 15 |
additional | Struct (ordered) | SQL | string | SELECT
i.T_items_autoID,
i.t_items_itemid,
i.t_items_title,
i.t_items_urltitle,
i.T_items_textonimage,
i.T_items_price,
i.T_items_price2,
i.t_items_order,
c.t_categories_urltitle AS cat_urltitle, sc.t_categories_urltitle AS subcat_urltitle,
ii.sItemImage_middlePath, ii.sItemImage_maxPath
FROM T_items i
LEFT JOIN T_categories c ON (
c.T_categories_ID = i.T_items_categoryID AND c.T_categories_subcat_parent = 0
AND c.T_categories_partnerID = 42
)
LEFT JOIN T_categories sc ON (
sc.T_categories_subcat_ID = i.t_items_subcategoryID AND sc.T_categories_ID = i.T_items_categoryID
AND sc.T_categories_partnerID = 42 AND sc.T_categories_subcat_ID > 0
)
INNER JOIN tblItemImages ii ON ii.t_items_autoid = i.t_items_autoid AND ii.iItemImage_order = 1
WHERE i.T_items_partnerID = 42
AND i.T_items_categoryID NOT IN (6826,6854,6855)
AND i.t_items_active = 1
AND (
T_items_title LIKE '%Chairs%'
OR T_items_shortDescription1 LIKE '%Chairs%'
OR T_items_reference_code LIKE '%Chairs%'
OR T_items_properties LIKE '%Chairs%'
OR T_items_properties2 LIKE '%Chairs%'
)
ORDER BY i.T_items_order ASC |
| DatabaseName | string | Microsoft SQL Server |
| DatabaseVersion | | DriverName | string | Microsoft JDBC Driver 7.2 for SQL Server |
| DriverVersion | | Datasource | |
|
DataSource | |
Detail | |
ErrorCode | |
Extended_Info | |
ExtendedInfo | |
Message | string | Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. |
|
NativeErrorCode | |
queryError | string | SELECT
i.T_items_autoID,
i.t_items_itemid,
i.t_items_title,
i.t_items_urltitle,
i.T_items_textonimage,
i.T_items_price,
i.T_items_price2,
i.t_items_order,
c.t_categories_urltitle AS cat_urltitle, sc.t_categories_urltitle AS subcat_urltitle,
ii.sItemImage_middlePath, ii.sItemImage_maxPath
FROM T_items i
LEFT JOIN T_categories c ON (
c.T_categories_ID = i.T_items_categoryID AND c.T_categories_subcat_parent = 0
AND c.T_categories_partnerID = 42
)
LEFT JOIN T_categories sc ON (
sc.T_categories_subcat_ID = i.t_items_subcategoryID AND sc.T_categories_ID = i.T_items_categoryID
AND sc.T_categories_partnerID = 42 AND sc.T_categories_subcat_ID > 0
)
INNER JOIN tblItemImages ii ON ii.t_items_autoid = i.t_items_autoid AND ii.iItemImage_order = 1
WHERE i.T_items_partnerID = 42
AND i.T_items_categoryID NOT IN (6826,6854,6855)
AND i.t_items_active = 1
AND (
T_items_title LIKE '%Chairs%'
OR T_items_shortDescription1 LIKE '%Chairs%'
OR T_items_reference_code LIKE '%Chairs%'
OR T_items_properties LIKE '%Chairs%'
OR T_items_properties2 LIKE '%Chairs%'
)
ORDER BY i.T_items_order ASC |
|
Sql | string | SELECT
i.T_items_autoID,
i.t_items_itemid,
i.t_items_title,
i.t_items_urltitle,
i.T_items_textonimage,
i.T_items_price,
i.T_items_price2,
i.t_items_order,
c.t_categories_urltitle AS cat_urltitle, sc.t_categories_urltitle AS subcat_urltitle,
ii.sItemImage_middlePath, ii.sItemImage_maxPath
FROM T_items i
LEFT JOIN T_categories c ON (
c.T_categories_ID = i.T_items_categoryID AND c.T_categories_subcat_parent = 0
AND c.T_categories_partnerID = 42
)
LEFT JOIN T_categories sc ON (
sc.T_categories_subcat_ID = i.t_items_subcategoryID AND sc.T_categories_ID = i.T_items_categoryID
AND sc.T_categories_partnerID = 42 AND sc.T_categories_subcat_ID > 0
)
INNER JOIN tblItemImages ii ON ii.t_items_autoid = i.t_items_autoid AND ii.iItemImage_order = 1
WHERE i.T_items_partnerID = 42
AND i.T_items_categoryID NOT IN (6826,6854,6855)
AND i.t_items_active = 1
AND (
T_items_title LIKE '%Chairs%'
OR T_items_shortDescription1 LIKE '%Chairs%'
OR T_items_reference_code LIKE '%Chairs%'
OR T_items_properties LIKE '%Chairs%'
OR T_items_properties2 LIKE '%Chairs%'
)
ORDER BY i.T_items_order ASC |
|
SQLState | |
StackTrace | string | lucee.runtime.exp.DatabaseException: Transaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5427)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1758)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1016)
at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:499)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:290)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:227)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1112)
at lucee.runtime.tag.Query._doEndTag(Query.java:686)
at lucee.runtime.tag.Query.doEndTag(Query.java:553)
at com.item_cfc$cf.udfCall(/com/item.cfc:170)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:681)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729)
at modules.items.dsp_itemdetails_cfm$cf.call(/modules/items/dsp_itemDetails.cfm:258)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
at templates.item_cfm$cf.call(/templates/item.cfm:16)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
at index_cfm$cf.call(/index.cfm:3)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:432)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
|
TagContext | Array | 1 | Struct | codePrintHTML | string | 168: ORDER BY i.T_items_order ASC<br>
169: </cfif><br>
<b>170: </cfquery></b><br>
171: <br>
172: <cfreturn q><br>
|
| codePrintPlain | string | 168: ORDER BY i.T_items_order ASC
169: </cfif>
170: </cfquery>
171:
172: <cfreturn q>
|
| column | | id | | line | | Raw_Trace | string | com.item_cfc$cf.udfCall(/com/item.cfc:170) |
| template | string | D:\vhosts\eurotrocbelgium.com\com\item.cfc |
| type | |
| 2 | Struct | codePrintHTML | string | 256: <cfelse><br>
257: <cfset qItems = application.item.getAll(<br>
<b>258: search = "#url.searchTerm#", t_items_active = 1, l_exclude_T_items_categoryID = '6826,6854,6855'</b><br>
259: )><br>
260: </cfif><br>
|
| codePrintPlain | string | 256: <cfelse>
257: <cfset qItems = application.item.getAll(
258: search = "#url.searchTerm#", t_items_active = 1, l_exclude_T_items_categoryID = '6826,6854,6855'
259: )>
260: </cfif>
|
| column | | id | | line | | Raw_Trace | string | modules.items.dsp_itemdetails_cfm$cf.call(/modules/items/dsp_itemDetails.cfm:258) |
| template | string | D:\vhosts\eurotrocbelgium.com\modules\items\dsp_itemDetails.cfm |
| type | |
| 3 | Struct | codePrintHTML | string | 14: <br>
15: <cftry><br>
<b>16: <cfinclude template="#request.webPath#modules/items/dsp_itemDetails.cfm"></b><br>
17: <cfcatch type="any"><br>
18: <cfdump var="#cfcatch#"/><br>
|
| codePrintPlain | string | 14:
15: <cftry>
16: <cfinclude template="#request.webPath#modules/items/dsp_itemDetails.cfm">
17: <cfcatch type="any">
18: <cfdump var="#cfcatch#"/>
|
| column | | id | | line | | Raw_Trace | string | templates.item_cfm$cf.call(/templates/item.cfm:16) |
| template | string | D:\vhosts\eurotrocbelgium.com\templates\item.cfm |
| type | |
| 4 | Struct | codePrintHTML | string | 1: <br>
2: <br>
<b>3: <cfinclude template="#request.pageTemplate#"></b><br>
4: <br>
|
| codePrintPlain | string | 1:
2:
3: <cfinclude template="#request.pageTemplate#">
4:
|
| column | | id | | line | | Raw_Trace | string | index_cfm$cf.call(/index.cfm:3) |
| template | string | D:\vhosts\eurotrocbelgium.com\index.cfm |
| type | |
|
|
type | |
where | |