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