Lucee 5.3.3.62 Error (database)
Message Invalid column name 'interestingness'.
SQL SELECT version.id AS versionId,version.filename,version.title,version.dateCreated AS dateUpdated,version.description,version.licenseId,object.deleted,object.liveVersionId,object.id,object.creatorId,object.url,object.classId,object._summary AS summary,object._searchData AS searchData,object._interestingness AS interestingness,object.dateCreated,iv.filename AS imageFilename,iv.id AS imageVersionId,io.id AS imageId,io.classid AS imageClassId,creator.username FROM
hiveMind_versions version
INNER JOIN hiveMind_objects object
ON version.id = object.liveVersionId
LEFT JOIN hivemind_objects io
ON object._relatedImageId = io.id
LEFT JOIN hivemind_versions iv
ON io.liveVersionId = iv.id
LEFT JOIN hivemind_users creator
ON object.creatorId = creator.id
LEFT JOIN hivemind_licenses license
ON version.licenseId = license.id
INNER JOIN hivemind_classes c on object.classid=c.id WHERE (object.deleted = false) and (object._mergeIntoObjectId IS NULL) and (object.classId <> 'newsitem') and (object.dateCreated > {d '2019-01-01'}) and (object.dateCreated < {d '2020-01-01'}) and (object.classid = 'photograph') and (object.creatorId = 13496) ORDER BY interestingness*c.searchweighting DESC OFFSET 0 ROWS FETCH NEXT 25 ROWS ONLY
DatabaseName Microsoft SQL Server
DatabaseVersion 14.00.3223
DriverName Microsoft JDBC Driver 7.2 for SQL Server
DriverVersion 7.2.2.0
Datasource tramperconz
Stacktrace The Error Occurred in
/org/lucee/cfml/Query.cfc: line 228
called from /org/lucee/cfml/Query.cfc: line 37
called from /var/www/vhosts/trampernz/public_html/whio/models/recordset.cfc: line 300
called from /var/www/vhosts/trampernz/public_html/whio/services/searchservice.cfc: line 89
called from /var/www/vhosts/trampernz/public_html/whio/models/user.cfc: line 655
called from /var/www/vhosts/trampernz/public_html/custom/controllers/member.cfc: line 77
called from /var/www/vhosts/trampernz/public_html/whio/framework/frontcontroller.cfc: line 41
called from /var/www/vhosts/trampernz/public_html/whio/framework/frontcontroller.cfc: line 94
called from /var/www/vhosts/trampernz/public_html/index.cfm: line 14
Java Stacktrace lucee.runtime.exp.DatabaseException: Invalid column name 'interestingness'.
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1621)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:592)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2935)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
  at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:294)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:270)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:215)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1055)
  at lucee.runtime.tag.Query._doEndTag(Query.java:655)
  at lucee.runtime.tag.Query.doEndTag(Query.java:537)
  at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:228)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
  at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:768)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1707)
  at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:37)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:646)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:768)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1707)
  at whio.models.recordset_cfc$cf.udfCall3(/whio/models/recordset.cfc:300)
  at whio.models.recordset_cfc$cf.udfCall(/whio/models/recordset.cfc)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:646)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:768)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1707)
  at whio.services.searchservice_cfc$cf$1.udfCall(/whio/services/searchservice.cfc:89)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:647)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:846)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1726)
  at whio.models.user_cfc$cf.udfCall3(/whio/models/user.cfc:655)
  at whio.models.user_cfc$cf.udfCall(/whio/models/user.cfc)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:647)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:846)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1726)
  at custom.controllers.member_cfc$cf.udfCall(/custom/controllers/member.cfc:77)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:647)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:880)
  at lucee.runtime.functions.dynamicEvaluation.Invoke.call(Invoke.java:49)
  at whio.framework.frontcontroller_cfc$cf.udfCall(/whio/framework/frontcontroller.cfc:41)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
  at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:768)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1707)
  at whio.framework.frontcontroller_cfc$cf.udfCall(/whio/framework/frontcontroller.cfc:94)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:646)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:768)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1707)
  at index_cfm$cf.call(/index.cfm:14)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:911)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
  at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2409)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2399)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2374)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1055)
  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:199)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  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:803)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
  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/02/20 3:08:23 PM