IRC log for #koha, 2013-12-28

All times shown according to UTC.

Time S Nick Message
00:18 kenan24 joined #koha
00:39 ebegin joined #koha
04:10 cjh I just noticed that I had received the 3.8.21 translation pull request, notified khall.
04:27 rangi thanks cjh
05:12 Oak joined #koha
05:13 * Oak waves
05:13 Oak how long should it take to delete 8K items?
05:14 Oak on a Core i7, 8GB RAM machine.
05:24 Oak never mind. done.
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:30 Oak but trying to empty 'bibiol' or 'biblioitems' says:
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`))
06:01 Oak ok truncated tables. rebuilt zebra. search results still showing up. odd.
06:11 Oak joined #koha
06:55 Oak ran no dice.
06:55 Oak magnuse?
07:08 cait joined #koha
07:09 Oak hello cait
07:09 cait hi Oak
07:10 Oak i have a koha problem.
07:10 Oak interested?
07:10 Oak :)
07:10 Oak i mean if you are not busy...
07:11 Oak you could be getting ready for work.
07:25 cait it's saturday :)
07:25 cait i think
07:25 * cait checks
07:25 cait a bit sleepy still but we can try
07:26 Oak okay thanks!
07:26 Oak wanted to delete all imported book records.
07:26 Oak used "Batch item deletion" in tools to delete all items.
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 then "SET foreign_key_checks = 1;"
07:26 Oak koha-rebuild-zebra with -f, with -r, with -a
07:27 Oak ran koha-foreach --enabled /usr/share/koha/bin/cronjobs/ --sessions --zebraqueue 10
07:27 Oak and still, when I search, I am seeing all the book results. where are they coming from?
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 other than that, nothing odd in logs.
07:28 Oak when I click on a search result, It says "The record you requested does not exist (2)."
07:30 cait hm
07:30 Oak that " [warn] ir_session (exception)" is coming in logs since 26th December though.
07:30 cait i think maybe use the package command for full reindex
07:30 cait oh you did
07:30 Oak thekoha-rebuild-zebra one?
07:30 Oak yes
07:30 cait i haven't used the packages much yet - i am not sure
07:30 Oak with different switches
07:30 cait did you use -r?
07:30 Oak i did
07:31 cait -a is authorities, you did -b too?
07:31 Oak let me show you its output
07:31 Oak wait
07:32 cait guessing mostly here, but i think it might be the -a
07:32 cait sudo koha-rebuild-zebra -f -v  instancename < from the wiki
07:32 Oak no luck. command runs fine, but keep getting results in search
07:32 Oak i'll paste output
07:32 cait[…]oha-rebuild-zebra
07:33 pastebot "Oak" at pasted "Zebra configuration informatio" (40 lines) at
07:33 Oak cait i know all that
07:33 Oak read it
07:34 cait sorry, just not sure what th eproblem could be
07:34 cait i haven't used the packages much so far
07:34 Oak hmm
07:34 cait hm
07:34 Oak *sigh* 2.5 hours of head banging
07:34 cait records exported is both 0
07:34 Oak what does that mean?
07:35 cait try cataloguing a new one maybe ... see if that get indexed properly?
07:35 Oak hmm. okay/
07:35 cait normally it would be the number of records indexed
07:35 Oak doing it
07:37 Oak yeah, now rebuild-zebra says Records exported: 1
07:38 Oak oh wait
07:38 dpk1 joined #koha
07:38 Oak all other results are gone from search results!!!
07:38 cait i think it didn't reset properly
07:38 cait before
07:38 cait not sure why
07:39 Oak well, you saved my day.
07:39 Oak cait++
07:39 cait phew :)
07:39 Oak thank you!
07:39 cait np
07:40 cait glad it worked
07:41 Oak what Koha install are you running cait if it's not the package one?
07:41 cait we use packages at work, but for my dev environment i use a dev install
07:41 Oak cool/
07:41 Oak got it/
07:44 Oak :)
10:27 Oak joined #koha
13:42 Oak joined #koha
13:47 Oak @wunder Konstanz
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 islamabad
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).
15:27 ebegin joined #koha
16:31 kenan24 joined #koha
16:55 dpk1 joined #koha
17:03 kenan24 joined #koha
18:08 dpk1 joined #koha
19:18 Dyrcona joined #koha
20:42 aab joined #koha
20:42 aab Hi there
21:00 tcohen joined #koha
21:26 kenan24 joined #koha
23:19 gmcharlt_ joined #koha
23:20 markvandenborre joined #koha
23:21 denials joined #koha
23:35 dbs joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary