Catch
Entries: 18 |
| additional | | Struct (ordered) | | SQL | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
| | DatabaseName | | | DatabaseVersion | | | DriverName | | | DriverVersion | | string | mysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c) |
| | Datasource | |
|
| Cause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
| | DatabaseName | | | DatabaseVersion | | | DriverName | | | DriverVersion | | string | mysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c) |
| | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primar' at line 13 |
| | NativeErrorCode | | | queryError | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
| | Sql | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primar' at line 13
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at com.inventory_search450.invsearch_cfc$cf.udfCall(/com/inventory-search/invSearch.cfc:453)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1794)
at layout.bootstrap_2015450.includes.inventory._get_inventory_cfm225$cf.call(/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm:21)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015450.includes._settings_inventory_search_results_cfm2565$cf.call(/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm:36)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015_cfm450$cf.call(/layout/bootstrap-2015.cfm:4)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015450.routes.trucking_cfm$cf.call(/layout/bootstrap-2015/routes/trucking.cfm:90)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at _router_cfm$cf.call(/_router.cfm:232)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at application_cfc$cf.udfCall1(/Application.cfc:83)
at application_cfc$cf.udfCall(/Application.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
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:779)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.valves.rewrite.RewriteValve.invoke(RewriteValve.java:289)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 451: LIMIT<br>
452: #((loc.params.page-1)*loc.params.perPage)#, #loc.params.perPage#<br>
<b>453: </cfquery></b><br>
454: <br>
455: <cfset loc.data = rsResults><br>
|
| | codePrintPlain | | string | 451: LIMIT
452: #((loc.params.page-1)*loc.params.perPage)#, #loc.params.perPage#
453: </cfquery>
454:
455: <cfset loc.data = rsResults>
|
| | column | | | id | | | line | | | Raw_Trace | | string | com.inventory_search450.invsearch_cfc$cf.udfCall(/com/inventory-search/invSearch.cfc:453) |
| | template | | string | /home/t2t/public_html/com/inventory-search/invSearch.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 19: <!--- remove Category ---><br>
20: <cfif results.data.RecordCount EQ 0 AND structKeyExists(request.routeInfo, "category") AND len(request.routeInfo.category)><br>
<b>21: <cfset results = application.invSearch.getInventory(category='')></b><br>
22: <cfset page.allSold = "Currently, all #page.title# have been sold. Here are some non-#request.routeInfo.category# listings... !"><br>
23: </cfif><br>
|
| | codePrintPlain | | string | 19: <!--- remove Category --->
20: <cfif results.data.RecordCount EQ 0 AND structKeyExists(request.routeInfo, "category") AND len(request.routeInfo.category)>
21: <cfset results = application.invSearch.getInventory(category='')>
22: <cfset page.allSold = "Currently, all #page.title# have been sold. Here are some non-#request.routeInfo.category# listings... !">
23: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.includes.inventory._get_inventory_cfm225$cf.call(/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm:21) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 34: <br>
35: <!--- get inventory search results ---><br>
<b>36: <cfinclude template="/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm"></b><br>
37: <br>
38: <cfset page.title = getInventoryTitle(argumentCollection=url)><br>
|
| | codePrintPlain | | string | 34:
35: <!--- get inventory search results --->
36: <cfinclude template="/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm">
37:
38: <cfset page.title = getInventoryTitle(argumentCollection=url)>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.includes._settings_inventory_search_results_cfm2565$cf.call(/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm:36) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 2: <br>
3: <!--- get any special settings for specified template ---><br>
<b>4: <cfinclude template="/layout/bootstrap-2015/includes/_settings-#page.template#.cfm"></b><br>
5: <br>
6: <!--- metatags ---><br>
|
| | codePrintPlain | | string | 2:
3: <!--- get any special settings for specified template --->
4: <cfinclude template="/layout/bootstrap-2015/includes/_settings-#page.template#.cfm">
5:
6: <!--- metatags --->
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015_cfm450$cf.call(/layout/bootstrap-2015.cfm:4) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 88: </cfif><br>
89: <br>
<b>90: <cfinclude template="/layout/#page.layout#.cfm"></b><br>
|
| | codePrintPlain | | string | 88: </cfif>
89:
90: <cfinclude template="/layout/#page.layout#.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.routes.trucking_cfm$cf.call(/layout/bootstrap-2015/routes/trucking.cfm:90) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/routes/trucking.cfm |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 230: <br>
231: // include proper route template<br>
<b>232: include request.routeInfo.templateToInclude;</b><br>
233: <br>
234: <br>
|
| | codePrintPlain | | string | 230:
231: // include proper route template
232: include request.routeInfo.templateToInclude;
233:
234:
|
| | column | | | id | | | line | | | Raw_Trace | | string | _router_cfm$cf.call(/_router.cfm:232) |
| | template | | string | /home/t2t/public_html/_router.cfm |
| | type | |
| | 7 | | Struct | | codePrintHTML | | string | 81: // include '/_redirect.cfm';<br>
82: include '/includes/application/_onRequest.cfm';<br>
<b>83: include arguments.targetPage;</b><br>
84: return;<br>
85: }<br>
|
| | codePrintPlain | | string | 81: // include '/_redirect.cfm';
82: include '/includes/application/_onRequest.cfm';
83: include arguments.targetPage;
84: return;
85: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall1(/Application.cfc:83) |
| | template | | string | /home/t2t/public_html/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primar' at line 13 |
|
| name | |
| NativeErrorCode | |
| queryError | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
|
| rootCause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
| | DatabaseName | | | DatabaseVersion | | | DriverName | | | DriverVersion | | string | mysql-connector-j-8.0.33 (Revision: 7d6b0800528b6b25c68b52dc10d6c1c8429c100c) |
| | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primar' at line 13 |
| | NativeErrorCode | | | queryError | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
| | Sql | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primar' at line 13
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at com.inventory_search450.invsearch_cfc$cf.udfCall(/com/inventory-search/invSearch.cfc:453)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1794)
at layout.bootstrap_2015450.includes.inventory._get_inventory_cfm225$cf.call(/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm:21)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015450.includes._settings_inventory_search_results_cfm2565$cf.call(/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm:36)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015_cfm450$cf.call(/layout/bootstrap-2015.cfm:4)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015450.routes.trucking_cfm$cf.call(/layout/bootstrap-2015/routes/trucking.cfm:90)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at _router_cfm$cf.call(/_router.cfm:232)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at application_cfc$cf.udfCall1(/Application.cfc:83)
at application_cfc$cf.udfCall(/Application.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
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:779)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.valves.rewrite.RewriteValve.invoke(RewriteValve.java:289)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 451: LIMIT<br>
452: #((loc.params.page-1)*loc.params.perPage)#, #loc.params.perPage#<br>
<b>453: </cfquery></b><br>
454: <br>
455: <cfset loc.data = rsResults><br>
|
| | codePrintPlain | | string | 451: LIMIT
452: #((loc.params.page-1)*loc.params.perPage)#, #loc.params.perPage#
453: </cfquery>
454:
455: <cfset loc.data = rsResults>
|
| | column | | | id | | | line | | | Raw_Trace | | string | com.inventory_search450.invsearch_cfc$cf.udfCall(/com/inventory-search/invSearch.cfc:453) |
| | template | | string | /home/t2t/public_html/com/inventory-search/invSearch.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 19: <!--- remove Category ---><br>
20: <cfif results.data.RecordCount EQ 0 AND structKeyExists(request.routeInfo, "category") AND len(request.routeInfo.category)><br>
<b>21: <cfset results = application.invSearch.getInventory(category='')></b><br>
22: <cfset page.allSold = "Currently, all #page.title# have been sold. Here are some non-#request.routeInfo.category# listings... !"><br>
23: </cfif><br>
|
| | codePrintPlain | | string | 19: <!--- remove Category --->
20: <cfif results.data.RecordCount EQ 0 AND structKeyExists(request.routeInfo, "category") AND len(request.routeInfo.category)>
21: <cfset results = application.invSearch.getInventory(category='')>
22: <cfset page.allSold = "Currently, all #page.title# have been sold. Here are some non-#request.routeInfo.category# listings... !">
23: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.includes.inventory._get_inventory_cfm225$cf.call(/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm:21) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 34: <br>
35: <!--- get inventory search results ---><br>
<b>36: <cfinclude template="/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm"></b><br>
37: <br>
38: <cfset page.title = getInventoryTitle(argumentCollection=url)><br>
|
| | codePrintPlain | | string | 34:
35: <!--- get inventory search results --->
36: <cfinclude template="/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm">
37:
38: <cfset page.title = getInventoryTitle(argumentCollection=url)>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.includes._settings_inventory_search_results_cfm2565$cf.call(/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm:36) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 2: <br>
3: <!--- get any special settings for specified template ---><br>
<b>4: <cfinclude template="/layout/bootstrap-2015/includes/_settings-#page.template#.cfm"></b><br>
5: <br>
6: <!--- metatags ---><br>
|
| | codePrintPlain | | string | 2:
3: <!--- get any special settings for specified template --->
4: <cfinclude template="/layout/bootstrap-2015/includes/_settings-#page.template#.cfm">
5:
6: <!--- metatags --->
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015_cfm450$cf.call(/layout/bootstrap-2015.cfm:4) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 88: </cfif><br>
89: <br>
<b>90: <cfinclude template="/layout/#page.layout#.cfm"></b><br>
|
| | codePrintPlain | | string | 88: </cfif>
89:
90: <cfinclude template="/layout/#page.layout#.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.routes.trucking_cfm$cf.call(/layout/bootstrap-2015/routes/trucking.cfm:90) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/routes/trucking.cfm |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 230: <br>
231: // include proper route template<br>
<b>232: include request.routeInfo.templateToInclude;</b><br>
233: <br>
234: <br>
|
| | codePrintPlain | | string | 230:
231: // include proper route template
232: include request.routeInfo.templateToInclude;
233:
234:
|
| | column | | | id | | | line | | | Raw_Trace | | string | _router_cfm$cf.call(/_router.cfm:232) |
| | template | | string | /home/t2t/public_html/_router.cfm |
| | type | |
| | 7 | | Struct | | codePrintHTML | | string | 81: // include '/_redirect.cfm';<br>
82: include '/includes/application/_onRequest.cfm';<br>
<b>83: include arguments.targetPage;</b><br>
84: return;<br>
85: }<br>
|
| | codePrintPlain | | string | 81: // include '/_redirect.cfm';
82: include '/includes/application/_onRequest.cfm';
83: include arguments.targetPage;
84: return;
85: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall1(/Application.cfc:83) |
| | template | | string | /home/t2t/public_html/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| Sql | | string | SELECT
AdBasic.RowGuid, AdBasic.MemberGuid, AdBasic.ID, AdBasic.NewUsed, AdBasic.Type,
AdBasic.AuctionPriceDisplay, AdBasic.Category, AdBasic.Qty, AdBasic.Year,
AdBasic.Make, AdBasic.Model, AdBasic.City, AdBasic.State, AdBasic.StockNum,
CAST(IFNULL(AdBasic.Price,0) AS SIGNED) AS price, AdBasic.Description, AdBasic.primaryPic as Picture, AdBasic.RecType,
AdBasic.YouTube, AdBasic.price_highlight, AdBasic.Phone AS unit_phone, AdBasic.Company AS unit_company,
AdBasic.featureUntil, AdBasic.leasing, AdBasic.rental, sd_customers.company, sd_customers.id AS customer_id,
sd_customers.phone as company_phone, IF(ppc_phonenums IS NULL,0,1) AS IsPPC, AdBasic.syncphotos
FROM
sd_customers JOIN AdBasic ON sd_customers.id = AdBasic.MemberGuid
WHERE
AdBasic.RecType = 'EL' AND
AdBasic.status = 'NH' AND AdBasic.type = ''Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primaryPic = '') THEN 1 ELSE 0 END, CASE WHEN (UNIX_TIMESTAMP(AdBasic.featureUntil) IS NULL OR UNIX_TIMESTAMP(AdBasic.featureUntil) = 0) THEN NULL ELSE AdBasic.featureUntil END DESC, AdBasic.RecentAdsSort DESC, AdBasic.id DESC
LIMIT
4425, 25 |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Trucks''
ORDER BY
CASE WHEN (AdBasic.primaryPic IS NULL OR AdBasic.primar' at line 13
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
at com.inventory_search450.invsearch_cfc$cf.udfCall(/com/inventory-search/invSearch.cfc:453)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866)
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1794)
at layout.bootstrap_2015450.includes.inventory._get_inventory_cfm225$cf.call(/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm:21)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015450.includes._settings_inventory_search_results_cfm2565$cf.call(/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm:36)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015_cfm450$cf.call(/layout/bootstrap-2015.cfm:4)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at layout.bootstrap_2015450.routes.trucking_cfm$cf.call(/layout/bootstrap-2015/routes/trucking.cfm:90)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at _router_cfm$cf.call(/_router.cfm:232)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at application_cfc$cf.udfCall1(/Application.cfc:83)
at application_cfc$cf.udfCall(/Application.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
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:779)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.valves.rewrite.RewriteValve.invoke(RewriteValve.java:289)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 451: LIMIT<br>
452: #((loc.params.page-1)*loc.params.perPage)#, #loc.params.perPage#<br>
<b>453: </cfquery></b><br>
454: <br>
455: <cfset loc.data = rsResults><br>
|
| | codePrintPlain | | string | 451: LIMIT
452: #((loc.params.page-1)*loc.params.perPage)#, #loc.params.perPage#
453: </cfquery>
454:
455: <cfset loc.data = rsResults>
|
| | column | | | id | | | line | | | Raw_Trace | | string | com.inventory_search450.invsearch_cfc$cf.udfCall(/com/inventory-search/invSearch.cfc:453) |
| | template | | string | /home/t2t/public_html/com/inventory-search/invSearch.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 19: <!--- remove Category ---><br>
20: <cfif results.data.RecordCount EQ 0 AND structKeyExists(request.routeInfo, "category") AND len(request.routeInfo.category)><br>
<b>21: <cfset results = application.invSearch.getInventory(category='')></b><br>
22: <cfset page.allSold = "Currently, all #page.title# have been sold. Here are some non-#request.routeInfo.category# listings... !"><br>
23: </cfif><br>
|
| | codePrintPlain | | string | 19: <!--- remove Category --->
20: <cfif results.data.RecordCount EQ 0 AND structKeyExists(request.routeInfo, "category") AND len(request.routeInfo.category)>
21: <cfset results = application.invSearch.getInventory(category='')>
22: <cfset page.allSold = "Currently, all #page.title# have been sold. Here are some non-#request.routeInfo.category# listings... !">
23: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.includes.inventory._get_inventory_cfm225$cf.call(/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm:21) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 34: <br>
35: <!--- get inventory search results ---><br>
<b>36: <cfinclude template="/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm"></b><br>
37: <br>
38: <cfset page.title = getInventoryTitle(argumentCollection=url)><br>
|
| | codePrintPlain | | string | 34:
35: <!--- get inventory search results --->
36: <cfinclude template="/layout/bootstrap-2015/includes/inventory/_get-inventory.cfm">
37:
38: <cfset page.title = getInventoryTitle(argumentCollection=url)>
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.includes._settings_inventory_search_results_cfm2565$cf.call(/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm:36) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/includes/_settings-inventory-search-results.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 2: <br>
3: <!--- get any special settings for specified template ---><br>
<b>4: <cfinclude template="/layout/bootstrap-2015/includes/_settings-#page.template#.cfm"></b><br>
5: <br>
6: <!--- metatags ---><br>
|
| | codePrintPlain | | string | 2:
3: <!--- get any special settings for specified template --->
4: <cfinclude template="/layout/bootstrap-2015/includes/_settings-#page.template#.cfm">
5:
6: <!--- metatags --->
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015_cfm450$cf.call(/layout/bootstrap-2015.cfm:4) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 88: </cfif><br>
89: <br>
<b>90: <cfinclude template="/layout/#page.layout#.cfm"></b><br>
|
| | codePrintPlain | | string | 88: </cfif>
89:
90: <cfinclude template="/layout/#page.layout#.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | layout.bootstrap_2015450.routes.trucking_cfm$cf.call(/layout/bootstrap-2015/routes/trucking.cfm:90) |
| | template | | string | /home/t2t/public_html/layout/bootstrap-2015/routes/trucking.cfm |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 230: <br>
231: // include proper route template<br>
<b>232: include request.routeInfo.templateToInclude;</b><br>
233: <br>
234: <br>
|
| | codePrintPlain | | string | 230:
231: // include proper route template
232: include request.routeInfo.templateToInclude;
233:
234:
|
| | column | | | id | | | line | | | Raw_Trace | | string | _router_cfm$cf.call(/_router.cfm:232) |
| | template | | string | /home/t2t/public_html/_router.cfm |
| | type | |
| | 7 | | Struct | | codePrintHTML | | string | 81: // include '/_redirect.cfm';<br>
82: include '/includes/application/_onRequest.cfm';<br>
<b>83: include arguments.targetPage;</b><br>
84: return;<br>
85: }<br>
|
| | codePrintPlain | | string | 81: // include '/_redirect.cfm';
82: include '/includes/application/_onRequest.cfm';
83: include arguments.targetPage;
84: return;
85: }
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall1(/Application.cfc:83) |
| | template | | string | /home/t2t/public_html/Application.cfc |
| | type | |
|
|
| type | |
| where | |