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.collectionIDcalled from C:\inetpub\wwwroot\Herbarium\jacq_image.cfm: line 78 76: |
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 |