Bug 7587 - Wrong table name for local cover images
Summary: Wrong table name for local cover images
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: 3.8
Hardware: All All
: P1 - high enhancement (vote)
Assignee: Jared Camins-Esakov
QA Contact: Ian Walls
URL:
Keywords:
Depends on:
Blocks: 1633
  Show dependency treegraph
 
Reported: 2012-02-23 18:27 UTC by Katrin Fischer
Modified: 2013-12-05 20:01 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Bug 7587: Fix table name for biblioimages table (2.49 KB, patch)
2012-03-09 12:40 UTC, Jared Camins-Esakov
Details | Diff | Splinter Review
[SIGNED-OFF] Bug 7587: Fix table name for biblioimages table (2.70 KB, patch)
2012-03-10 17:48 UTC, Katrin Fischer
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
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