Bugzilla – Attachment 8117 Details for
Bug 7587
Wrong table name for local cover images
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7587: Fix table name for biblioimages table
Bug-7587-Fix-table-name-for-biblioimages-table.patch (text/plain), 2.49 KB, created by
Jared Camins-Esakov
on 2012-03-09 12:40:14 UTC
(
hide
)
Description:
Bug 7587: Fix table name for biblioimages table
Filename:
MIME Type:
Creator:
Jared Camins-Esakov
Created:
2012-03-09 12:40:14 UTC
Size:
2.49 KB
patch
obsolete
>From 99fef530a25d02c8b1acdc27e638458aaf439c37 Mon Sep 17 00:00:00 2001 >From: Jared Camins-Esakov <jcamins@cpbibliography.com> >Date: Fri, 9 Mar 2012 07:24:43 -0500 >Subject: [PATCH] Bug 7587: Fix table name for biblioimages table >Content-Type: text/plain; charset="UTF-8" > >The kohastructure.sql file had the wrong name for the biblioimages table, >which broke the local cover images feature for new installations, and filled >the log with error messages. >--- > installer/data/mysql/kohastructure.sql | 6 +++--- > installer/data/mysql/updatedatabase.pl | 19 +++++++++++++++++++ > 2 files changed, 22 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 9dbd032..153e17b 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2695,12 +2695,12 @@ CREATE TABLE `fieldmapping` ( -- koha to keyword mapping > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > -- >--- Table structure for table `bibliocoverimage` >+-- Table structure for table `biblioimages` > -- > >-DROP TABLE IF EXISTS `bibliocoverimage`; >+DROP TABLE IF EXISTS `biblioimages`; > >-CREATE TABLE `bibliocoverimage` ( >+CREATE TABLE `biblioimages` ( > `imagenumber` int(11) NOT NULL AUTO_INCREMENT, > `biblionumber` int(11) NOT NULL, > `mimetype` varchar(15) NOT NULL, >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 06eded1..4f2e424 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -4884,6 +4884,25 @@ Date due: <<issues.date_due>><br /> > SetVersion($DBversion); > } > >+$DBversion = "3.07.00.XXX"; >+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { >+ $dbh->do( >+ q|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| >+ ); >+ $dbh->do( q|DROP TABLE bibliocoverimage| ); >+ print >+"Upgrade to $DBversion done (Correct table name for local cover images[please disregard any error messages])\n"; >+ SetVersion($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 DropAllForeignKeys($table) >-- >1.7.2.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 7587
:
8117
|
8148