|
Mantis - Resin
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 1221 | minor | always | 06-28-06 09:58 | 06-28-06 19:03 | |
|
|
|||||
| Reporter: | artem | Platform: | |||
| Assigned To: | ferg | OS: | |||
| Priority: | normal | OS Version: | |||
| Status: | closed | Product Version: | 3.0.19 | ||
| Product Build: | Resolution: | fixed | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | 3.0.20 | ||
|
|
|||||
| Summary: | 0001221: reopen issue 0001188. more details. mysql SELECT * from table1 | ||||
| Description: |
I added <log name="" level="all" path="logs/error.log" timestamp="[%H:%M:%S.%s] "/> to conf file. It showed following error on "select * from table1" query. [19:49:07.781] java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date [19:49:07.781] at com.mysql.jdbc.ResultSet.getDateFromString(ResultSet.java:1963) [19:49:07.781] at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:4874) [19:49:07.781] at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4739) [19:49:07.781] at com.caucho.quercus.lib.db.JdbcResultResource.getColumnValue(JdbcResultResource.java:1009) [19:49:07.781] at com.caucho.quercus.lib.db.JdbcResultResource.fetchArray(JdbcResultResource.java:911) [19:49:07.781] at com.caucho.quercus.lib.db.MysqliResult.fetch_array(MysqliResult.java:90) [19:49:07.781] at com.caucho.quercus.lib.db.MysqlModule.mysql_fetch_array(MysqlModule.java:257) [19:49:07.781] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [19:49:07.781] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [19:49:07.781] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [19:49:07.781] at java.lang.reflect.Method.invoke(Method.java:585) [19:49:07.781] at com.caucho.quercus.module.StaticFunction.invoke(StaticFunction.java:114) [19:49:07.781] at com.caucho.quercus.env.JavaInvoker.call(JavaInvoker.java:531) [19:49:07.781] at com.caucho.quercus.env.JavaInvoker.call(JavaInvoker.java:404) [19:49:07.781] at com.caucho.quercus.env.JavaInvoker.call(JavaInvoker.java:390) [19:49:07.781] at com.caucho.quercus.env.JavaInvoker.callCopy(JavaInvoker.java:399) [19:49:07.781] at com.caucho.quercus.expr.FunctionExpr.evalImpl(FunctionExpr.java:179) [19:49:07.781] at com.caucho.quercus.expr.FunctionExpr.evalCopy(FunctionExpr.java:150) [19:49:07.781] at com.caucho.quercus.expr.AssignExpr.eval(AssignExpr.java:80) [19:49:07.781] at com.caucho.quercus.expr.Expr.evalBoolean(Expr.java:443) [19:49:07.781] at com.caucho.quercus.program.WhileStatement.execute(WhileStatement.java:62) [19:49:07.781] at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:112) [19:49:07.781] at com.caucho.quercus.program.QuercusProgram.execute(QuercusProgram.java:264) [19:49:07.781] at com.caucho.quercus.page.InterpretedPage.execute(InterpretedPage.java:71) [19:49:07.781] at com.caucho.quercus.page.QuercusPage.executeTop(QuercusPage.java:122) [19:49:07.781] at com.caucho.quercus.servlet.QuercusServlet.service(QuercusServlet.java:237) [19:49:07.781] at javax.servlet.http.HttpServlet.service(HttpServlet.java:92) [19:49:07.781] at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106) [19:49:07.781] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178) [19:49:07.781] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229) [19:49:07.781] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268) [19:49:07.781] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:402) [19:49:07.781] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:507) [19:49:07.781] at com.caucho.util.ThreadPool.run(ThreadPool.java:433) [19:49:07.781] at java.lang.Thread.run(Thread.java:595) It seems it does not work well with dates. May be new Date('0000-00-00') does not work well. |
||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Relationships | |||||
| Attached Files: | |||||
| Notes | |||||
|
|
|||||
|
|
||||