[Koha-bugs] [Bug 7957] Routing lists: manage several routing list for each subscription, and export them as CSV

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #6 from Frédéric Demians <frederic at tamil.fr> ---
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.