| Time |
S |
Nick |
Message |
| 00:02 |
|
wizzyrea |
https://bugs.koha-community.or[…]_bug.cgi?id=17698 it might have been this one |
| 00:02 |
|
huginn |
Bug 17698: enhancement, P5 - low, ---, aleisha, Needs Signoff , Make patron notes show up on staff dashboard |
| 00:04 |
|
wizzyrea |
https://bugs.koha-community.or[…].cgi?id=17698#c24 |
| 00:04 |
|
wizzyrea |
here |
| 00:04 |
|
huginn |
Bug 17698: enhancement, P5 - low, ---, aleisha, Needs Signoff , Make patron notes show up on staff dashboard |
| 00:05 |
|
mtj |
mtompset: when i get really stuck... i wrap the code block in a DBI trace |
| 00:06 |
|
mtj |
DBI->trace(2); |
| 00:06 |
|
mtj |
my $check_category = Koha::Patron::Categories->find( $categorycode ); |
| 00:06 |
|
mtj |
DBI->trace(0); |
| 00:06 |
|
mtj |
i think that trace syntax should work |
| 00:06 |
|
mtompset |
And where does that output go? |
| 00:07 |
|
mtj |
default error log, afaik |
| 00:08 |
|
mtj |
C4::Context->dbh->trace(2); |
| 00:08 |
|
mtj |
..that syntax works too |
| 00:10 |
|
mtj |
..its really handy for WTF sql bugs |
| 00:11 |
|
mtompset |
boy it is noisy. |
| 00:12 |
|
mtompset |
But I'm not sure I can make sense of it. |
| 00:13 |
|
mtompset |
It seems to have gotten the correct SQL query built. |
| 00:13 |
|
mtompset |
Binding parameters: SELECT COUNT( * ) FROM `categories` `me` WHERE ( `categorycode` = 'CPL' ) |
| 00:14 |
|
mtompset |
but it is returning 0 |
| 00:15 |
|
mtj |
trace(1) might be nicer for your situ |
| 00:16 |
|
pastebot |
"mtompset" at 127.0.0.1 pasted "Code Snippet" (6 lines) at http://paste.koha-community.org/547 |
| 00:17 |
|
pastebot |
"mtompset" at 127.0.0.1 pasted "Log Snippet" (104 lines) at http://paste.koha-community.org/548 |
| 00:20 |
|
mtompset |
Any novice mistakes that I made from what you can tell? |
| 00:22 |
|
mtj |
that dump is too nosiy for me to parse |
| 00:23 |
|
mtj |
trace a single statement |
| 00:23 |
|
mtompset |
I'm tweaking. |
| 00:25 |
|
pastebot |
"mtompset" at 127.0.0.1 pasted "just a Koha::Patron::Categories->find( $categorycode );" (85 lines) at http://paste.koha-community.org/549 |
| 00:25 |
|
mtompset |
I think I might try to REMOVE the URL noise. |
| 00:28 |
|
mtj |
https://httpd.apache.org/docs/[…]ml#errorlogformat |
| 00:28 |
|
pastebot |
"mtompset" at 127.0.0.1 pasted "less noisy" (85 lines) at http://paste.koha-community.org/550 |
| 00:29 |
|
mtj |
i use 'ErrorLogFormat "%M"' in my apache vhost file |
| 00:29 |
|
mtj |
.. which removes that referer/url noise |
| 00:30 |
|
mtj |
trace(1) looks better |
| 00:30 |
|
mtompset |
that aside... any ideas? |
| 00:31 |
|
mtompset |
why does the execute generate 0E0? |
| 00:33 |
|
mtj |
hmm, i cant set it calling a count().. so thats odd hey |
| 00:33 |
|
mtompset |
I changed the code trae. |
| 00:33 |
|
mtompset |
my $category = Koha::Patron::Categories->find( $categorycode ); |
| 00:36 |
|
mtj |
no ideas |
| 00:37 |
|
mtompset |
Well, thanks for the debugging tips. |
| 00:37 |
|
mtj |
..other than trace(2) looks to be a bit noisy - try trace(1) |
| 00:41 |
|
|
Francesca joined #koha |
| 00:45 |
|
|
Francesca joined #koha |
| 00:50 |
|
|
Francesca joined #koha |
| 01:11 |
|
|
dcook joined #koha |
| 01:30 |
|
|
Francesca joined #koha |
| 01:31 |
|
|
Francesca joined #koha |
| 01:34 |
|
|
Francesca joined #koha |
| 02:04 |
|
|
Francesca joined #koha |
| 02:59 |
|
|
JoshB joined #koha |
| 03:23 |
|
|
Francesca joined #koha |
| 05:35 |
|
|
cait joined #koha |
| 05:37 |
|
|
Scott-CSPL joined #koha |
| 06:19 |
|
|
LibraryClaire joined #koha |
| 06:47 |
|
|
AndrewIsh joined #koha |
| 06:52 |
|
|
paul_p joined #koha |
| 06:53 |
|
|
laurence joined #koha |
| 07:01 |
|
|
fridolin joined #koha |
| 07:22 |
|
|
sophie_m joined #koha |
| 07:24 |
|
|
greenjimll joined #koha |
| 07:35 |
|
|
cait joined #koha |
| 07:37 |
|
|
gaetan_B joined #koha |
| 07:37 |
|
gaetan_B |
hello |
| 07:43 |
|
* cait |
waves |
| 07:43 |
|
cait |
good morning #koha |
| 09:14 |
|
|
eddie joined #koha |
| 09:52 |
|
* kidclamp |
waves |
| 10:01 |
|
eythian |
hi |
| 10:25 |
|
|
fridolin joined #koha |
| 10:37 |
|
|
Francesca joined #koha |
| 11:19 |
|
|
caboose joined #koha |
| 11:24 |
|
|
JesseM joined #koha |
| 11:27 |
|
|
meliss joined #koha |
| 12:08 |
|
|
nengard joined #koha |
| 12:11 |
|
|
edveal joined #koha |
| 12:28 |
|
|
jzairo joined #koha |
| 12:29 |
|
|
talljoy joined #koha |
| 12:34 |
|
|
LeeJ joined #koha |
| 12:34 |
|
* LeeJ |
waves |
| 12:34 |
|
LeeJ |
morning #koha |
| 12:36 |
|
* LeeJ |
settles into his new office |
| 12:38 |
|
|
kellym joined #koha |
| 12:41 |
|
Joubu |
hi #koha |
| 12:42 |
|
|
khall joined #koha |
| 12:45 |
|
JesseM |
hi Joubu |
| 12:47 |
|
LeeJ |
hi to everyone! |
| 12:47 |
|
|
gerundio joined #koha |
| 12:50 |
|
|
edveal joined #koha |
| 12:54 |
|
|
marcelr joined #koha |
| 12:54 |
|
marcelr |
hi #koha |
| 13:03 |
|
LeeJ |
hi marcelr |
| 13:03 |
|
marcelr |
hey LeeJ |
| 13:09 |
|
|
kmlussier joined #koha |
| 13:15 |
|
|
Dyrcona joined #koha |
| 13:17 |
|
|
NateC joined #koha |
| 13:17 |
|
gerundio |
hi everyone |
| 13:19 |
|
gerundio |
I'm using koha 3.22.07 and after a library staff member performed an inventory operation in the intranet UI our error log sky rocketed |
| 13:19 |
|
gerundio |
25G worth of "inventory.pl: Use of uninitialized value in string eq at /usr/share/koha/intranet/cgi-bin/tools/inventory.pl line 326" in 2.5h |
| 13:21 |
|
gerundio |
after clearing up the logs and stoping apache, a "0" file under a /tmp subdir consumed all the 25G in a blink of an eye |
| 13:21 |
|
gerundio |
I just stopped the zebra process and things seems calmer now |
| 13:26 |
|
|
meliss joined #koha |
| 13:26 |
|
gerundio |
any idea what could be behind this behavior? |
| 13:33 |
|
cait |
we recenty had a dateformat problem with inventory |
| 13:33 |
|
cait |
but it just caused an error |
| 13:36 |
|
gerundio |
@cait, whatever the process was, it wrote a lot of entries just like that every second in the error log |
| 13:36 |
|
huginn |
gerundio: I'll give you the answer just as soon as RDA is ready |
| 13:36 |
|
huginn |
New commit(s) kohagit: Bug 17829: Fix import patron <http://git.koha-community.org/[…]6494816ecaeedb200> |
| 13:37 |
|
cait |
it seems quiet here tonight, maybe somoene on the mailing list will know more |
| 13:39 |
|
Joubu |
Hi gerundio, the last version of the 3.22 series is 3.22.21, could you try with it? |
| 13:40 |
|
gerundio |
@Joubu, not at the moment |
| 13:40 |
|
huginn |
gerundio: I'll give you the answer as soon as RDA is ready |
| 13:44 |
|
gerundio |
@huginn ok, I'll be here |
| 13:44 |
|
huginn |
gerundio: I've exhausted my database of quotes |
| 13:44 |
|
gerundio |
lolol, bot, should've figured |
| 13:46 |
|
|
AdamB_ joined #koha |
| 13:49 |
|
|
kellym joined #koha |
| 13:58 |
|
|
jac joined #koha |
| 14:09 |
|
Joubu |
cait: so, what's next? :) |
| 14:09 |
|
cait |
sorry, didn't check today |
| 14:09 |
|
cait |
any movement on the bugs? |
| 14:10 |
|
cait |
i think next is pushing, backporting... and a clean-up script/instructions |
| 14:10 |
|
cait |
what do I do if the script says there are duplicated ids? |
| 14:10 |
|
Joubu |
sounds like bug 18966 is SO, tcohen added his SO patches but did not switch the status |
| 14:10 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=18966 blocker, P5 - low, ---, jonathan.druart, Needs Signoff , Move of checkouts - Deal with duplicate IDs at DBMS level |
| 14:10 |
|
cait |
it's rather easy for issues compared to some of the others |
| 14:10 |
|
cait |
but i think issues is the most important |
| 14:10 |
|
cait |
i'd agree |
| 14:10 |
|
cait |
I have added mine to the 16.11 ones as I didn't test with all versions |
| 14:12 |
|
Joubu |
fridolin, mtj: around this week? Ready to release in the next days? |
| 14:13 |
|
fridolin |
yep |
| 14:13 |
|
fridolin |
iam |
| 14:14 |
|
cait |
same here |
| 14:14 |
|
Joubu |
fridolin: will you have time to take a look at 18966? |
| 14:15 |
|
fridolin |
Joubu: yep i will take time , lets say Thurthday |
| 14:15 |
|
fridolin |
Joubu: check on 17.05.x you mean right ? |
| 14:15 |
|
Joubu |
yes |
| 14:16 |
|
fridolin |
looks like optimize table can reset the next id |
| 14:16 |
|
fridolin |
I'll test that with reboot |
| 14:18 |
|
fridolin |
I've had today the same issue with old_reserves |
| 14:18 |
|
fridolin |
huggly bug |
| 14:21 |
|
cait |
yes, we have seen it in 3.22 too with reserves |
| 14:21 |
|
cait |
but it fails silently |
| 14:21 |
|
cait |
just in the logs |
| 14:22 |
|
cait |
and the reserve will be either filled or cancelled... losing that is not that big of a proble compared to an issue with connected fines |
| 14:26 |
|
cait |
Is someone working on clean-up instrucstions? |
| 14:26 |
|
Joubu |
@later tell khall Hi! Do you have plan for bug 15707? |
| 14:26 |
|
huginn |
Joubu: The operation succeeded. |
| 14:31 |
|
|
LibraryClaire left #koha |
| 14:34 |
|
fridolin |
cait: cleanup_database you mean ? |
| 14:34 |
|
fridolin |
i plan to add old_xxx and deleted_xxx |
| 14:35 |
|
fridolin |
even statistics |
| 14:35 |
|
fridolin |
some of our databases are reeeeely old and those tables always get bigger |
| 14:36 |
|
cait |
@later tell fridolin - no, I meant a way to actually return the book from the account, as the new patches will stop the transaction |
| 14:36 |
|
huginn |
cait: The operation succeeded. |
| 14:36 |
|
Joubu |
cait: I am not willing to propose it, I think support companies should provide and share such fix when they will face the different problems |
| 14:37 |
|
|
fridolin joined #koha |
| 14:37 |
|
cait |
@later tell fridolin and simply truncating them will cause you unhappy libraries - old issues is used for statistics rather heavily |
| 14:37 |
|
huginn |
cait: The operation succeeded. |
| 14:38 |
|
fridolin |
cait: not all libraries do stats, and some have 10 years old rows, useless |
| 14:38 |
|
cait |
depends on the library i guess |
| 14:38 |
|
fridolin |
and not so good for privacy |
| 14:38 |
|
fridolin |
O:-) |
| 14:38 |
|
cait |
we are aiming for a tool to anonymize frequently |
| 14:38 |
|
cait |
agreed on that point |
| 14:39 |
|
cait |
but removing the link to borrowers would already help with that |
| 14:39 |
|
cait |
you can do that from the interface with one of the tools, but I think it would be nicer as a cronjob |
| 14:39 |
|
cait |
also depetedborrowers |
| 14:39 |
|
cait |
remove everything that is not needed for reports (branchcode, categorycode, sort1 sort1 maybe...) |
| 14:39 |
|
fridolin |
deletedbiblioitems is huge in database |
| 14:39 |
|
cait |
we need to keep inventorybooks here |
| 14:39 |
|
fridolin |
it takes space in innobd buffer pool |
| 14:40 |
|
cait |
so throwing out data to identify the book deleted... could be a problem |
| 14:40 |
|
cait |
but yeah, having the options is sitll good, not stopping you :) |
| 14:40 |
|
fridolin |
i'll propose a simple truncation of tables |
| 14:40 |
|
cait |
just have spent some time working on a concept aroudn those |
| 14:40 |
|
cait |
concept of how long to store which data... so I thought about it quite a lot |
| 14:41 |
|
fridolin |
yep |
| 14:41 |
|
fridolin |
i'm more a datakiller, simple and performant |
| 14:41 |
|
fridolin |
most libraries just dont know it exists ;) |
| 14:42 |
|
fridolin |
and privacy is always in danger when data exists, even anonymously |
| 14:56 |
|
|
tcohen joined #koha |
| 14:56 |
|
cait |
ours are pretty keen on satistics |
| 14:56 |
|
cait |
more and more so even |
| 14:56 |
|
cait |
more pressure on the libraries to deliver reports and numbers |
| 14:56 |
|
cait |
so i think anonymization could be a good middle ground |
| 14:56 |
|
tcohen |
morning |
| 14:57 |
|
cait |
morning tcohen |
| 14:59 |
|
|
TGoat joined #koha |
| 15:02 |
|
Joubu |
jajm: around? |
| 15:06 |
|
jajm |
Joubu, i'm leaving, sorry |
| 15:06 |
|
|
fridolin left #koha |
| 15:07 |
|
Joubu |
jajm: it would be great if you could take a look at bug 18966, it is delaying stable releases |
| 15:07 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=18966 blocker, P5 - low, ---, jonathan.druart, Signed Off , Move of checkouts - Deal with duplicate IDs at DBMS level |
| 15:08 |
|
Joubu |
that can wait tomorrow : |
| 15:08 |
|
Joubu |
:) |
| 15:10 |
|
cait |
have to leave too and work on something non-koha when i get home tonight |
| 15:10 |
|
cait |
will be back tomorrow |
| 15:10 |
|
|
cait left #koha |
| 15:18 |
|
|
jbeno joined #koha |
| 15:23 |
|
|
laurence left #koha |
| 15:43 |
|
|
greenjimll joined #koha |
| 15:43 |
|
jenkins |
Project Koha_Master_D8 build #227: UNSTABLE in 2 hr 0 min: https://jenkins.koha-community[…]ha_Master_D8/227/ |
| 15:43 |
|
jenkins |
Jonathan Druart: Bug 17829: Fix import patron |
| 15:43 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=17829 enhancement, P5 - low, ---, jonathan.druart, RESOLVED FIXED, Move GetMember to Koha::Patron |
| 15:48 |
|
|
cait joined #koha |
| 15:55 |
|
|
greenjimll joined #koha |
| 16:17 |
|
|
greenjimll joined #koha |
| 16:20 |
|
|
LeeJ joined #koha |
| 16:20 |
|
* LeeJ |
waves |
| 16:25 |
|
|
CJSHayward joined #koha |
| 16:25 |
|
CJSHayward |
I am interested in installing Koha along the lines outlined in https://web.archive.org/web/20[…]y.org/wiki/Debian rather than bundled with a complete life support system. |
| 16:26 |
|
CJSHayward |
I've got Koha listening in some sense, at least, but I get an error page: "Software error: Can't call method "config" on unblessed reference at /usr/share/koha/lib/Koha/Database.pm line 56. For help, please send mail to the webmaster (webmaster localhost), giving this error message and the time and date of the error." |
| 16:32 |
|
LeeJ |
CJSHayward: it would take some digging into the Koha commit log but it appears you are having repo conflicts. Which version of Koha are you attempting to install? |
| 16:33 |
|
CJSHayward |
I attempted to install "stable." Would you advise I wipe completely (I don't have anything valuable in the system) all Koha installation(s) and reinstall? If so, how can I do that? |
| 16:35 |
|
|
CJSHayward joined #koha |
| 16:36 |
|
LeeJ |
CJSHayward: if you're trying to install the version of stable listed in that link you posted (which would mean you are trying to install Koha 3.22) that is most likely the problem you have as since 3.22 there have been significant changes to most of the Koha modules (in this case Database.pm) |
| 16:36 |
|
CJSHayward |
Ok; thank you. |
| 16:37 |
|
LeeJ |
CJSHayward: the current stable version is 17.05 |
| 16:37 |
|
CJSHayward |
So is there an easy way to wipe all installation(s) and reinstall? |
| 16:38 |
|
LeeJ |
none that I'm aware of other than starting over, I'm afraid. However, I could be wrong. Asking on the Koha lists may yield more helpful information |
| 16:43 |
|
|
edveal joined #koha |
| 16:51 |
|
Joubu |
CJSHayward: you can list the instances with koha-list, the delete them one by one with koha-remove |
| 16:52 |
|
Joubu |
you should consider using the wiki page https://wiki.koha-community.org/wiki/Debian, and install a recent Koha version on top of a recent Debian-base OS |
| 16:52 |
|
Joubu |
i.e. jessie-based |
| 17:49 |
|
LeeJ |
anyone have any suggestions how to get jQuery's datetimepicker to function in the OPAC? |
| 17:49 |
|
LeeJ |
for a plugin |
| 17:54 |
|
cait |
hm |
| 17:54 |
|
cait |
you need the time part, right? |
| 17:55 |
|
cait |
trying to remember if we have that somewhere.... but i think we might not in the OPAC |
| 17:57 |
|
kidClamp |
check the rolling hard due dates plugin LeeJ - I think that has date picker |
| 17:58 |
|
kidClamp |
https://github.com/bywatersolu[…]ng-hard-due-dates |
| 17:58 |
|
kidClamp |
or kitchen sink maybe: https://github.com/bywatersolu[…]ugin-kitchen-sink |
| 17:58 |
|
kidClamp |
when in doubt - copy and paste :D |
| 18:06 |
|
LeeJ |
kidClamp++ # for having his thinking cap on today when I don't |
| 18:07 |
|
LeeJ |
kidClamp: ahhh...looks like rolling hard due dates uses calendar.inc |
| 19:08 |
|
|
jbeno1 joined #koha |
| 20:05 |
|
huginn |
New commit(s) kohagit: Bug 18982: Create a circ rule for the data we created <http://git.koha-community.org/[…]ed1067ed61f822a4b> / Bug 18982: Create a specific itemtype for these tests <http://git.koha-community.org/[…]2e59e90daa1b1524a> / Bug 18982: category.categorycode must be uppercase <http://git.koha-community.org/gitweb/?p=koha.git; |
| 20:18 |
|
|
CJSHayward_ joined #koha |
| 20:35 |
|
cait |
Joubu: bug 18984 - interesting! |
| 20:35 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=18984 enhancement, P5 - low, ---, magnus, NEW , Remove support for NORMARC |
| 20:38 |
|
Joubu |
heh, good :) |
| 20:41 |
|
|
edveal_ joined #koha |
| 20:44 |
|
|
edveal joined #koha |
| 20:48 |
|
|
edveal joined #koha |
| 21:28 |
|
rangi |
oh cool :) |
| 21:30 |
|
cait |
hm? |
| 21:34 |
|
wizzyrea |
ooh, do they not use normarc anymore? |
| 21:34 |
|
wizzyrea |
or do they do like, bibframe now |
| 21:36 |
|
cait |
marc21 |
| 21:37 |
|
wizzyrea |
neat |
| 21:44 |
|
|
JoshB left #koha |
| 21:52 |
|
|
alexbuckley joined #koha |
| 22:00 |
|
eythian |
https://mpsh.ru/25406-ukrainka[…]-nevozmozhno.html <-- wizzyrea, now you know what to expect from your move to NZ |
| 22:02 |
|
wizzyrea |
everything will be in russian? |
| 22:05 |
|
wizzyrea |
hm. |
| 22:05 |
|
eythian |
Volcanos, snakes, etc. |
| 22:13 |
|
jenkins |
Project Koha_Master_D8 build #228: STILL UNSTABLE in 2 hr 0 min: https://jenkins.koha-community[…]ha_Master_D8/228/ |
| 22:13 |
|
jenkins |
* Jonathan Druart: Bug 18982: Use KOHA_INTRANET_URL instead of syspref staffClientBaseURL |
| 22:13 |
|
jenkins |
* Jonathan Druart: Bug 18982: category.categorycode must be uppercase |
| 22:13 |
|
jenkins |
* Jonathan Druart: Bug 18982: Create a specific itemtype for these tests |
| 22:13 |
|
jenkins |
* Jonathan Druart: Bug 18982: Create a circ rule for the data we created |
| 22:13 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=18982 normal, P5 - low, ---, jonathan.druart, Pushed to Master , selenium tests needs too many prerequisites |
| 22:53 |
|
|
lisettelatah joined #koha |
| 23:03 |
|
|
jac joined #koha |
| 23:22 |
|
|
edveal joined #koha |
| 23:59 |
|
|
Francesca joined #koha |
