2006 SCION TC - Import Cars / Tuners

Muscle Cars / Hot Rods

Classic Cars / Vintage

Import Cars / Tuners

Custom Trucks

Bikes / Choppers

Lowriders / Other

OC12 Countdown:

HOME	CAR SHOW	PRIZES	RULES & REGS	CLUBS	EVENTS	FORUMS	OCS BLOG	CONTACT US


	Car Show Class:

	Car Show Sub Class:

	Keyword:

	Country:

	Province/State:

	Year:
	From:	To:

	Make:

	Model:

	User:

	Most recent photos
	OCS Vehicles For Sale

Online-Car-Show News

Import Cars / Tuners

	Photos: 1-12/311
1 2 3 4 . 6 . . 12 . . 18 . . 24 . .

>> Account Login <<

struct

Cause

struct

ErrorCode

1064

Message

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 'and c.carID NOT IN () order by rand()' at line 9

SQLState

42000

StackTrace

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'and c.carID NOT IN () order by rand()' at line 9 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3243) at com.mysql.jdbc.Connection.execSQL(Connection.java:3172) at com.mysql.jdbc.Statement.execute(Statement.java:701) at com.mysql.jdbc.Statement.execute(Statement.java:783) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1192) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfsimilarcar2ecfm162647566.runPage(C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cftpl_mainbody2ecfm847667419.runPage(C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm:116) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfcarshow2ecfm1267574639.runPage(C:\websites\online-car-show_com\webroot\carshow.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cf929_2006_scion_tc2ecfm569182757.runPage(C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm:6) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	12
RAW_TRACE	at cfsimilarcar2ecfm162647566.runPage(C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm:12)
TEMPLATE	C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	116
RAW_TRACE	at cftpl_mainbody2ecfm847667419.runPage(C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm:116)
TEMPLATE	C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	12
RAW_TRACE	at cfcarshow2ecfm1267574639.runPage(C:\websites\online-car-show_com\webroot\carshow.cfm:12)
TEMPLATE	C:\websites\online-car-show_com\webroot\carshow.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	6
RAW_TRACE	at cf929_2006_scion_tc2ecfm569182757.runPage(C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm:6)
TEMPLATE	C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm
TYPE	CFML

Type

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

DataSource

ocs_mysql

Detail

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 'and c.carID NOT IN () order by rand()' at line 9

ErrorCode

42000

Message

Error Executing Database Query.

NativeErrorCode

1064

RootCause

struct

ErrorCode

1064

Message

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 'and c.carID NOT IN () order by rand()' at line 9

SQLState

42000

StackTrace

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	12
RAW_TRACE	at cfsimilarcar2ecfm162647566.runPage(C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm:12)
TEMPLATE	C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	116
RAW_TRACE	at cftpl_mainbody2ecfm847667419.runPage(C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm:116)
TEMPLATE	C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	12
RAW_TRACE	at cfcarshow2ecfm1267574639.runPage(C:\websites\online-car-show_com\webroot\carshow.cfm:12)
TEMPLATE	C:\websites\online-car-show_com\webroot\carshow.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	6
RAW_TRACE	at cf929_2006_scion_tc2ecfm569182757.runPage(C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm:6)
TEMPLATE	C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm
TYPE	CFML

Type

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

SQLState

42000

Sql

SELECT c.carID, m.memberID, c.Title, c.FName, c.FNameSub1, c.FNameSub2, c.FNameSub3, c.FNameSub4, c.RateSum, c.RateNum, Disclose, c.UploadDate, coalesce(c.UpdateDate, c.UploadDate) as UpdateDate, tc.ParentCategory, tc.categoryName, c.categoryID, m.firstname, m.lastname, tm.makename, tmo.modelname, c.carYear FROM car c JOIN member m ON c.memberID = m.memberID LEFT JOIN tblCategory tc ON tc.categoryID = c.categoryID LEFT JOIN tblmake tm ON tm.makeID = c.makeID LEFT JOIN tblmodel tmo ON tmo.modelID = c.modelID where c.modelID = -100 and c.categoryID = and c.carID NOT IN () order by rand()

StackTrace

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:583) at cfsimilarcar2ecfm162647566.runPage(C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cftpl_mainbody2ecfm847667419.runPage(C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm:116) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cfcarshow2ecfm1267574639.runPage(C:\websites\online-car-show_com\webroot\carshow.cfm:12) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:2644) at cf929_2006_scion_tc2ecfm569182757.runPage(C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm:6) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 'and c.carID NOT IN () order by rand()' at line 9 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) at com.mysql.jdbc.Connection.execSQL(Connection.java:3243) at com.mysql.jdbc.Connection.execSQL(Connection.java:3172) at com.mysql.jdbc.Statement.execute(Statement.java:701) at com.mysql.jdbc.Statement.execute(Statement.java:783) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1192) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) ... 42 more

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	12
RAW_TRACE	at cfsimilarcar2ecfm162647566.runPage(C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm:12)
TEMPLATE	C:\websites\online-car-show_com\webroot\carshow\similarcar.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	116
RAW_TRACE	at cftpl_mainbody2ecfm847667419.runPage(C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm:116)
TEMPLATE	C:\websites\online-car-show_com\webroot\tpl_mainbody.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	12
RAW_TRACE	at cfcarshow2ecfm1267574639.runPage(C:\websites\online-car-show_com\webroot\carshow.cfm:12)
TEMPLATE	C:\websites\online-car-show_com\webroot\carshow.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	6
RAW_TRACE	at cf929_2006_scion_tc2ecfm569182757.runPage(C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm:6)
TEMPLATE	C:\websites\online-car-show_com\webroot\car-show\import_cars\929_2006_scion_tc.cfm
TYPE	CFML

Type

Database

queryError

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 'and c.carID NOT IN () order by rand()' at line 9

where

[empty string]


	X Free Features Manage all your club cars pictures and detailed information. A free micro car show site for your club - just cut and paste the URL outputted in your OCS club listing...enjoy! Latest Club listing on the home page. Searchable database by region or keyword.