... |
... |
@@ -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 |
+ |