Bug 7587

Summary: Wrong table name for local cover images
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: Architecture, internals, and plumbingAssignee: Jared Camins-Esakov <jcamins>
Status: CLOSED FIXED QA Contact: Ian Walls <koha.sekjal>
Severity: enhancement    
Priority: P1 - high CC: jcamins, paul.poulain
Version: 3.8   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 1633    
Attachments: Bug 7587: Fix table name for biblioimages table
[SIGNED-OFF] Bug 7587: Fix table name for biblioimages table

Description Katrin Fischer 2012-02-23 18:27:37 UTC
While testing I noticed lots of error messages in my logs and tracked it down to a big difference in updatedatabase.pl vs. kohastructure.sql.

While kohastructure has
2679 CREATE TABLE `bibliocoverimage` (

updatedatabase is
4631         q|CREATE TABLE `biblioimages` (

Opac error logs:
[Thu Feb 23 07:54:26 2012] [error] [client 127.0.0.1] [Thu Feb 23 07:54:26 2012] opac-detail.pl: DBD::mysql::st execute failed: Table 'koha.biblioimages' doesn't exist at /home/katrin/kohaclone/C4/Images.pm line 127., referer: http://localhost/cgi-bin/koha/opac-search.pl?q=der
[Thu Feb 23 07:54:26 2012] [error] [client 127.0.0.1] [Thu Feb 23 07:54:26 2012] opac-detail.pl: Database error! at /home/katrin/kohaclone/C4/Images.pm line 128., referer: http://localhost/cgi-bin/koha/opac-search.pl?q=der
[Thu Feb 23 07:54:26 2012] [error] [client 127.0.0.1] [Thu Feb 23 07:54:26 2012] opac-image.pl: DBD::mysql::st execute failed: Table 'koha.biblioimages' doesn't exist at /home/katrin/kohaclone/C4/Images.pm line 127., referer: http://localhost/cgi-bin/koha/opac-detail.pl?biblionumber=21
[Thu Feb 23 07:54:26 2012] [error] [client 127.0.0.1] [Thu Feb 23 07:54:26 2012] opac-image.pl: Database error! at /home/katrin/kohaclone/C4/Images.pm line 128., referer: http://localhost/cgi-bin/koha/opac-detail.pl?biblionumber=21
Comment 1 Jared Camins-Esakov 2012-03-09 12:40:14 UTC Comment hidden (obsolete)
Comment 2 Katrin Fischer 2012-03-10 17:48:38 UTC
Created attachment 8148 [details] [review]
[SIGNED-OFF] Bug 7587: Fix table name for biblioimages table

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.

Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
1) Checked a broken installation with wrong table name.
2) Checked for a new installation
Feature works perfectly.

http://bugs.koha-community.org/show_bug.cgi?id=7487
Comment 3 Ian Walls 2012-03-12 10:14:14 UTC
Deletes an unusable table and creates a usable replacement in it's place.  Marking as Passed QA.
Comment 4 Paul Poulain 2012-03-13 14:58:42 UTC
It's a follow-up of an enhancement, so, even if it's a CRI fix, switching severity to ENH, and version to