ArchiveLister
 
Full Editor
  save   cancel   load es  
View History
Continue

ERROR:

meta:changeLanguage ss:/multilingual/changeLanguage.do

--

java.lang.NullPointerException
at MaiArch.Struts.ChangeLanguage.execute(ChangeLanguage.java:52)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
changing country for: null INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/changeLanguage.do','','2022/12/5','68.169.51.12','',NULL,'9E48FF9ECA16357AE75CF3316A85BE7B') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageFeatureDefinitions.do%3Bjsessionid=2E4C74E4D590E31D145825EDF7FA94CA?dispatch=showAllFeatures&txtClass=MediaTools.Property.House','30203A8323D44A5BE8C4EDAE8DD06150') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 meta:homeAction ss:/multilingual/homeAction.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/homeAction.do','','2022/12/5','68.169.51.12','',NULL,'A8504256D586E3F587C843186641141B') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 SELECT lngID,txtCategory,intParentID,txtType,txtDescription,txtClass,boolActive FROM tblCategory WHERE intParentID = 389 ORDER BY txtDescription

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 SELECT lngID,txtCategory,intParentID,txtType,txtDescription,txtClass,boolActive FROM tblCategory WHERE intParentID = 389 ORDER BY txtDescription INIT SESSION HOUSES BY TOWN meta:filterHouses ss:/multilingual/filterHouses.do shuffling operacion::VENTA typeName::Local Commercial INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/filterHouses.do','','2022/12/5','68.169.51.12','',NULL,'2DE1BF44BA9E71E778EA2723777352AF') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:processLoginForm_badLogin ss:/multilingual/processLoginForm.do SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'martin@allmydates.com' OR tblUser.lngID = -1 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'madeleine' OR tblUser.lngID = -1 INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/processLoginForm.do','','2022/12/5','68.169.51.12','',NULL,'33E2877AAE5646E8DF4793965AF0AEB4') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 INIT SESSION HOUSES BY TOWN meta:filterHouses ss:/multilingual/filterHouses.do shuffling INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/filterHouses.do','','2022/12/5','68.169.51.12','',NULL,'292E02BE4A8EDC2378FE6D2A18ABFFB8') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:listAllGalleries ss:/multilingual/listAllGalleries.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/listAllGalleries.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/listAllGalleries.do%3Bjsessionid=2D8DA6D31863C68225519CA046CA3C3B','7A83DDB842CA035C5F429A0F98CFE241') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:settingsManager_insufficientSecurity ss:/multilingual/settingsManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/settingsManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageCategories.do%3Bjsessionid=83AFA75FA8E3F0BF20ACBF64D3C2CDC7?typeName=PROPERTY_TYPE','E27B458F004EA4090936EFD5B6ABAFBF') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:261)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:261)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 INIT SESSION HOUSES BY TOWN meta:paginateHouses ss:/multilingual/buy_property_mallorca/paginateHouses.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/buy_property_mallorca/paginateHouses.do','','2022/12/5','68.169.51.12','',NULL,'7A34CD97F381072C6615DD04EBABC79F') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/generalAdmin.do%3Bjsessionid=1D14D67038844FB89B58F26C85AE49E0?content=manual.index','C364D5AA9F4AB83F67197CAFD09C8FDB') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:processLoginForm_badLogin ss:/multilingual/processLoginForm.do SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'martin@allmydates.com' OR tblUser.lngID = -1 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'madeleine' OR tblUser.lngID = -1 INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/processLoginForm.do','','2022/12/5','68.169.51.12','',NULL,'A22CE734378390ED2BA2984CF5EF7497') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:listAllGalleries ss:/multilingual/listAllGalleries.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/listAllGalleries.do','','2022/12/5','68.169.51.12','',NULL,'E623BB76B170DEE740B9ABBD1A7F9A4B') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 .. org.apache.struts.action.MODULE org.apache.struts.action.mapping.instance org.apache.struts.taglib.tiles.CompContext org.apache.struts.action.MESSAGE javax.servlet.forward.query_string javax.servlet.forward.servlet_path javax.servlet.forward.context_path javax.servlet.forward.request_uri javax.servlet.include.servlet_path javax.servlet.include.context_path javax.servlet.include.request_uri .. country sessionActiveHousesByTownsHt sessionActiveHousesByZonesHt org.apache.struts.action.LOCALE SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'Marga' OR tblUser.lngID = -1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.mainPublic_jsp._jspService(mainPublic_jsp.java:483)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.mainPublic_jsp._jspService(mainPublic_jsp.java:483)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 INIT SESSION HOUSES BY TOWN meta:contact ss:/multilingual/contact.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/contact.do','','2022/12/5','68.169.51.12','',NULL,'1E9F786E12969AA099DD38DF3EDD90D0') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageFeatureDefinitions.do%3Bjsessionid=F0A5C7FA925E4D4976F4D11D0FDFF7A0?dispatch=showAllFeatures&txtClass=MediaTools.Property.House','88657BE335AB6CD978B8FB80FC0ED04C') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/listAllGalleries.do%3Bjsessionid=F6004A78B3596C8672140EB08B098041','1B831A3E3882498B99D5DAC12231E2E5') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:settingsManager_insufficientSecurity ss:/multilingual/settingsManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/settingsManager.do','','2022/12/5','68.169.51.12','',NULL,'ED9BE52F86469EA1DB34DEE154AB9E3F') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.doHead(HttpServlet.java:245)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.doHead(HttpServlet.java:245)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 meta:homeAction ss:/multilingual/homeAction.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/homeAction.do','','2022/12/5','68.169.51.12','',NULL,'F31B25E201E07C78FDF758ECB841D885') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','',NULL,'3B03AC37CBFA00D065C8C2B8DD5A13ED') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 meta:homeAction ss:/multilingual/homeAction.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/homeAction.do','','2022/12/5','68.169.51.12','',NULL,'66368EF4B1C247B58D0D761F706FD97A') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/generalAdmin.do%3Bjsessionid=624D5F4E6A967644E7BFC993999F3674?content=manual.index','34718548406ACA5C2B82D501ECE62DB9') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:settingsManager_insufficientSecurity ss:/multilingual/settingsManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/settingsManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageLocations.do%3Bjsessionid=53FD5D32C424933522C991057206BAE6','AC8CE33DC2633DE31D4AE248E5C174AD') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:processLoginForm_badLogin ss:/multilingual/processLoginForm.do SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'martin@allmydates.com' OR tblUser.lngID = -1 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'madeleine' OR tblUser.lngID = -1 INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/processLoginForm.do','','2022/12/5','68.169.51.12','',NULL,'7B0BBF0FA3C5902CA3B28CE53B60EBC7') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 0 meta:manageCategories ss:/multilingual/manageCategories.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/manageCategories.do','','2022/12/5','68.169.51.12','',NULL,'B76B5163DEF6AD96F2C1D41C376FEB77') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:manageFeatureDefinitions ss:/multilingual/manageFeatureDefinitions.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/manageFeatureDefinitions.do','','2022/12/5','68.169.51.12','',NULL,'2B3295207F485A97A90F63BCE644F47A') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 .. org.apache.struts.action.MODULE reservationForm org.apache.struts.action.mapping.instance org.apache.struts.taglib.tiles.CompContext org.apache.struts.action.MESSAGE javax.servlet.forward.query_string javax.servlet.forward.servlet_path javax.servlet.forward.context_path javax.servlet.forward.request_uri javax.servlet.include.servlet_path javax.servlet.include.context_path javax.servlet.include.request_uri .. country org.apache.struts.action.LOCALE SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'ADMIN FINCAS' OR tblUser.lngID = -1 .. org.apache.struts.action.MODULE org.apache.struts.action.mapping.instance org.apache.struts.taglib.tiles.CompContext org.apache.struts.action.MESSAGE javax.servlet.forward.query_string javax.servlet.forward.servlet_path javax.servlet.forward.context_path javax.servlet.forward.request_uri javax.servlet.include.servlet_path javax.servlet.include.context_path javax.servlet.include.request_uri .. country org.apache.struts.action.LOCALE SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'ADMIN FINCAS' OR tblUser.lngID = -1 meta:general_admin_fincas ss:/multilingual/general.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/general.do','','2022/12/5','68.169.51.12','',NULL,'65A8AADEB5002AD708342CA9A73349A9') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 SELECT lngID,txtCategory,intParentID,txtType,txtDescription,txtClass,boolActive FROM tblCategory WHERE intParentID = 403 ORDER BY txtDescription

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 UNABLE TO LOAD PARENT:0 SELECT lngID,txtCategory,intParentID,txtType,txtDescription,txtClass,boolActive FROM tblCategory WHERE intParentID = 403 ORDER BY txtDescription INIT SESSION HOUSES BY TOWN meta:filterHouses ss:/multilingual/filterHouses.do shuffling operacion::ALQUILER typeName::Suelo INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/filterHouses.do','','2022/12/5','68.169.51.12','',NULL,'D43C87046D103CBE4DD94B7262A98766') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:createHouse ss:/multilingual/buy_property_mallorca/createHouse.do

