Re: [Koha] Koha 21.11.00 released
I let you catch the missing 'o'! :-) Le ven. 26 nov. 2021 à 14:34, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> a écrit : > Hell everybody, > > Today is the day everybody is talking about: Koha 21.11.00 is out! > > It is with great pleasure that the Koha community announces the > release of Koha 21.11, a major release of the Koha open source > integrated library system. > > Read the full release notes here: > https://koha-community.org/koha-21-11-released/ > > The Debian packages for this new version will be available soon. Stay > tuned! > > Note that I have built some statistics about the Koha development > community, using git. > I have published the charts on the wiki: > https://wiki.koha-community.org/wiki/Development_Community_Statistics > > Cheers, > Jonathan > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 21.11.00 released
Great work ! Thanks Marcel Op vr 26 nov. 2021 om 14:35 schreef Jonathan Druart < jonathan.dru...@bugs.koha-community.org>: > Hell everybody, > > Today is the day everybody is talking about: Koha 21.11.00 is out! > > It is with great pleasure that the Koha community announces the > release of Koha 21.11, a major release of the Koha open source > integrated library system. > > Read the full release notes here: > https://koha-community.org/koha-21-11-released/ > > The Debian packages for this new version will be available soon. Stay > tuned! > > Note that I have built some statistics about the Koha development > community, using git. > I have published the charts on the wiki: > https://wiki.koha-community.org/wiki/Development_Community_Statistics > > Cheers, > Jonathan > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha SMPT Server Configuration
Hi Mahesh, Check your SMTP server log. /var/log/mail/ There you can see if it receives the mail from Koha and then if it was delivered. There might be a hint of the error also. Regards, Alvaro || Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le jeu. 25 nov. 2021 à 21:52, Mahesh Palamuttath < maheshpalamutt...@gmail.com> a écrit : > Has anybody succeeded in configuring the SMTP server in Koha from version > 20.11? > > I have enabled Gmail two-step verification and added SMTP details along > with enabling email in my koha instance. > > I tried my best but failed. > > Hope anyone can help in this regard > > Thanks in advance > > -- Mahesh Palamuttath > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error 500 search not working
Dear Alvaro, Thanks, I'll check it out. On Fri, 26 Nov, 2021, 9:30 pm Alvaro Cornejo, wrote: > Hi Vimal > > DB Error seems to indicate that the field "created_on" in table > virtualshleves does not exist.. Can you verify it? > > You can do it from koha itself creating a report like > > select * from virtualshelves > > If the field does not exist, you can add that field from within mysql. > > Here you can find the table information you might need to create that > field. > > http://schema.koha-community.org/21_05/tables/virtualshelves.html > > Hope it helps. > > Regards, > > Alvaro > > > > || > Stay safe / Cuídate/ Reste sécurisé > *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à > mesure. > *q *Recycle always / Recicla siempre / Recyclez toujours > P Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > Le ven. 26 nov. 2021 à 05:56, Vimal Kumar V. a > écrit : > >> Dear Friends, >> Koha version 21.05.5. >> Xubuntu 20.04 LTS >> >> I got the following error when searching for the barcode in Advanced >> search. >> The same problem when searching barcoded in the search bar. >> >> An error has occurred! >> Error 500 >> This message may have been caused by any of the following reasons: >> You made use of an external link to an item that is no longer available >> You followed an outdated link e.g. from a search engine or a bookmark >> You tried to access a page that needs authentication >> An internal link in the client is broken and the page does not exist >> >> This is the error log. I could not interpret the log entries. Please help >> me to solve the error. >> >> [Fri Nov 26 14:10:04.628073 2021] [cgi:error] [pid 25265] [client >> 127.0.0.1:47400] AH01215: No method count found for Koha::Virtualshelves >> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st >> execute failed: Unknown column 'me.created_on' in 'field list' [for >> Statement "SELECT COUNT( * ) FROM (SELECT `me`.`shelfnumber`, >> `me`.`shelfname`, `me`.`owner`, `me`.`category`, `me`.`sortfield`, >> `me`.`lastmodified`, `me`.`created_on`, `me`.`allow_change_from_owner`, >> `me`.`allow_change_from_others` FROM `virtualshelves` `me` WHERE ( ( ( ( >> `me`.`allow_change_from_owner` = ? AND `me`.`owner` = ? ) OR >> `me`.`allow_change_from_others` = ? ) AND `category` = ? ) ) GROUP BY >> `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, `me`.`category`, >> `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`, >> `me`.`allow_change_from_owner`, `me`.`allow_change_from_others`) `me`" >> with >> ParamValues: 0=1, 1=1354, 2=1, 3=2] at /usr/share/koha/lib/Koha/Objects.pm >> line 601: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: >> http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl >> [Fri Nov 26 14:10:04.628152 2021] [cgi:error] [pid 25265] [client >> 127.0.0.1:47400] AH01215: at >> >> /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/cat-toolbar.inc >> line 157.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: >> http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl >> [Fri Nov 26 14:10:04.637228 2021] [cgi:error] [pid 25265] [client >> 127.0.0.1:47400] AH01215: Template process failed: undef error - >> DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st >> execute failed: Unknown column 'me.created_on' in 'field list' [for >> Statement "SELECT `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, >> `me`.`category`, `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`, >> `me`.`allow_change_from_owner`, `me`.`allow_change_from_others` FROM >> `virtualshelves` `me` LEFT JOIN `virtualshelfcontents` >> `virtualshelfcontents` ON `virtualshelfcontents`.`shelfnumber` = >> `me`.`shelfnumber` WHERE ( ( `biblionumber` = ? AND `category` = ? ) )" >> with ParamValues: 0="22320", 1=2] at /usr/share/koha/lib/Koha/Objects.pm >> line 417: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: >> http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl >> [Fri Nov 26 14:10:04.681634 2021] [cgi:error] [pid 25265] [client >> 127.0.0.1:47400] End of script output before headers: detail.pl, referer: >> http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl >> >> -- >> *Dr Vimal Kumar V.* >> Reference Assistant >> Mahatma Gandhi University Library >> Kottayam, Kerala-686560 >> -- >> My Home page:www.vimalkumar.info >> My Blogs:linuxhalwa.blogspot.com >> kohageek.blogspot.com moovandan.blogspot.com >> --- >> *"The illiterate of the 21st century will not be those who cannot read and >> write, but those who cannot learn, unlearn, and relearn." Alvin Toffler* >> ___ >> >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> Unsubscribe:
Re: [Koha] Error 500 search not working
Hi Vimal DB Error seems to indicate that the field "created_on" in table virtualshleves does not exist.. Can you verify it? You can do it from koha itself creating a report like select * from virtualshelves If the field does not exist, you can add that field from within mysql. Here you can find the table information you might need to create that field. http://schema.koha-community.org/21_05/tables/virtualshelves.html Hope it helps. Regards, Alvaro || Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 26 nov. 2021 à 05:56, Vimal Kumar V. a écrit : > Dear Friends, > Koha version 21.05.5. > Xubuntu 20.04 LTS > > I got the following error when searching for the barcode in Advanced > search. > The same problem when searching barcoded in the search bar. > > An error has occurred! > Error 500 > This message may have been caused by any of the following reasons: > You made use of an external link to an item that is no longer available > You followed an outdated link e.g. from a search engine or a bookmark > You tried to access a page that needs authentication > An internal link in the client is broken and the page does not exist > > This is the error log. I could not interpret the log entries. Please help > me to solve the error. > > [Fri Nov 26 14:10:04.628073 2021] [cgi:error] [pid 25265] [client > 127.0.0.1:47400] AH01215: No method count found for Koha::Virtualshelves > DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st > execute failed: Unknown column 'me.created_on' in 'field list' [for > Statement "SELECT COUNT( * ) FROM (SELECT `me`.`shelfnumber`, > `me`.`shelfname`, `me`.`owner`, `me`.`category`, `me`.`sortfield`, > `me`.`lastmodified`, `me`.`created_on`, `me`.`allow_change_from_owner`, > `me`.`allow_change_from_others` FROM `virtualshelves` `me` WHERE ( ( ( ( > `me`.`allow_change_from_owner` = ? AND `me`.`owner` = ? ) OR > `me`.`allow_change_from_others` = ? ) AND `category` = ? ) ) GROUP BY > `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, `me`.`category`, > `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`, > `me`.`allow_change_from_owner`, `me`.`allow_change_from_others`) `me`" with > ParamValues: 0=1, 1=1354, 2=1, 3=2] at /usr/share/koha/lib/Koha/Objects.pm > line 601: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: > http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl > [Fri Nov 26 14:10:04.628152 2021] [cgi:error] [pid 25265] [client > 127.0.0.1:47400] AH01215: at > > /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/cat-toolbar.inc > line 157.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: > http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl > [Fri Nov 26 14:10:04.637228 2021] [cgi:error] [pid 25265] [client > 127.0.0.1:47400] AH01215: Template process failed: undef error - > DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st > execute failed: Unknown column 'me.created_on' in 'field list' [for > Statement "SELECT `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, > `me`.`category`, `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`, > `me`.`allow_change_from_owner`, `me`.`allow_change_from_others` FROM > `virtualshelves` `me` LEFT JOIN `virtualshelfcontents` > `virtualshelfcontents` ON `virtualshelfcontents`.`shelfnumber` = > `me`.`shelfnumber` WHERE ( ( `biblionumber` = ? AND `category` = ? ) )" > with ParamValues: 0="22320", 1=2] at /usr/share/koha/lib/Koha/Objects.pm > line 417: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: > http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl > [Fri Nov 26 14:10:04.681634 2021] [cgi:error] [pid 25265] [client > 127.0.0.1:47400] End of script output before headers: detail.pl, referer: > http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl > > -- > *Dr Vimal Kumar V.* > Reference Assistant > Mahatma Gandhi University Library > Kottayam, Kerala-686560 > -- > My Home page:www.vimalkumar.info > My Blogs:linuxhalwa.blogspot.com > kohageek.blogspot.com moovandan.blogspot.com > --- > *"The illiterate of the 21st century will not be those who cannot read and > write, but those who cannot learn, unlearn, and relearn." Alvin Toffler* > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] MARC field 008, subfield 33 set to "no fiction" by default
Hi. When I am cataloguing a new book record, the subfield 33 (literary form) of the 008 field is automatically set to 0 (no fiction). I would like to set the default to | (not used). I have got a custom framework that I am using for cataloguing, but I cannot find out how to customize the settings of the 008 field, as there are no subfields that can be customized. I can see that the field is using a plugin, marc21_field_008.pl. Do I have to change the setting in the plugin? If so, how do I do that? Thank you very much. Isabel ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha SMPT Server Configuration
On 26/11/2021 03:52, Mahesh Palamuttath wrote: Has anybody succeeded in configuring the SMTP server in Koha from version 20.11? I have enabled Gmail two-step verification and added SMTP details along with enabling email in my koha instance. I tried my best but failed. Hope anyone can help in this regard Thanks in advance -- Mahesh Palamuttath ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha Hi Mahesh can you check the koha log files for useful messages about the failure? best regards John ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha 21.11.00 released
Congratulations Jonathan and team for such a great accomplishment! Great work! El vie, 26 nov 2021 a las 10:35, Jonathan Druart (< jonathan.dru...@bugs.koha-community.org>) escribió: > Hell everybody, > > Today is the day everybody is talking about: Koha 21.11.00 is out! > > It is with great pleasure that the Koha community announces the > release of Koha 21.11, a major release of the Koha open source > integrated library system. > > Read the full release notes here: > https://koha-community.org/koha-21-11-released/ > > The Debian packages for this new version will be available soon. Stay > tuned! > > Note that I have built some statistics about the Koha development > community, using git. > I have published the charts on the wiki: > https://wiki.koha-community.org/wiki/Development_Community_Statistics > > Cheers, > Jonathan > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha 21.11.00 released
Hell everybody, Today is the day everybody is talking about: Koha 21.11.00 is out! It is with great pleasure that the Koha community announces the release of Koha 21.11, a major release of the Koha open source integrated library system. Read the full release notes here: https://koha-community.org/koha-21-11-released/ The Debian packages for this new version will be available soon. Stay tuned! Note that I have built some statistics about the Koha development community, using git. I have published the charts on the wiki: https://wiki.koha-community.org/wiki/Development_Community_Statistics Cheers, Jonathan ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Error 500 search not working
Dear Friends, Koha version 21.05.5. Xubuntu 20.04 LTS I got the following error when searching for the barcode in Advanced search. The same problem when searching barcoded in the search bar. An error has occurred! Error 500 This message may have been caused by any of the following reasons: You made use of an external link to an item that is no longer available You followed an outdated link e.g. from a search engine or a bookmark You tried to access a page that needs authentication An internal link in the client is broken and the page does not exist This is the error log. I could not interpret the log entries. Please help me to solve the error. [Fri Nov 26 14:10:04.628073 2021] [cgi:error] [pid 25265] [client 127.0.0.1:47400] AH01215: No method count found for Koha::Virtualshelves DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.created_on' in 'field list' [for Statement "SELECT COUNT( * ) FROM (SELECT `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, `me`.`category`, `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`, `me`.`allow_change_from_owner`, `me`.`allow_change_from_others` FROM `virtualshelves` `me` WHERE ( ( ( ( `me`.`allow_change_from_owner` = ? AND `me`.`owner` = ? ) OR `me`.`allow_change_from_others` = ? ) AND `category` = ? ) ) GROUP BY `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, `me`.`category`, `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`, `me`.`allow_change_from_owner`, `me`.`allow_change_from_others`) `me`" with ParamValues: 0=1, 1=1354, 2=1, 3=2] at /usr/share/koha/lib/Koha/Objects.pm line 601: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl [Fri Nov 26 14:10:04.628152 2021] [cgi:error] [pid 25265] [client 127.0.0.1:47400] AH01215: at /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/includes/cat-toolbar.inc line 157.: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl [Fri Nov 26 14:10:04.637228 2021] [cgi:error] [pid 25265] [client 127.0.0.1:47400] AH01215: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'me.created_on' in 'field list' [for Statement "SELECT `me`.`shelfnumber`, `me`.`shelfname`, `me`.`owner`, `me`.`category`, `me`.`sortfield`, `me`.`lastmodified`, `me`.`created_on`, `me`.`allow_change_from_owner`, `me`.`allow_change_from_others` FROM `virtualshelves` `me` LEFT JOIN `virtualshelfcontents` `virtualshelfcontents` ON `virtualshelfcontents`.`shelfnumber` = `me`.`shelfnumber` WHERE ( ( `biblionumber` = ? AND `category` = ? ) )" with ParamValues: 0="22320", 1=2] at /usr/share/koha/lib/Koha/Objects.pm line 417: /usr/share/koha/intranet/cgi-bin/catalogue/detail.pl, referer: http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl [Fri Nov 26 14:10:04.681634 2021] [cgi:error] [pid 25265] [client 127.0.0.1:47400] End of script output before headers: detail.pl, referer: http://127.0.1.1:8080/cgi-bin/koha/mainpage.pl -- *Dr Vimal Kumar V.* Reference Assistant Mahatma Gandhi University Library Kottayam, Kerala-686560 -- My Home page:www.vimalkumar.info My Blogs:linuxhalwa.blogspot.com kohageek.blogspot.com moovandan.blogspot.com --- *"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." Alvin Toffler* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha