[Koha] New items not showing

Sat Mar 6 03:38:34 NZDT 2021

👍👏🤘😀

that did it !!!

Thank you Sir !!!

and .... are there upgrade instructions to 20.05 posted somewhere.??
all I ever do is:

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install koha-common

On Fri, Mar 5, 2021 at 9:10 AM Tomas Cohen Arazi <tomascohen at gmail.com>
wrote:

> My suggestion is:
>
> # get the instance name
> $ sudo koha-list
> # fix permissions
> $ sudo chown -R <instance>-koha:<instance>-koha /var/lib/koha/<instance>
> # perform a full rebuild, the package's way
> $ sudo koha-rebuild-zebra -f -a -b -v <instance>
> # make sure the indexer is enabled (should read USE_INDEXER_DAEMON="yes")
> $ sudo vim /etc/default/koha-common
> # start the indexer
> $ sudo koha-indexer --restart <instance>
>
> The init service 'koha-common' already handles the koha-indexer, so you
> can just
> $ sudo service koha-common restart
>
> One thing you can do is running this on a terminal:
> $ watch -n 0.5 'echo "SELECT * FROM zebraqueue WHERE done=0;| sudo
> koha-mysql <instance>"'
>
> You will see the 'pending' updates. If it is empty, you can just edit
> something and see things added, and then disappear.
> If they don't seem to be updated (the indexes) then you should look at
> /var/log/koha/<instance>/indexer*.log
>
> BTW: I strongly suggest you upgrade (at least) to the 20.05 release (19.11
> is still maintained but not sure how long).
>
> Good luck!
>
>
> El vie, 5 mar 2021 a las 10:58, Scott Owen (<sowen at almaschools.net>)
> escribió:
>
>> yes.
>>
>> On Fri, Mar 5, 2021 at 8:55 AM Tomas Cohen Arazi <tomascohen at gmail.com>
>> wrote:
>>
>>> Did you install Koha using the Debian repository at
>>> debian.koha-community.org and then installing 'koha-common'?
>>>
>>>
>>> El vie, 5 mar 2021 a las 10:51, Scott Owen (<sowen at almaschools.net>)
>>> escribió:
>>>
>>>> Version:
>>>>
>>>> ***********************************************
>>>> Koha version: 17.11.18.000
>>>> OS version ('uname -a'): Linux hskoha 3.16.0-4-686-pae #1 SMP Debian
>>>> 3.16.51-3 (2017-12-13) i686
>>>> Perl interpreter: /usr/bin/perl
>>>> Perl version: 5.020002
>>>> Perl @INC: /usr/share/koha/lib
>>>> /etc/perl
>>>> /usr/local/lib/i386-linux-gnu/perl/5.20.2
>>>> /usr/local/share/perl/5.20.2
>>>> /usr/lib/i386-linux-gnu/perl5/5.20
>>>> /usr/share/perl5
>>>> /usr/lib/i386-linux-gnu/perl/5.20
>>>> /usr/share/perl/5.20
>>>> /usr/local/lib/site_perl
>>>> .
>>>> MySQL version: mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu
>>>> (i686) using readline 6.3
>>>> Apache version: Server version: Apache/2.4.10 (Debian)
>>>> Memcached: Servers: undefined | Namespace: koha | Status: unknown |
>>>> Config read from: Nowhere Note that the right place to define the memcached
>>>> config is in your $KOHA_CONF file. Currently you do not have a valid
>>>> memcached configuration defined. | Effective caching method:
>>>> Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free
>>>> software, covered by the GNU General Public License, and you are welcome to
>>>> change it and/or distribute copies of it under certain conditions. SHA1 ID:
>>>> c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU
>>>> ***********************************************************
>>>>
>>>>
>>>> " and maybe that's why the incremental indexer is failing, as it is
>>>> running as the instance's user."
>>>> -- certainly sounds possible.
>>>>
>>>> --  Any way to test / verify koha-indexer ?? (login as different users
>>>> via putty and run the command ?? What output should I expect to see ...if
>>>> any... )
>>>>
>>>> thank you!
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, Mar 5, 2021 at 8:35 AM Tomas Cohen Arazi <tomascohen at gmail.com>
>>>> wrote:
>>>>
>>>>> What Koha version are you using and what install method?
>>>>>
>>>>> When you use Debian packages, you are provided with a script
>>>>> (koha-indexer) that can be used to start/stop the incremental indexing of
>>>>> any changes on the DB, without the need of a full reindex.
>>>>> Also, the fact you are used to manually run rebuild_zebra.pl (instead
>>>>> of, again, the management scripts the packages provide like
>>>>> koha-rebuild-zebra) with the --run-as-root flag, makes me suspect running
>>>>> with --run-as-root is generating a permissions issue on the Zebra index
>>>>> files, and maybe that's why the incremental indexer is failing, as it is
>>>>> running as the instance's user.
>>>>>
>>>>> Hope it clarifies
>>>>> Keep us posted
>>>>>
>>>>> El vie, 5 mar 2021 a las 10:23, Scott Owen (<sowen at almaschools.net>)
>>>>> escribió:
>>>>>
>>>>>> ..until I do a DB repair/rebuild.
>>>>>> Items are added, lookups done at LOC etc...everything seems OK...
>>>>>> but...the items never "show up" in Koha...ie: users search for the
>>>>>> items,
>>>>>> but get no results until I run a rebuild/repair
>>>>>>
>>>>>> I'm unsure of where to even start looking?
>>>>>>
>>>>>>
>>>>>> export PERL5LIB=/usr/share/koha/lib/
>>>>>> export KOHA_CONF=/etc/koha/sites/<My_Site>/koha-conf.xml
>>>>>> perl /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v
>>>>>> -run-as-root
>>>>>> _______________________________________________
>>>>>>
>>>>>> Koha mailing list  http://koha-community.org
>>>>>> Koha at 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
>>>>>
>>>>
>>>
>>> --
>>> Tomás Cohen Arazi
>>> Theke Solutions (http://theke.io)
>>> ✆ +54 9351 3513384
>>> GPG: B2F3C15F
>>>
>>
>
> --
> Tomás Cohen Arazi
> Theke Solutions (http://theke.io)
> ✆ +54 9351 3513384
> GPG: B2F3C15F
>