mvnForum Homepage Welcome Guest  |  Register  |  Login
Login Name Password
  Search  
  Index  | Recent Threads  | Unanswered Threads  | List Polls  | Public Albums  | Who's Online  | User List  | Help

This is the enterprise version of mvnForum. Click here to run in the portlet (JSR 168) mode. Detailed feature description of enterprise edition.


  mvnForum
  Category: mvnForum International Communities
  Forum: Spanish - Español
  Thread: MySQL 5.0.67 + mvnforum: Error al intentar leer

Quick Go »


No member browsing this thread
Thread Status: Active
Total posts in this thread: 4 		Post new Thread
Author
Previous Thread This topic has been viewed 1910 times and has 3 replies
yosoy
Stranger




Joined: Dec 26, 2008
Post Count: 2
Status: Offline
Reply to this Post  Reply with Quote 
MySQL 5.0.67 + mvnforum: Error al intentar leer
Me aparece el siguiente error cuando hago clic sobre un hilo (tema) del foro:

Error executing SQL in MemberDAOImplJDBC.getMember_forPublic(pk).


¿Saben a qué se debe?
¿Tienen alguna guía en español de como se instala el mvnForum?

Es que la persona que lo instalo ya no está aquí y yo es la primera vez que toco esto y no se por donde empezar a mirar.

Cualquier información me servirá, gracias.

Saludos.

PD.: tomcat 5.5, mysql 5 y opencms.
[Dec 26, 2008 12:21:57 PM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest [Link] Report threatening or abusive post: please login first  Go to top 
minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2998
Status: Offline
Reply to this Post  Reply with Quote 
Re: MySQL 5.0.67 + mvnforum: Error al intentar leer
Please post the stacktrace here and I will help you (please config log4j.properties first)
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[Jan 1, 2009 1:40:11 AM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest    http://www.MyVietnam.net    minhnn_mvn [Link] Report threatening or abusive post: please login first  Go to top 
yosoy
Stranger




Joined: Dec 26, 2008
Post Count: 2
Status: Offline
Reply to this Post  Reply with Quote 
Re: MySQL 5.0.67 + mvnforum: Error al intentar leer
stacktrace:

2078727243 DEBUG [http-80-Processor77] admin.AdminModuleProcessor - AdminModuleProcessor : responseURI = /mvnplugin/mvnforum/admin/error.jsp. (2 ms)
2078727248 DEBUG [http-80-Processor77] admin.ForumAdminServlet - ForumAdminServlet processed 120 times. Took 7 miliseconds.

2078867132 DEBUG [http-80-Processor77] admin.AdminModuleProcessor - AdminModuleProcessor : requestURI = /logout
2078867135 DEBUG [http-80-Processor77] admin.AdminModuleProcessor - AdminModuleProcessor : responseURI = /mvnplugin/mvnforum/admin/login.jsp. (3 ms)
2078867139 DEBUG [http-80-Processor77] admin.ForumAdminServlet - ForumAdminServlet processed 121 times. Took 7 miliseconds.

2078867343 DEBUG [http-80-Processor77] admin.AdminModuleProcessor - AdminModuleProcessor : requestURI = /null
2078867344 DEBUG [http-80-Processor77] admin.AdminModuleProcessor - AdminModuleProcessor : responseURI = /mvnplugin/mvnforum/admin/login.jsp. (1 ms)
2078867346 DEBUG [http-80-Processor77] admin.ForumAdminServlet - ForumAdminServlet processed 122 times. Took 3 miliseconds.

2078876320 DEBUG [http-80-Processor56] admin.AdminModuleProcessor - AdminModuleProcessor : requestURI = /loginprocess
2078876330 DEBUG [http-80-Processor56] admin.AdminModuleProcessor - AdminModuleProcessor : responseURI = /mvnforumadmin/null?. (10 ms)
2078876331 DEBUG [http-80-Processor56] admin.ForumAdminServlet - ForumAdminServlet processed 123 times. Took 11 miliseconds.

2078876440 DEBUG [http-80-Processor56] admin.AdminModuleProcessor - AdminModuleProcessor : requestURI = /null
2078876442 ERROR [http-80-Processor56] admin.AdminModuleProcessor - Exception: missing urlmap entry in admin module: requestURI = /null
2078876443 DEBUG [http-80-Processor56] admin.AdminModuleProcessor - AdminModuleProcessor : responseURI = /mvnplugin/mvnforum/admin/error.jsp. (3 ms)
2078876446 DEBUG [http-80-Processor56] admin.ForumAdminServlet - ForumAdminServlet processed 124 times. Took 6 miliseconds.

2078876622 DEBUG [http-80-Processor56] admin.AdminModuleProcessor - AdminModuleProcessor : requestURI = /null
2078876623 ERROR [http-80-Processor56] admin.AdminModuleProcessor - Exception: missing urlmap entry in admin module: requestURI = /null
2078876624 DEBUG [http-80-Processor56] admin.AdminModuleProcessor - AdminModuleProcessor : responseURI = /mvnplugin/mvnforum/admin/error.jsp. (2 ms)
2078876626 DEBUG [http-80-Processor56] admin.ForumAdminServlet - ForumAdminServlet processed 125 times. Took 4 miliseconds.

2078880545 DEBUG [http-80-Processor56] user.UserModuleProcessor - UserModuleProcessor : requestURI =
2078880546 DEBUG [http-80-Processor56] user.UserModuleProcessor - UserModuleProcessor : responseURI = /mvnforum/index. (1 ms)
2078880546 DEBUG [http-80-Processor56] user.ForumUserServlet - ForumUserServlet processed 3843 times. Took 1 miliseconds.

2078880634 DEBUG [http-80-Processor56] user.UserModuleProcessor - UserModuleProcessor : requestURI = /index
2078880644 DEBUG [http-80-Processor56] user.UserModuleProcessor - UserModuleProcessor : responseURI = /mvnplugin/mvnforum/user/index.jsp. (10 ms)
2078880651 DEBUG [http-80-Processor56] user.ForumUserServlet - ForumUserServlet processed 3844 times. Took 17 miliseconds.

2078887773 DEBUG [http-80-Processor80] user.UserModuleProcessor - UserModuleProcessor : requestURI = /viewthread
2078887777 ERROR [http-80-Processor80] jdbc.MemberDAOImplJDBC - Sql Execution Error!
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 11 to TIMESTAMP.
at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:6369)
at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6394)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2268)
at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2300)
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getMember_forPublic(MemberDAOImplJDBC.java:1202)
at com.mvnforum.user.PostWebHandler.prepareViewThread(PostWebHandler.java:1202)
at com.mvnforum.user.UserModuleProcessor.process(UserModuleProcessor.java:119)
at com.mvnforum.user.ForumUserServlet.process(ForumUserServlet.java:182)
at com.mvnforum.user.ForumUserServlet.doGet(ForumUserServlet.java:119)
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 net.myvietnam.mvncore.servlet.filter.CompressionFilter.doFilter(CompressionFilter.java:234)
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.valves.AccessLogValve.invoke(AccessLogValve.java:548)
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:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
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:595)
2078887778 ERROR [http-80-Processor80] user.UserModuleProcessor - Exception in UserModuleProcessor [net.myvietnam.mvncore.exception.DatabaseException] : Error executing SQL in MemberDAOImplJDBC.getMember_forPublic(pk).
net.myvietnam.mvncore.exception.DatabaseException: Error executing SQL in MemberDAOImplJDBC.getMember_forPublic(pk).
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getMember_forPublic(MemberDAOImplJDBC.java:1239)
at com.mvnforum.user.PostWebHandler.prepareViewThread(PostWebHandler.java:1202)
at com.mvnforum.user.UserModuleProcessor.process(UserModuleProcessor.java:119)
at com.mvnforum.user.ForumUserServlet.process(ForumUserServlet.java:182)
at com.mvnforum.user.ForumUserServlet.doGet(ForumUserServlet.java:119)
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 net.myvietnam.mvncore.servlet.filter.CompressionFilter.doFilter(CompressionFilter.java:234)
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.valves.AccessLogValve.invoke(AccessLogValve.java:548)
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:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
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:595)
2078887779 DEBUG [http-80-Processor80] user.UserModuleProcessor - UserModuleProcessor : responseURI = /mvnplugin/mvnforum/user/error.jsp. (6 ms)
2078887784 DEBUG [http-80-Processor80] user.ForumUserServlet - ForumUserServlet processed 3845 times. Took 11 miliseconds.

