Lucee 5.3.10.120 Error (database)
Message
SQL SELECT c.Sammler, c2.Sammler_2, gn.iso_alpha_3_code, gn.nation_engl, gp.provinz, herbar_view.GetScientificName(s.taxonID, 0) AS NameAuthorYearString, mc.coll_gbif_pilot, mc.source_id, s.alt_number, s. altitude_max, s.altitude_min, s.Bemerkungen, IFNULL(s.Coord_E,0) AS Coord_E, IFNULL(s.Coord_N,0) AS Coord_N, IFNULL(s.Coord_S,0) AS Coord_S, IFNULL(s.Coord_W,0) as Coord_W, s.Datum, s.Datum2, s.det, s.digital_image, IFNULL(s.E_Min,0) AS E_Min, IFNULL(s.E_Sec,0) AS E_Sec, s.exactness, s.Fundort, s.HerbNummer, IFNULL(s.N_Min,0) AS N_Min, IFNULL(s.N_Sec,0) AS N_Sec, s.Nummer, s.observation, IFNULL(s.S_Min,0) AS S_Min, IFNULL(s.S_Sec,0) AS S_Sec, s.series_number, s.taxon_alt, IFNULL(s.W_Min,0) AS W_Min, IFNULL(s.W_Sec,0) AS W_Sec, ss.series, ta.author author, ta1.author author1, ta2.author author2, ta3.author author3, ta4.author author4, ta5.author author5, te.epithet, te1.epithet epithet1, te2.epithet epithet2, te3.epithet epithet3, te4.epithet epithet4, te5.epithet epithet5, tf.family, tg.genus, ts.statusID, ts.taxonID, ttr.rank, s.specimen_ID, mc.coll_short, mc.collection, mc.collectionID, s.digital_image_obs, s.ncbi_accession, s.typified, tid.imgserver_IP, ts.synID, tsc.cat_description, ty.typus_lat, uri.stableIdentifier
FROM (tbl_specimens s, tbl_collector c, tbl_tax_species ts, tbl_tax_rank ttr, tbl_management_collections mc)
LEFT JOIN tbl_collector_2 c2 ON c2.Sammler_2ID = s.Sammler_2ID
LEFT JOIN tbl_tax_authors ta ON ta.authorID = ts.authorID
LEFT JOIN tbl_tax_authors ta1 ON ta1.authorID = ts.subspecies_authorID
LEFT JOIN tbl_tax_authors ta2 ON ta2.authorID = ts.variety_authorID
LEFT JOIN tbl_tax_authors ta3 ON ta3.authorID = ts.subvariety_authorID
LEFT JOIN tbl_tax_authors ta4 ON ta4.authorID = ts.forma_authorID
LEFT JOIN tbl_tax_authors ta5 ON ta5.authorID = ts.subforma_authorID
LEFT JOIN tbl_tax_epithets te ON te.epithetID = ts.speciesID
LEFT JOIN tbl_tax_epithets te1 ON te1.epithetID = ts.subspeciesID
LEFT JOIN tbl_tax_epithets te2 ON te2.epithetID = ts.varietyID
LEFT JOIN tbl_tax_epithets te3 ON te3.epithetID = ts.subvarietyID
LEFT JOIN tbl_tax_epithets te4 ON te4.epithetID = ts.formaID
LEFT JOIN tbl_tax_epithets te5 ON te5.epithetID = ts.subformaID
LEFT JOIN tbl_tax_genera tg ON tg.genID = ts.genID
LEFT JOIN tbl_geo_nation gn ON gn.nationID = s.NationID
LEFT JOIN tbl_tax_families tf ON tf.familyID = tg.familyID
LEFT JOIN tbl_geo_province gp ON gp.provinceID = s.provinceID
LEFT JOIN tbl_specimens_series ss ON ss.seriesID = s.seriesID
LEFT JOIN tbl_img_definition tid ON tid.source_id_fk=mc.source_id
LEFT JOIN tbl_tax_systematic_categories tsc ON tf.categoryID=tsc.categoryID
LEFT JOIN tbl_typi ty ON s.typusID = ty.typusID
LEFT JOIN tbl_specimens_stblid uri ON s.specimen_ID = uri.specimen_ID

WHERE Replace((REPLACE (s.HerbNummer,' ','')),'-','') LIKE 'obs_1012867_DR056517'

AND s.SammlerID = c.SammlerID
AND s.taxonID = ts.taxonID
AND ts.tax_rankID = ttr.tax_rankID
AND s.collectionID = mc.collectionID
AND s.accessible > 0;
DatabaseName MySQL
DatabaseVersion 5.5.5-10.5.12-MariaDB-1:10.5.12+maria~stretch-log
DriverName MySQL Connector/J
DriverVersion mysql-connector-java-8.0.30 (Revision: 1de2fe873fe26189564c030a343885011412976a)
Datasource jacq_mirror
Stacktrace The Error Occurred in
C:\inetpub\wwwroot\Herbarium\templates\build_name_link_jacq.cfm: line 57
55: AND s.collectionID = mc.collectionID
56: AND s.accessible > 0;
57: </CFQUERY>
58:
59:

called from C:\inetpub\wwwroot\Herbarium\jacq_image.cfm: line 78
Java Stacktrace lucee.runtime.exp.DatabaseException:
  at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287)
  at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
  at lucee.runtime.tag.Query._doEndTag(Query.java:700)
  at lucee.runtime.tag.Query.doEndTag(Query.java:566)
  at herbarium.templates.build_name_link_jacq_cfm$cf$jw.call(/Herbarium/Templates/build_name_link_jacq.cfm:57)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
  at herbarium.jacq_image_cfm$cf$jv.call(/Herbarium/jacq_image.cfm:78)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:65)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:45)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
  at lucee.runtime.engine.Request.exe(Request.java:45)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)
  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 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.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415)
  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:1639)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.base/java.lang.Thread.run(Unknown Source)
 
Timestamp 3/28/24 5:24:09 PM CET