Thanks Sergiu for your help. I'll go with the second approach. -----Original Message----- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Sergiu Dumitriu Sent: Wednesday, October 12, 2011 21:44 PM To: XWiki Users Subject: Re: [xwiki-users] Upgrade to 3.2 minor issues
On 10/12/2011 06:02 AM, coldserenity wrote: > >> Could you upgrade the version of MySQL used? > I can try to but that might take me couple of days since I'm not a > MySQL guru > >> Is the activitystream_events table correctly set up with utf8 encoding? >> Are the other tables using InnoDB or MyISAM? > I have attached the file > http://xwiki.475771.n2.nabble.com/file/n6884313/XwikiDatabaseCollation > sAndEngines.txt XwikiDatabaseCollationsAndEngines.txt with > engines/collations/encodings information. > All of tables are on UTF8 but it turns out that all tables of my XWiki > use 'MyISAM' engine except for 'activitystream_events_params' which > uses 'InnoDB'. I have a strong feeling that's not how it should have been. > Can this issue be also related to changing the hibernate dialect from > 'org.hibernate.dialect.MySQLDialect' to > 'org.hibernate.dialect.MySQL5InnoDBDialect'? > Yes, and my main suspect is the fact that MySQL doesn't support linking two types of tables with a foreign key. You can do two things: 1. Change the configuration back to MySQLDialect, drop the activitystream_events_params table, restart XWiki. 2. Change all the other tables to use the InnoDB engine, with a statement like this for each table: alter table xwikircs ENGINE=InnoDB; For the future, 2 is better. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
