Time  Nick     Message
20:42 aab      Hi there
13:47 huginn   Oak: The current temperature in Islamabad, Pakistan is 12.0°C (6:00 PM PKT on December 28, 2013). Conditions: Haze. Humidity: 51%. Dew Point: 2.0°C. Pressure: 30.09 in 1019 hPa (Falling).
13:47 Oak      @wunder islamabad
13:47 huginn   Oak: The current temperature in Taegerwilen, Taegerwilen, Germany is 2.8°C (2:45 PM CET on December 28, 2013). Conditions: Clear. Humidity: 97%. Dew Point: 2.0°C. Windchill: 3.0°C. Pressure: 29.71 in 1006 hPa (Steady).
13:47 Oak      @wunder Konstanz
07:44 Oak      :)
07:44 cait     [off] how did you know? :)
07:43 Oak      [off] time to wash your face now cait. brush teeth. then breakfast.
07:41 Oak      got it/
07:41 Oak      cool/
07:41 cait     we use packages at work, but for my dev environment i use a dev install
07:41 Oak      what Koha install are you running cait if it's not the package one?
07:40 cait     glad it worked
07:39 cait     np
07:39 Oak      thank you!
07:39 cait     phew :)
07:39 Oak      cait++
07:39 Oak      well, you saved my day.
07:38 cait     not sure why
07:38 cait     before
07:38 cait     i think it didn't reset properly
07:38 Oak      all other results are gone from search results!!!
07:38 Oak      oh wait
07:37 Oak      yeah, now rebuild-zebra says Records exported: 1
07:35 Oak      doing it
07:35 cait     normally it would be the number of records indexed
07:35 Oak      hmm. okay/
07:35 cait     try cataloguing a new one maybe ... see if that get indexed properly?
07:34 Oak      what does that mean?
07:34 cait     records exported is both 0
07:34 Oak      *sigh* 2.5 hours of head banging
07:34 cait     hm
07:34 Oak      hmm
07:34 cait     i haven't used the packages much so far
07:34 cait     sorry, just not sure what th eproblem could be
07:33 Oak      read it
07:33 Oak      cait i know all that
07:33 pastebot "Oak" at 192.168.0.204 pasted "Zebra configuration informatio" (40 lines) at http://paste.koha-community.org/46
07:32 cait     http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-rebuild-zebra
07:32 Oak      i'll paste output
07:32 Oak      no luck. command runs fine, but keep getting results in search
07:32 cait     sudo koha-rebuild-zebra -f -v  instancename < from the wiki
07:32 cait     guessing mostly here, but i think it might be the -a
07:31 Oak      wait
07:31 Oak      let me show you its output
07:31 cait     -a is authorities, you did -b too?
07:30 Oak      i did
07:30 cait     did you use -r?
07:30 Oak      with different switches
07:30 cait     i haven't used the packages much yet - i am not sure
07:30 Oak      yes
07:30 Oak      thekoha-rebuild-zebra one?
07:30 cait     oh you did
07:30 cait     i think maybe use the package command for full reindex
07:30 Oak      that " [warn] ir_session (exception)" is coming in logs since 26th December though.
07:30 cait     hm
07:28 Oak      when I click on a search result, It says "The record you requested does not exist (2)."
07:27 Oak      other than that, nothing odd in logs.
07:27 Oak      everytime i make search, this gets added to the zebra-output.log logs: zebrasrv(10) [warn] ir_session (exception)
07:27 Oak      and still, when I search, I am seeing all the book results. where are they coming from?
07:27 Oak      ran koha-foreach --enabled /usr/share/koha/bin/cronjobs/cleanup_database.pl --sessions --zebraqueue 10
07:26 Oak      koha-rebuild-zebra with -f, with -r, with -a
07:26 Oak      then "SET foreign_key_checks = 1;"
07:26 Oak      did "SET foreign_key_checks = 0;" and truncated biblio, biblioitems, items, import_records, import_items, import_biblios, zebraqueue, deletedbiblio, deletedbiblioitems in the database
07:26 Oak      used "Batch item deletion" in tools to delete all items.
07:26 Oak      wanted to delete all imported book records.
07:26 Oak      okay thanks!
07:25 cait     a bit sleepy still but we can try
07:25 * cait   checks
07:25 cait     i think
07:25 cait     it's saturday :)
07:11 Oak      you could be getting ready for work.
07:10 Oak      i mean if you are not busy...
07:10 Oak      :)
07:10 Oak      interested?
07:10 Oak      i have a koha problem.
07:09 cait     hi Oak
07:09 Oak      hello cait
06:55 Oak      magnuse?
06:55 Oak      ran cleanup_database.pl. no dice.
06:01 Oak      ok truncated tables. rebuilt zebra. search results still showing up. odd.
05:30 Oak      #1701 - Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `koha_test`.`biblio` (`biblionumber`))
05:30 Oak      but trying to empty 'bibiol' or 'biblioitems' says:
05:28 Oak      okay all items are deleted. how can i batch delete the records now? basically i just want to empty the database.
05:24 Oak      never mind. done.
05:14 Oak      on a Core i7, 8GB RAM machine.
05:13 Oak      how long should it take batchMod.pl to delete 8K items?
05:13 * Oak    waves
04:27 rangi    thanks cjh
04:10 cjh      I just noticed that I had received the 3.8.21 translation pull request, notified khall.