--

java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:191)
at MaiArch.Struts.ActionCreateBean.execute(ActionCreateBean.java:61)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:261)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
creating new null INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/buy_property_mallorca/createHouse.do','','2022/12/5','68.169.51.12','',NULL,'950A2F8C75889B7B53EB30348BF2D2FC') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:createHouse ss:/multilingual/buy_property_mallorca/createHouse.do

--

java.lang.ClassNotFoundException: WEBSITE
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1438)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1284)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:191)
at MaiArch.Struts.ActionCreateBean.execute(ActionCreateBean.java:61)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:524)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:261)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
creating new WEBSITE INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/buy_property_mallorca/createHouse.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/buy_property_mallorca/createHouse.do','24108F83DCA84480E9479DF72575E86D') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:createHouse ss:/multilingual/buy_property_mallorca/createHouse.do

--

java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:191)
at MaiArch.Struts.ActionCreateBean.execute(ActionCreateBean.java:61)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:261)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
creating new null INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/buy_property_mallorca/createHouse.do','','2022/12/5','68.169.51.12','',NULL,'24108F83DCA84480E9479DF72575E86D') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:generalAdmin_manual.index ss:/multilingual/generalAdmin.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/generalAdmin.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/listAllGalleries.do%3Bjsessionid=67687D1E6110DD44B9EA468CBFF8082D','2CFB1AC197EFE1AA94D3DB8CFC280474') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/generalAdmin.do%3Bjsessionid=1E6B92E9EDA57F668889CB6F5C2C60CD?content=manual.index','7C212E1462BA9579B8FCC0D6E815E960') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageLocations.do%3Bjsessionid=8801A8E17D1C8C4E13417F0406688683','8E5E5C196DDDB0EF0E743D1EA5BEA04C') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:manageFeatureDefinitions ss:/multilingual/manageFeatureDefinitions.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/manageFeatureDefinitions.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageFeatureDefinitions.do%3Bjsessionid=F7FB4A3411FCF6E0D63CD4623A66929B?dispatch=showAllFeatures&txtClass=MediaTools.Property.House','4F87F07A255CFA485C27913E6ABC4447') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageCategories.do%3Bjsessionid=5BE24F569ED65B3C4D94284B24789A78?typeName=PROPERTY_TYPE','4403FFFC3A5BC54B329A7D0089264FB0') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:changeLanguage ss:/multilingual/changeLanguage.do

