Re: [Koha] Sorry, your Google login failed

2023-01-18 Thread Pablo Bianchi
Did you mean AutoEmailPrimaryAddress syspref?

I'm having the same issue, but without a user already created on Koha and
GoogleOpenIDConnectAutoRegister set to Allow.
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] 22.11.02 Koha String Freeze

2023-01-18 Thread O'Mara, Jacob
Hello all,

Happy New Year!

This email is to announce a String Freeze for the coming 22.11.02
release of Koha stable.

Kind regards,


-- 

*Jacob O'Mara*

*Junior Software Engineer*



E: jacob.om...@ptfs-europe.com 

P: +44 (0) 1483 378728 ext. 1019

www.ptfs-europe.com
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Koha upgrade and restore issue

2023-01-18 Thread vinod mishra
Hello
I wish to restore the database from one server to other in same version
(22.05.07.000) but while running the " *sudo koha-upgrade-schema library*"
command it through following error. Almost same error getting while running
" *sudo koha-rebuild-zebra -v -f library* " command. Please suggest the
possible issue.

root@koha-OptiPlex-9010:/home/koha# sudo koha-upgrade-schema library
Upgrading database schema for library
DBD::mysql::st execute failed: Table 'koha_library.systempreferences'
doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st execute failed: Table 'koha_library.systempreferences'
doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
Use of uninitialized value in numeric lt (<) at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 78.
DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at
/usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist
at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
Undefined subroutine ::DropAllForeignKeys called at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 86.
root@koha-OptiPlex-9010:/home/koha#

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
URL: http://vinod.itshelp.co.in/
ORCID ID: http://orcid.org/-0003-4666-7874
Scopus ID: 57223138343

*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] SQL for Report generation - Help needed

2023-01-18 Thread Manoj Kumar
Can anyone help me to write the sql code for retrieving Most checked out
books of a particular range of call numbers and the patron who took those
books.

Regards
manoj

-- 
manoj
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha