Time  Nick          Message
20:34 cm            carried over from some ancient access-db 15 years ago
20:33 cm            i've sadly got a couple of hundreds of them
20:33 cm            what is the recommened way to mass delete duplicate authorities?
20:33 wahanui       hey, cm
20:33 cm            hi
20:18 tuxayo        'koha_kohadev.biblio_framework.frameworktext' isn't in GROUP BY [for Statement "select count(*),marc_tag_structure.fram [...]
20:18 tuxayo        CGI::Compile::ROOT::kohadevbox_koha_admin_marctagstructure_2epl::marctagstructure_2epl(): DBI Exception: DBD::mysql::st execute failed:
20:18 tuxayo        3. Internal server error
20:18 tuxayo        2. Marc structure
20:18 tuxayo        1. Create new framework
20:18 tuxayo        Is that expected that
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 :)
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: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.
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:36 reiveune      bye
16:36 ashimema      it's easily missed
16:36 ashimema      haha, no worries
16:36 * ashimema    wants to add 'percentage' discounts to that modal at some point
16:36 oleonard      I must have just overlooked it, it's right there!
16:36 ashimema      brill :)
16:36 oleonard      Got it
16:36 ashimema      does that help?
16:35 ashimema      so `Patron > Accounting > Transactions`
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:33 oleonard      Yes
16:33 ashimema      oleonard still here?
16:32 wahanui       hi oleopard
16:32 ashimema      hi oleonard
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:06 oleonard      Anyone else know what the "discount modal" is? Bug 27967
16:04 thd           Joubu: We definitely have some non-ascii CJK.
16:03 stallings     Joubu: Thanks! Is there a Koha tool for this up, or do I need to look into doing it manually?
16:03 Joubu         thd: I have to run, see you later. Let me know when you published the script
16:03 Joubu         not if you have only ascii characters
16:03 thd           Joubu: Character set conversion does produce extra errors.
16:02 oleonard      ashimema still around?
16:01 Joubu         ok but migrating from utf8_general_ci to binary does not seem a big problem :)
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.
15:59 thd           Joubu: Names attached to some email addresses have some CJK 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: I think that we do not have such characters.
15:58 Joubu         It's not needed to deal with complex stuffs if there is none in the DB
15:58 Joubu         that's not my question :) Where are those 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         ok, you mean we have special characters
15:57 Joubu         thd: what is the "basic multilingual plane"?
15:57 Joubu         stallings: looks like you have your innodb files that are corrupted
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:55 Joubu         like a given char on a given page
15:55 Joubu         thd: I meant something to check the encoding issues
15:54 tcohen        was just checking side effects on a non-existent feature haha
15:54 tcohen        nevermind
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        I expected them to have similar-ish behaviors
15:54 tcohen        yes, it cough me by surprise
15:54 Joubu         C4::Circ
15:53 Joubu         tcohen: 2526 sub _debar_user_on_return {
15:53 tcohen        k
15:53 Joubu         tcohen: yes, on return
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:52 Joubu         do you have something specific in mind I should look at?
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: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:48 thd           Joubu: We should do a proper test as we had planned years ago when suddenly DokuWiki went down with LibLime troubles.
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:47 Joubu         I will be happy to have a look at your script once you published it
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         then I will deal with the encoding issues depending on the choice we made
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:46 thd           We do have CJK names.
15:45 thd           Half of the page would be gone but we may have no high order CJK nor emojis.
15:45 oleonard      🛸
15:44 thd           We may have nothing outside the basic multilinual plane.
15:44 Joubu         or half of the page is gone?
15:44 Joubu         like a missing character?
15:44 thd           Yes 99% are ascii but one character outside the base multilingual plane causes silent truncation of the data.
15:43 Joubu         you should first clean and publish the script then
15:43 Joubu         99.99% of the characters on the wiki are ascii ;)
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         findability of some things? what do you mean?
15:41 thd           Conversion should be easy but there are some differences.
15:40 thd           The archive should be upgraded over time and I would like to fix findability of some things.
15:40 Joubu         most of them should fit in utf8_general_ci, and moving it to binary seems pretty straightfwd
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:39 thd           DokuWiki is not a problem because it uses the character encoding of the file system with diffs no real database.
15:38 thd           Joubu: no because I still had some hard coded passwords until this week.
15:37 Joubu         did you submit it somewhere?
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 thd           MediaWiki developers considered the installed base with binary too large to address utf8 to utf8mb4.
15:36 * oleonard    isn't sure where the exact error is getting logged
15:36 oleonard      Anyone else get an error when trying to import quotes?
15:35 thd           utf8mb4 is not a supported MediaWiki character set.
15:34 Joubu         And we we moved from utf8_general_ci to utf8mb4_unicode_ci without major problems
15:34 ashimema      pretty much tuxayo
15:33 Joubu         I don't understand the problem, we are using utf8mb4_unicode_ci in Koha we everything is working great
15:33 Joubu         I don't know what is "true utf8"
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:30 tuxayo        Just copying the original string right?
15:30 tuxayo        > we tend to mark it all
15:29 tuxayo        That's cheating!
15:29 tuxayo        > for en-GB you can only translate what you need and the rest will appear as is
15:28 ashimema      though we tend to mark it all so we don't look like it's only part done
15:28 ashimema      indeed
15:28 caroline      at least for en-GB you can only translate what you need and the rest will appear as is
15:27 ashimema      thankfully it's usually not too bad
15:27 Joubu         thd: yes, I mainly used that https://www.winterrodeln.org/trac/wiki/MediaWikiPostgresqlToMysql
15:27 ashimema      one of my colleagues does the GB translation
15:27 ashimema      not that I know of
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: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:25 caroline      no prob!
15:25 Joubu         caroline++ :)
15:25 Joubu         thanks!
15:25 caroline      yes I will find what info I need to include
15:25 tcohen        Joubu++
15:25 Joubu         caroline: ok with the action? :)
15:24 oleonard      15UTC++
15:24 oleonard      Joubu++
15:24 tuxayo        Joubu++
15:24 cait1         Joubu++ thx!
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 huginn        Minutes (text): https://meetings.koha-community.org/2021/general_irc_meeting_17_march_2021.2021-03-17-15.00.txt
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        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 Joubu         #endmeeting
15:24 Joubu         feel free to ping me if you want to modify it
15:24 Joubu         and I am sticking to this timezone, the general meeting does not happen when scheduled in the other slot
15:23 Joubu         #info Next meeting: 14 April 2021, 15 UTC
15:23 cait1         and more time....
15:23 cait1         need mroe hands? :)
15:22 Joubu         #topic Set time of next meeting
15:22 Joubu         something else?
15:22 Joubu         #topic General development discussion (trends, ideas, ...)
15:21 cait1         it's pretty, right? :)
15:21 tuxayo        ++
15:21 Joubu         spelling!
15:21 Joubu         #info There is no discussion, "Catalog" must be used since we switched to American English spleling
15:21 oleonard      Wild. Everyone loves ß
15:21 cait1         they don't have ß
15:20 cait1         there even is a de-CH for swiss
15:20 cait1         yeah, it woudl turn it all upside down switching now
15:20 tuxayo        lol
15:20 * ashimema    is just trolling for fun
15:20 ashimema      we have en-GB to fix silly americanisms :P
15:20 ashimema      I agree
15:20 cait1         i thin it just got lost that we had already decided
15:20 ashimema      haha..
15:20 cait1         yeah but it makes no sense to mix AE and BE... that makes it worse
15:20 Joubu         so there is no need for discussion? :)
15:20 caroline      some pages in Koha have both
15:20 cait1         i dug it out from the history
15:19 ashimema      as much as it's spelt wrong ;)
15:19 ashimema      I agree
15:19 cait1         i thin i put it on the wiki page?
15:19 ashimema      yup
15:19 tuxayo        ok
15:19 cait1         American English
15:19 oleonard      "Catalog" was the defacto standard since we made the switch to American English spelling.
15:19 Joubu         and we add it to the wiki?
15:19 cait1         AE
15:19 kidclamp      Catalog
15:19 cait1         it only got lost when the terminology page was changed
15:19 Joubu         Catalog then?
15:19 cait1         i mean it already has been decided
15:19 cait1         there is no need to decide
15:19 tuxayo        This managed to not be in the terminology until now? It must be a touchy topic ^^"
15:19 Joubu         kidclamp: Catalog vs Catalogue opinion?
15:18 Joubu         We need to pick one and have it on https://wiki.koha-community.org/wiki/Terminology
15:18 caroline      #info Caroline Cyr La Rose, inlibro
15:18 Joubu         #topic Terminology Catalog or Catalogue?
15:18 Joubu         #topic Terminology
15:18 wahanui       o/`'`'`'`'`'`'`'`'`'`'`'`
15:17 tuxayo        confetti!
15:17 cait1         moving on?
15:17 cait1         Pakistan++
15:17 cait1         mean
15:16 Joubu         no, that's why
15:16 cait1         is she here? :)
15:16 cait1         and put it on the wiki
15:16 Joubu         #action caroline Officially announce KohaCon21 will be organized by Koha Pakistan Community & National Library of Pakistan
15:16 cait1         i thin we need to inform them that they won
15:16 cait1         heren ow
15:15 cait1         sorry, got stuck on an email
15:15 ashimema      I wonder if the british council of pakistan would be interested in helping out
15:15 cait1         around now
15:15 ashimema      only appears to be one proposal
15:14 Joubu         We cannot postpone this one again
15:13 Joubu         #link https://wiki.koha-community.org/wiki/KohaCon21_Proposals
15:13 Joubu         caroline, cait1, around?
15:13 Joubu         #topic KohaCon21
15:13 Joubu         thanks!
15:12 * ashimema    will look at bug 27933.. hadn't realised you'd submitted something already.. thanks :)
15:12 tuxayo        RMaint: no new from me
15:12 tuxayo        Thanks for the patch JouI'll try the MARC framework patch
15:12 Joubu         apart from the 3 bugs I listed above?
15:11 Joubu         anything special to the next releases?
15:11 tcohen        today, Joubu
15:11 wahanui       rmaints is fridolin, AndrewFH and tuxayo
15:11 Joubu         rmaints?
15:11 Joubu         #topic Update on stable releases
15:10 Joubu         today? :)
15:10 * tcohen      volunteers to work through them
15:10 Joubu         planned on 23
15:10 Joubu         that would be great to have them ready for the next stable releases, in few days!
15:10 ashimema      nice one
15:09 tuxayo        My bug! :D
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 Joubu         bug 27933
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 27968
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 27835
15:09 Joubu         Here I'd like to highglithg 3 bugs:
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         as usual, see the last dev meeting for specific update about 21.05
15:09 Joubu         I haven't faced any encoding issues
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:08 Joubu         #topic Update from the Release Manager (21.05)
15:08 Joubu         Any other announcements?
15:08 Joubu         so I don't see a problem there
15:08 Joubu         you can "view source" when you are not logged in
15:07 Joubu         useful content will moved, adjusted, grouped and improved :)
15:07 tuxayo        Does an archived MediaWiki still allows to get the wikicode?
15:07 Nemo_bis      Got it, thanks. :)
15:06 Joubu         the archived/readonly version of the current wiki, yes
15:06 Nemo_bis      So MediaWiki would continue to run there?
15:06 tuxayo        perfect :)
15:06 Joubu         "this page has been removed/archived and is available at https://old-wiki.koha-community.org"
15:06 Joubu         and we would link from the new to the old when a page was removed
15:05 Joubu         there will be an archived version of the wiki
15:05 tuxayo        Great!
15:05 Nemo_bis      What will happen with the old links?
15:05 Joubu         To compare the mediawiki/dokuwiki version. Then we will see during the next cycle what we decide
15:05 tcohen        #info Tomas Cohen Arazi, Theke Solutions
15:05 wahanui       darn tootin' it is.
15:04 oleonard      Excellent!
15:04 Joubu         All went well and I hope to make it available for test in the next couple of weeks.
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 kidclamp      #info Nick Clemens, ByWater Solutions
15:04 Joubu         #topic Announcements
15:03 Joubu         nobody else?
15:02 Joubu         #link https://wiki.koha-community.org/wiki/General_IRC_meeting_17_March_2021
15:02 tuxayo        #info tuxayo/Victor Grousset, France
15:01 ashimema      cait2
15:01 ashimema      cait1
15:01 thd           #info Thomas Dukleth, Agogme, New York City
15:01 ashimema      #info Martin Renvoize, PTFS Europe
15:01 oleonard      #info Owen Leonard, Athens County Public Libraries, Ohio, USA
15:00 wahanui       qa_team is cait, dcook, amoyano, ashimema, marcelr, kohaputti, jajm, tcohen, josef_moravec, kidclamp, khall and tuxayo
15:00 Joubu         qa_team?
15:00 wahanui       rmaints is probably fridolin, AndrewFH and tuxayo
15:00 Joubu         rmaints?
15:00 Joubu         #info Jonathan Druart
15:00 Joubu         #topic Introductions
15:00 huginn        The meeting name has been set to 'general_irc_meeting_17_march_2021'
15:00 huginn        Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
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 Joubu         #startmeeting General IRC meeting 17 March 2021
15:00 Joubu         reboot? :)
14:59 stallings     Same errors. Is there somewhere else I should be looking? opac-error is empty, intranet-error is the same as above
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:54 Joubu         still the same apache errors in the log?
14:52 stallings     Wow, still nothing after those two commands.
14:51 Joubu         sudo service koha-common restart
14:51 Joubu         sudo service apache2 restart
14:51 Joubu         try:
14:50 Joubu         this is apache error
14:50 Joubu         you may have services in broken states because of the lack of disk spaces
14:50 Joubu         I would restart the server
14:49 stallings     Fair. Here's from intranet-error.log: https://pastebin.com/wCatqKyg
14:46 Joubu         if you get "internal server error" on the interface then there is something more meaningful in the log file
14:45 Joubu         in the log file
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:43 Joubu         still the same error?
14:43 stallings     MariaDB show tables; yields a table called "sessions"
14:42 stallings     I appreciate the help! Ran sudo service mysql restart, no luck.
14:41 Joubu         did you confirm the table existed?
14:41 Joubu         service mysqld restart
14:40 Joubu         restart your DBMS
14:39 stallings     Ran sudo koha-plack --restart <instance> no luck, either.
14:37 wahanui       Joubu: I forgot mysql
14:37 Joubu         wahanui: forget mysql
14:36 wahanui       mysql is probably down i don't know why
14:36 Joubu         mysql?
14:36 stallings     Ran sudo service koha-common restart, no luck.
14:34 Joubu         stallings: reboot?
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:33 tuxayo        Oh, thanks Joubu !
14:33 Joubu         general IRC meeting in less than 30min
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:28 Joubu         shouldn't take you more than 1 hour
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         have a look at our koha-testing-docker project, you will setup a Koha very easily
14:27 Joubu         cm: you will lose much more time if other things went wrong during the upgrade
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:26 cm            again to both of you: thx alot!
14:26 cm            have to leave now, but i might be back
14:26 cm            that might be an idea
14:25 cait1         don't have to throw out what you did already
14:25 cait1         hm and rerunning it on a separate system? just to get the log?
14:25 cm            besides, some customization has been done already
14:25 cm            don't have that much time left
14:25 cait1         for a big jump like this
14:25 cm            yeah, but that's not possible i guess
14:24 cait1         the output is long
14:24 cait1         the sql errors shoudl have shown, but might have gone unnoticed
14:24 cm            just to make sure that nothing is lurking
14:24 cait1         i think JOubu was suggesting to redo the update
14:24 cm            in any case, any hints for how to verify my library would be appreciated
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:22 cm            Joubu: if the output of koha-upgrade-schema wasn't saved somewhere then no, i dont have it
14:22 cait1         it works well for things like this
14:21 cm            only for troubleshooting :-)
14:21 cm            but haven't used it much since
14:21 cm            was playing ego shooters in a clan back then
14:21 cm            well, i spent almost 10 years on irc between 1999 and 2008
14:20 wahanui       irc regulars is https://wiki.koha-community.org/wiki/IRC_Regulars
14:20 cait1         irc regulars?
14:20 cm            hehe
14:20 cait1         possible, and also in Germany :)
14:20 cm            maybe it was you who helped me :)
14:20 cm            i was here a couple of weeks ago and asked about the upgrade process
14:19 cm            cait1: i'm from germany
14:19 cait1         cm: can I ask where you are located? :) (just out of interest, I feel like we might have talked before?)
14:18 Joubu         (by any chances..)
14:18 Joubu         do you still have the output of koha-upgrade-schema?
14:18 Joubu         so check the output carefully
14:18 Joubu         sorry, the updatedatabase logs are created when the upgrade is run from the UI!
14:17 cm            how can it be that there is no updatedatabase.log?
14:16 cm            and then rebuilt the zebra-index
14:16 cm            i used koha-upgrade-schema library
14:15 cm            i did that
14:15 Joubu         and watch for log in /var/log/koha/YOUR_SITE/updatedatabase*
14:15 Joubu         use the commandline to upgrade
14:15 Joubu         so restore from backup and replay the update
14:15 cm            ok
14:15 Joubu         I would not continue until you understood why the column was missing
14:13 cm            problem is, i'm just "the computer guy", i know almost nothing of kobra :-)
14:12 cm            dont't want them to spot an error some month from now
14:12 cm            i'm doing this as a contract job
14:12 cm            now how could i check for possible further errors which happened during the upgrade?
14:11 cm            hm
14:11 Joubu         hum weird, no idea why you were missing this column then
14:10 cm            thx alot cait1 and Joubu
14:10 cm            hey, it worked!
14:10 cm            2587 patrons have been successfully deleted
14:10 cm            updatedatabases* doesnt exist
14:09 cm            intranet-error.log and opac-error.log have a current timestamp
14:09 Joubu         in /var/log/koha/YOUR_SITE/updatedatabase-error*
14:09 Joubu         I'd like to know if you have something useful there
14:09 Joubu         cm: have a look a the log please
14:09 cm            batch deletion is running
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:08 cm            ok fingers crossed
14:08 Joubu         the lists will have the "lastmodified" value set to today
14:08 Joubu         not a big deal I'd say
14:08 cm            might that be a problem?
14:08 cm            oh, you are right
14:08 Joubu         too late if you run it already
14:07 cm            ok, ill do that
14:07 Joubu         otherwise lastmodified will be set to now()
14:07 Joubu         SET created_on = lastmodified, lastmodified = lastmodified
14:07 Joubu         UPDATE virtualshelves
14:07 Joubu         the exact query was:
14:06 cm            i set created_on to lastmodfied
14:06 cm            what do you mean by that?
14:06 cm            <@Joubu> you certainly need the "update" query that is in the same DB update
14:06 Joubu         cm: then you should have a look at the "update" log in /var/log/koha/YOUR_SITE/
14:05 cait1         thx for stepping in Joubu
14:04 Joubu         you certainly need the "update" query that is in the same DB update
14:03 cm            wait a sec.
14:03 cm            ok thx
14:03 Joubu         no need to restart anything
14:03 Joubu         no
14:03 cm            ok and then just restart mysqld?
14:02 cm            i just compared my table to the schema
14:02 Joubu         ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified
14:02 Joubu         ALTER TABLE virtualshelves
14:02 Joubu         then try to add it manually
14:02 cm            only created_on is missing
14:02 cm            yes
14:02 Joubu         do you have the lastmodified column??
13:59 cm            and set the value accordingly
13:59 cm            cant i just add the column myself?
13:58 cm            but that didn't work
13:58 cm            Set created_on = lastmodified
13:58 cm            so that was supposed to happen in version 3.19.x
13:57 cm            so that didn't work for me :-)
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            print "Upgrade to $DBversion done (Bug 13421: Add DB field virtualshelves.created_on)\n";
13:56 cm            ah i see..
13:55 cm            how can i check that exaclty?
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:54 cait1         to see where it might have failed
13:54 cait1         you could check updatedatabase.pl for the update that shoudl have added or renamed it maybe
13:54 cait1         hm
13:50 cm            the rest of the columns are identical, just this one is missing
13:50 cm            my virtualshelves table is missing the 'created_on' column
13:50 cm            now that's interesting
13:45 cm            might give a hint, which column is meant by 'me'
13:45 cm            is there any way to extend the deletion script to print the exact sql-command it is executing?
13:43 cm            looking at my database, the only table i'm missing is virtualshelves
13:42 cm            so these tables all have a created_on column
13:42 cm            items_last_borrower, library_groups, account_offsets, virtualshelves, article_requests, return_claims, problem_reports
13:41 cait1         http://schema.koha-community.org/20_11/columns.html (you can search here by column names)
13:41 cait1         the other tables seem unrelated to patrons directly
13:41 cait1         hm there is a created on in items_last_borrower
13:39 cm            no, ill have a look, thx
13:39 cait1         do you know that website?
13:39 cait1         http://schema.koha-community.org/
13:39 cait1         i am checking that right now in the schema
13:39 cait1         actually i am not sure it's borrowers
13:39 cm            not
13:39 cm            no, it does nit
13:37 cm            wait a sec, ill check it right away
13:37 cait1         have you checked if you rtable borrowers has an created_on column?
13:37 cait1         you can't really hm
13:34 cm            how could i verify this now?
13:34 cm            cait1: none that i'm aware of
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:17 cait1         cm: where there any sql error in your update?
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:42 cm            when i now want to batch delete patrons, however, the following error occurs:
12:42 cm            i just did an upgrade from 3.10.x to the most recent version, everything seems to be fine
12:40 cm            hi
11:12 simiya        thnks so much oleonardo and tchon. I wanted to make sure there was an easier way than editing xslt files
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: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: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: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:03 simiya        yeah. it check leader position 7-8. if 7 is a and b a or b. koha consider it as article
11:01 simiya        i have backup of xslt files
11:00 oleonard      (it also might be incorrect, in which case it's a bug)
11:00 oleonard      It does check the leader to show record types, but it may not be as specific as you want
10:59 oleonard      simiya: Have you examined MARC21slim2OPACDetail.xsl to see how it works?
10:57 simiya        thesis and mnbuscripts both have tm in leader 7 and 8 position
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:56 oleonard      simiya: The various XSLT system preferences allow you to specify a filename or full URL
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:47 simiya        is it a good strategy?
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:43 TimothyAlexis oleonard then it's probably something only in our branch
10:42 ashimema      pass
10:42 oleonard      TimothyAlexis: I can't find it in the code or make it appear
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:37 TimothyAlexis Could it be something we've added in our branch?
10:37 ashimema      funny what you're not aware of sometimes
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:36 TimothyAlexis It's in /cgi-bin/koha/members/pay.pl
10:25 oleonard-away TimothyAlexis: Where do you see it?
10:17 TimothyAlexis I'm wondering: Where does the (Item is deleted) string get appended to the title?
10:16 simiya        any idea?
10:16 simiya        if leader7-8 are ab koha consider record as article
10:13 simiya        articles and bookreviews are same as marc standards
10:12 simiya        there is no specific filed in marc to do that
10:12 simiya        anybody knows how to seperate book reviews from articles in koha
10:09 simiya        hi everybody
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/
09:53 wahanui       Congratulations!
09:53 koha-jenkins  Yippee, build fixed!
09:02 koha-jenkins  Project Koha_Master build #1600: FIXED in 45 min: https://jenkins.koha-community.org/job/Koha_Master/1600/
09:02 wahanui       Congratulations!
09:02 koha-jenkins  Yippee, build fixed!
09:01 severine_q    Hi #koha !
08:41 dersmon       the xsl only applies to the record part of the oai response
08:41 dersmon       yeah, i  think you are right
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: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:38 magnuse       you have the syspref OAI-PMH:archiveID, but that does not use any placeholders or other fancy stuff, i think
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:37 wahanui       Congratulations!
08:37 koha-jenkins  Yippee, build fixed!
08:36 magnuse       ah, sorry, i was a bit quick then
08:35 dersmon       i want the oai id to be 001 instead of biblionumber
08:35 dersmon       i do not want biblionumber as 001
08:35 dersmon       sorry
08:35 dersmon       ah wait, i think your script does something different
08:34 Joubu         restart memcached
08:32 dersmon       currently i dont see any change
08:32 dersmon       do i have to rebuild the sets?
08:31 dersmon       ah whoops,      xsl_file: /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: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:27 koha-jenkins  Project Koha_Master_D9 build #1601: FIXED in 58 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1601/
08:27 wahanui       Congratulations!
08:27 koha-jenkins  Yippee, build fixed!
08:26 magnuse       np
08:26 dersmon       thank you :)
08:25 dersmon       nice!
08:25 magnuse       dersmon: ^
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:19 magnuse       *check
08:19 magnuse       dersmon: i think i have done something like that, let me cgeck
08:19 cait1         trainign a library again this morning - bbl!
08:19 cait1         but we haven't made a change like this yet
08:18 cait1         iirc
08:18 cait1         dersmon: i think you could use a custom xslt that is linked to the metadata format
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 wahanui       Congratulations!
08:18 koha-jenkins  Yippee, build fixed!
08:18 cait1         magnuse: do i remember right that you di d that?
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:16 koha-jenkins  Project Koha_Master_U2010 build #134: FIXED in 50 min: https://jenkins.koha-community.org/job/Koha_Master_U2010/134/
08:16 wahanui       Congratulations!
08:16 koha-jenkins  Yippee, build fixed!
08:13 dersmon       hi!
08:11 nlegrand      Bonjour #koha !
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/
07:59 wahanui       Congratulations!
07:59 koha-jenkins  Yippee, build fixed!
07:58 cait1         good morning #koha
07:54 wahanui       what's up, alex_a
07:54 alex_a        Bonjour
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:23 wahanui       what's up, reiveune
07:23 reiveune      hello