--

java.lang.NullPointerException
at MaiArch.Struts.ChangeLanguage.execute(ChangeLanguage.java:52)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
changing country for: null INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/changeLanguage.do','','2022/12/5','68.169.51.12','',NULL,'2082504F7FEFFDB98B775DD3F9700D05') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:manageFeatureDefinitions ss:/multilingual/manageFeatureDefinitions.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/manageFeatureDefinitions.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageCategories.do%3Bjsessionid=6BFFF3A67BDE46CDC2E264403B71FACE?typeName=PROPERTY_TYPE','3FFB8B2D804DCBBDAA020734E3C29922') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:settingsManager_insufficientSecurity ss:/multilingual/settingsManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/settingsManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageLocations.do%3Bjsessionid=A8EC99EB1B98539D99D82F75AF4C454D','4D186707B4A73157FC7374214D7D5222') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/generalAdmin.do%3Bjsessionid=4208B6BDEC16B4725B5B8625839E9A47?content=manual.index','24EF93BC21B7224F6A008EE57F403303') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:processLoginForm_badLogin ss:/multilingual/processLoginForm.do SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'martin@allmydates.com' OR tblUser.lngID = -1 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'madeleine' OR tblUser.lngID = -1 INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/processLoginForm.do','','2022/12/5','68.169.51.12','',NULL,'00FAC6C83B7CFF7CB516398BFBCE8A47') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:generalAdmin_manual.index ss:/multilingual/generalAdmin.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/generalAdmin.do','','2022/12/5','68.169.51.12','',NULL,'ACD0E1DE5C84CF2E11E9FBED8D706ED8') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.lang.ArrayIndexOutOfBoundsException: 0 >= 0
at java.util.Vector.elementAt(Vector.java:447)
at MaiArch.Struts.Tags.OptionsRenderer.doStartTag(OptionsRenderer.java:92)
at org.apache.jsp.jsp.include.buscadorWide_jsp._jspService(buscadorWide_jsp.java:424)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:508)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
SELECT lngID,txtCategory,intParentID,txtType,txtDescription,txtClass,boolActive FROM tblCategory WHERE intParentID = 432 ORDER BY txtDescription

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:482)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119

