[Koha-bugs] [Bug 1368] FOREIGN KEY on categorycode fails during install

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1368


galen.charlton at liblime.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |galen.charlton at liblime.com




------- Comment #15 from galen.charlton at liblime.com  2007-12-24 14:39 -------
I have submitted a patch to remove use of SET FOREIGN_KEY_CHECKS = 1 from the
web installer and its SQL scripts.  I have verified that the current English
and French MARC21 and UNIMARC script, plus optional scripts, all load without
error.

Dependencies between SQL scripts that I'm aware of include (all paths relative
to installer/data/mysql):

en/optional/sample_patron.sql depends on
  * en/optional/patron_categories.sql
  * en/optional/sample_libraries.sql

fr/3-LecturePub/sample_itemtypes.sql excludes
  * fr/4-Conservation/sample_itemtypes.sql

fr/3-LecturePub/sample_itemtypes.sql excludes
  * fr/4-Conservation/sample_itemtypes.sql

Even if my patch is accepted, the bug should remain open, albeit at a lower
severity, because the installer should handle cases where the user does not
select *all* or *no* optional scripts, and thus needs to be smarter about
dependencies.  For example, nothing currently prevents the user from trying to
load sample patrons without loading the sample categories and libraries.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.