Re: [Koha] Deleted biblio still appearing in search results staff interface

2019-09-05 Thread Alvaro Cornejo
Hi Elaine A couple of things that might help: - Have you run a full zebra reindex or only partial? I'll go for a full reindex - If you run a report that looks for the "deleted" biblio by name, author and/or record number, what does you get? If in any of the reports you get something, then for so

Re: [Koha] [KOHA] ALL TRANSACTIONS DELETE

2019-09-06 Thread Alvaro Cornejo
Hi I think you have a couple of options: 1) Reload a backup previous to your training. 2) backup/export biblio, authorities, patrons and other info you might want to keep, delete your instance and recreate it again. Restore/import your patrons, authority, biblio, etc. or start from scratch. Rega

Re: [Koha] APP for a Koha installation

2019-10-09 Thread Alvaro Cornejo
HI Victor Can you explain more your request? Koha support mobile devices already. Regards, Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Ne

Re: [Koha] [koha] Edited barcodes not saving

2019-11-06 Thread Alvaro Cornejo
Hi Muirunyeri The query used to update the barcode said it is finding several results "...Query returned more than one row..." This means that, when updating a record, msql is founding several records to update this might seems you have duplicated records in your database. Check on the about

Re: [Koha] [koha] Edited barcodes not saving

2019-11-07 Thread Alvaro Cornejo
changing the homebranch and > save again (maybe try changing all the branch info on that item) > > It may be that somehow someone deleted a branch, check in administration, > to see if all the libraries/branches are there that you expect to be > > Chris > > On 7 November

[Koha] How to enable zebra as daemon or place it in cron

2019-11-08 Thread Alvaro Cornejo
Hi We are having some issues with zebra indexation. Modifications to registries are not reflected on queries after saving them. ps -ef shows zebra server is running, but not zebra update.script koha-common in cron.dayly has a commented line about un-commenting this line if not wishing the zebra

Re: [Koha] How to enable zebra as daemon or place it in cron

2019-11-08 Thread Alvaro Cornejo
oha-indexer daemon? > > You enable by doing: > koha-indexer --enable > And then start it with: > koha-indexer --start > > Regards > > > > El vie., 8 nov. 2019 a las 14:34, Alvaro Cornejo (< > cornejo.alv...@gmail.com>) escribió: > >> Hi >> >&

Re: [Koha] Duplicate ID

2019-11-15 Thread Alvaro Cornejo
Hi Go to More/About/System information and check if you have a warning about duplicated records. If is the case, follow instructions on the error message. Regards. Alvaro |-| Envíe y

Re: [Koha] [koha] Edited barcodes not saving

2019-11-20 Thread Alvaro Cornejo
ue in homebranch doenst > match a row in the branches table. > That's why you can't update that item. Try changing the homebranch and > save again (maybe try changing all the branch info on that item) > > It may be that somehow someone deleted a branch, check in ad

[Koha] Plack using 100% CPU

2019-11-23 Thread Alvaro Cornejo
Hi After enabling plack, CPU start running at 100% and I get a lot of "compliation errors" as below: Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": Can 't locate object method "cache_dir" via package "Swagger2::SchemaValidator" at /usr/

Re: [Koha] Upload Barcode data to koha

2019-11-25 Thread Alvaro Cornejo
Hi Aaru Barcodes are a property of the items; not of the records. You must upload barcodes with items, not records or upload both at the same time. Regards, Alvaro |-| Envíe y Reciba D

Re: [Koha] Source of Acquisition

2019-12-05 Thread Alvaro Cornejo
Hi Charles You might concatenate the acquisition number and the Access Db id on 952$i with a character separator like a pipe, asterisk, semicolon, etc. ie 2019-01325|54342. Once you get rid of the old Access DB system you can run a query to the Koha DB biblio table and, using the separator, remo

Re: [Koha] Source of Acquisition

2019-12-06 Thread Alvaro Cornejo
Hi Charles I don't know if you can do the replacement/truncate the 952 from koha but you can doit directly in mysq with a query like: https://basitaalishan.com/2014/02/23/removing-part-of-string-before-and-after-specific-character-using-transact-sql-string-functions/ https://stackoverflow.com/qu

[Koha] Happy New Year

