Time Nick Message
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/gitweb/?p=koha.git;a=commitdiff;h=c28b85740495b4fe65bdb290f7b4f7145a2bd050>
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.org/job/Koha_Master_D9_MDB_Latest/549/
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.org/job/Koha_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.org/job/Koha_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.org/job/Koha_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.org/job/Koha_Master_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: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.org/job/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.org/job/Koha_Master_D10_CPAN/276/
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:17 TimothyAlexis I'm wondering: Where does the (Item is deleted) string get appended to the title?
10:25 oleonard-away TimothyAlexis: Where do you see it?
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: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
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
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/gitweb/?p=koha.git;a=commitdiff;h=ec4bb0539a2b2479130159408c33ccfb82292888>
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.org/20_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: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.org/job/Koha_Master_D9_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.org/bugzilla3/show_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.org/job/Koha_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: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.org/job/Koha_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.org/job/Koha_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.org/job/Koha_Master_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 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:59 koha-jenkins Project Koha_Master_D10_CPAN build #277: SUCCESS in 50 min: https://jenkins.koha-community.org/job/Koha_Master_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 huginn The meeting name has been set to 'general_irc_meeting_17_march_2021'
15:00 Joubu #topic Introductions
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.org/wiki/General_IRC_meeting_17_March_2021
15:03 Joubu nobody else?
15:04 Joubu #topic Announcements
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 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.org/bugzilla3/show_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.org/bugzilla3/show_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.org/bugzilla3/show_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 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 Joubu caroline, cait1, around?
15:13 Joubu #link https://wiki.koha-community.org/wiki/KohaCon21_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 Joubu #topic Terminology Catalog or Catalogue?
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 Joubu something else?
15:22 Joubu #topic Set time of next meeting
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 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-community.org/2021/general_irc_meeting_17_march_2021.2021-03-17-15.00.html
15:24 huginn Minutes (text): https://meetings.koha-community.org/2021/general_irc_meeting_17_march_2021.2021-03-17-15.00.txt
15:24 huginn Log: https://meetings.koha-community.org/2021/general_irc_meeting_17_march_2021.2021-03-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/trac/wiki/MediaWikiPostgresqlToMysql
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.org/job/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.org/bugzilla3/show_bug.cgi?id=27967 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Modals on the borrower account page don't validate minimum values
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:37 ashimema that table needs a good cleaning.. It's on my list... actually, it's what prompted work in this area again
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: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: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