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.