2019-12-31 Thread Alvaro Cornejo
Hi All / kia ora Just a few lines to thanks all Koha team for their 2019 hard work and to wish to all the community a happy new year and a 2020 full of successes. Alvaro |-| Envíe y Re

[Koha] Upgrading ubuntu & koha

2020-01-04 Thread Alvaro Cornejo
Hi We are going to move a server from ubuntu 16.4 to 18.4 and koha from 17.5 to latest stable. All this in a new machine to minimize downtime. Is there any special consideration to take care of? In my understanding, for the biblio DB, I only need to install base koha (command line part) an then

Re: [Koha] Upgrading ubuntu & koha

2020-01-07 Thread Alvaro Cornejo
ve stored any files on the server or have made changes to > configuration files (SIP for example) you will have to move them > separately. > > Which dependency are you referring too? > > Hope this helps, > > Katrin > > On 04.01.20 17:36, Alvaro Cornejo wrote: > >

[Koha] Errors on new install Ubuntu 18.04 & koha 19.11

2020-01-07 Thread Alvaro Cornejo
Hi I´ve started a new install of koha and when installing additional languages, I get the following errors. acornejo@CelacpVPS-2:~$ sudo koha-translate --install es-ES Connection to the memcached servers '__MEMCACHED_SERVERS__' failed. Are the unix socket permissions set properly? Is the host r

[Koha] moving database from 17.5 to 19.11 error

2020-01-07 Thread Alvaro Cornejo
Hi I´m tryin to do the DB move from 17.5 to 19.11. I take following steps: - backup 17.5 with koha-backup and I get two files a sql.gz and a tar.gz - scp both files to new server - run koha-remove biblioteca - run koha-restore sql tar files and I start having a lot of errors like: ERROR: File

Re: [Koha] Warning about patron relationship problems?

2020-01-08 Thread Alvaro Cornejo
Hi Martin, I have the same problem ad I saw that the patch was pushed to 19.11.02 When does it will be available? Or can I apply the patch without breaking apt-get update/upgrade? Regards, Alvaro |

[Koha] Opac Navbar font

2020-01-13 Thread Alvaro Cornejo
Hi I´ve installed koha 19.11 and customized opac navbar color. The result shows font and icons as if they have a white shadow. is that right? How can I remove this ¨shadow¨ Please see the difference between 17.05 and 19.11 https://pasteboard.co/IPSitMw.png (17.05) https://pasteboard.co/IPSiWxa.

Re: [Koha] Opac Navbar font

2020-01-14 Thread Alvaro Cornejo
Thanks Owen. It worked Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplica

[Koha] Audit system preferences changes

2020-01-14 Thread Alvaro Cornejo
Hi Is there a way to know what global system preferences were changed and what was its previous value? Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde c

Re: [Koha] Audit system preferences changes

2020-01-14 Thread Alvaro Cornejo
de the previous > value. Afaik, that would only be available from a backup. > I hope this helps, > Bob Birchall > *CALYX* > > > > On Wed, 15 Jan 2020 at 03:38, Alvaro Cornejo > wrote: > >> Hi >> >> Is there a way to know what global system preferen

[Koha] icuchain vs charmap

2020-01-15 Thread Alvaro Cornejo
Hi I have a doubt about which kind of index to use in koha for a mostly spanish library. I read some suggestions about changing charmap word-phrase-utf.chr with icuchain words-icu.xml on the default zebradb config but have no a clear idea Regards, Alvaro |---

[Koha] run koha without mpm_itk

2020-01-20 Thread Alvaro Cornejo
Hi Is it posible to run koha without mpm_itk? I want to test apache2 performance with apache2buddy.pl but it does not support mpm_itk I tried to replace it with mod_suexec and suexecUserGroup unsuccessfully. Regards Alvaro |--

Re: [Koha] Download koha software

2020-01-21 Thread Alvaro Cornejo
Go to koha official site https://koha-community.org/download-koha/ Regards Alvaro |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú

Re: [Koha] INSTANCE CREATED NOT AVAILABLE IN APACHE RELATED FOLDERS

2020-01-22 Thread Alvaro Cornejo
have you used sudo when creating the instance? You can try to remove and then recreate it Regards |-| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y N

[Koha] bywatersolutions marc checker plugin

2020-01-22 Thread Alvaro Cornejo
Hi I tried bywatersolutions marc checker plugin and have added perl modules marc::libnt & Marc::file:usmarc Even though modules are not shown on koha about page, I have the plugin shown. When runing the report, I get "Must pass a MARC::Record object to check_record" error for each record. Is so

