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

Reply via email to