[xwiki-users] Installation problem

[Sergiu Dumitriu]

Sylvain Desbureaux wrote:
> Hi all,
> I tried to install xwiki with Jetty/MySQL  on a fedora core 8 server.
> I had some issues:
> * log4j*.jar must be put on the jetty lib and not on the xwiki lib
> * I had to remove  xerces*.jar
> 
> 
> Now, I have this fault (plus others, but I hope this is the key 
> exception): java.sql.BatchUpdateException: Data truncation: Out of range 
> value adjusted for column 'XWD_MINOREDIT' at row 1
>  Any idea why?
> 
> thnaks in advance,
> 
> Sylvain
> 

Hi,

I created http://jira.xwiki.org/jira/browse/XWIKI-1879 for this issue. 
It seems that a certain version of mysql, configured for a stricter sql 
mode, doesn't like the statement generated by hibernate. I think that 
"false" is not recognized as a valid bit(1) value, while in a lax sql 
mode (by default enabled in different versions of mysql), correctly 
converts it to 0.

Can you tell me the exact version of mysql you are using, and what is 
the result of "select @@sql_mode;"?

Sergiu