[Koha] upgrade from 17.05 to oldstable dependency error.

2020-01-25 Thread Alvaro Cornejo
Hi I{m trying to upgrade a koha installation from 17.05 to oldstable (tried stable also) but apt-get upgrade said package will be kept back. OS is Ubunutu xenial (16.4) I check dependency and I get this: acornejo@CelacpVps:~$ sudo apt-get --with-new-pkgs upgrade koha-common Reading package list

Re: [Koha] INSTANCE CREATED NOT AVAILABLE IN APACHE RELATED FOLDERS

2020-01-27 Thread Alvaro Cornejo
ation/ > importation of the data. > > On Wed, Jan 22, 2020 at 7:14 PM Alvaro Cornejo > wrote: > >> have you used sudo when creating the instance? >> >>

Re: [Koha] FW: Koha on Digital Ocean (Was: Re: Installation on so-called virtual server at external internet service provider IONOS)

2020-01-28 Thread Alvaro Cornejo
Hi Fred In my basic understanding -might be, awfully, wrong-: 1) Data encryption: There are several levels of data encryption you can set up. -) Apache: You define this in apache config and depends on the ssl certificate you get for your website. -) Mysql encryption. You can encrypt data in mysq

Re: [Koha] Upgrade: Ubuntu 16.04.6 LTS / Koha 17.11.18.000

2020-01-28 Thread Alvaro Cornejo
Hi Alex, We just move from Ubuntu 16.04 to 18.04, koha from 17.05 to 19.11 and went from a 1core 2GB Ram box to a 2 core 4 GB Ram box. What we did was to install everything from scratch in a new Linode and then move the DB from old machine to the new one. Do all tests needed and when satisfied,

[Koha] Cover image not shown in opac search result but biblio detail

2020-01-28 Thread Alvaro Cornejo
Hi I´m running koha 19.11.002 and noticed that the opac search result does not show biblio some cover images; however biblio detail show it. On the intranet, image is shown in both, the search page and the biblio detail. I´ve checked all cover system preferences but found nothing that can help.

[Koha] list of biblio without items and empty marc 773

2020-01-28 Thread Alvaro Cornejo
Hi I´m trying to get a report of all biblios that does not have an item and marc 773 / * are empty/NULL or just 773 / 0. The issue is that when linking analytical monographic reccord to a specific biblio, field/subfields of 773 are populated with "parent" record information. Analitical Monograp

Re: [Koha] Cover image not shown in opac search result but biblio detail

2020-01-29 Thread Alvaro Cornejo
Visitenos en www.perusms.com Le mer. 29 janv. 2020 à 16:42, Alvaro Cornejo a écrit : > Hi Katrin > > Thanks for your answer. > > I'll try disabling all cover services and removing all custom css & js. > > We have Amazon and Google covers acti

[Koha] upgrade tp 19.00.02-1 memcached error

2020-01-29 Thread Alvaro Cornejo
Hi I´ve just upgrade to 19.11.02-1 and the upgrade showed the following errors regarding memcached. Setting up koha-common (19.11.02-1) ... Upgrading database schema for biblioteca Connection to the memcached servers '__MEMCACHED_SERVERS__' failed. Are the unix socket permissions set properly?

Re: [Koha] need help with accessing koha from outside via DynDNS

2020-02-06 Thread Alvaro Cornejo
Hi Heinz Usually this issue means Apache is receiving a call for a site that does "not exist" so it shows its default page. Check that your koha site is enabled (sudo a2ensite bibliotthek.conf) As per tcp6 0 0 :::80 :::* LISTEN 1113/apache2 Seems apache is not listenin

Re: [Koha] No physical items for this record

2020-02-18 Thread Alvaro Cornejo
Hi Bruck How did you do the DB transfer? I did about the same at the beginning of the year using mysqldump and worked fine. Regards, Alvaro || *7* Switch off as you go / Apaga lo que no usas / Débranchez a

Re: [Koha] No physical items for this record

2020-02-19 Thread Alvaro Cornejo
n the backend of the system using > Mysqldump for both exporting it from the server with 16.05 version to the > server with 18.11 version. The holding tab on 16.05 shows data but not > 18.11 for the same book. > > > > Best regards, > > Bruck T. > > > > *From:* A

