OfficiaNet - Online Business Networking Directory

OfficiaNet - Building Better Business
Sign Up for Free Membership of OfficiaNet - the next stage of evolution for business networking
Officianet - Online Business Networking

Already a Member?
OfficiaNet Members Log In

Membership of our Business Networking section is FREE
OfficiaNet Business Networking

Online Business Networking
Sign Up for Membership of OfficiaNet B2B Business Networking
OfficiaNet Online Project Management Solution

Lucee 5.2.7.63 Error (database)
Message
Detail Table 'offician_i8d.districts' doesn't exist
SQL SELECT *
FROM districts
ORDER BY DistrictID
DatabaseName MySQL
DatabaseVersion 5.6.37
DriverName MySQL Connector Java
DriverVersion mysql-connector-java-5.1.40 ( Revision: 402933ef52cad9aa82624e80acbea46e3a701ce6 )
Datasource offician_i8d
Stacktrace The Error Occurred in
/home/offician/public_html/directory/index.cfm: line 13
11: FROM districts
12: ORDER BY DistrictID
13: </cfquery>
14:
15: <cfquery datasource="#request.datasource#" name="Getindustrytypes">

Java Stacktrace lucee.runtime.exp.DatabaseException:
  at sun.reflect.GeneratedConstructorAccessor130.newInstance(Unknown Source)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  at com.mysql.jdbc.Util.getInstance(Util.java:408)
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)
  at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839)
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:293)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:271)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:224)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:951)
  at lucee.runtime.tag.Query.doEndTag(Query.java:700)
  at directory.index_cfm$cf.call(/directory/index.cfm:13)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427)
  at lucee.runtime.engine.Request.exe(Request.java:44)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1091)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1039)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)
 
Timestamp 18/11/19 19:28:54 GMT