Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -63,3 +63,23 @@
63	63	mysql -u xwiki -p xwiki -h 127.0.0.1 < mycommands.sql
64	64	{code}
65	65
	66	+1.1.1 Data Truncation Error
	67	+
	68	+If you receive an Exception like the following while installing / upgrading XWiki:
	69	+
	70	+{code}
	71	+Caused by: java.sql.BatchUpdateException: Data truncation: Out of
	72	+range value adjusted for column 'XWD_HIDDEN' at row 1
	73	+ at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:894)
	74	+ at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
	75	+ at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
	76	+ at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
	77	+ at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
	78	+{code}
	79	+
	80	+chances are, that you are using an outdated version of MySQLConnectorJ.
	81	+
	82	+On Linux, mysql-connector-java-3.1.14-bin.jar has proven *not* to work due to a bug in the handling of UTF-8.
	83	+
	84	+Upgrade to the latest version of MySQLConnectorJ should solve such an error in most of the cases.
	85	+