Hi Sergiu Dumitriu,
Thank you for you reply. But I still can't resolve my problem.
Others
Importing SQL commands into your MySQL database
Execute the following:
mysql -u xwiki -p xwiki -h 127.0.0.1 < mycommands.sql
I have creat a database which name is xwiki. and I also create a xwiki/xwiki
and grant all priviledge to it. except the top script. In fact, I don't know
why I need it. maybe it's just addition.
I also guess the xwiki will import database when it start. but in mu trace,
there are nothing about this.
Deleted entity synthetic identifier rollback: disabled
Default entity-mode: pojo
Named query checking : enabled
building session factory
Not binding factory to JNDI, no JNDI name configured
Updating schema update for wiki [xwiki]...
Using dialect: org.hibernate.dialect.MySQLDialect
Failed updating schema while executing query [update xwikidoc set
xwd_translation=0 where xwd_translation is null]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'xwiki.xwikidoc'
doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
I think the green background is the hibernate init, and then, the error
occur. Why there are no action for import database between the two script?
thanks
Jing Shen
2008/5/30, Sergiu Dumitriu <sergiu(a)xwiki.com>om>:
jing shen wrote:
I use tomcat and mysql to install xwiki. I choose
war file to deploy. But
after I finish the configure and visit the link(
http://localhost:8080/xwiki/
).
The error occur. I think maybe because I do not import the database
schema. But I can't find it in the war file.
As stated on
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL
you should run:
create database xwiki
grant all privileges on xwiki.* to xwiki(a)127.0.0.1 identified by 'xwiki'
XWiki creates its tables when started, there's no need to import any
schema. It just needs the right to do that.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users