http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8312 Priority: P5 - low Change sponsored?: --- Bug ID: 8312 Assignee: oleonard@myacpl.org Summary: Bug 1633 causes an error when upgrading the database Severity: major Classification: Unclassified OS: All Reporter: robin@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.