Re: [Koha] Install fails: 19.11 on fresh Debian 9: table $SITE.zebraqueue doesn't exist

2020-03-09 Thread Alvaro Cornejo
Hi Both possibilities you refer end on the same. database is not ready/complete for the next processes to take place. Therefore I guess there is actually a race condition. Have you tried to manually create the DB? # sudo su mysql -uroot -p [Enter the MySQL Root password] drop database koha_libra

Re: [Koha] Install fails: 19.11 on fresh Debian 9: table $SITE.zebraqueue doesn't exist

2020-03-10 Thread Alvaro Cornejo
on the command > line, about tables not existing. The koha-upgrade-schema program assumes > that tables already exist. > > --Dwight > > On Mon, Mar 9, 2020 at 11:32 AM Alvaro Cornejo > wrote: > >> Hi >> >> Both possibilities you refer end on the same. d

Re: [Koha] Installation problem in Debian vps

2020-03-16 Thread Alvaro Cornejo
Hi Last week there was a similar problem but with debian 9. Short solution found: Increase apache timeout. You can take a look at that thead. Regards Alvaro || *7* Switch off as you go / Apaga lo que no us

Re: [Koha] Excel to Koha year wise filtration problem

2020-03-20 Thread Alvaro Cornejo
Hi Can´t you do the filtration in excel, create sub.set files and import just those? Regards Alvaro || *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / R

Re: [Koha] sign in in koha administration

2020-03-20 Thread Alvaro Cornejo
Hi You should point your user to "YourKohaInstalce-admin.YourDomain.com:8080" if you are using domain setup or "KokaIpAdress:8080" if you don´t Asuming you defines 8080 as the koha admin port. Regards, Alvaro |

Re: [Koha] sign in in koha administration

2020-03-20 Thread Alvaro Cornejo
necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 20 mars 2020 à 11:21, Alvaro Cornejo a écrit : > Hi > > You should point your user to "YourKohaInstalce-admin.YourDomain.com:8080" > if you are using domain setup or "KokaIpAdress:8080&qu

[Koha] Connection to memcached servers failed after update to 19.11.04

2020-04-04 Thread Alvaro Cornejo
Hi I have just updated koha from 19.11.02 to 19.11.04 and got the following erors during update. Upgrade to 19.11.04.000 done (19.11.04 release) Connection to the memcached servers '__MEMCACHED_SERVERS__' failed. Are the unix socket permissions set properly? Is the host reachabl

[Koha] Log access from intranet

2020-04-07 Thread Alvaro Cornejo
Hi, I´m trying to access /tools/AccessFiles but I get the error message: Error: Files could not be found because the "access_dir" option was not set in "koha-conf.xml". Contact your system administrator to add this option. I looked to koha-conf file in /etc/koha/blibioteca/ but file does not hav

Re: [Koha] To batch change the returns / check-in

2020-04-15 Thread Alvaro Cornejo
Hi José Before running the UPDATE query I´ll recommend you to do a validation of the update by converting it to a SELECT statement So UPDATE issues SET date_due="2020-04-29 23:59:00", lastreneweddate="2020-04-15 15:01:00" WHERE date_due > '2020-03-17'; Will become: SELECT date_due, lastrenewed

Re: [Koha] Koha as Doc Man System

2020-04-21 Thread Alvaro Cornejo
Hi Akia Koha is a library system; therefore you can consider it a "specialized" document management system. Even though it is designed for libraries use, you can configure it to manage any type of documents or other items. There are libraries that manage tools, videos, CDs, small appliances, etc.

Re: [Koha] SQL help?

2020-05-26 Thread Alvaro Cornejo
Hi Mysql does not have the ability to read info from any other place than its own tables. You can, however write an script in any language you know to loop through your borrowers file and check if they owe something. This shall be done at server level, not koha. Regards, Alvaro |--

Re: [Koha] Zebra error 1011/10004

2020-06-01 Thread Alvaro Cornejo
Hi Please take a look at the error section. https://wiki.koha-community.org/wiki/Troubleshooting_Zebra Regards, Alvaro || Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas

[Koha] plack proxy error after upgradiing to 19.11.06

