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.
This seems to be because the biblio table on my database is MyISAM, and so forcing it to InnoDB causes breakage.
This appears to be a problem at my end, rather than with koha. Cancelling.
Also in older mysql, it was TYPE=InnoDB, and in later ENGINE=InnoDB Just in case that was the issue