--

java.lang.ArrayIndexOutOfBoundsException: 0 >= 0
at java.util.Vector.elementAt(Vector.java:447)
at MaiArch.Struts.Tags.OptionsRenderer.doStartTag(OptionsRenderer.java:92)
at org.apache.jsp.jsp.include.buscador_jsp._jspService(buscador_jsp.java:415)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.showHouses_jsp._jspService(showHouses_jsp.java:475)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
SELECT lngID,txtCategory,intParentID,txtType,txtDescription,txtClass,boolActive FROM tblCategory WHERE intParentID = 432 ORDER BY txtDescription INIT SESSION HOUSES BY TOWN meta:filterHouses ss:/multilingual/filterHouses.do shuffling operacion::ALQUILER typeName::Parking INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/filterHouses.do','','2022/12/5','68.169.51.12','',NULL,'87989D5FCCDB0259152DC6E57918D445') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:generalAdmin_manual.index ss:/multilingual/generalAdmin.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/generalAdmin.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/listAllGalleries.do%3Bjsessionid=6D02C7ABE40EF4AA22E96563705620DD','69F64C8BE46AF167786AC169B04DDED7') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 .. org.apache.struts.action.MODULE reservationForm org.apache.struts.action.mapping.instance org.apache.struts.taglib.tiles.CompContext org.apache.struts.action.MESSAGE javax.servlet.forward.query_string javax.servlet.forward.servlet_path javax.servlet.forward.context_path javax.servlet.forward.request_uri javax.servlet.include.servlet_path javax.servlet.include.context_path javax.servlet.include.request_uri .. country org.apache.struts.action.LOCALE SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'SEGUROS' OR tblUser.lngID = -1 .. org.apache.struts.action.MODULE org.apache.struts.action.mapping.instance org.apache.struts.taglib.tiles.CompContext org.apache.struts.action.MESSAGE javax.servlet.forward.query_string javax.servlet.forward.servlet_path javax.servlet.forward.context_path javax.servlet.forward.request_uri javax.servlet.include.servlet_path javax.servlet.include.context_path javax.servlet.include.request_uri .. country org.apache.struts.action.LOCALE SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'SEGUROS' OR tblUser.lngID = -1 meta:general_dept_juridicio ss:/multilingual/general.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/general.do','','2022/12/5','68.169.51.12','',NULL,'BC150542BABA5E1844513DED9228F81D') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/generalAdmin.do%3Bjsessionid=8F2C4CFBF984B2D0732B3E8B98D0B47F?content=manual.index','320728C99A7FF7E3A2722A7D689A7921') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/manageCategories.do%3Bjsessionid=BF23D4092FF607C93D5564DFBF595DBF?typeName=PROPERTY_TYPE','BC6A393772FD7B6A7BEBBCDB7E42377E') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:templateManager_insufficientSecurity ss:/multilingual/templateManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/templateManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/listAllGalleries.do%3Bjsessionid=7CD2DE062BFB9CFE5BB44CC99AD5C45A','DA0B65814A3A67CA48EE5E18F4A1C7B8') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:settingsManager_insufficientSecurity ss:/multilingual/settingsManager.do /insufficientSecurity.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/settingsManager.do','','2022/12/5','68.169.51.12','','http://www.vallsinmobiliaria.com/multilingual/generalAdmin.do%3Bjsessionid=8015E27FDD2C739ACBEA862814883B75?content=manual.index','563C76558BD351DB2882FF00653793B0') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.mainPublic_jsp._jspService(mainPublic_jsp.java:483)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.mainPublic_jsp._jspService(mainPublic_jsp.java:483)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 INIT SESSION HOUSES BY TOWN meta:map ss:/multilingual/map.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/map.do','','2022/12/5','68.169.51.12','',NULL,'38172241535B0FC2083E8106FEA60DFC') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:general_admin_fincas ss:/multilingual/general.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/general.do','','2022/12/5','68.169.51.12','',NULL,'C4CA50CE566BEAE885EEEC7F79A84577') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)

