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 <[email protected]>:
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 [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users