Thread: Problem with groups in 0.4beta

Originally Posted by bagu

EDIT : there is a problem with the mysql files...Because, i make a backup of my database, i drop everything, then reload mysql.initial.sql and then some updates of mysql.update.sql and everything work well now...

I'm having the same problem. I did execute the SQL statements in mysql.update.sql.
My users and contacts tables are myISAM. It seems they changed the storage engine between 0.1.1 and 0.2 stable in the mysql.initial.sql file, but there's no 'alter table ... engine=innodb' in the mysql.update.sql files. So unless I'm missing something, there is a problem with the mysql files.

I've just had this problem myself, and after opening a ticket (#1486794) alec pointed me in the right direction to solve it. If you're upgrading from an older version, your tables might be using the MyISAM engine - and RC requires InnoDB. Having tables using different engines causes all sorts of exciting problems!


This can be fixed by using:

ALTER TABLE {tablename} TYPE=InnoDB;

replacing {tablename} with each table in your RC database in turn to convert them all to InnoDB.

(do it on a copy of the DB first, just to be safe!)

same problem, i have solved with:

ALTER TABLE `cache` ENGINE=InnoDB;
ALTER TABLE `session` ENGINE=InnoDB;
ALTER TABLE `messages` ENGINE=InnoDB;
ALTER TABLE `users` ENGINE=InnoDB;
ALTER TABLE `contacts` ENGINE=InnoDB;
ALTER TABLE `identities` ENGINE=InnoDB;