[Bug 7587] New: Wrong table name for local cover images
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Bug #: 7587 Summary: Wrong table name for local cover images Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: critical Priority: P5 - low Component: Architecture, internals, and plumbing AssignedTo: gmcharlt@gmail.com ReportedBy: katrin.fischer@bsz-bw.de QAContact: koha.sekjal@gmail.com 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |P1 - high CC| |jcamins@cpbibliography.com Assignee|gmcharlt@gmail.com |jcamins@cpbibliography.com -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 --- Comment #1 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- Created attachment 8117 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8117&action=edit 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #8117|0 |1 is obsolete| | --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 8148 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8148&action=edit [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 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Ian Walls <koha.sekjal@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA --- Comment #3 from Ian Walls <koha.sekjal@gmail.com> --- Deletes an unusable table and creates a usable replacement in it's place. Marking as Passed QA. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master CC| |paul.poulain@biblibre.com Version|master |rel_3_8 Blocks| |1633 Severity|critical |enhancement --- Comment #4 from Paul Poulain <paul.poulain@biblibre.com> --- It's a follow-up of an enhancement, so, even if it's a CRI fix, switching severity to ENH, and version to -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7587 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org