Error Executing Database Query.
Syntax error or access violation: 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 'ShadowKey, ShatteredKey, ArcatrazKey, KarazhanKey, Tempe' at line 14
The error occurred in E:\wwwdocs\azergarde.ca\custom\mychars.cfm: line 54
52 : '#form.LowerCityRep#',
53 : '#form.ShatarRep#',
54 : '#form.KeepersRep#')
55 : </cfquery>
56 : </cfif>
SQL insert into custom_chars (user_id, char_name, char_type, char_rank, char_level, char_race, char_class, char_prof1, char_prof2, char_link1, char_link2, char_link3 ShadowKey, ShatteredKey, ArcatrazKey, KarazhanKey, TempestKey, SerpentshrineKey, HonorRep, CenarionRep, LowerCityRep, ShatarRep, KeepersRep) values (89, 'Beowolf', 'Main', 9, 70, 3, 11, 22, 14, '', '', '', 'No', 'Yes', 'Yes', 'Yes', 'No', 'No', 'Honored', 'Honored', 'Honored', 'Honored', 'Honored')
DATASOURCE azergardemain
VENDORERRORCODE 1064
SQLSTATE 42000
Resources:
* Check the ColdFusion documentation to verify that you are using the correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2
Remote Address 24.34.216.13
Referrer
http://www.azergarde.ca/custom/mychars.cfm
Date/Time 27-Feb-07 09:57 AM
Stack Trace
at cfmychars2ecfm1134082117.runPage(E:\wwwdocs\azergarde.ca\custom\mychars.cfm:54) at cfmychars2ecfm1134082117.runPage(E:\wwwdocs\azergarde.ca\custom\mychars.cfm:54)
java.sql.SQLException: Syntax error or access violation: 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 'ShadowKey,
ShatteredKey,
ArcatrazKey,
KarazhanKey,
Tempe' at line 14
at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Statement.execute(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Statement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:753)
at coldfusion.sql.Executive.executeQuery(Executive.java:675)
at coldfusion.sql.Executive.executeQuery(Executive.java:636)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cfmychars2ecfm1134082117.runPage(E:\wwwdocs\azergarde.ca\custom\mychars.cfm:54)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Figured I'd try a new browser - but no it just hates me