2078887936 DEBUG [http-80-Processor80] user.UserModuleProcessor - UserModuleProcessor : requestURI = /null
2078887936 ERROR [http-80-Processor80] user.UserModuleProcessor - Exception: missing urlmap entry in forum module: requestURI = /null
2078887937 DEBUG [http-80-Processor80] user.UserModuleProcessor - UserModuleProcessor : responseURI = /mvnplugin/mvnforum/user/error.jsp. (1 ms)
2078887940 DEBUG [http-80-Processor80] user.ForumUserServlet - ForumUserServlet processed 3846 times. Took 5 miliseconds.

¿Alguna idea?
[Jan 2, 2009 12:44:05 PM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest [Link] Report threatening or abusive post: please login first  Go to top 
minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2998
Status: Offline
Reply to this Post  Reply with Quote 
Re: MySQL 5.0.67 + mvnforum: Error al intentar leer
Hi, could you tell me what version of mvnForum are you running, and did you do any thing (such as upgrade mysql, upgrade mvnForum, run mvnForum upgrade script, etc) and then you got this error?
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[Jan 3, 2009 5:29:19 PM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest    http://www.MyVietnam.net    minhnn_mvn [Link] Report threatening or abusive post: please login first  Go to top 
Show Printable Version of Thread  Post new Thread

Google

RSS feeds Current timezone is GMT
Jul 4, 2009 11:56:39 PM

Powered by mvnForum Enterprise 1.3-dev (Build: 24 July 2008)
Copyright © 2002-2008 by MyVietnam.net