[Koha-bugs] [Bug 8312] New: Bug 1633 causes an error when upgrading the database

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

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

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 8312
          Assignee: oleonard at myacpl.org
           Summary: Bug 1633 causes an error when upgrading the database
          Severity: major
    Classification: Unclassified
                OS: All
          Reporter: robin at catalyst.net.nz
          Hardware: All
            Status: NEW
           Version: rel_3_8
         Component: OPAC
           Product: Koha

This causes an error on upgrade:

[Tue Jun 26 04:58:51 2012] updatedatabase.pl: DBD::mysql::db do failed: Can't
create table 'koha_central.biblioimages' (errno: 150) at
/home/robin/kohaclones/ca/installer/data/mysql/updatedatabase.pl line 4634.

This SQL:

       CREATE TABLE `biblioimages` (
          `imagenumber` int(11) NOT NULL AUTO_INCREMENT,
          `biblionumber` int(11) NOT NULL,
          `mimetype` varchar(15) NOT NULL,      
          `imagefile` mediumblob NOT NULL, 
          `thumbnail` mediumblob NOT NULL,
          PRIMARY KEY (`imagenumber`),
          CONSTRAINT `bibliocoverimage_fk1` FOREIGN KEY (`biblionumber`)
REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8

doesn't work unless everything after 'ENGINE' is ommitted.

-- 
You are receiving this mail because:
You are watching all bug changes.