| 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 batchMod.pl 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 cleanup_database.pl. 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/cleanup_database.pl --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 |
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 |
|
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 |
