← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 batchMod.pl to delete 8K items? |
| 05:14 | on a Core i7, 8GB RAM machine. | |
| 05:24 | never mind. done. | |
| 05:28 | okay all items are deleted. how can i batch delete the records now? basically i just want to empty the database. | |
| 05:30 | but trying to empty 'bibiol' or 'biblioitems' says: | |
| 05:30 | #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 | ok truncated tables. rebuilt zebra. search results still showing up. odd. | |
| 06:11 | Oak joined #koha | |
| 06:55 | Oak | ran cleanup_database.pl. no dice. |
| 06:55 | 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 | interested? | |
| 07:10 | :) | |
| 07:10 | i mean if you are not busy... | |
| 07:11 | you could be getting ready for work. | |
| 07:25 | cait | it's saturday :) |
| 07:25 | i think | |
| 07:25 | * cait | checks |
| 07:25 | cait | a bit sleepy still but we can try |
| 07:26 | Oak | okay thanks! |
| 07:26 | wanted to delete all imported book records. | |
| 07:26 | used "Batch item deletion" in tools to delete all items. | |
| 07:26 | 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 | then "SET foreign_key_checks = 1;" | |
| 07:26 | koha-rebuild-zebra with -f, with -r, with -a | |
| 07:27 | ran koha-foreach --enabled /usr/share/koha/bin/cronjobs/cleanup_database.pl --sessions --zebraqueue 10 | |
| 07:27 | and still, when I search, I am seeing all the book results. where are they coming from? | |
| 07:27 | everytime i make search, this gets added to the zebra-output.log logs: zebrasrv(10) [warn] ir_session (exception) | |
| 07:27 | other than that, nothing odd in logs. | |
| 07:28 | 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 | oh you did | |
| 07:30 | Oak | thekoha-rebuild-zebra one? |
| 07:30 | 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 | wait | |
| 07:32 | cait | guessing mostly here, but i think it might be the -a |
| 07:32 | 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 | i'll paste output | |
| 07:32 | cait | http://wiki.koha-community.org[…]oha-rebuild-zebra |
| 07:33 | pastebot | "Oak" at 192.168.0.204 pasted "Zebra configuration informatio" (40 lines) at http://paste.koha-community.org/46 |
| 07:33 | Oak | cait i know all that |
| 07:33 | read it | |
| 07:34 | cait | sorry, just not sure what th eproblem could be |
| 07:34 | 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 | yeah, now rebuild-zebra says Records exported: 1 | |
| 07:38 | 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 | before | |
| 07:38 | not sure why | |
| 07:39 | Oak | well, you saved my day. |
| 07:39 | cait++ | |
| 07:39 | cait | phew :) |
| 07:39 | Oak | thank you! |
| 07:39 | cait | np |
| 07:40 | 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 | got it/ | |
| 07:44 | :) | |
| 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 |
← Previous day | Today | Next day → | Search | Index