2020-06-03 Thread Alvaro Cornejo
Hi We have noticed slow koha since last update of koha Koha 19.11.06.000 MySQL version: mysql Ver 14.14 Distrib 5.7.30, for Linux (x86_64) using EditLine wrapper Apache version: Server version: Apache/2.4.29 (Ubuntu) Memcached: Servers: 127.0.0.1:11211 | Namespace: koha_library | Status: running.

Re: [Koha] plack proxy error after upgradiing to 19.11.06

2020-06-04 Thread Alvaro Cornejo
u confirm you tried the following cmds: > koha-plack --enable INSTANCE > koha-plack --start INSTANCE > service apache2 restart > > Regards, > Jonathan > > Le jeu. 4 juin 2020 à 03:32, Alvaro Cornejo a > écrit : > > > > Hi > > > > We have

Re: [Koha] Software error:DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.library_groups' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 130

2020-06-05 Thread Alvaro Cornejo
Hi Francis Do you have the log of the koha-upgrade-shema or the one from the upgrade? There might be a tip on the cause of the error. Regards, Alvaro || Stay safe / Cuídate/ Reste sécurisé *7* Switch off as

Re: [Koha] Unable to save

2020-06-06 Thread Alvaro Cornejo
Hi You should give read/wite permissions to your koha user to the mentioned fiile. Even better, to the whole directory since koha will write all logs to that folder /var/log/koha/library/ Note that "library" is the instance name of your library. Regards, Alvaro |--

Re: [Koha] Software error:DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.library_groups' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 130

2020-06-06 Thread Alvaro Cornejo
backup to > new koha version. I got this error. I don't have idea of how to check the > log details? Can you guide me? > Thanks once again for your help > Ashok. > > On Sat, 6 Jun 2020, 1:19 am Alvaro Cornejo, > wrote: > >> Hi Francis >> >> Do you have

Re: [Koha] Unable to save

2020-06-07 Thread Alvaro Cornejo
, Dawson Weber a écrit : > Hi Alvaro, > > Is it common to have to reset read/write permissions after an upgrade? > > Thanks. best, Dawson > > On Sat, Jun 6, 2020 at 12:33 PM Alvaro Cornejo > wrote: > >> Hi >> >> You should give read/wite permissions

Re: [Koha] Coverflow installation problems

