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.

General error: Incorrect key file for table 'C:\WINDOWS\TEMP\#sql_c4_0.MYI'; try to repair it
 
The error occurred in D:\goldspot\sitemap.cfm: line 1
1 : <cfquery datasource="goldspot" name="prod_list">
2 : select products.*, type.type as tname, mfr.name as mfrname, category.name as cname
3 : from products, type, mfr, category

SQL    select products.*, type.type as tname, mfr.name as mfrname, category.name as cname from products, type, mfr, category where products.style = type.id and products.mfr = mfr.id and category.cat_id = products.cat_id and products.cat_id NOT IN (9,36) order by mfrname, cname, products.name, tname, partno
DATASOURCE   goldspot
VENDORERRORCODE   126
SQLSTATE   S1000
Resources:

Browser   ColdFusion
Remote Address   66.6.128.40
Referrer  
Date/Time   28-Aug-14 11:23 AM
Stack Trace
at cfsitemap2ecfm1478356371.runPage(D:\goldspot\sitemap.cfm:1) at cfsitemap2ecfm1478356371.runPage(D:\goldspot\sitemap.cfm:1)

java.sql.SQLException: General error: Incorrect key file for table 'C:\WINDOWS\TEMP\#sql_c4_0.MYI'; try to repair it
	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:719)
	at coldfusion.sql.Executive.executeQuery(Executive.java:652)
	at coldfusion.sql.Executive.executeQuery(Executive.java:613)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:499)
	at cfsitemap2ecfm1478356371.runPage(D:\goldspot\sitemap.cfm:1)
	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:210)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	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)