<
From version < 72.2 >
edited by Beat Burgener
on 2021/11/16
To version < 73.1
edited by Thomas Mortagne
on 2022/05/25
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.BeatBurgener
1 +XWiki.ThomasMortagne
Content
... ... @@ -67,7 +67,6 @@
67 67  <property name="connection.username">xwiki</property>
68 68  <property name="connection.password">xwiki</property>
69 69  <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
70 -<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
71 71  <property name="connection.useUnicode">true</property>
72 72  <property name="connection.characterEncoding">UTF-8</property>
73 73  {{/code}}
... ... @@ -162,6 +162,19 @@
162 162  In case the above script fails to convert some rows with "ERROR 1833 (HY000) at line 1: Cannot change column 'columnname': used in a foreign key constraint 'FK2bj2ghquiq79toomkvugw7iie' of table 'xwiki.tablename', you can drop the foreign keys, convert the columns and then restart xWiki. Hibernate will re-create the dropped indexes automatically.
163 163  )))
164 164  
164 +(% class="box infomessage" %)
165 +(((
166 +In case the above script fails with "ERROR 1118 (42000) at line 1: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
167 +xwikistatsvisit", you can use the following SQL statements to change tables column types to LONGTEXT to be able to convert the tables to utf8mb4.
168 +)))
169 +
170 +{{code}}
171 +ALTER TABLE activitystream_events MODIFY ase_url LONGTEXT, MODIFY ase_title LONGTEXT, MODIFY ase_body LONGTEXT, MODIFY ase_param1 LONGTEXT, MODIFY ase_param2 LONGTEXT, MODIFY ase_param3 LONGTEXT, MODIFY ase_param4 LONGTEXT, MODIFY ase_param5 LONGTEXT;
172 +ALTER TABLE xwikistatsreferer MODIFY XWR_REFERER LONGTEXT;
173 +ALTER TABLE xwikistatsvisit MODIFY XWV_USER_AGENT LONGTEXT, MODIFY XWV_COOKIE LONGTEXT;
174 +ALTER TABLE xwikipreferences MODIFY XWP_LEFT_PANELS LONGTEXT, MODIFY XWP_RIGHT_PANELS LONGTEXT, MODIFY XWP_DOCUMENT_BUNDLES LONGTEXT;
175 +{{/code}}
176 +
165 165  You can also look at [[this snippet to perform this conversion inside XWiki>>snippets:Extension.Migrate MySQL databases to utf8mb4]].
166 166  
167 167  == Convert from MyISAM to InnoDB ==

Get Connected