[Bug 18836] New: Patron login is erroring out after failing to find table
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Bug ID: 18836 Summary: Patron login is erroring out after failing to find table Change sponsored?: --- Product: Koha Version: 17.05 Hardware: Macintosh OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: CJSH@CJSHayward.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com (Checked the Wiki, tried chat, and searched bugs before reporting.) I tried to log in as a user and got: Software error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 260 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. The VirtualHost below is the only one listening on its special port: Listen 7026 # OPAC <VirtualHost *:7026> <IfVersion >= 2.4> Define instance "library" </IfVersion> Include /etc/koha/apache-shared.conf # Include /etc/koha/apache-shared-disable.conf # Include /etc/koha/apache-shared-opac-plack.conf Include /etc/koha/apache-shared-opac.conf ServerName library.myDNSname.org SetEnv KOHA_CONF "/etc/koha/sites/library/koha-conf.xml" AssignUserID library-koha library-koha ErrorLog /var/log/koha/library/opac-error.log # TransferLog /var/log/koha/library/opac-access.log # RewriteLog /var/log/koha/library/opac-rewrite.log </VirtualHost> What can I do to either create missing tables like koha_libary.club_enrollments, or mark them as not needed for the patron screen to do its work? Thanks, C.J.S. Hayward https://CJSHayward.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Did you have any errors running the web installer? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #2 from C.J.S. Hayward <CJSH@CJSHayward.com> --- I don't remember seeing errors. Would it make sense to wipe the installation and re-run the installer, and if so, how can I do that? Thx, -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- You could create and try with another instance - this might be the easiest and you might be able to compare the 2 databases. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #4 from C.J.S. Hayward <CJSH@CJSHayward.com> --- Thank you; I tried and ran into an error. Ducked into chat, and they said a bugfix that might address my current difficulty is slated for announcement in the next few days. Thanks, -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I know ;) I was thinking of bug 18741 - it might be a fix, but I am not sure. Maybe someone else could run a test? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- We just got a report of a successful Koha installation in Ubuntu with 17.05. Made me wonder - which DBMS are you using? MySQL? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #7 from C.J.S. Hayward <CJSH@CJSHayward.com> --- I'm using MySQL on a Mint 18.1 VM running under VirtualBox on a Mac. Would it make sense to erase all traces of Koha installations and reinstall from scratch? If so, what do I need to do so Koha sees a clean slate? TIA, C.J.S. Hayward https://CJSHayward.com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #8 from C.J.S. Hayward <CJSH@CJSHayward.com> --- linux-tools monasterylibrary # mysql --version mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #9 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Ok, first thing: Don't use Mysql 5.7 - it won't work well with Koha, there are known problems with it. It's recommended to use MariaDB instead. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mtompset@hotmail.com --- Comment #10 from M. Tompsett <mtompset@hotmail.com> --- (In reply to C.J.S. Hayward from comment #7)
I'm using MySQL on a Mint 18.1 VM running under VirtualBox on a Mac. Would it make sense to erase all traces of Koha installations and reinstall from scratch?
No, it makes more sense to restart the VirtualBox image from scratch. Clean is important. I successfully installed Koha 17.05 on Linux Mint 18 (I used https://linuxmint.com/edition.php?id=217). I generally followed: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages I have updated the instructions to highlight the community's preference for MariaDB. Your use of specialized port suggests that you should read https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Appendix_A:_N... My test was a Name Based installation, as does following the dotted blue boxes (at least they are on my screen). DISCLAIMER: I make no claims about overall functionality, nor do I recommend the use of Linux Mint. Debian has the ability to add a Desktop. It makes no sense to me using Linux Mint, when you could choose GNOME, XFCE, or a couple others as part of the Debian installation. Any problems you are encountering are likely related to https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_... Particularly, the second option without the MySQL configuration tweak. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC|mtompset@hotmail.com | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Patron login is erroring |Table |out after failing to find |'koha_library.club_enrollme |table |nts' doesn't exist -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Magnus Enger <magnus@libriotech.no> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |magnus@libriotech.no --- Comment #11 from Magnus Enger <magnus@libriotech.no> --- (In reply to C.J.S. Hayward from comment #0)
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.club_enrollments' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 260
The problem is that the table 'koha_library.club_enrollments' does not exist. This is because MySQL 5.7 does not like the default value given to the "date_created" column: mysql> CREATE TABLE IF NOT EXISTS club_enrollments ( -> id int(11) NOT NULL AUTO_INCREMENT, -> club_id int(11) NOT NULL, -> borrowernumber int(11) NOT NULL, -> date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -> date_canceled timestamp NULL DEFAULT NULL, -> date_created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', -> date_updated timestamp NULL DEFAULT NULL, -> branchcode varchar(10) NULL DEFAULT NULL, -> PRIMARY KEY (id), -> KEY club_id (club_id), -> KEY borrowernumber (borrowernumber), -> KEY branchcode (branchcode), -> CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE, -> CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, -> CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; ERROR 1067 (42000): Invalid default value for 'date_created' MySQL 5.5 does not have any problems with the default value. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #12 from C.J.S. Hayward <CJSH@CJSHayward.com> --- Thank you. How do things stand after migrating the VM to use MariaDB? Thanks, -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Freddy Enrique <freddysky@outlook.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |freddysky@outlook.com --- Comment #13 from Freddy Enrique <freddysky@outlook.com> --- I ran into the same problem after updating Koha. what could be the possible solution? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 --- Comment #14 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Freddy, same question to you: Are you running MySQL 5.7 by chance? See here: https://wiki.koha-community.org/wiki/Koha_on_Debian#Debian_Packages_on_Koha -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|17.05 |master Depends on| |12461 Severity|normal |major Summary|Table |MySQL 5.7 - Table |'koha_library.club_enrollme |'koha_library.club_enrollme |nts' doesn't exist |nts' doesn't exist CC| |jonathan.druart@bugs.koha-c | |ommunity.org Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12461 [Bug 12461] Add patron clubs feature -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |17258 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMNIBUS] MySQL 5.7 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Paul Chau <chichau@optusnet.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chichau@optusnet.com.au --- Comment #15 from Paul Chau <chichau@optusnet.com.au> --- I am using ubuntu 16.04 The problem seems to be related to setting of sql-mode in /etc/mysql/mariadb.conf.d/50-server.cnf If anyone can confirm after changing sql-mode to other value like '' will allow clubenrollments to be created. Also somewhere from the net mentioned "SET SESSION sql_mode = '';" will help. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18836 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #16 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Will be fixed by bug 20144 *** This bug has been marked as a duplicate of bug 20144 *** -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org