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/
