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