Heavy Trader | Used Heavy Equipment

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND tbl_items.ItemImage <> '' AND tbl_items.marketplace = 1 and tbl_items.V...' at line 91
 
The error occurred in D:/home/heavytrader.ca/wwwroot/vendor/index.cfm: line 382
Called from D:/home/heavytrader.ca/wwwroot/vendor/index.cfm: line 263
Called from D:/home/heavytrader.ca/wwwroot/vendor/index.cfm: line 1
Called from D:/home/heavytrader.ca/wwwroot/vendor/index.cfm: line 382
Called from D:/home/heavytrader.ca/wwwroot/vendor/index.cfm: line 263
Called from D:/home/heavytrader.ca/wwwroot/vendor/index.cfm: line 1
380 : 			<cfif keyword neq ""> and (itemtitle like '%#keyword#%' or dealercompany like '%#keyword#%' or stockno = '#keyword#') </cfif>  
381 : 			<cfif session.sort neq "0">order by itemamount <cfif session.sort eq "2">desc</cfif><cfif session.sort eq "1">asc</cfif><cfelse>order by itemid desc</cfif>
382 :     LIMIT <cfqueryparam value="#start#" cfsqltype="cf_sql_integer" />,<cfqueryparam value="#paginationArgs.rowsPerPage#" cfsqltype="cf_sql_integer" />
383 : 
384 :     </cfquery>

SQLSTATE   42000
DATASOURCE   heavytrader
VENDORERRORCODE   1064
SQL    SELECT tbl_items.ItemID, tbl_items.VendorID, tbl_items.AdID, tbl_items.AgentID, tbl_items.TypeID, tbl_items.sold, tbl_items.rental, tbl_items.RegionID, tbl_items.KijijiProfileID, tbl_items.MakeID, tbl_items.ItemAmount, tbl_items.ItemTitle, tbl_items.ItemYear, tbl_items.ItemDescription, tbl_items.ItemImage, tbl_items.ItemImage2, tbl_items.ItemImage3, tbl_items.ItemImage4, tbl_items.ItemImage5, tbl_items.ItemImage6, tbl_items.ItemImage7, tbl_items.ItemImage8, tbl_items.Address, tbl_items.Region, tbl_items.NewUpdate, tbl_items.Zip, tbl_items.KijijiURL, tbl_items.MapURL, tbl_items.IsDealer, tbl_items.PostedDate, tbl_items.AdVisits, tbl_items.Category, tbl_items.Colour, tbl_items.Kilometers, tbl_items.StockNo, tbl_items.ItemNew, tbl_items.AdLastUpdate, tbl_items.ItemUsage, tbl_items.buybackdollar, tbl_items.ItemTerms, tbl_items.ItemHours, tbl_items.AdExpired, tbl_items.VisitsQuote, tbl_items.VisitsPrint, tbl_items.PublicKey, tbl_items.AppCnt, tbl_items.ViewCnt, tbl_items.ItemModel, tbl_items.ItemMake, tbl_items.BrokerFee, tbl_items.RevShare, tbl_items.InterestRate, tbl_items.ItemFeatured, tbl_items.DefaultFees, tbl_items.ItemFeatured, tbl_items.ItemVisits, tbl_items.ItemType, tbl_items.CreationDate, tbl_items.Latitude_FromKijiji, tbl_items.Longitude_FromKijiji, tbl_items.Latitude, tbl_items.Longitude, tbl_items.Refetch, tbl_items.AddressProcessed, tbl_items.Marketplace, tbl_items.ImageRefresh, tbl_items.Logitude, tbl_items.Visits, tbl_items.ShouldFetch, tbl_items.SellingPrice, tbl_vendors.DealerCompany, tbl_vendors.ContactAddress, tbl_vendors.ContactName, tbl_vendors.ContactEmail, tbl_vendors.DealerURL, tbl_vendors.PublicKey, tbl_vendors.PhoneNumber, tbl_vendors.DealerLogo, tbl_vendors.DealerDescription, tbl_item_types.Type, tbl_makes.Make FROM tbl_items LEFT OUTER JOIN tbl_vendors ON tbl_items.VendorID = tbl_vendors.VendorID LEFT OUTER JOIN tbl_item_types ON tbl_items.TypeID = tbl_item_types.TypeID LEFT OUTER JOIN tbl_makes ON tbl_items.MakeID = tbl_makes.MakeID WHERE tbl_items.VendorID = tbl_vendors.VendorID AND tbl_items.VendorID = AND tbl_items.ItemImage <> '' AND tbl_items.marketplace = 1 and tbl_items.VendorID = order by itemid desc LIMIT (param 1) , (param 2)
Resources:

Browser   claudebot
Remote Address   3.227.252.87
Referrer  
Date/Time   28-Mar-24 06:40 AM
Stack Trace
at cfindex2ecfm656801285._factor5(D:/home/heavytrader.ca/wwwroot/vendor/index.cfm:382) at cfindex2ecfm656801285._factor7(D:/home/heavytrader.ca/wwwroot/vendor/index.cfm:263) at cfindex2ecfm656801285.runPage(D:/home/heavytrader.ca/wwwroot/vendor/index.cfm:1) at cfindex2ecfm656801285._factor5(D:/home/heavytrader.ca/wwwroot/vendor/index.cfm:382) at cfindex2ecfm656801285._factor7(D:/home/heavytrader.ca/wwwroot/vendor/index.cfm:263) at cfindex2ecfm656801285.runPage(D:/home/heavytrader.ca/wwwroot/vendor/index.cfm:1)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND
tbl_items.ItemImage <> '' AND
tbl_items.marketplace = 1 and tbl_items.V...' at line 91
	at jdk.internal.reflect.GeneratedConstructorAccessor514.newInstance(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:488)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1583)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cfindex2ecfm656801285._factor5(D:\home\heavytrader.ca\wwwroot\vendor\index.cfm:382)
	at cfindex2ecfm656801285._factor7(D:\home\heavytrader.ca\wwwroot\vendor\index.cfm:263)
	at cfindex2ecfm656801285.runPage(D:\home\heavytrader.ca\wwwroot\vendor\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at jdk.internal.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:564)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:280)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:170)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:221)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:145)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:143)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at jdk.internal.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:564)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:280)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:187)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:145)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:143)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at jdk.internal.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:564)
	at org.apache.catalina.security.SecurityUtil.lambda$execute$0(SecurityUtil.java:280)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at java.base/javax.security.auth.Subject.doAsPrivileged(Subject.java:550)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:311)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:253)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:187)
	at org.apache.catalina.core.ApplicationFilterChain.lambda$doFilter$0(ApplicationFilterChain.java:145)
	at java.base/java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:143)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	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:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	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(Thread.java:844)