[Bug 7796] New: C4/VirtualShelves.pm needs globally scoped $dbh for plack
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7796 Priority: P5 - low Change sponsored?: --- Bug ID: 7796 Assignee: gmcharlt@gmail.com Summary: C4/VirtualShelves.pm needs globally scoped $dbh for plack QA Contact: koha.sekjal@gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: dpavlin@rot13.org Hardware: All Status: NEW Version: rel_3_8 Component: Virtual Shelves Product: Koha -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7796 --- Comment #1 from Dobrica Pavlinusic <dpavlin@rot13.org> --- Created attachment 8499 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8499&action=edit Bug 7796 - C4/VirtualShelves.pm needs globally scoped $dbh for plack otherwise, we get a lot of "MySQL server has gone away" error messages -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7796 Dobrica Pavlinusic <dpavlin@rot13.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Blocks| |7172 Assignee|gmcharlt@gmail.com |dpavlin@rot13.org -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7796 Dobrica Pavlinusic <dpavlin@rot13.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #8499|0 |1 is obsolete| | --- Comment #2 from Dobrica Pavlinusic <dpavlin@rot13.org> --- Created attachment 8531 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8531&action=edit Bug 7796 - C4/VirtualShelves.pm $dbh plack scoping we get a lot of "MySQL server has gone away" error messages and defining global $dbh isn't the best solution. Existing code gets $dbh from context in some subs, so this change makes it always use $dbh from context. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7796 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |alex.arnaud@biblibre.com --- Comment #3 from Alex Arnaud <alex.arnaud@biblibre.com> --- Dobrica, could you give me more details about how to reproduce the bug? I didn't get such errors when browsing shelves. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7796 Dobrica Pavlinusic <dpavlin@rot13.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |In Discussion --- Comment #4 from Dobrica Pavlinusic <dpavlin@rot13.org> --- It seems that I can't reproduce it right now (silly me for not recoording URL to example together with bug). I changed bug status and if I don't find it again this week, I will close it with WONTFIX -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7796 Dobrica Pavlinusic <dpavlin@rot13.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |RESOLVED Resolution|--- |INVALID --- Comment #5 from Dobrica Pavlinusic <dpavlin@rot13.org> --- Today, I got this error again. Accessing /cgi-bin/koha/catalogue/search.pl?idx=&q=human DBD::mysql::db selectall_arrayref failed: MySQL server has gone away at /srv/koha/C4/VirtualShelves.pm line 202. DBD::mysql::db selectall_arrayref failed: MySQL server has gone away at /srv/koha/C4/VirtualShelves.pm line 214. DBD::mysql::db selectall_arrayref failed: MySQL server has gone away at /srv/koha/C4/VirtualShelves.pm line 202. DBD::mysql::db selectall_arrayref failed: MySQL server has gone away at /srv/koha/C4/VirtualShelves.pm line 214. I have virtualshelves "allow" in syspreference. Even more interesting, after restart I got different error: DBD::mysql::db selectall_arrayref failed: Unknown column 'allow_add' in 'where clause' at /srv/koha/C4/VirtualShelves.pm line 202. DBD::mysql::db selectall_arrayref failed: Unknown column 'allow_add' in 'where clause' at /srv/koha/C4/VirtualShelves.pm line 214. Which got me thinking... I was using database from version 3.07.00.019 which explains why VirtualShelves which got changed in 3.07.00.032 didn't work. I'm closing this ticket, although I sould re-visit question why plack didn't force me to upgrade database to current version. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org