--

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getNativeFloat(ResultSet.java:3622)
at com.mysql.jdbc.ResultSet.getFloat(ResultSet.java:2203)
at MediaTools.Property.House.ejbLoad(House.java:491)
at MediaTools.Property.House.(House.java:212)
at MediaTools.Property.House.ejbFindByPrimaryKey(House.java:219)
at org.apache.jsp.jsp.include.featured_jsp._jspService(featured_jsp.java:98)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:565)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:493)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:965)
at org.apache.jsp.jsp.layouts.index_jsp._jspService(index_jsp.java:546)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:274)
at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:254)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:309)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1480)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:506)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at MaiArch.Struts.Filters.MultiLingualURLManipulator.doFilter(MultiLingualURLManipulator.java:271)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:881)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:674)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:701)
ERROR trying to load house 4119 meta:homeAction ss:/multilingual/homeAction.do INSERT INTO tblWebLog (txtDocument, txtResource, dtmDate, txtIP, tblUserTxtID, txtReferrer,txtSessionID ) VALUES ('/multilingual/homeAction.do','','2022/12/5','68.169.51.12','',NULL,'833FD9BB1A01F6320064DBC2F18684B4') ERROR Runing SQL com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'dtmDate' at row 1 meta:manageCustomers ss:/multilingual/manageCustomers no Field Layouts found for SQL MaiArch.Contact.Person WebServer 1927 found SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '78012' OR tblUser.lngID = 78012 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '91870' OR tblUser.lngID = 91870 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '18333' OR tblUser.lngID = 18333 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'WebServer' OR tblUser.lngID = -1 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '5191' OR tblUser.lngID = 5191 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '94118' OR tblUser.lngID = 94118 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = 'SEGUROS' OR tblUser.lngID = -1 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '83385' OR tblUser.lngID = 83385 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '83203' OR tblUser.lngID = 83203 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '60557' OR tblUser.lngID = 60557 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '34329' OR tblUser.lngID = 34329 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '45846' OR tblUser.lngID = 45846 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '48726' OR tblUser.lngID = 48726 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '76130' OR tblUser.lngID = 76130 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '56452' OR tblUser.lngID = 56452 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '16424' OR tblUser.lngID = 16424 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '26279' OR tblUser.lngID = 26279 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '31989' OR tblUser.lngID = 31989 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '44984' OR tblUser.lngID = 44984 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '36305' OR tblUser.lngID = 36305 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '84581' OR tblUser.lngID = 84581 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '31358' OR tblUser.lngID = 31358 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '68937' OR tblUser.lngID = 68937 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '76612' OR tblUser.lngID = 76612 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '15339' OR tblUser.lngID = 15339 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '81936' OR tblUser.lngID = 81936 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '91018' OR tblUser.lngID = 91018 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '30338' OR tblUser.lngID = 30338 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '23799' OR tblUser.lngID = 23799 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '7617' OR tblUser.lngID = 7617 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEmailPassword AS tblUserTxtEmailPassword, tblUser.lngID AS tblUserlngID, tblUser.dtmLastLogin AS tblUserDtmLastLogin, tblUser.tblUserTxtID AS tblUserTblUserTxtID, tblUser.tblUserLevelTxtID AS tblUserTblUserLevelTxtID, tblUserLevel.intLevel AS tblUserLevelIntLevel, tblUserLevel.txtID AS tblUserLevelTxtID FROM tblUser LEFT JOIN tblUserLevel ON tblUser.tblUserLevelTxtID = tblUserLevel.txtID WHERE tblUser.txtID = '58382' OR tblUser.lngID = 58382 SELECT tblUser.txtID AS tblUserTxtID, tblUser.txtPassword AS tblUserTxtPassword, tblUser.txtName AS tblUserTxtName, tblUser.txtEmail AS tblUserTxtEmail, tblUser.txtEma