Koha upgrade 3.18.11 --> 3.20.07
I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised? The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3 . . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release) gcb ______________________ Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel@sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575 Washington State Library: Empowering 21st Century Washington
Hi Gary,
DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584.
I would say that the foreign key on course_reserves has not been created. You should check the data in course_items (some don't have a correspondence in course_reserves).
DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614.
You can forget this one, you already had the self_checkout syspref in your database. Regards, Jonathan 2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised?
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
. . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release)
gcb ______________________
Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel@sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575
Washington State Library: Empowering 21st Century Washington
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Correction: It comes from bug 14205 which has been pushed to 3.18.x and 3.20.x, so you already have the constraint (but double check!). You can also forget this one :) 2016-01-11 16:24 GMT+00:00 Jonathan Druart <jonathan.druart@bugs.koha-community.org>:
Hi Gary,
DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584.
I would say that the foreign key on course_reserves has not been created. You should check the data in course_items (some don't have a correspondence in course_reserves).
DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614.
You can forget this one, you already had the self_checkout syspref in your database.
Regards, Jonathan
2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised?
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
. . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release)
gcb ______________________
Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel@sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575
Washington State Library: Empowering 21st Century Washington
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hmmm... Using "SHOW CREATE TABLE course_reserves" returns... . . . PRIMARY KEY (`cr_id`), UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), KEY `course_id` (`course_id`), KEY `course_reserves_ibfk_2` (`ci_id`), CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), CONSTRAINT `course_reserves_ibfk_2` FOREIGN KEY (`ci_id`) REFERENCES `course_items` (`ci_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | The course reserves function is not enabled on this instance and both course_reserves and course_items are empty. Could it be updatedatabase.pl is expecting that function to be enabled and those tables to contain at least one item? I hate to admit it, but I don't see a line 10584 in updatedatabase.pl so it's difficult for me to determine what is throwing the error. gcb ______________________ Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588 Washington State Library: Empowering 21st Century Washington -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 8:24 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07 Hi Gary,
DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584.
I would say that the foreign key on course_reserves has not been created. You should check the data in course_items (some don't have a correspondence in course_reserves).
DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614.
You can forget this one, you already had the self_checkout syspref in your database. Regards, Jonathan 2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised?
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
. . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release)
gcb ______________________
Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel@sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575
Washington State Library: Empowering 21st Century Washington
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mys... It exploded because you already had the constraint (course_reserves_ibfk_2), so everything is fine. 2016-01-11 17:01 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
Hmmm...
Using "SHOW CREATE TABLE course_reserves" returns...
. . . PRIMARY KEY (`cr_id`), UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), KEY `course_id` (`course_id`), KEY `course_reserves_ibfk_2` (`ci_id`), CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), CONSTRAINT `course_reserves_ibfk_2` FOREIGN KEY (`ci_id`) REFERENCES `course_items` (`ci_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
The course reserves function is not enabled on this instance and both course_reserves and course_items are empty. Could it be updatedatabase.pl is expecting that function to be enabled and those tables to contain at least one item? I hate to admit it, but I don't see a line 10584 in updatedatabase.pl so it's difficult for me to determine what is throwing the error.
gcb ______________________
Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588
Washington State Library: Empowering 21st Century Washington
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 8:24 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
Hi Gary,
DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584.
I would say that the foreign key on course_reserves has not been created. You should check the data in course_items (some don't have a correspondence in course_reserves).
DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614.
You can forget this one, you already had the self_checkout syspref in your database.
Regards, Jonathan
2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised?
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
. . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release)
gcb ______________________
Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel@sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575
Washington State Library: Empowering 21st Century Washington
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hmmm...
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
I updated to Koha 3.20.07 this morning and the staff site is now exhibiting behavior related to Bug 15431 (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15431). After navigating to a patron with materials checked out, "Checkout(s)" at the bottom of the page shows "Loading..." indefinitely. Clicking on the "Check out" tab brings a pop-up message box " Loading…you may continue scanning.", but the checked out items never appear. I assume checkouts and returns continue to work. (There's no way to verify since the checkout information doesn't appear.) This does, however, make it difficult for them to renew materials for patrons. Any suggestions? gcb ______________________ Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588 Washington State Library: Empowering 21st Century Washington -----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 9:14 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07 http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mys... It exploded because you already had the constraint (course_reserves_ibfk_2), so everything is fine. 2016-01-11 17:01 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
Hmmm...
Using "SHOW CREATE TABLE course_reserves" returns...
. . . PRIMARY KEY (`cr_id`), UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), KEY `course_id` (`course_id`), KEY `course_reserves_ibfk_2` (`ci_id`), CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), CONSTRAINT `course_reserves_ibfk_2` FOREIGN KEY (`ci_id`) REFERENCES `course_items` (`ci_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
The course reserves function is not enabled on this instance and both course_reserves and course_items are empty. Could it be updatedatabase.pl is expecting that function to be enabled and those tables to contain at least one item? I hate to admit it, but I don't see a line 10584 in updatedatabase.pl so it's difficult for me to determine what is throwing the error.
gcb ______________________
Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588
Washington State Library: Empowering 21st Century Washington
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 8:24 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
Hi Gary,
DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584.
I would say that the foreign key on course_reserves has not been created. You should check the data in course_items (some don't have a correspondence in course_reserves).
DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614.
You can forget this one, you already had the self_checkout syspref in your database.
Regards, Jonathan
2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised?
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
. . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10614. Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release)
gcb ______________________
Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel@sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575
Washington State Library: Empowering 21st Century Washington
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've just done this exact same thing, and I used the patch from 15341 to patch the running system live. It should be fixed in 3.20.08. Nasty little bug, that. Liz On 13/01/16 12:42, Bortel, Gary wrote:
Hmmm...
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
I updated to Koha 3.20.07 this morning and the staff site is now exhibiting behavior related to Bug 15431 (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15431). After navigating to a patron with materials checked out, "Checkout(s)" at the bottom of the page shows "Loading..." indefinitely. Clicking on the "Check out" tab brings a pop-up message box " Loading…you may continue scanning.", but the checked out items never appear.
I assume checkouts and returns continue to work. (There's no way to verify since the checkout information doesn't appear.) This does, however, make it difficult for them to renew materials for patrons.
Any suggestions?
gcb ______________________
Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588
Washington State Library: Empowering 21st Century Washington
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 9:14 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/da ta/mysql/updatedatabase.pl;h=950ed2067dac0edd51cf5e49ff25862c6f53ecdb;hb =refs/heads/3.20.x#l10576
(course_reserves_ibfk_2), so everything is fine.
2016-01-11 17:01 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
Hmmm...
Using "SHOW CREATE TABLE course_reserves" returns...
. . . PRIMARY KEY (`cr_id`), UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`), KEY `course_id` (`course_id`), KEY `course_reserves_ibfk_2` (`ci_id`), CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`course_id`), CONSTRAINT `course_reserves_ibfk_2` FOREIGN KEY (`ci_id`) REFERENCES `course_items` (`ci_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
The course reserves function is not enabled on this instance and both course_reserves and course_items are empty. Could it be updatedatabase.pl is expecting that function to be enabled and those tables to contain at least one item? I hate to admit it, but I don't see a line 10584 in updatedatabase.pl so it's difficult for me to determine what is throwing the error.
gcb ______________________
Gary C. Bortel Office of the Secretary of State, Washington State Library gary.bortel@sos.wa.gov 360.570.5588
Washington State Library: Empowering 21st Century Washington
-----Original Message----- From: Koha [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 8:24 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
Hi Gary,
DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase .pl
I would say that the foreign key on course_reserves has not been created. You should check the data in course_items (some don't have a correspondence in course_reserves).
DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase
.pl
You can forget this one, you already had the self_checkout syspref in your database.
Regards, Jonathan
2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bortel@sos.wa.gov>:
I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 3.20.07. Are these benign or something about which concern should be raised?
The installation here is Ubuntu 14.04.3 with a multi-tenant package install of Koha. Mysql Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) using readline 6.3
. . . . Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' (errno: 121) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase
.pl
Item/Record does not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug 14717: Prevent 0000-00-00 dates in patron data) DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase .pl
It exploded because you already had the constraint line 10584. line 10614. line 10584. Upgrade to 3.20.03.001 done (Bug 14205: Deleting an line 10614. Upgrade to 3.20.03.003 done (Bug 14298:
AutoSelfCheckID user should only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4) Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7 release)
gcb ______________________
Gary C. Bortel IT Services Manager, Library Development Program Office of the Secretary of State, Washington State Library 6880 Capitol Boulevard Southeast P.O. Box 42460 Olympia, WA 98501-2460 gary.bortel@sos.wa.gov<mailto:gbortel@secstate.wa.gov> voice: 360.570.5588 fax: 360.586.7575
Washington State Library: Empowering 21st Century Washington
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQEcBAEBAgAGBQJWlaZQAAoJELbCpJ03Jji3fVQH/RLybgwrdA654iRjwuI+GkhV sJaicNjln9Ee5cP7ecM0FzkVmmXSvFTMOyflHomecD93U1iXfzYKXKA7cju+hlnV K2+N+woxZ1S87sOVxR2I4gL7nU49+GUlrUPsh1Apc+kpTLC43zXIfvowmqhnOG2L xHi5zHxM7ZNvNHXBgdegqYwMDv+bqRNmRchWTXZeEK6MHYACKZOWqvirmneBPiHX jbB1BVbDlJJSTdk0uyowe/8qquHOHvvDm61ezKxumRCFY8r1M/FMfn37+UQYIaxC AfGClVIDCT+TfMidWEuCNxmfAh/H3gJwTcLUcWg4SvoFiP0yFtxYFWZ29YT/Ptw= =KWgi -----END PGP SIGNATURE-----
I assume checkouts and returns continue to work. (There's no way to verify since the checkout information doesn't appear.) This does, however, make it difficult for them to renew materials for patrons.
Yes, no visual feedback but it works.
Any suggestions?
The 3.20 package will be updated, fixing this bug, this week-end. In the meantime, if you want, you can apply a quick fix following this procedure: - Access your Koha server with shell. - Locate the file 'checkouts' in your local Koha installation. It is in 'svc' subdirectory of the Koha home directory. - Change your working directory to the directory containing 'checkouts'. - Run this command: wget -O checkouts http://tinyurl.com/zg6ukte It retrieves a valid 'checkouts' program. Kind regards, -- Frédéric DEMIANS http://www.tamil.fr/fdemians
Perfect and thanks to all! We're in business again... gcb -----Original Message----- From: frederic.demians@gmail.com [mailto:frederic.demians@gmail.com] On Behalf Of Frédéric Demians Sent: Tuesday, January 12, 2016 10:57 PM To: Bortel, Gary <gary.bortel@sos.wa.gov> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
I assume checkouts and returns continue to work. (There's no way to verify since the checkout information doesn't appear.) This does, however, make it difficult for them to renew materials for patrons.
Yes, no visual feedback but it works.
Any suggestions?
The 3.20 package will be updated, fixing this bug, this week-end. In the meantime, if you want, you can apply a quick fix following this procedure: - Access your Koha server with shell. - Locate the file 'checkouts' in your local Koha installation. It is in 'svc' subdirectory of the Koha home directory. - Change your working directory to the directory containing 'checkouts'. - Run this command: wget -O checkouts http://tinyurl.com/zg6ukte It retrieves a valid 'checkouts' program. Kind regards, -- Frédéric DEMIANS http://www.tamil.fr/fdemians
I just upgraded from 17.11 to 18.11. Afterward, both the staff client and OPAC display very basic HTML, with no styling. The staff client login looks like this: Koha <http://koha-community.org/> Username: Password: Library: * English * Tiếng Việt <http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN> I can log in to the staff client, and I can run searches in OPAC, but the pages are not displaying correctly. It is almost as if stylesheets were not included in the upgrade. Can anyone suggest how I can troubleshoot this problem? Daniel
Hi Daniel, Did you do *the* one mandatory step after every major version upgrade - clear your browser cache? Hope this helps Indranil Das Gupta L2C2 Technologies On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, <dcowens76@gmail.com> wrote:
I just upgraded from 17.11 to 18.11. Afterward, both the staff client and OPAC display very basic HTML, with no styling. The staff client login looks like this:
Koha <http://koha-community.org/>
Username:
Password:
Library:
* English * Tiếng Việt < http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN
I can log in to the staff client, and I can run searches in OPAC, but the pages are not displaying correctly. It is almost as if stylesheets were not included in the upgrade.
Can anyone suggest how I can troubleshoot this problem?
Daniel _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Thank you Indranil and Beda for the suggestion to clear my browser cache. I did clear the browser, but the page still has no styling. Any other ideas? Daniel On 3/22/19 10:40 AM, Indranil Das Gupta wrote:
Hi Daniel,
Did you do *the* one mandatory step after every major version upgrade - clear your browser cache?
Hope this helps Indranil Das Gupta L2C2 Technologies
On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com>> wrote:
I just upgraded from 17.11 to 18.11. Afterward, both the staff client and OPAC display very basic HTML, with no styling. The staff client login looks like this:
Koha <http://koha-community.org/>
Username:
Password:
Library:
* English * Tiếng Việt <http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN>
I can log in to the staff client, and I can run searches in OPAC, but the pages are not displaying correctly. It is almost as if stylesheets were not included in the upgrade.
Can anyone suggest how I can troubleshoot this problem?
Daniel _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
Keep the browser console on while you reload the page and see what errors show up. On Fri 22 Mar, 2019, 11:17 PM Daniel Owens, <dcowens76@gmail.com> wrote:
Thank you Indranil and Beda for the suggestion to clear my browser cache. I did clear the browser, but the page still has no styling.
Any other ideas?
Daniel
On 3/22/19 10:40 AM, Indranil Das Gupta wrote:
Hi Daniel,
Did you do *the* one mandatory step after every major version upgrade - clear your browser cache?
Hope this helps Indranil Das Gupta L2C2 Technologies
On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com>> wrote:
I just upgraded from 17.11 to 18.11. Afterward, both the staff client and OPAC display very basic HTML, with no styling. The staff client login looks like this:
Koha <http://koha-community.org/>
Username:
Password:
Library:
* English * Tiếng Việt
< http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN
I can log in to the staff client, and I can run searches in OPAC, but the pages are not displaying correctly. It is almost as if stylesheets were not included in the upgrade.
Can anyone suggest how I can troubleshoot this problem?
Daniel _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Oh, of course. Full output is below, but looking through the errors, I found two kinds: * "Loading failed for the <script> with source...": It seems all the files referenced had "min_18.1103000" before the file extension. So I looked in the jquery folder to find those files, and none of the files contain "min_18.1103000". * "ReferenceError: $ is not defined" or "ReferenceError: _ is not defined" Daniel Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-2.2.3.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:192:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-migrate-1.3.0.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:193:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-ui-1.11.4.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:194:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/shortcut/shortcut_18.1103000.js”. thuvien.hbc.edu.vn:8080:195:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.cookie.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:196:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.highlight-3_18.1103000.js”. thuvien.hbc.edu.vn:8080:197:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/bootstrap/bootstrap.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:198:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.validate.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:199:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/staff-global_18.1103000.js”. thuvien.hbc.edu.vn:8080:201:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/commons_18.1103000.js”. thuvien.hbc.edu.vn:8080:202:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:206:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: _ is not defined[Learn More] thuvien.hbc.edu.vn:8080:233:13 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/basket_18.1103000.js”. thuvien.hbc.edu.vn:8080:250:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:261:9 <http://thuvien.hbc.edu.vn:8080/> <http://thuvien.hbc.edu.vn:8080/> On 3/22/19 1:02 PM, Indranil Das Gupta wrote:
Keep the browser console on while you reload the page and see what errors show up.
On Fri 22 Mar, 2019, 11:17 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com>> wrote:
Thank you Indranil and Beda for the suggestion to clear my browser cache. I did clear the browser, but the page still has no styling.
Any other ideas?
Daniel
On 3/22/19 10:40 AM, Indranil Das Gupta wrote: > Hi Daniel, > > Did you do *the* one mandatory step after every major version upgrade > - clear your browser cache? > > Hope this helps > Indranil Das Gupta > L2C2 Technologies > > On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com> > <mailto:dcowens76@gmail.com <mailto:dcowens76@gmail.com>>> wrote: > > I just upgraded from 17.11 to 18.11. Afterward, both the staff client > and OPAC display very basic HTML, with no styling. The staff client > login looks like this: > > > Koha <http://koha-community.org/> > > Username: > > Password: > > Library: > > * English > * Tiếng Việt > > <http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN> > > I can log in to the staff client, and I can run searches in OPAC, but > the pages are not displaying correctly. It is almost as if > stylesheets > were not included in the upgrade. > > Can anyone suggest how I can troubleshoot this problem? > > Daniel > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> <mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>> > https://lists.katipo.co.nz/mailman/listinfo/koha >
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
Ahh those are changed by apache, it looks like one or 2 of your config files didn't update (maybe local changes) In /etc/koha Check that apache-shared-intranet.conf and apache-shared-opac.conf have RewriteRule ^(.*)_[0-9]{2}\.[0-9]{7}\.(js|css)$ $1.$2 [L] If not add that This actually means in future after upgrades you don't have to clear the cache :) Chris On 23 March 2019 7:48:54 AM NZDT, Daniel Owens <dcowens76@gmail.com> wrote:
Oh, of course.
Full output is below, but looking through the errors, I found two kinds:
* "Loading failed for the <script> with source...": It seems all the files referenced had "min_18.1103000" before the file extension. So I looked in the jquery folder to find those files, and none of the files contain "min_18.1103000". * "ReferenceError: $ is not defined" or "ReferenceError: _ is not defined"
Daniel
Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-2.2.3.min_18.1103000.js”.
thuvien.hbc.edu.vn:8080:192:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-migrate-1.3.0.min_18.1103000.js”.
thuvien.hbc.edu.vn:8080:193:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-ui-1.11.4.min_18.1103000.js”.
thuvien.hbc.edu.vn:8080:194:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/shortcut/shortcut_18.1103000.js”.
thuvien.hbc.edu.vn:8080:195:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.cookie.min_18.1103000.js”.
thuvien.hbc.edu.vn:8080:196:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.highlight-3_18.1103000.js”.
thuvien.hbc.edu.vn:8080:197:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/bootstrap/bootstrap.min_18.1103000.js”.
thuvien.hbc.edu.vn:8080:198:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.validate.min_18.1103000.js”.
thuvien.hbc.edu.vn:8080:199:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/staff-global_18.1103000.js”.
thuvien.hbc.edu.vn:8080:201:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/commons_18.1103000.js”.
thuvien.hbc.edu.vn:8080:202:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:206:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: _ is not defined[Learn More] thuvien.hbc.edu.vn:8080:233:13 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/basket_18.1103000.js”.
thuvien.hbc.edu.vn:8080:250:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:261:9 <http://thuvien.hbc.edu.vn:8080/> <http://thuvien.hbc.edu.vn:8080/> On 3/22/19 1:02 PM, Indranil Das Gupta wrote:
Keep the browser console on while you reload the page and see what errors show up.
On Fri 22 Mar, 2019, 11:17 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com>> wrote:
Thank you Indranil and Beda for the suggestion to clear my browser cache. I did clear the browser, but the page still has no styling.
Any other ideas?
Daniel
On 3/22/19 10:40 AM, Indranil Das Gupta wrote: > Hi Daniel, > > Did you do *the* one mandatory step after every major version upgrade > - clear your browser cache? > > Hope this helps > Indranil Das Gupta > L2C2 Technologies > > On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com> > <mailto:dcowens76@gmail.com <mailto:dcowens76@gmail.com>>> wrote: > > I just upgraded from 17.11 to 18.11. Afterward, both the staff client > and OPAC display very basic HTML, with no styling. The staff client > login looks like this: > > > Koha <http://koha-community.org/> > > Username: > > Password: > > Library: > > * English > * Tiếng Việt > >
<http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN>
> > I can log in to the staff client, and I can run searches in OPAC, but > the pages are not displaying correctly. It is almost as if > stylesheets > were not included in the upgrade. > > Can anyone suggest how I can troubleshoot this problem? > > Daniel > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> <mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>> > https://lists.katipo.co.nz/mailman/listinfo/koha >
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Thank you, Chris. I will apply this when I return to my computer. Daniel
On 24 Mar 2019, at 11:48 AM, Chris Cormack <chrisc@catalyst.net.nz> wrote:
Ahh those are changed by apache, it looks like one or 2 of your config files didn't update (maybe local changes)
In /etc/koha Check that apache-shared-intranet.conf and apache-shared-opac.conf have
RewriteRule ^(.*)_[0-9]{2}\.[0-9]{7}\.(js|css)$ $1.$2 [L]
If not add that
This actually means in future after upgrades you don't have to clear the cache :)
Chris
On 23 March 2019 7:48:54 AM NZDT, Daniel Owens <dcowens76@gmail.com> wrote: Oh, of course.
Full output is below, but looking through the errors, I found two kinds:
* "Loading failed for the <script> with source...": It seems all the files referenced had "min_18.1103000" before the file extension. So I looked in the jquery folder to find those files, and none of the files contain "min_18.1103000". * "ReferenceError: $ is not defined" or "ReferenceError: _ is not defined"
Daniel
Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-2.2.3.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:192:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-migrate-1.3.0.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:193:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-ui-1.11.4.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:194:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/shortcut/shortcut_18.1103000.js”. thuvien.hbc.edu.vn:8080:195:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.cookie.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:196:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.highlight-3_18.1103000.js”. thuvien.hbc.edu.vn:8080:197:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/bootstrap/bootstrap.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:198:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.validate.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:199:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/staff-global_18.1103000.js”. thuvien.hbc.edu.vn:8080:201:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/commons_18.1103000.js”. thuvien.hbc.edu.vn:8080:202:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:206:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: _ is not defined[Learn More] thuvien.hbc.edu.vn:8080:233:13 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/basket_18.1103000.js”. thuvien.hbc.edu.vn:8080:250:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:261:9 <http://thuvien.hbc.edu.vn:8080/> <http://thuvien.hbc.edu.vn:8080/>
On 3/22/19 1:02 PM, Indranil Das Gupta wrote: Keep the browser console on while you reload the page and see what errors show up.
On Fri 22 Mar, 2019, 11:17 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com>> wrote:
Thank you Indranil and Beda for the suggestion to clear my browser cache. I did clear the browser, but the page still has no styling.
Any other ideas?
Daniel
On 3/22/19 10:40 AM, Indranil Das Gupta wrote: Hi Daniel,
Did you do *the* one mandatory step after every major version
upgrade
- clear your browser cache?
Hope this helps Indranil Das Gupta L2C2 Technologies
On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com> <mailto:dcowens76@gmail.com <mailto:dcowens76@gmail.com>>> wrote:
I just upgraded from 17.11 to 18.11. Afterward, both the staff client and OPAC display very basic HTML, with no styling. The staff client login looks like this:
Koha <http://koha-community.org/>
Username:
Password:
Library:
* English * Tiếng Việt
<http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN>
I can log in to the staff client, and I can run searches in
OPAC, but
the pages are not displaying correctly. It is almost as if stylesheets were not included in the upgrade.
Can anyone suggest how I can troubleshoot this problem?
Daniel Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
<mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>>
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Chris, Thanks for this suggestion. I checked, and both files contain the RewriteRule you mention below. So I can rule that out. But now the situation has changed to look more like a database problem. I was away from my computer for the past few days and unable to check on this. In the meantime, the OPAC started picking up the stylesheets fine, but another error cropped up, one that prevents loading the staff client: Software error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_hbc.branches' doesn't exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 269 A similar error prevents searches in the OPAC: *No results found!* You did not specify any search criteria. Error: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_hbc.branches' doesn't exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 129 I am not finding much online about this particular issue. I did confirm that there is no data in the table "koha_hbc.branches" in my present database. However, a backup of my Koha database from 21 March does have data in that table. I am now concerned that the upgrade process led to data loss (thankfully I have backups!). I did a mysqldump of the Koha database, and it complained: mysqldump: Got error: 1932: "Table 'koha_hbc.borrower_attribute_types' doesn't exist in engine" when using LOCK TABLES That data is also missing in my current database, though it is present in a recent backup. Any suggestions about how best to proceed? Should I roll Koha back to before the upgrade and try again? Daniel On 3/24/19 11:48 AM, Chris Cormack wrote:
Ahh those are changed by apache, it looks like one or 2 of your config files didn't update (maybe local changes)
In /etc/koha Check that apache-shared-intranet.conf and apache-shared-opac.conf have
RewriteRule ^(.*)_[0-9]{2}\.[0-9]{7}\.(js|css)$ $1.$2 [L]
If not add that
This actually means in future after upgrades you don't have to clear the cache :)
Chris
On 23 March 2019 7:48:54 AM NZDT, Daniel Owens <dcowens76@gmail.com> wrote:
Oh, of course.
Full output is below, but looking through the errors, I found two kinds:
* "Loading failed for the <script> with source...": It seems all the files referenced had "min_18.1103000" before the file extension. So I looked in the jquery folder to find those files, and none of the files contain "min_18.1103000". * "ReferenceError: $ is not defined" or "ReferenceError: _ is not defined"
Daniel
Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-2.2.3.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:192:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-migrate-1.3.0.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:193:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-ui-1.11.4.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:194:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/shortcut/shortcut_18.1103000.js”. thuvien.hbc.edu.vn:8080:195:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.cookie.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:196:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.highlight-3_18.1103000.js”. thuvien.hbc.edu.vn:8080:197:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/bootstrap/bootstrap.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:198:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.validate.min_18.1103000.js”. thuvien.hbc.edu.vn:8080:199:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/staff-global_18.1103000.js”. thuvien.hbc.edu.vn:8080:201:1 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/commons_18.1103000.js”. thuvien.hbc.edu.vn:8080:202:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:206:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: _ is not defined[Learn More] thuvien.hbc.edu.vn:8080:233:13 <http://thuvien.hbc.edu.vn:8080/> Loading failed for the <script> with source “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/basket_18.1103000.js”. thuvien.hbc.edu.vn:8080:250:1 <http://thuvien.hbc.edu.vn:8080/> ReferenceError: $ is not defined[Learn More] thuvien.hbc.edu.vn:8080:261:9 <http://thuvien.hbc.edu.vn:8080/> <http://thuvien.hbc.edu.vn:8080/> On 3/22/19 1:02 PM, Indranil Das Gupta wrote:
Keep the browser console on while you reload the page and see what errors show up. On Fri 22 Mar, 2019, 11:17 PM Daniel Owens, <dcowens76@gmail.com <mailto:dcowens76@gmail.com>> wrote: Thank you Indranil and Beda for the suggestion to clear my browser cache. I did clear the browser, but the page still has no styling. Any other ideas? Daniel On 3/22/19 10:40 AM, Indranil Das Gupta wrote:
Hi Daniel, Did you do *the* one mandatory step after every major version
upgrade
- clear your browser cache? Hope this helps Indranil Das Gupta L2C2 Technologies On Fri 22 Mar, 2019, 8:59 PM Daniel Owens, <dcowens76@gmail.com
<mailto:dcowens76@gmail.com>
<mailto:dcowens76@gmail.com <mailto:dcowens76@gmail.com>>> wrote: I just upgraded from 17.11 to 18.11. Afterward, both the
staff client
and OPAC display very basic HTML, with no styling. The staff
client
login looks like this: Koha <http://koha-community.org/> Username: Password: Library: * English * Tiếng Việt
<http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN>
I can log in to the staff client, and I can run searches in
OPAC, but
the pages are not displaying correctly. It is almost as if stylesheets were not included in the upgrade. Can anyone suggest how I can troubleshoot this problem? Daniel ------------------------------------------------------------------------ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
<mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>>
https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------------------------------------------------ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------------------------------------------------ Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Dear All, We faced a problem in koha that is Patron categories won't be renewed to a new date, if we renew any patron it's coming again with an old date for example, I renew my account to oct/2020 when I sign out and sign in again become back to old date oct/2019 and my account becomes Expirated and all Patron categories have the same problem. can you please help us with this issue. Thank you. ________________________________ DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While “Alfaisal University” has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment.
Hello Mohammad, Which version of Koha are you using? Regards, Jonathan Le mer. 16 oct. 2019 à 10:30, Mohammad Nashbat <MNashbat@alfaisal.edu> a écrit :
Dear All,
We faced a problem in koha that is Patron categories won't be renewed to a new date, if we renew any patron it's coming again with an old date
for example, I renew my account to oct/2020 when I sign out and sign in again become back to old date oct/2019 and my account becomes Expirated and all Patron categories have the same problem.
can you please help us with this issue.
Thank you.
________________________________
DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While “Alfaisal University” has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha version:16.11.14.000 Best Regards, Mohammed Nashbat Instructor Librarian -------------------------------------------------- Alfaisal University PO Box 11533 Riyadh 50927 Saudi Arabia Tel +966 11 2157942 Mob +966 503 101214 Email mnashbat@alfaisal.edu ________________________________________ From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Sent: Wednesday, October 16, 2019 11:58 AM To: Mohammad Nashbat Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem with Patron categories Expiration Hello Mohammad, Which version of Koha are you using? Regards, Jonathan Le mer. 16 oct. 2019 à 10:30, Mohammad Nashbat <MNashbat@alfaisal.edu> a écrit :
Dear All,
We faced a problem in koha that is Patron categories won't be renewed to a new date, if we renew any patron it's coming again with an old date
for example, I renew my account to oct/2020 when I sign out and sign in again become back to old date oct/2019 and my account becomes Expirated and all Patron categories have the same problem.
can you please help us with this issue.
Thank you.
________________________________
DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While “Alfaisal University” has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
________________________________ DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While “Alfaisal University” has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment.
Koha version:16.11.14.000 Best Regards, Mohammed Nashbat Instructor Librarian -------------------------------------------------- Alfaisal University PO Box 11533 Riyadh 50927 Saudi Arabia Tel +966 11 2157942 Mob +966 503 101214 Email mnashbat@alfaisal.edu ________________________________________ From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> Sent: Wednesday, October 16, 2019 11:58 AM To: Mohammad Nashbat Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Problem with Patron categories Expiration Hello Mohammad, Which version of Koha are you using? Regards, Jonathan Le mer. 16 oct. 2019 à 10:30, Mohammad Nashbat <MNashbat@alfaisal.edu> a écrit :
Dear All,
We faced a problem in koha that is Patron categories won't be renewed to a new date, if we renew any patron it's coming again with an old date
for example, I renew my account to oct/2020 when I sign out and sign in again become back to old date oct/2019 and my account becomes Expirated and all Patron categories have the same problem.
can you please help us with this issue.
Thank you.
________________________________
DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While “Alfaisal University” has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
________________________________ DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While “Alfaisal University” has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment.
Best Regards, Mohammed Nashbat Instructor Librarian -------------------------------------------------- Alfaisal University PO Box 11533 Riyadh 50927 Saudi Arabia Tel +966 11 2157942 Mob +966 503 101214 Email mnashbat@alfaisal.edu ________________________________________ From: Mohammad Nashbat Sent: Wednesday, October 16, 2019 11:30 AM To: Chris Cormack; koha@lists.katipo.co.nz; Daniel Owens Subject: [Koha] Problem with Patron categories Expiration Dear All, We faced a problem in koha that is Patron categories won't be renewed to a new date, if we renew any patron it's coming again with an old date for example, I renew my account to oct/2020 when I sign out and sign in again become back to old date oct/2019 and my account becomes Expirated and all Patron categories have the same problem. can you please help us with this issue. Thank you. ________________________________ DISCLAIMER: This electronic mail transmission contains confidential information intended only for the person(s) named. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you received this transmission in error, please notify the sender by reply e-mail and then destroy the message. Opinions, conclusions, and other information in this message that do not relate to the official business of Alfaisal University shall understand to be neither given nor endorsed by Alfaisal University. The contents of any attachment to this e-mail may contain software viruses, which could damage your own computer system. While “Alfaisal University” has taken every reasonable precaution to minimize this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checks before opening the attachment.
Did you clear the browser history? That usually helps. Beda Am 22.03.2019 um 16:28 schrieb Daniel Owens:
I just upgraded from 17.11 to 18.11. Afterward, both the staff client and OPAC display very basic HTML, with no styling. The staff client login looks like this:
Koha <http://koha-community.org/>
Username:
Password:
Library:
* English * Tiếng Việt <http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN>
I can log in to the staff client, and I can run searches in OPAC, but the pages are not displaying correctly. It is almost as if stylesheets were not included in the upgrade.
Can anyone suggest how I can troubleshoot this problem?
Daniel _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (9)
-
Beda Szukics -
Bortel, Gary -
Chris Cormack -
Daniel Owens -
Frédéric Demians -
Indranil Das Gupta -
Jonathan Druart -
Liz Rea -
Mohammad Nashbat