12 Oct
2011
12 Oct
'11
8:43 p.m.
On 10/12/2011 06:02 AM, coldserenity wrote:
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/
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/XwikiDatabaseCollationsAndE…
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'?