Time |
S |
Nick |
Message |
00:54 |
|
|
lukeG1 joined #koha |
01:41 |
|
|
mtj left #koha |
01:41 |
|
|
mtj joined #koha |
04:34 |
|
|
dcook_ joined #koha |
05:34 |
|
|
dcook__ joined #koha |
07:07 |
|
|
sonOfRa_ joined #koha |
07:07 |
|
|
cait joined #koha |
07:08 |
|
|
cait1 joined #koha |
07:22 |
|
|
reiveune joined #koha |
07:23 |
|
reiveune |
hello |
07:23 |
|
wahanui |
what's up, reiveune |
07:25 |
|
huginn |
News from kohagit: Bug 18532: Add missing notice template for it-IT <https://git.koha-community.org[…]0f7b4f7145a2bd050> |
07:29 |
|
|
did joined #koha |
07:49 |
|
|
lds joined #koha |
07:54 |
|
|
alex_a joined #koha |
07:54 |
|
alex_a |
Bonjour |
07:54 |
|
wahanui |
what's up, alex_a |
07:58 |
|
cait1 |
good morning #koha |
07:59 |
|
koha-jenkins |
Yippee, build fixed! |
07:59 |
|
wahanui |
Congratulations! |
07:59 |
|
koha-jenkins |
Project Koha_Master_D9_MDB_Latest build #549: FIXED in 31 min: https://jenkins.koha-community[…]9_MDB_Latest/549/ |
08:10 |
|
|
dersmon joined #koha |
08:11 |
|
|
paul_p joined #koha |
08:11 |
|
|
nlegrand joined #koha |
08:11 |
|
nlegrand |
Bonjour #koha ! |
08:13 |
|
dersmon |
hi! |
08:16 |
|
koha-jenkins |
Yippee, build fixed! |
08:16 |
|
wahanui |
Congratulations! |
08:16 |
|
koha-jenkins |
Project Koha_Master_U2010 build #134: FIXED in 50 min: https://jenkins.koha-community[…]Master_U2010/134/ |
08:17 |
|
dersmon |
quick question: can i configure the oai pmh endpoint so that it uses 001 instead of the biblionumber for generating record ids? |
08:18 |
|
cait1 |
magnuse: do i remember right that you di d that? |
08:18 |
|
koha-jenkins |
Yippee, build fixed! |
08:18 |
|
wahanui |
Congratulations! |
08:18 |
|
koha-jenkins |
Project Koha_Master_D11 build #245: FIXED in 52 min: https://jenkins.koha-community[…]a_Master_D11/245/ |
08:18 |
|
cait1 |
dersmon: i think you could use a custom xslt that is linked to the metadata format |
08:18 |
|
cait1 |
iirc |
08:19 |
|
cait1 |
but we haven't made a change like this yet |
08:19 |
|
cait1 |
trainign a library again this morning - bbl! |
08:19 |
|
magnuse |
dersmon: i think i have done something like that, let me cgeck |
08:19 |
|
magnuse |
*check |
08:25 |
|
pastebot |
"magnuse" at 127.0.0.1 pasted "XSLT to put biblionumber in 001" (32 lines) at http://paste.koha-community.org/28242 |
08:25 |
|
magnuse |
dersmon: ^ |
08:25 |
|
dersmon |
nice! |
08:26 |
|
dersmon |
thank you :) |
08:26 |
|
magnuse |
np |
08:27 |
|
koha-jenkins |
Yippee, build fixed! |
08:27 |
|
wahanui |
Congratulations! |
08:27 |
|
koha-jenkins |
Project Koha_Master_D9 build #1601: FIXED in 58 min: https://jenkins.koha-community[…]a_Master_D9/1601/ |
08:30 |
|
dersmon |
just to make sure: i just added your file as /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/xslt/MARC21slim2OAIcustom.xsl |
08:30 |
|
dersmon |
and then added xsl_file: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/xslt/MARC21slim2OAIZenon.xsl to the marcxml config in koha-oai.conf |
08:31 |
|
dersmon |
ah whoops, xsl_file: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/xslt/MARC21slim2OAIcustom.xsl |
08:32 |
|
dersmon |
do i have to rebuild the sets? |
08:32 |
|
dersmon |
currently i dont see any change |
08:34 |
|
Joubu |
restart memcached |
08:35 |
|
dersmon |
ah wait, i think your script does something different |
08:35 |
|
dersmon |
sorry |
08:35 |
|
dersmon |
i do not want biblionumber as 001 |
08:35 |
|
dersmon |
i want the oai id to be 001 instead of biblionumber |
08:36 |
|
magnuse |
ah, sorry, i was a bit quick then |
08:37 |
|
koha-jenkins |
Yippee, build fixed! |
08:37 |
|
wahanui |
Congratulations! |
08:37 |
|
koha-jenkins |
Project Koha_Master_D9_My8 build #532: FIXED in 1 hr 10 min: https://jenkins.koha-community[…]aster_D9_My8/532/ |
08:38 |
|
magnuse |
you have the syspref OAI-PMH:archiveID, but that does not use any placeholders or other fancy stuff, i think |
08:40 |
|
magnuse |
dersmon: if i remember correctly, OAI-PMH:archiveID is combined with the biblionumber to form the record id? but you want it to use the value from 001 instead? |
08:40 |
|
magnuse |
i don't think that is possible. i might be wrong, but i think the xslt only works on the marcxml, not on the wrapping around it. i might remember it wrong, though! |
08:41 |
|
dersmon |
yeah, i think you are right |
08:41 |
|
dersmon |
the xsl only applies to the record part of the oai response |
09:00 |
|
|
severine_q joined #koha |
09:01 |
|
severine_q |
Hi #koha ! |
09:02 |
|
koha-jenkins |
Yippee, build fixed! |
09:02 |
|
wahanui |
Congratulations! |
09:02 |
|
koha-jenkins |
Project Koha_Master build #1600: FIXED in 45 min: https://jenkins.koha-community[…]Koha_Master/1600/ |
09:53 |
|
koha-jenkins |
Yippee, build fixed! |
09:53 |
|
wahanui |
Congratulations! |
09:53 |
|
koha-jenkins |
Project Koha_Master_D10_CPAN build #276: FIXED in 51 min: https://jenkins.koha-community[…]ter_D10_CPAN/276/ |
10:08 |
|
|
simiya joined #koha |
10:09 |
|
simiya |
hi everybody |
10:12 |
|
simiya |
anybody knows how to seperate book reviews from articles in koha |
10:12 |
|
simiya |
there is no specific filed in marc to do that |
10:13 |
|
simiya |
articles and bookreviews are same as marc standards |
10:16 |
|
simiya |
if leader7-8 are ab koha consider record as article |
10:16 |
|
simiya |
any idea? |
10:16 |
|
|
TimothyAlexis joined #koha |
10:17 |
|
TimothyAlexis |
I'm wondering: Where does the (Item is deleted) string get appended to the title? |
10:21 |
|
|
alex_a_ joined #koha |
10:25 |
|
oleonard-away |
TimothyAlexis: Where do you see it? |
10:36 |
|
|
TimothyAlexis joined #koha |
10:36 |
|
TimothyAlexis |
It's in /cgi-bin/koha/members/pay.pl |
10:36 |
|
ashimema |
ooh.. that's a new one to me.. and I've played in that area allot over the last few years |
10:37 |
|
ashimema |
funny what you're not aware of sometimes |
10:37 |
|
TimothyAlexis |
Could it be something we've added in our branch? |
10:38 |
|
tcohen |
simiya I believe the term 'Article' in Koha is not accurate. It was just convenient for most users at some point |
10:42 |
|
oleonard |
TimothyAlexis: I can't find it in the code or make it appear |
10:42 |
|
ashimema |
pass |
10:43 |
|
TimothyAlexis |
oleonard then it's probably something only in our branch |
10:46 |
|
simiya |
so i should use a local marc field to detemine type of record and should edit MARC21slim2OPACDetail.xsl to tell koha that if field value was x show matrial type as Book review |
10:47 |
|
simiya |
is it a good strategy? |
10:49 |
|
|
khall joined #koha |
10:56 |
|
oleonard |
simiya: The only comment I have is that you should probably create a new xsl file rather than edit an existing one so that your changes won't be overwritten during upgrade |
10:56 |
|
oleonard |
simiya: The various XSLT system preferences allow you to specify a filename or full URL |
10:57 |
|
simiya |
i think koha must use another way other than by leader 7-8 to show record types . Same problem is in the cataloging theses and manuscripts |
10:57 |
|
simiya |
thesis and mnbuscripts both have tm in leader 7 and 8 position |
10:59 |
|
oleonard |
simiya: Have you examined MARC21slim2OPACDetail.xsl to see how it works? |
11:00 |
|
oleonard |
It does check the leader to show record types, but it may not be as specific as you want |
11:00 |
|
oleonard |
(it also might be incorrect, in which case it's a bug) |
11:01 |
|
simiya |
i have backup of xslt files |
11:03 |
|
simiya |
yeah. it check leader position 7-8. if 7 is a and b a or b. koha consider it as article |
11:05 |
|
oleonard |
Like tcohen said, this was probably a term chosen because it was more user-friendly than "Serial component part" while not being too innaccurate. |
11:05 |
|
simiya |
i changed xslt to if leader7 is a and 8 is a show book review and if leader8 is b show article but its not trure and dont solve the problem about other materials like thesis and manuscripts |
11:07 |
|
simiya |
marc has not any spesific field to determin defrence between article/bookreview or manuscript/thesis. so leader7-8 maybe not complete to this propose |
11:09 |
|
simiya |
if koha use a local field for this propose could be better. like filed 942$c that koha use for koha item type |
11:12 |
|
simiya |
thnks so much oleonardo and tchon. I wanted to make sure there was an easier way than editing xslt files |
11:31 |
|
|
sta joined #koha |
12:40 |
|
|
cm joined #koha |
12:40 |
|
cm |
hi |
12:42 |
|
cm |
i just did an upgrade from 3.10.x to the most recent version, everything seems to be fine |
12:42 |
|
cm |
when i now want to batch delete patrons, however, the following error occurs: |
12:43 |
|
cm |
DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.created_on' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 145 |
12:43 |
|
|
khall joined #koha |
12:46 |
|
|
dpk_ joined #koha |
12:57 |
|
|
Dyrcona joined #koha |
12:58 |
|
|
marie-luce joined #koha |
13:15 |
|
|
alex_a_ joined #koha |
13:17 |
|
cait1 |
cm: where there any sql error in your update? |
13:20 |
|
huginn |
News from kohagit: Bug 27969: Change wording on returns page <https://git.koha-community.org[…]08c33ccfb82292888> |
13:34 |
|
cm |
cait1: none that i'm aware of |
13:34 |
|
cm |
how could i verify this now? |
13:37 |
|
cait1 |
you can't really hm |
13:37 |
|
cait1 |
have you checked if you rtable borrowers has an created_on column? |
13:37 |
|
cm |
wait a sec, ill check it right away |
13:39 |
|
cm |
no, it does nit |
13:39 |
|
cm |
not |
13:39 |
|
cait1 |
actually i am not sure it's borrowers |
13:39 |
|
cait1 |
i am checking that right now in the schema |
13:39 |
|
cait1 |
http://schema.koha-community.org/ |
13:39 |
|
cait1 |
do you know that website? |
13:39 |
|
cm |
no, ill have a look, thx |
13:41 |
|
cait1 |
hm there is a created on in items_last_borrower |
13:41 |
|
cait1 |
the other tables seem unrelated to patrons directly |
13:41 |
|
cait1 |
http://schema.koha-community.o[…]0_11/columns.html (you can search here by column names) |
13:42 |
|
cm |
items_last_borrower, library_groups, account_offsets, virtualshelves, article_requests, return_claims, problem_reports |
13:42 |
|
cm |
so these tables all have a created_on column |
13:43 |
|
cm |
looking at my database, the only table i'm missing is virtualshelves |
13:45 |
|
cm |
is there any way to extend the deletion script to print the exact sql-command it is executing? |
13:45 |
|
cm |
might give a hint, which column is meant by 'me' |
13:50 |
|
cm |
now that's interesting |
13:50 |
|
cm |
my virtualshelves table is missing the 'created_on' column |
13:50 |
|
cm |
the rest of the columns are identical, just this one is missing |
13:52 |
|
|
bdonnahue2 joined #koha |
13:54 |
|
cait1 |
hm |
13:54 |
|
cait1 |
you could check updatedatabase.pl for the update that shoudl have added or renamed it maybe |
13:54 |
|
cait1 |
to see where it might have failed |
13:54 |
|
koha-jenkins |
Project Koha_Master_D9_MDB_Latest build #550: SUCCESS in 31 min: https://jenkins.koha-community[…]9_MDB_Latest/550/ |
13:55 |
|
cm |
how can i check that exaclty? |
13:56 |
|
cm |
ah i see.. |
13:57 |
|
cm |
print "Upgrade to $DBversion done (Bug 13421: Add DB field virtualshelves.created_on)\n"; |
13:57 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=13421 enhancement, P5 - low, ---, jonathan.druart, CLOSED FIXED, Add the creation time for virtual shelves |
13:57 |
|
cm |
so that didn't work for me :-) |
13:58 |
|
cm |
so that was supposed to happen in version 3.19.x |
13:58 |
|
cm |
Set created_on = lastmodified |
13:58 |
|
cm |
but that didn't work |
13:59 |
|
cm |
cant i just add the column myself? |
13:59 |
|
cm |
and set the value accordingly |
14:02 |
|
Joubu |
do you have the lastmodified column?? |
14:02 |
|
cm |
yes |
14:02 |
|
cm |
only created_on is missing |
14:02 |
|
Joubu |
then try to add it manually |
14:02 |
|
Joubu |
ALTER TABLE virtualshelves |
14:02 |
|
Joubu |
ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified |
14:02 |
|
cm |
i just compared my table to the schema |
14:03 |
|
cm |
ok and then just restart mysqld? |
14:03 |
|
Joubu |
no |
14:03 |
|
Joubu |
no need to restart anything |
14:03 |
|
cm |
ok thx |
14:03 |
|
cm |
wait a sec. |
14:04 |
|
Joubu |
you certainly need the "update" query that is in the same DB update |
14:05 |
|
cait1 |
thx for stepping in Joubu |
14:06 |
|
Joubu |
cm: then you should have a look at the "update" log in /var/log/koha/YOUR_SITE/ |
14:06 |
|
cm |
<@Joubu> you certainly need the "update" query that is in the same DB update |
14:06 |
|
cm |
what do you mean by that? |
14:06 |
|
cm |
i set created_on to lastmodfied |
14:07 |
|
Joubu |
the exact query was: |
14:07 |
|
Joubu |
UPDATE virtualshelves |
14:07 |
|
Joubu |
SET created_on = lastmodified, lastmodified = lastmodified |
14:07 |
|
Joubu |
otherwise lastmodified will be set to now() |
14:07 |
|
cm |
ok, ill do that |
14:08 |
|
Joubu |
too late if you run it already |
14:08 |
|
cm |
oh, you are right |
14:08 |
|
cm |
might that be a problem? |
14:08 |
|
Joubu |
not a big deal I'd say |
14:08 |
|
Joubu |
the lists will have the "lastmodified" value set to today |
14:08 |
|
cm |
ok fingers crossed |
14:09 |
|
koha-jenkins |
Project Koha_Master_U2010 build #135: SUCCESS in 47 min: https://jenkins.koha-community[…]Master_U2010/135/ |
14:09 |
|
cm |
batch deletion is running |
14:09 |
|
Joubu |
cm: have a look a the log please |
14:09 |
|
Joubu |
I'd like to know if you have something useful there |
14:09 |
|
Joubu |
in /var/log/koha/YOUR_SITE/updatedatabase-error* |
14:09 |
|
cm |
intranet-error.log and opac-error.log have a current timestamp |
14:10 |
|
cm |
updatedatabases* doesnt exist |
14:10 |
|
cm |
2587 patrons have been successfully deleted |
14:10 |
|
cm |
hey, it worked! |
14:10 |
|
cm |
thx alot cait1 and Joubu |
14:11 |
|
Joubu |
hum weird, no idea why you were missing this column then |
14:11 |
|
cm |
hm |
14:12 |
|
cm |
now how could i check for possible further errors which happened during the upgrade? |
14:12 |
|
cm |
i'm doing this as a contract job |
14:12 |
|
cm |
dont't want them to spot an error some month from now |
14:13 |
|
cm |
problem is, i'm just "the computer guy", i know almost nothing of kobra :-) |
14:14 |
|
|
stallings joined #koha |
14:15 |
|
Joubu |
I would not continue until you understood why the column was missing |
14:15 |
|
cm |
ok |
14:15 |
|
Joubu |
so restore from backup and replay the update |
14:15 |
|
Joubu |
use the commandline to upgrade |
14:15 |
|
Joubu |
and watch for log in /var/log/koha/YOUR_SITE/updatedatabase* |
14:15 |
|
cm |
i did that |
14:16 |
|
cm |
i used koha-upgrade-schema library |
14:16 |
|
cm |
and then rebuilt the zebra-index |
14:17 |
|
cm |
how can it be that there is no updatedatabase.log? |
14:18 |
|
Joubu |
sorry, the updatedatabase logs are created when the upgrade is run from the UI! |
14:18 |
|
Joubu |
so check the output carefully |
14:18 |
|
Joubu |
do you still have the output of koha-upgrade-schema? |
14:18 |
|
Joubu |
(by any chances..) |
14:19 |
|
cait1 |
cm: can I ask where you are located? :) (just out of interest, I feel like we might have talked before?) |
14:19 |
|
cm |
cait1: i'm from germany |
14:20 |
|
cm |
i was here a couple of weeks ago and asked about the upgrade process |
14:20 |
|
cm |
maybe it was you who helped me :) |
14:20 |
|
cait1 |
possible, and also in Germany :) |
14:20 |
|
cm |
hehe |
14:20 |
|
cait1 |
irc regulars? |
14:20 |
|
wahanui |
irc regulars is https://wiki.koha-community.org/wiki/IRC_Regulars |
14:21 |
|
cm |
well, i spent almost 10 years on irc between 1999 and 2008 |
14:21 |
|
cm |
was playing ego shooters in a clan back then |
14:21 |
|
cm |
but haven't used it much since |
14:21 |
|
cm |
only for troubleshooting :-) |
14:22 |
|
cait1 |
it works well for things like this |
14:22 |
|
cm |
Joubu: if the output of koha-upgrade-schema wasn't saved somewhere then no, i dont have it |
14:23 |
|
koha-jenkins |
Project Koha_Master_D9 build #1602: SUCCESS in 58 min: https://jenkins.koha-community[…]a_Master_D9/1602/ |
14:24 |
|
cm |
in any case, any hints for how to verify my library would be appreciated |
14:24 |
|
cait1 |
i think JOubu was suggesting to redo the update |
14:24 |
|
cm |
just to make sure that nothing is lurking |
14:24 |
|
cait1 |
the sql errors shoudl have shown, but might have gone unnoticed |
14:24 |
|
cait1 |
the output is long |
14:25 |
|
cm |
yeah, but that's not possible i guess |
14:25 |
|
cait1 |
for a big jump like this |
14:25 |
|
cm |
don't have that much time left |
14:25 |
|
cm |
besides, some customization has been done already |
14:25 |
|
cait1 |
hm and rerunning it on a separate system? just to get the log? |
14:25 |
|
cait1 |
don't have to throw out what you did already |
14:26 |
|
cm |
that might be an idea |
14:26 |
|
cm |
have to leave now, but i might be back |
14:26 |
|
cm |
again to both of you: thx alot! |
14:27 |
|
koha-jenkins |
Project Koha_Master_D11 build #246: SUCCESS in 1 hr 6 min: https://jenkins.koha-community[…]a_Master_D11/246/ |
14:27 |
|
Joubu |
cm: you will lose much more time if other things went wrong during the upgrade |
14:28 |
|
Joubu |
have a look at our koha-testing-docker project, you will setup a Koha very easily |
14:28 |
|
Joubu |
then git checkout the branch you are using, insert your dump in the DB, restart_all and run the upgrade again |
14:28 |
|
Joubu |
shouldn't take you more than 1 hour |
14:32 |
|
koha-jenkins |
Project Koha_Master_D9_My8 build #533: SUCCESS in 1 hr 10 min: https://jenkins.koha-community[…]aster_D9_My8/533/ |
14:33 |
|
Joubu |
general IRC meeting in less than 30min |
14:33 |
|
tuxayo |
Oh, thanks Joubu ! |
14:33 |
|
stallings |
We are running Koha 19.11 on Debian 9 via a 10 GB Google Cloud vm. Both the > OPAC and staff client pages currently return an internal server error. Initially was out of space, so increased to 15GB. df now says 65% in use, but the error persists. opac-error.log is empty, but plack-error has lots of this: https://pastebin.com/XThjzhxM |
14:34 |
|
|
alex_a_ joined #koha |
14:34 |
|
Joubu |
stallings: reboot? |
14:36 |
|
stallings |
Ran sudo service koha-common restart, no luck. |
14:36 |
|
Joubu |
mysql? |
14:36 |
|
wahanui |
mysql is probably down i don't know why |
14:37 |
|
Joubu |
wahanui: forget mysql |
14:37 |
|
wahanui |
Joubu: I forgot mysql |
14:39 |
|
stallings |
Ran sudo koha-plack --restart <instance> no luck, either. |
14:40 |
|
Joubu |
restart your DBMS |
14:41 |
|
Joubu |
service mysqld restart |
14:41 |
|
Joubu |
did you confirm the table existed? |
14:42 |
|
stallings |
I appreciate the help! Ran sudo service mysql restart, no luck. |
14:43 |
|
stallings |
MariaDB show tables; yields a table called "sessions" |
14:43 |
|
Joubu |
still the same error? |
14:45 |
|
stallings |
Yes, and barely an error. Just "Internal Server Error." If I try to go directly to a bib page, I get the more verbose 404 error (with css, etc), but nothing else. |
14:45 |
|
Joubu |
in the log file |
14:46 |
|
Joubu |
if you get "internal server error" on the interface then there is something more meaningful in the log file |
14:49 |
|
stallings |
Fair. Here's from intranet-error.log: https://pastebin.com/wCatqKyg |
14:50 |
|
Joubu |
I would restart the server |
14:50 |
|
Joubu |
you may have services in broken states because of the lack of disk spaces |
14:50 |
|
Joubu |
this is apache error |
14:51 |
|
Joubu |
try: |
14:51 |
|
Joubu |
sudo service apache2 restart |
14:51 |
|
Joubu |
sudo service koha-common restart |
14:52 |
|
stallings |
Wow, still nothing after those two commands. |
14:54 |
|
Joubu |
still the same apache errors in the log? |
14:56 |
|
|
thd joined #koha |
14:59 |
|
koha-jenkins |
Project Koha_Master_D10_CPAN build #277: SUCCESS in 50 min: https://jenkins.koha-community[…]ter_D10_CPAN/277/ |
14:59 |
|
stallings |
Same errors. Is there somewhere else I should be looking? opac-error is empty, intranet-error is the same as above |
15:00 |
|
Joubu |
reboot? :) |
15:00 |
|
Joubu |
#startmeeting General IRC meeting 17 March 2021 |
15:00 |
|
huginn |
Meeting started Wed Mar 17 15:00:27 2021 UTC. The chair is Joubu. Information about MeetBot at http://wiki.debian.org/MeetBot. |
15:00 |
|
huginn |
Useful Commands: #action #agreed #help #info #idea #link #topic #startvote. |
15:00 |
|
|
Topic for #koha is now (Meeting topic: General IRC meeting 17 March 2021) |
15:00 |
|
huginn |
The meeting name has been set to 'general_irc_meeting_17_march_2021' |
15:00 |
|
Joubu |
#topic Introductions |
15:00 |
|
|
Topic for #koha is now Introductions (Meeting topic: General IRC meeting 17 March 2021) |
15:00 |
|
Joubu |
#info Jonathan Druart |
15:00 |
|
Joubu |
rmaints? |
15:00 |
|
wahanui |
rmaints is probably fridolin, AndrewFH and tuxayo |
15:00 |
|
Joubu |
qa_team? |
15:00 |
|
wahanui |
qa_team is cait, dcook, amoyano, ashimema, marcelr, kohaputti, jajm, tcohen, josef_moravec, kidclamp, khall and tuxayo |
15:01 |
|
oleonard |
#info Owen Leonard, Athens County Public Libraries, Ohio, USA |
15:01 |
|
ashimema |
#info Martin Renvoize, PTFS Europe |
15:01 |
|
thd |
#info Thomas Dukleth, Agogme, New York City |
15:01 |
|
ashimema |
cait1 |
15:01 |
|
ashimema |
cait2 |
15:02 |
|
tuxayo |
#info tuxayo/Victor Grousset, France |
15:02 |
|
Joubu |
#link https://wiki.koha-community.or[…]ing_17_March_2021 |
15:03 |
|
Joubu |
nobody else? |
15:04 |
|
Joubu |
#topic Announcements |
15:04 |
|
|
Topic for #koha is now Announcements (Meeting topic: General IRC meeting 17 March 2021) |
15:04 |
|
kidclamp |
#info Nick Clemens, ByWater Solutions |
15:04 |
|
Joubu |
On Friday I had a go at upgrading/moving the wiki. Galen sent me a dump of the DB to try it out. I managed to move the postgres DB to mysql, upgrade to the latest media version (available in debian 10), and move to dokuwiki. |
15:04 |
|
Joubu |
All went well and I hope to make it available for test in the next couple of weeks. |
15:04 |
|
oleonard |
Excellent! |
15:05 |
|
wahanui |
darn tootin' it is. |
15:05 |
|
tcohen |
#info Tomas Cohen Arazi, Theke Solutions |
15:05 |
|
Joubu |
To compare the mediawiki/dokuwiki version. Then we will see during the next cycle what we decide |
15:05 |
|
Nemo_bis |
What will happen with the old links? |
15:05 |
|
tuxayo |
Great! |
15:05 |
|
Joubu |
there will be an archived version of the wiki |
15:06 |
|
Joubu |
and we would link from the new to the old when a page was removed |
15:06 |
|
Joubu |
"this page has been removed/archived and is available at https://old-wiki.koha-community.org" |
15:06 |
|
tuxayo |
perfect :) |
15:06 |
|
Nemo_bis |
So MediaWiki would continue to run there? |
15:06 |
|
Joubu |
the archived/readonly version of the current wiki, yes |
15:07 |
|
Nemo_bis |
Got it, thanks. :) |
15:07 |
|
tuxayo |
Does an archived MediaWiki still allows to get the wikicode? |
15:07 |
|
Joubu |
useful content will moved, adjusted, grouped and improved :) |
15:08 |
|
Joubu |
you can "view source" when you are not logged in |
15:08 |
|
Joubu |
so I don't see a problem there |
15:08 |
|
Joubu |
Any other announcements? |
15:08 |
|
Joubu |
#topic Update from the Release Manager (21.05) |
15:08 |
|
|
Topic for #koha is now Update from the Release Manager (21.05) (Meeting topic: General IRC meeting 17 March 2021) |
15:08 |
|
thd |
I will offer to improve the read only version with correct character encoding if Joubu's work has any such problems. |
15:09 |
|
Joubu |
I haven't faced any encoding issues |
15:09 |
|
Joubu |
as usual, see the last dev meeting for specific update about 21.05 |
15:09 |
|
tuxayo |
Great. It could have been done with a generic crawler that would generate a fully static version and thus the wikicode wouldn't be accessible which wouldn't hinder migration |
15:09 |
|
Joubu |
Here I'd like to highglithg 3 bugs: |
15:09 |
|
Joubu |
bug 27835 |
15:09 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=27835 critical, P5 - low, ---, nick, Signed Off , Closed days offsets with one day |
15:09 |
|
Joubu |
bug 27968 |
15:09 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=27968 major, P5 - low, ---, jonathan.druart, Needs Signoff , MARC framework CSV and ODS import incomplete or corrupted |
15:09 |
|
Joubu |
bug 27933 |
15:09 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=27933 major, P5 - low, ---, jonathan.druart, Needs Signoff , Order patron search broken (dateofbirth, cardnumber, expirationdate) |
15:09 |
|
tuxayo |
My bug! :D |
15:10 |
|
ashimema |
nice one |
15:10 |
|
Joubu |
that would be great to have them ready for the next stable releases, in few days! |
15:10 |
|
Joubu |
planned on 23 |
15:10 |
|
* tcohen |
volunteers to work through them |
15:10 |
|
Joubu |
today? :) |
15:11 |
|
Joubu |
#topic Update on stable releases |
15:11 |
|
|
Topic for #koha is now Update on stable releases (Meeting topic: General IRC meeting 17 March 2021) |
15:11 |
|
Joubu |
rmaints? |
15:11 |
|
wahanui |
rmaints is fridolin, AndrewFH and tuxayo |
15:11 |
|
tcohen |
today, Joubu |
15:11 |
|
Joubu |
anything special to the next releases? |
15:12 |
|
Joubu |
apart from the 3 bugs I listed above? |
15:12 |
|
tuxayo |
Thanks for the patch JouI'll try the MARC framework patch |
15:12 |
|
tuxayo |
RMaint: no new from me |
15:12 |
|
* ashimema |
will look at bug 27933.. hadn't realised you'd submitted something already.. thanks :) |
15:13 |
|
Joubu |
thanks! |
15:13 |
|
Joubu |
#topic KohaCon21 |
15:13 |
|
|
Topic for #koha is now KohaCon21 (Meeting topic: General IRC meeting 17 March 2021) |
15:13 |
|
Joubu |
caroline, cait1, around? |
15:13 |
|
Joubu |
#link https://wiki.koha-community.or[…]haCon21_Proposals |
15:14 |
|
Joubu |
We cannot postpone this one again |
15:15 |
|
ashimema |
only appears to be one proposal |
15:15 |
|
cait1 |
around now |
15:15 |
|
ashimema |
I wonder if the british council of pakistan would be interested in helping out |
15:15 |
|
cait1 |
sorry, got stuck on an email |
15:16 |
|
cait1 |
heren ow |
15:16 |
|
cait1 |
i thin we need to inform them that they won |
15:16 |
|
Joubu |
#action caroline Officially announce KohaCon21 will be organized by Koha Pakistan Community & National Library of Pakistan |
15:16 |
|
cait1 |
and put it on the wiki |
15:16 |
|
cait1 |
is she here? :) |
15:16 |
|
Joubu |
no, that's why |
15:17 |
|
cait1 |
mean |
15:17 |
|
cait1 |
Pakistan++ |
15:17 |
|
cait1 |
moving on? |
15:17 |
|
tuxayo |
confetti! |
15:18 |
|
wahanui |
o/`'`'`'`'`'`'`'`'`'`'`'` |
15:18 |
|
Joubu |
#topic Terminology |
15:18 |
|
|
Topic for #koha is now Terminology (Meeting topic: General IRC meeting 17 March 2021) |
15:18 |
|
Joubu |
#topic Terminology Catalog or Catalogue? |
15:18 |
|
|
Topic for #koha is now Terminology Catalog or Catalogue? (Meeting topic: General IRC meeting 17 March 2021) |
15:18 |
|
caroline |
#info Caroline Cyr La Rose, inlibro |
15:18 |
|
Joubu |
We need to pick one and have it on https://wiki.koha-community.org/wiki/Terminology |
15:19 |
|
Joubu |
kidclamp: Catalog vs Catalogue opinion? |
15:19 |
|
tuxayo |
This managed to not be in the terminology until now? It must be a touchy topic ^^" |
15:19 |
|
cait1 |
there is no need to decide |
15:19 |
|
cait1 |
i mean it already has been decided |
15:19 |
|
Joubu |
Catalog then? |
15:19 |
|
cait1 |
it only got lost when the terminology page was changed |
15:19 |
|
kidclamp |
Catalog |
15:19 |
|
cait1 |
AE |
15:19 |
|
Joubu |
and we add it to the wiki? |
15:19 |
|
oleonard |
"Catalog" was the defacto standard since we made the switch to American English spelling. |
15:19 |
|
cait1 |
American English |
15:19 |
|
tuxayo |
ok |
15:19 |
|
ashimema |
yup |
15:19 |
|
cait1 |
i thin i put it on the wiki page? |
15:19 |
|
ashimema |
I agree |
15:19 |
|
ashimema |
as much as it's spelt wrong ;) |
15:20 |
|
cait1 |
i dug it out from the history |
15:20 |
|
caroline |
some pages in Koha have both |
15:20 |
|
Joubu |
so there is no need for discussion? :) |
15:20 |
|
cait1 |
yeah but it makes no sense to mix AE and BE... that makes it worse |
15:20 |
|
ashimema |
haha.. |
15:20 |
|
cait1 |
i thin it just got lost that we had already decided |
15:20 |
|
ashimema |
I agree |
15:20 |
|
ashimema |
we have en-GB to fix silly americanisms :P |
15:20 |
|
* ashimema |
is just trolling for fun |
15:20 |
|
tuxayo |
lol |
15:20 |
|
cait1 |
yeah, it woudl turn it all upside down switching now |
15:20 |
|
cait1 |
there even is a de-CH for swiss |
15:21 |
|
cait1 |
they don't have ß |
15:21 |
|
oleonard |
Wild. Everyone loves ß |
15:21 |
|
Joubu |
#info There is no discussion, "Catalog" must be used since we switched to American English spleling |
15:21 |
|
Joubu |
spelling! |
15:21 |
|
tuxayo |
++ |
15:21 |
|
cait1 |
it's pretty, right? :) |
15:22 |
|
Joubu |
#topic General development discussion (trends, ideas, ...) |
15:22 |
|
|
Topic for #koha is now General development discussion (trends, ideas, ...) (Meeting topic: General IRC meeting 17 March 2021) |
15:22 |
|
Joubu |
something else? |
15:22 |
|
Joubu |
#topic Set time of next meeting |
15:23 |
|
|
Topic for #koha is now Set time of next meeting (Meeting topic: General IRC meeting 17 March 2021) |
15:23 |
|
cait1 |
need mroe hands? :) |
15:23 |
|
cait1 |
and more time.... |
15:23 |
|
Joubu |
#info Next meeting: 14 April 2021, 15 UTC |
15:24 |
|
Joubu |
and I am sticking to this timezone, the general meeting does not happen when scheduled in the other slot |
15:24 |
|
Joubu |
feel free to ping me if you want to modify it |
15:24 |
|
Joubu |
#endmeeting |
15:24 |
|
|
Topic for #koha is now Welcome to #koha this channel is for discussion of the Koha project and software https://koha-community.org |
15:24 |
|
huginn |
Meeting ended Wed Mar 17 15:24:26 2021 UTC. Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4) |
15:24 |
|
huginn |
Minutes: https://meetings.koha-communit[…]-03-17-15.00.html |
15:24 |
|
huginn |
Minutes (text): https://meetings.koha-communit[…]1-03-17-15.00.txt |
15:24 |
|
huginn |
Log: https://meetings.koha-communit[…]17-15.00.log.html |
15:24 |
|
cait1 |
Joubu++ thx! |
15:24 |
|
tuxayo |
Joubu++ |
15:24 |
|
oleonard |
Joubu++ |
15:24 |
|
oleonard |
15UTC++ |
15:25 |
|
Joubu |
caroline: ok with the action? :) |
15:25 |
|
tcohen |
Joubu++ |
15:25 |
|
caroline |
yes I will find what info I need to include |
15:25 |
|
Joubu |
thanks! |
15:25 |
|
Joubu |
caroline++ :) |
15:25 |
|
caroline |
no prob! |
15:25 |
|
thd |
Joubu: I assume in your MediaWiki database conversion you kept the wiki in utf8 rather than converting to the MediaWiki binary default. |
15:26 |
|
tuxayo |
ashimema, cait1 Do en-GB and de-CH have a way to base themselves on the other translations to not have to duplicate the work? |
15:27 |
|
ashimema |
not that I know of |
15:27 |
|
ashimema |
one of my colleagues does the GB translation |
15:27 |
|
Joubu |
thd: yes, I mainly used that https://www.winterrodeln.org/t[…]PostgresqlToMysql |
15:27 |
|
ashimema |
thankfully it's usually not too bad |
15:28 |
|
caroline |
at least for en-GB you can only translate what you need and the rest will appear as is |
15:28 |
|
ashimema |
indeed |
15:28 |
|
ashimema |
though we tend to mark it all so we don't look like it's only part done |
15:29 |
|
tuxayo |
> for en-GB you can only translate what you need and the rest will appear as is |
15:29 |
|
tuxayo |
That's cheating! |
15:30 |
|
tuxayo |
> we tend to mark it all |
15:30 |
|
tuxayo |
Just copying the original string right? |
15:32 |
|
thd |
Joubu: I have greatly modified that script to convert to the MediaWiki binary default as full UTF8 has been considered unsupported by mySQL MediaWiki because of historic mySQL limitation of not offering true UTF8. |
15:33 |
|
Joubu |
I don't know what is "true utf8" |
15:33 |
|
Joubu |
I don't understand the problem, we are using utf8mb4_unicode_ci in Koha we everything is working great |
15:34 |
|
ashimema |
pretty much tuxayo |
15:34 |
|
Joubu |
And we we moved from utf8_general_ci to utf8mb4_unicode_ci without major problems |
15:35 |
|
thd |
utf8mb4 is not a supported MediaWiki character set. |
15:36 |
|
oleonard |
Anyone else get an error when trying to import quotes? |
15:36 |
|
* oleonard |
isn't sure where the exact error is getting logged |
15:37 |
|
thd |
MediaWiki developers considered the installed base with binary too large to address utf8 to utf8mb4. |
15:37 |
|
Joubu |
maybe it's supported by dokuwiki then. I will spend time on it when I will have the problem, so far so good. It could help to have your script if you are close to the finish line |
15:37 |
|
Joubu |
did you submit it somewhere? |
15:38 |
|
thd |
Joubu: no because I still had some hard coded passwords until this week. |
15:39 |
|
thd |
DokuWiki is not a problem because it uses the character encoding of the file system with diffs no real database. |
15:39 |
|
Joubu |
I don't see a problem with using the binary default. We don't have much in the wiki that is using special characters |
15:40 |
|
Joubu |
most of them should fit in utf8_general_ci, and moving it to binary seems pretty straightfwd |
15:40 |
|
thd |
The archive should be upgraded over time and I would like to fix findability of some things. |
15:41 |
|
thd |
Conversion should be easy but there are some differences. |
15:43 |
|
Joubu |
findability of some things? what do you mean? |
15:43 |
|
thd |
I have been working continuously for a few days time permitting to somewhat properly finish my work which I had almost finished in Nov. 2019. |
15:43 |
|
Joubu |
99.99% of the characters on the wiki are ascii ;) |
15:43 |
|
Joubu |
you should first clean and publish the script then |
15:44 |
|
thd |
Yes 99% are ascii but one character outside the base multilingual plane causes silent truncation of the data. |
15:44 |
|
Joubu |
like a missing character? |
15:44 |
|
Joubu |
or half of the page is gone? |
15:44 |
|
thd |
We may have nothing outside the basic multilinual plane. |
15:45 |
|
oleonard |
🛸 |
15:45 |
|
thd |
Half of the page would be gone but we may have no high order CJK nor emojis. |
15:46 |
|
thd |
We do have CJK names. |
15:46 |
|
Joubu |
my plan is to provide a dokuwiki version to let the community decide if we do a switch or a simple upgrade |
15:47 |
|
Joubu |
then I will deal with the encoding issues depending on the choice we made |
15:47 |
|
koha-jenkins |
Project Koha_Master build #1601: UNSTABLE in 47 min: https://jenkins.koha-community[…]Koha_Master/1601/ |
15:47 |
|
Joubu |
I will be happy to have a look at your script once you published it |
15:48 |
|
stallings |
Hope I'm not interrupting. I'm tracing the internal server error to mysql logs (https://pastebin.com/urkx2NpR), which have a similar error (missing "sessions" table) as the plack error logs: https://pastebin.com/f5XQXkTy . The former references a mysql guide, but I'm not comfortable making changes there without assurances from those who know Koha better than I do. |
15:48 |
|
thd |
Joubu: We should do a proper test as we had planned years ago when suddenly DokuWiki went down with LibLime troubles. |
15:50 |
|
thd |
Joubu: I am keen to publish it. I am currently fixing a relatively new excessive data size for MySQL definition problem which was not in my previous bug report because I kept testing with an old dump. |
15:51 |
|
thd |
I will have to do in person work for a few days from tomorrow and will be back to fixing the script next Tuesday and Wednesday. |
15:52 |
|
Joubu |
do you have something specific in mind I should look at? |
15:52 |
|
tcohen |
Joubu is it me, or suspensions don't have the same behavior of fines, and they are only calculated on check-in? |
15:53 |
|
Joubu |
tcohen: yes, on return |
15:53 |
|
tcohen |
k |
15:53 |
|
Joubu |
tcohen: 2526 sub _debar_user_on_return { |
15:54 |
|
Joubu |
C4::Circ |
15:54 |
|
tcohen |
yes, it cough me by surprise |
15:54 |
|
tcohen |
I expected them to have similar-ish behaviors |
15:54 |
|
thd |
Joubu I did have one problem which kept me up all night before I realised it was just a date which should be truncated. |
15:54 |
|
tcohen |
nevermind |
15:54 |
|
tcohen |
was just checking side effects on a non-existent feature haha |
15:55 |
|
Joubu |
thd: I meant something to check the encoding issues |
15:55 |
|
Joubu |
like a given char on a given page |
15:56 |
|
thd |
Joubu: I think that we probably only have characters in the basic multilingual plane and true UTF8 may help for converting to DokuWiki. |
15:57 |
|
Joubu |
stallings: looks like you have your innodb files that are corrupted |
15:57 |
|
Joubu |
thd: what is the "basic multilingual plane"? |
15:58 |
|
Joubu |
ok, you mean we have special characters |
15:58 |
|
thd |
However, any archive should be maintained in a MediaWiki supported format. MediaWiki considers both Postgress and utf8 to be experimental unsupported options. |
15:58 |
|
Joubu |
that's not my question :) Where are those characters? |
15:58 |
|
Joubu |
It's not needed to deal with complex stuffs if there is none in the DB |
15:59 |
|
thd |
Joubu: I think that we do not have such characters. |
15:59 |
|
Joubu |
So my question was: do you know places where I should bring more attention on the char encoding? |
15:59 |
|
thd |
Joubu: Names attached to some email addresses have some CJK characters. |
16:01 |
|
thd |
Joubu: your process will not have caused character encoding problems and is what I did initially before I read that it was not a supported path long term. |
16:01 |
|
Joubu |
ok but migrating from utf8_general_ci to binary does not seem a big problem :) |
16:02 |
|
oleonard |
ashimema still around? |
16:03 |
|
thd |
Joubu: Character set conversion does produce extra errors. |
16:03 |
|
Joubu |
not if you have only ascii characters |
16:03 |
|
Joubu |
thd: I have to run, see you later. Let me know when you published the script |
16:03 |
|
stallings |
Joubu: Thanks! Is there a Koha tool for this up, or do I need to look into doing it manually? |
16:04 |
|
thd |
Joubu: We definitely have some non-ascii CJK. |
16:06 |
|
oleonard |
Anyone else know what the "discount modal" is? Bug 27967 |
16:06 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=27967 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Modals on the borrower account page don't validate minimum values |
16:08 |
|
|
khall joined #koha |
16:14 |
|
|
khall_ joined #koha |
16:28 |
|
|
khall joined #koha |
16:32 |
|
ashimema |
hi oleonard |
16:32 |
|
wahanui |
hi oleopard |
16:33 |
|
ashimema |
oleonard still here? |
16:33 |
|
oleonard |
Yes |
16:34 |
|
ashimema |
If you have the 'updatecharges_discount' permission.. when you look at a patrons accounts you should get an 'Apply discount' button in the actions column on any debits that are not yet paid off at all (and are not a payout) |
16:35 |
|
ashimema |
so `Patron > Accounting > Transactions` |
16:36 |
|
ashimema |
does that help? |
16:36 |
|
oleonard |
Got it |
16:36 |
|
ashimema |
brill :) |
16:36 |
|
oleonard |
I must have just overlooked it, it's right there! |
16:36 |
|
* ashimema |
wants to add 'percentage' discounts to that modal at some point |
16:36 |
|
ashimema |
haha, no worries |
16:36 |
|
ashimema |
it's easily missed |
16:36 |
|
reiveune |
bye |
16:36 |
|
|
reiveune left #koha |
16:37 |
|
ashimema |
that table needs a good cleaning.. It's on my list... actually, it's what prompted work in this area again |
16:49 |
|
|
khall_ joined #koha |
17:02 |
|
|
cait1 left #koha |
19:25 |
|
stallings |
How can I drop/restore the sessions table? Been chasing an internal server error all day, and have run into the following after attempting cleanup_database:DBD::mysql::st execute failed: Table 'koha.sessions' doesn't exist in engine [for Statement " TRUNCATE sessions "] at ./cleanup_database.pl line 221. |
19:40 |
|
stallings |
The sessions table shows up as "in use" in phpMyAdmin, where I'm unable to repair or determine its size. I noticed the issue after my installation bloated to over 10G and the site shut down. Not certain that this is the cause, but nothing else seems out of the ordinary. |
19:48 |
|
ashimema |
oleonard++ #thanks for taking on those table sorts.. nice to see us modernising.. I'd kinda forgotten about our clever title- stuff until recently :) |
20:01 |
|
|
khall joined #koha |
20:02 |
|
|
khall joined #koha |
20:05 |
|
|
khall joined #koha |
20:09 |
|
|
khall joined #koha |
20:10 |
|
|
khall joined #koha |
20:12 |
|
|
khall joined #koha |
20:14 |
|
|
khall joined #koha |
20:17 |
|
|
khall joined #koha |
20:18 |
|
tuxayo |
Is that expected that |
20:18 |
|
tuxayo |
1. Create new framework |
20:18 |
|
tuxayo |
2. Marc structure |
20:18 |
|
tuxayo |
3. Internal server error |
20:18 |
|
tuxayo |
CGI::Compile::ROOT::kohadevbox_koha_admin_marctagstructure_2epl::marctagstructure_2epl(): DBI Exception: DBD::mysql::st execute failed: |
20:18 |
|
tuxayo |
'koha_kohadev.biblio_framework.frameworktext' isn't in GROUP BY [for Statement "select count(*),marc_tag_structure.fram [...] |
20:19 |
|
|
khall_ joined #koha |
20:28 |
|
|
khall joined #koha |
20:31 |
|
|
khall joined #koha |
20:33 |
|
|
cm joined #koha |
20:33 |
|
cm |
hi |
20:33 |
|
wahanui |
hey, cm |
20:33 |
|
cm |
what is the recommened way to mass delete duplicate authorities? |
20:33 |
|
cm |
i've sadly got a couple of hundreds of them |
20:34 |
|
cm |
carried over from some ancient access-db 15 years ago |
20:35 |
|
|
khall joined #koha |
20:45 |
|
|
khall joined #koha |
20:46 |
|
|
khall joined #koha |
20:49 |
|
|
khall joined #koha |
20:50 |
|
|
khall joined #koha |
20:54 |
|
|
khall joined #koha |
20:56 |
|
|
khall joined #koha |
21:02 |
|
|
khall joined #koha |
21:04 |
|
|
khall joined #koha |
21:06 |
|
|
khall joined #koha |
21:08 |
|
|
khall joined #koha |
21:08 |
|
|
cait joined #koha |
21:29 |
|
|
cm left #koha |
21:51 |
|
|
dcook joined #koha |
22:41 |
|
|
AndrewFH joined #koha |
23:09 |
|
|
AndrewFH joined #koha |