Login

mvnForum

mvnForum Homepage Welcome Guest
  Search  
  Index  | Recent Threads  | Unanswered Threads  | List Polls  | Public Albums  | Who's Online  | Help

  mvnForum
  Category: mvnForum
  Forum: Installation & Upgrade
  Thread: Unable to install in Mysql

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 513 times and has 3 replies Next Thread
Female saravvij
Stranger




Joined: Oct 2, 2008
Post Count: 2
Status: Offline
Reply to this Post  Reply with Quote 
Unable to install in Mysql
Hello,

I installed forum code in Tomcat and ran the mvnad_mysql.sql script in mysql db. When I run the tomcat, I get the below error in console,

2008-10-02 03:28:36,612 ERROR [Thread-1] jdbc.MemberDAOImplJDBC (MemberDAOImplJDBC.java:1292) -
Sql Execution Error!
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mvnforum.mvnforummember' doesn't e
xist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1888)
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getNumberOfMembers(MemberDAOImplJDBC.java:1288)
at com.mvnforum.service.impl.MvnForumLifeCycleServiceImplDefault.contextInitialized(MvnForum
LifeCycleServiceImplDefault.java:111)
at com.mvnforum.MVNForumContextListener.contextInitialized(MVNForumContextListener.java:89)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2008-10-02 03:28:36,622 FATAL [Thread-1] impl.MvnForumLifeCycleServiceImplDefault (MvnForumLifeCycle
ServiceImplDefault.java:128) - Error while access database. Please correct it first.
net.myvietnam.mvncore.exception.DatabaseException: Error executing SQL in MemberDAOImplJDBC.getNumbe
rOfMembers.
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getNumberOfMembers(MemberDAOImplJDBC.java:1293)
at com.mvnforum.service.impl.MvnForumLifeCycleServiceImplDefault.contextInitialized(MvnForum
LifeCycleServiceImplDefault.java:111)
at com.mvnforum.MVNForumContextListener.contextInitialized(MVNForumContextListener.java:89)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:924)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:887)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1147)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2008-10-02 03:28:36,622 DEBUG [Thread-1] impl.MvnForumLifeCycleServiceImplDefault (MvnForumLifeCycle
ServiceImplDefault.java:133) - Schedule the WatchSendTask
2008-10-02 03:28:36,642 DEBUG [Thread-1] mvnforum.MVNForumConfig (MVNForumConfig.java:231) -


When I go back and look at mysql data base, the table mvnforummember does not exist, there is no script provided in the mysql script file to create this table, can anyone please help me to solve this issue.

Thanks.
Sarav
[Oct 2, 2008 7:45:25 AM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2956
Status: Offline
Reply to this Post  Reply with Quote 
Re: Unable to install in Mysql
Please also run sql script mvnForum_mysql.sql
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[Oct 20, 2008 8:01:33 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 
Female saravvij
Stranger




Joined: Oct 2, 2008
Post Count: 2
Status: Offline
Reply to this Post  Reply with Quote 
Re: Unable to install in Mysql
Yes, I have run mysql script. Looks like, the script does not include this table mvnforummember. Can you please help?
[Oct 20, 2008 1:25:33 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2956
Status: Offline
Reply to this Post  Reply with Quote 
Re: Unable to install in Mysql
I am sure that sql script mvnForum_mysql.sql include table mvnforumMember, please check again
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[Oct 28, 2008 6:58:40 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 
Show Printable Version of Thread  Post new Thread

RSS feeds Current timezone is GMT
Jan 8, 2009 5:39:58 PM

Powered by mvnForum Portlet 1.2 GA (Build: 27 June 2008)
Copyright © 2002-2008 by MyVietnam.net