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

View Profile

Name: Ian Gregson

Location:
Joined: 14 Apr 2010
Last Online:



Company Name:

Lucee 5.3.7.48 Error (database)
Message column [SOCIAL_TWITTER_LINK] not found in query, columns are [USERID,USERNAME,PASSWORD,COMPLETIONDATE,DISTRICTID,REFERRERID,FIRSTNAME,LASTNAME,COMPANY,ADDRESS1,ADDRESS2,CITY,COUNTYSTATE,POSTCODE,TELEPHONE,FAX,EMAILADDRESS,WEBADDRESS,COMPANYDESCRIPTION,ACCOUNTACTIVE,REFERRER,RENEWALDATE,SIGNINS,TITLE,KUDOSAWARDS,LASTONLINE,ACCOUNTTYPE,UUID]
SQL SELECT *
FROM users
Where users.UserID = 114
Stacktrace The Error Occurred in
/home/offician/public_html/directory/profileview.cfm: line 72
70: <cfelse><br /><a href="#company_website3#?link=www.officianet.com" target="_blank" title="#Subject# - #Summary#">website</a></cfif></p></td>
71: </tr></cfif>
72: <cfif UserDetails.social_twitter_link neq "" OR UserDetails.social_facebook_link neq "">
73: <tr>
74: <td valign="top" class="profile_sub" width="135"><b>Social Media Links: </b></td><td valign="top" class="profile_sub"><cfif UserDetails.social_twitter_link neq ""><a href="#UserDetails.social_twitter_link#?officianet.com" target="_blank"><img src="twitter_officianet.jpg" alt="Twitter Account for #UserDetails.FirstName# #UserDetails.LastName#" /></a> &nbsp;</cfif><cfif UserDetails.social_facebook_link neq ""><a href="#UserDetails.social_facebook_link#?officianet.com" target="_blank"><img src="facebook_officianet.jpg" alt="Facebook Account for #UserDetails.FirstName# #UserDetails.LastName#" /></a></cfif> </td></tr>

Java Stacktrace lucee.runtime.exp.DatabaseException: column [SOCIAL_TWITTER_LINK] not found in query, columns are [USERID,USERNAME,PASSWORD,COMPLETIONDATE,DISTRICTID,REFERRERID,FIRSTNAME,LASTNAME,COMPANY,ADDRESS1,ADDRESS2,CITY,COUNTYSTATE,POSTCODE,TELEPHONE,FAX,EMAILADDRESS,WEBADDRESS,COMPANYDESCRIPTION,ACCOUNTACTIVE,REFERRER,RENEWALDATE,SIGNINS,TITLE,KUDOSAWARDS,LASTONLINE,ACCOUNTTYPE,UUID]
  at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:921)
  at lucee.runtime.type.QueryImpl.get(QueryImpl.java:1819)
  at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:278)
  at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1502)
  at directory.profileview_cfm$cf.call(/directory/profileview.cfm:72)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  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:53)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at jdk.internal.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809)
  at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
  at jdk.internal.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
  at jdk.internal.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
  at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
  at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
  at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.base/java.lang.Thread.run(Thread.java:834)
 
Timestamp 22/10/2021 12:12:36 GMT