2020-06-07 Thread Alvaro Cornejo
Hi Quỳnh, There were a couple of errors in your query. Try this: - SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title FROM items i LEFT JOIN biblioitems m USING (biblioitemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) WHERE DATE_SUB(CURDATE(),INTE

[Koha] Patron save button dissabled after adding JS to addbiblio

2020-06-13 Thread Alvaro Cornejo
Hi I´m trying to make this JS work in 19.11.06, even though it is noted to work on 16.05. The JS was supposed to be enabled only on cataloging form, however, it locks/disables the save button in patron creations form. Any idea what's wrong with it? / https://wiki.koha-community.org/wiki/JQuery_L

Re: [Koha] Limpiar Base de datos

2020-06-16 Thread Alvaro Cornejo
Buenas tardes Luis No sé si hay forma de borrar todo menos la clave principal. Lo que si puedes es borrar por completo la BD y crear una nueva. El procedimiento es, más o menos: - Detener los servicios de koha (koha-commom, memcache y plack) si los estás usando - Entrar a la BD y borrar la BD d

Re: [Koha] Enquiry for Installation

2020-06-20 Thread Alvaro Cornejo
Hi You can run it in a virtual machine under any virtualization software like vmware, virtual software, virtual pc, etc. You need to take into account the machine resources used by the host OS/apps, guest OS and Koha so your koha runs as expected. Regards, Alvaro |--

Re: [Koha] Koha 20.05 - Adding a description meta tag to

2020-06-21 Thread Alvaro Cornejo
Hi Craig You can do it either way However, it is always better to avoid modifying koha code to avoid conflicts when upgrading/updating koha versions. Regards, Alvaro || Stay safe / Cuídate/ Reste sécurisé

Re: [Koha] Serving an Intranet WebPAC from a Website

2020-06-26 Thread Alvaro Cornejo
Hi What about embed opac inside a frame into your IIS? 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 al

Re: [Koha] Koha 19.11.07 released

2020-06-29 Thread Alvaro Cornejo
Hi Does debian packages have been released? I was getting this message on apt-get update E: Repository 'http://debian.koha-community.org/koha stable InRelease' changed its 'Codename' value from '19.11' to '20.05' So I changed: koha.list to deb http://debian.koha-community.org/koha 19.11 main

[Koha] Plack error in koha 19.11.06

2020-06-30 Thread Alvaro Cornejo
Hi Since this morning we start to have this errors in plack: Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": [JSON::Validator] GET http://swagger.io/v2/schema.json == Connect timeout at /usr/share/perl5/JSON/Validator.pm line 274. Compil

Re: [Koha] Plack error in koha 19.11.06

2020-06-30 Thread Alvaro Cornejo
round is described in comment 11 > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23653#c11 > > $ git clone https://github.com/mojolicious/json-validator > $ cd json-validator > $ git reset --hard 3.06 > HEAD is now at 8b19ba0 Released version 3.06 > > $ sudo cp -a ./

[Koha] Include dynamic content in opac main page

2020-07-03 Thread Alvaro Cornejo
Hi We want to include some content that is generated daily in html format into the main opac/intranet pages. We tried to use this (snip) code in IntranetmainUserblock and OpacNavBottom but can´t get the content to be shown $(function(){ $("#includedContent").load("DynamicCode.html"

Re: [Koha] Problem with coverflow plugin, Koha 20.05

2020-07-05 Thread Alvaro Cornejo
Hi Have you tried to reintall it after upgrade? I had a similar issue on 17.05 and reinstalling the plugging it worked. Note that eventhough I reinstall it. It kept original configuration. I had to just enable it. Regards, Alvaro |

Re: [Koha] upgrade from koha 16.11, Ubuntu 16.04 to koha 17.05, 17.11 --not usable for check out

2020-07-06 Thread Alvaro Cornejo
Hi Heinrich It seems the db upgrade schema had an error in the upgrade process. I'll suggest you try to run the db upgrade schema to see if that works. Always do a DB backup before tweaking it. #sudo koha-upgrade-schema YourInstance Then recreate your index #sudo koha-rebuild-zebra -v -f YourIns

Re: [Koha] upgrade from koha 16.11, Ubuntu 16.04 to koha 17.05, 17.11 --not usable for check out

2020-07-06 Thread Alvaro Cornejo
helps > the input file I used comes from koha-dump (16.11) as > library-2020-06-24.sql.gz ans was expanded using gunzip. > -- endless errors filled my terminalbuffer. > Are you referring to some other DB backupformat? > > Best regards > Heinrich > ==

Re: [Koha] Include dynamic content in opac main page

2020-07-06 Thread Alvaro Cornejo
sary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le lun. 6 juil. 2020 à 16:55, Tim McMahon a écrit : > You should use htdocs instead of cgi-bin for HTML files, but I'm not > sure how good of an idea it is to put custom content in a Koha directory. > > On 7/

[Koha] Mailing list policy change? message held for review

2020-07-07 Thread Alvaro Cornejo
Hi Since last week I'm receiving a message to my reply to the list about it being held for admin review. The reason I get is: Too many recipients to the message I'm sending the message to 2 or 3 specific persons plus the list. What is the max recipients allowed now? Regards, Alvaro |

[Koha] Parsing public reports

2020-07-07 Thread Alvaro Cornejo
Hi I´m trying to parse the results of a report setup as public but are unable to get the data. This is the script I'm working on #!/usr/bin/perl use strict; use warnings; use LWP::UserAgent; use HTTP::Request; my $ua = new LWP::UserAgent; $ua->agent("Perl API Client/1.0"); my $url = "ht

Re: [Koha] delete content of a biblio instance

2020-07-08 Thread Alvaro Cornejo
020, 20:22:07 CEST schrieb Alvaro Cornejo: > > Hi, > > > > If you have imported the records through the upload tool of koha, you can > > remove those same records through the same tool. > > > > Regards, > > > > Alvaro > > Hi Alvaro, &g

Re: [Koha] Parsing public reports

2020-07-08 Thread Alvaro Cornejo
Hi Alexander, That works !! Thanks 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 / Rec

Re: [Koha] delete content of a biblio instance

2020-07-09 Thread Alvaro Cornejo
jeu. 9 juil. 2020 à 05:36, Heinz-Jürgen Oertel a écrit : > Am Donnerstag, 9. Juli 2020, 00:18:01 CEST schrieb Alvaro Cornejo: > > Hi, > > > > Sorry, yes, that was it. > > > > It has been a long time since I did that import. I think it was a two > step >

[Koha] report behaves differently if run from intranet or the outside

2020-07-10 Thread Alvaro Cornejo
Hi I´ve been working with a report to get records stats and found a strange behaviour. The exactly same report provides different data if run it from the report interface in koha than calling it from the outside (public link) either from a perl script or from a browser (tested on ie / chrome) Th

Re: [Koha] report behaves differently if run from intranet or the outside

2020-07-11 Thread Alvaro Cornejo
toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le sam. 11 juil. 2020 à 00:41, Alvaro Cornejo a écrit : > Hi > > I´ve been working with a report to get records stats and found a strange > behaviour. > > The e

Re: [Koha] report behaves differently if run from intranet or the outside [SOLVED]

2020-07-11 Thread Alvaro Cornejo
e Le sam. 11 juil. 2020 à 11:27, Alvaro Cornejo a écrit : > Hi > > It seems to be a problem with the public setup of the report. Hard limit > somewhere in the code? > > I changed almost all my reports to public to test and in all cases, I get > no more than the first 10 r

Re: [Koha] Wrong order wehen sorting public list by copyright year

2020-07-12 Thread Alvaro Cornejo
Hi Michael Have you reindexed your DB after the change? 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 a

Re: [Koha] item-level_itypes set but no itemtype set ...

2020-07-12 Thread Alvaro Cornejo
Hi Heinrich You need to check each of the records shown in your logs " item (61258) " and check that their items have the itemtype defined in sub-field "y" . You can also check field 942c Regards, Alvaro |---

Re: [Koha] OPACReportProblem Koha 20.05

2020-07-13 Thread Alvaro Cornejo
Hi Elaine, Emails are handled by a cron. I guess the ones you mention also. Have you checked the mail log (/var/log/mail.log) to see if your messages are being processed by your smtp server? are other mails are being sent? Regards, Alvaro |--

[Koha] openlibrary search error

2020-07-15 Thread Alvaro Cornejo
Hi Since some time, I'm getting an error when enabling openlibrary searches: I get this on chrome debugger: jquery-3.4.1.min_19.1107000.js:2 GET https://openlibrary.org/api/volumes/brief/json?callback=jQuery3410806…_1594855600920&show_all_items=true&_=1594855600921 net::ERR_ABORTED 404 (Not Foun

Re: [Koha] Error in report

2020-07-15 Thread Alvaro Cornejo
Hi You can try this also SELECT branchname AS Branch, homebranch AS Branchcode, count( DISTINCT biblionumber) AS Records, count(itemnumber) AS Items FROM items LEFT JOIN branches ON (items.homebranch=branches.branchcode) GROUP BY branchname WITH ROLLUP LIMIT 50 Will provide records & ite

Re: [Koha] Unable to create patron

2020-07-18 Thread Alvaro Cornejo
Hi Miichael I´ll go back to js and delete all js content added opan/admin and test without them. I had an issue where a missing ' in a js killed the save button in the record edit page even though the js had nothing to do with the record edit function. note that this kind of error might come fr

[Koha] multilingual opac nav

2020-07-19 Thread Alvaro Cornejo
Hi Is there a way to have the opac nav bottom show content in the appropriate user language? ie if the user selects spanish, show content in spanish, and if he changes it to another language show content in the new language? I guess I´ll need some JS, first to detect language selected and the oth

Re: [Koha] multilingual opac nav (SOLVED)

2020-07-19 Thread Alvaro Cornejo
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 dim. 19 juil. 2020 à 12:50, Alvaro Cornejo a écrit : > Hi > > Is there a wa

Re: [Koha] openlibrary search error

2020-07-20 Thread Alvaro Cornejo
; jonathan.dru...@bugs.koha-community.org> a écrit : > Hi Alvaro, > > Which terms do you use for the search? What is the full openlibrary url? > > Regards, > Jonathan > > Le jeu. 16 juil. 2020 à 01:39, Alvaro Cornejo > a écrit : > > > > Hi > > > > Si

Re: [Koha] openlibrary search error

2020-07-21 Thread Alvaro Cornejo
oha-community.org> a écrit : > Hi Alvaro, > > If you have the openlibrary syspref ON, then a search to their services is > made. > Which exact version of Koha are you using? Can you share the url of the > OPAC? > > Regards, > Jonathan > > > Le mar. 21 jui

[Koha] dual cover images suport

2020-08-01 Thread Alvaro Cornejo
Hi We have seen that the cover images we have been loading into koha, in png format, are quite big (some over 1Mb) so we are checking a way to optimise their size. One option is to replace those png files with one with a lower resolution/size keeping the same png format and/or move to jpeg. Anot

Re: [Koha] dual cover images suport

2020-08-03 Thread Alvaro Cornejo
id Nind | david.n...@gmail.com > PO Box 12367, Thorndon, Wellington, New Zealand 6144 > m. +64 21 0537 847 > > > On Sun, 2 Aug 2020 at 06:13, Alvaro Cornejo > wrote: > >> Hi >> >> We have seen that the cover images we have been loading into koha, in png >>

Re: [Koha] Storage of Perl Scripts [Was: Orphaned Authority Records: Finding Them and Deleting Them]

2020-08-04 Thread Alvaro Cornejo
Hi Charles You can use "locate" command to find files in linux #sudo updatedb (Updates locate index) #sudlo locate remove_unused_authorities.pl the script mentioned is in #/usr/share/koha/bin/migration_tools/ For running you can go to that dir and do: # sudo koha-shell YOURLIBRARY_INSTANCE

Re: [Koha] Storage of Perl Scripts [Was: Orphaned Authority Records: Finding Them and Deleting Them]

2020-08-05 Thread Alvaro Cornejo
Hi Charles for the locate/updatdb commands, you can install it with # sudo apt-get install locate. You need to first run sudo updatedb before the sudo locate so your file index is updated before your search About the error, have you accessed your koha user shell before running it? Else you can

[Koha] Cache and languange change not working

2020-08-09 Thread Alvaro Cornejo
Hi Folllowing some advise from https://www.webpagetest.org/ and https://lighthouse-dot-webdotdevsite.appspot.com/ for optimizing koha. I´ve found small issues that I was able to fix locally and some, well,are too complex fro my knowledge and guess require changes in koha code. Note that lighth

[Koha] Intranet pending notification

2020-08-14 Thread Alvaro Cornejo
Hi Is there a way to move/duplicate the pending notification area to, for example the intranet breadcrumbs areas? or have a pop-up notification? Librarians can´t see it if they are anywhere away from the main intranet or they do not refresh it. Also in some low resolution screens, Librarian need

Re: [Koha] Intranet pending notification

2020-08-16 Thread Alvaro Cornejo
, Alvaro Cornejo a écrit : > Hi > > Is there a way to move/duplicate the pending notification area to, for > example the intranet breadcrumbs areas? or have a pop-up notification? > > Librarians can´t see it if they are anywhere away from the main intranet > or they do not refresh

Re: [Koha] Help with SQL script please

2020-08-24 Thread Alvaro Cornejo
Hi Gustavo Not sure where the error might be but for troubleshooting you can split your query from the inside out and see where it stops working. Also, if you do know the values for Jesuit%, you might replace that query with a list of values or a specific value for testing purposes. A) Test

[Koha] Internal redirects exceeded on staff and opac interface

2020-08-25 Thread Alvaro Cornejo
Hi, Doing a check on koha error logs I saw several of this error logs in both interfaces. How/where can I enable debug to check the origin of the error? [Mon Aug 24 07:42:42.636346 2020] [core:error] [pid 18902] [client 134.209.80.26:36734] AH00124: Request exceeded the limit of 10 internal redi

Re: [Koha] moving database from 17.5 to 19.11 error

2020-08-26 Thread Alvaro Cornejo
suggestion will be very appreciated :-) > > thanks > tommaso > > Il 08/01/20 07:13, Alvaro Cornejo ha scritto: > > Hi > > > > I´m tryin to do the DB move from 17.5 to 19.11. > > > > I take following steps: > > > > - backup 17.5 with koha-backup and I

[Koha] New version not showing in about page

2020-09-04 Thread Alvaro Cornejo
Hi I´ve upgraded my koha from 19.11.08 to 19.11.09 but koha about page still shows 19.11.08 How can I fix this? After upgrade I´ve restarted apache, memcached and plack and cleared my browser cache. I´m running ubuntu bionic (18.04) _ Server information (after upgrade to 19.

  1   2   3   >