http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7957

--- Comment #6 from Frédéric Demians <[email protected]> ---
The above error arise because the new table and the existing one don't
have the same engine: InnoDB for the former, and MyISAM for the old.

This could be a solution:

 ALTER TABLE borrowers ENGINE = InnoDB;
 ALTER TABLE subscription ENGINE = InnoDB;

But I'm not sure it is good to force to InnoDB tables which may have
been in MyISAM for good reasons.

Another solution could be to modify updatedatabase.pl to set the new
table to the same engine as the related tables.

You can get it with:

  SELECT ENGINE
    FROM information_schema.TABLES
   WHERE TABLE_SCHEMA = DATABASE()
     AND TABLE_NAME = 'subscription'

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to