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.9.31 Error (database)
Message
Detail Table 'offician_i8d.userprofiles' doesn't exist
SQL SELECT *
FROM userprofiles
Where userprofiles.NewsItemID = '15'
AND Active = 1
DatabaseName MySQL
DatabaseVersion 5.7.25
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/profileview.cfm: line 7
5: Where userprofiles.NewsItemID = '#url.profileitem#'
6: AND Active = 1
7: </cfquery>
8: <cfif UserProfile.RecordCount IS 0>
9: <cfelse>

Java Stacktrace lucee.runtime.exp.DatabaseException:
  at sun.reflect.GeneratedConstructorAccessor47.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:273)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:226)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:951)
  at lucee.runtime.tag.Query.doEndTag(Query.java:700)
  at directory.profileview_cfm$cf.call(/directory/profileview.cfm:7)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:66)
  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:1090)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1038)
  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:493)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
  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 23/01/19 13:17:13 GMT