Time  Nick        Message
21:12 indradg     aloha #koha
20:58 cait        Joubu++
20:22 cait        :D
20:22 cait        cool :)
20:22 cait        ohohoh
20:22 * LeeJ      waves bye to everyone
20:22 LeeJ        cait: I have to leave work now but you'll be getting an email from me later on :)
20:21 LeeJ        I can't wait until I leave! ^_^
20:21 LeeJ        cait: guess what came in the mail today?! :D
20:21 * cait      waves :)
20:20 * LeeJ      waves to cait
20:05 LeeJ        general question..if I pass as a param say $template->param(foo => $bar) when I go to the TT file and say I want it printed out with a paragraph tag wouldn't I just do <p>[% foo %]</p> ?
18:33 CrispyBran  Joubu, I can after lunch.  Trying to meet some deadlines today, but I can try to squeeze it in.  :)
18:33 CrispyBran  We may have several holds sitting on shelves that did not get confirmed.
18:33 Joubu       CrispyBran: could you test on master?
18:32 CrispyBran  That patch might have changed something to break this.  The issue could easily be overlooked if not testing with items from another library.  But it is dealing with the modal.
18:32 LeeJ        ^ that's the one
18:32 Joubu       Nuentoter: IntranetCatalogSearchPulldown?
18:30 LeeJ        Joubu: oh dear
18:29 Nuentoter   not a problem, im here for another 3.5 hrs.
18:29 LeeJ        Nuentoter: if you could wait a few minutes I'll find the name of the syspref..we're trying to help CrispyBran with a critical issue :)
18:28 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18438 major, P5 - low, ---, alexbuckley, Pushed to Stable , Check in: Modal about holds hides important check in messages
18:28 Joubu       bug 18438 has been pushed to .8
18:28 Nuentoter   ver 17.05.01    the main search bar at the top. masthead search box
18:27 CrispyBran  I think we were on 16.11.5.  I had asked to be updated to .7, and we were updated to .9.
18:26 LeeJ        CrispyBran: so you were on 16.11.8 prior to Monday correct?
18:26 kIdClAmP    this sounds familiar CrispyBran
18:25 LeeJ        Nuentoter: which search list are you referring to? And which Koha version are you running on?
18:25 CrispyBran  I was just notified minutes ago.  Might be something in the last minor update we just had on Monday.
18:25 Nuentoter   hello Koha world! question, is the dropdown search list something that needs enabling in the staff side?
18:24 LeeJ        CrispyBran: is this something you just noticed happening today?
18:22 LeeJ        **can't switch boxes..stupid typo
18:21 LeeJ        drat..and I'm working on a time-sensitive project so I can switch boxes now myself....is there a BWS demo running 16.11? or just 17.05?
18:20 kIdClAmP    not at the moment
18:20 LeeJ        kIdClAmP: do you happen to have a 16.11 box running by chance?
18:19 LeeJ        that's unusual...
18:18 CrispyBran  All it does is close the modal.  It does not mark the item as waiting.  It still shows in transit.  If it is a local hold, it works, but if it is from another library, it doesn't.
18:18 LeeJ        CrispyBran: could you elaborate on what you mean by it doesn't work? Is it not clickable? Is it clickable but doesn't proceed?
18:16 CrispyBran  Can anyone confirm a critical bug on 16.11.9?  Confirm button does not work on holds from another library (not the Print and confirm button).
18:12 LeeJ        well it occurred to me that onion rings aren't potatoes :P
18:11 kIdClAmP    you came clean prettty quick, it's okay
18:10 LeeJ        actually I lied..only one way
18:10 LeeJ        I just had some for lunch two ways! :D
18:10 kIdClAmP    mmmm..french fried potaters
18:09 LeeJ        kIdClAmP: is kater like a tater?
18:06 huginn      kIdClAmP: The operation succeeded.
18:06 kIdClAmP    @later tell tcohen I agree
18:06 huginn      kIdClAmP: downloading the Perl source
18:06 kIdClAmP    @kater tell tcohen I agree
18:01 LeeJ        hi #koha
18:01 * LeeJ      waves
17:24 huginn      Joubu: The operation succeeded.
17:24 Joubu       @later tell fridolin you need 18976 and 18977 to fix the selenium test failures
17:18 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18832 trivial, P5 - low, ---, veron, Pushed to Stable , Missing space between icon and label in button 'Patron lists'
17:18 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18839 enhancement, P5 - low, ---, chris.kirby, Pushed to Stable , suggestion.pl: 'unknown' is spelled 'unkown'
17:18 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18918 enhancement, P5 - low, ---, aleisha, Pushed to Stable , Exporting bibs in CSV when you have no CSV profiles created causes error
17:18 jenkins     * fridolin.somers: Bug 18832: Missing space between icon and label in button 'Patron lists'
17:18 jenkins     * fridolin.somers: Bug 18839: Suggestion.pl spelling mistake
17:18 jenkins     * fridolin.somers: Bug 18918: Disable CSV option if no CSV profiles exist
17:18 jenkins     * fridolin.somers: Bug 18982: Remove data in the correct order
17:18 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18982 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , selenium tests needs too many prerequisites
17:18 jenkins     * fridolin.somers: Bug 18982: Create a circ rule for the data we created
17:18 jenkins     * fridolin.somers: Bug 18982: Create a specific itemtype for these tests
17:18 jenkins     * fridolin.somers: Bug 18982: category.categorycode must be uppercase
17:18 jenkins     * fridolin.somers: Bug 18982: Use KOHA_INTRANET_URL instead of syspref staffClientBaseURL
17:18 jenkins     Project Koha_17.05.x_D8 build #7: STILL UNSTABLE in 1 hr 56 min: https://jenkins.koha-community.org/job/Koha_17.05.x_D8/7/
16:23 huginn      Joubu: The operation succeeded.
16:23 Joubu       @later tell wizzyrea Are you sure? https://lists.katipo.co.nz/pipermail/koha/2017-July/048554.html It remembers me something but it has been fixed months ago
16:04 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18993 normal, P5 - low, ---, mirko, NEW , Bump libtest-simple-perl to 1.302075
16:04 mtj         bug 18993
15:54 mtj         yep, doing now..
15:51 Joubu       yes, maybe we should add it to our perl dep list
15:48 mtj         great find ^ :)
15:48 mtj         'I upgraded Test::Simple from 1.001014 to 1.302075 and the tests now pass!'
15:48 mtj         yes, will do
15:42 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18979 minor, P5 - low, ---, jonathan.druart, Needs Signoff , Speed up 'valid-templates.t' tests
15:42 Joubu       mtj: could you take a look at bug 18979 when you will have some time? (not urgent)
15:41 Joubu       mtj: I marked #41 and #42 as "keep forever", just in case...
15:40 mtj         yes... i think i actually did earlier today
15:39 Joubu       I would have compared the execution time between the changes in prove args
15:39 Joubu       I'd not say "complete" :)
15:37 mtj         yes, i am sure there was a complete history for 16.5 eariler today
15:37 wahanui     rumour has it ^ is what I think too
15:37 Joubu       tcohen: ^ ?
15:37 Joubu       it's very weird because 1h ago there were 2 + 1 running, now the run is finished there are still 2
15:37 * mtj       has no admin or shell access to the jenkins boxes
15:36 mtj         no, i noticed myself... i thought someone did a tidy-up?
15:35 Joubu       mtj: do you know why there are only 2 builds kept for 16.05 whereas the config says 30?
15:33 kidclamp    I will try to get a better explanation when filing
15:33 kidclamp    I was looking at both, the problem seems to be in C4::Auth_with_ldap
15:32 Joubu       kidclamp: I'd suggest you to read the code of C4::Auth::checkpw, in master. I tried to clean up the code a bit
15:32 Joubu       no*
15:31 Joubu       kidclamp: apparently the current behavior is: if there is a koha user and pwd fail, we fallback, if there is not koha user we do not
15:30 wahanui     ashimema is on qa now .)
15:30 kidclamp    ashimema
15:30 kidclamp    yeah, this seems to have existed for some time - different behaviour depending on ldap setup - I will file a bug and add you and ashimeme
15:29 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18880 blocker, P5 - low, ---, jonathan.druart, RESOLVED FIXED, Regression breaks local authentication fallback for all external authentications
15:29 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18314 enhancement, P5 - low, ---, jonathan.druart, RESOLVED FIXED, Account lockout
15:29 Joubu       I am aware of bug 18314 (in 17.05) that introduced bug 18880, so not for 16.11
15:27 kidclamp    16.11.07
15:27 kidclamp    but we don't check it if using a bind user and password fails
15:26 kidclamp    16.11
15:26 kidclamp    we do fallback if doing auth_by_bind and will check koha password if ldap password doesn't match
15:26 JesseM      Not an available option that I can see
15:26 Joubu       versions?
15:26 kidclamp    It seems we have different behaviour based on ldap setup
15:26 JesseM      thank you Joubu
15:25 Joubu       kidclamp: context? There are 2 bugs related to that
15:25 kidclamp    all re ldap
15:25 Joubu       https://www.iana.org/assignments/language-tags/language-tags.xml
15:25 kidclamp    Joubu can you answer^
15:24 kidclamp    under bind by auth without anonymous bind we fall back to koha login if user exists and password fails - if using bind user and password fails we don't fallback - is this correct?
15:24 Joubu       Hong Kong should be "zh-Hant-HK" apparently
15:22 JesseM      I searched the wiki for definitions but didn't find anything
15:21 JesseM      #koha I'm adding language pack to site and I don't see an option for Chinese (Hong Kong). Would that option be zh-Hans-TW ?
15:19 kidclamp    will do joubu
15:19 mtj         ..if you dont want failed first, then --state='slow,all,save' was the fastest option, for me
15:19 kidclamp    anyone around using ldap?
15:15 mtj         yep.. tomas did, some weeks ago
15:14 Joubu       mtj: you already modified the jenkins config for 16.05, right?
15:13 mtj         yes, depends... i found it very handy to know that my problematic test will pass/fail in 10 mins, rather than wait 2 hours
15:11 Joubu       but yesterday I did not want, I wanted some tests to be executed before the failed ones
15:11 Joubu       well, it depends I guess
15:11 Joubu       mtj: nope we do not want the failures first, we want to keep the random
15:10 mtj         getting the slow tests to run in parallel, gave a speed boost
15:09 mtj         i think this was the best option... -> --state='failed,slow,all,save'
15:07 mtj         a trival fix..
15:07 mtj         'prove' wants to write to a file called ./.prove... but cant
15:04 mtj         fyi, there is currently a permissions bug on jenkins, that means the state args are currently ignored
15:03 mtj         hmm, thats a typo... should be  --state=failed,all,save
15:01 Joubu       mtj: trying to understand: --state=save,failed,slow, from the doc: "failed: Run only the tests that failed on the last run"
15:00 TGoat       good morning :)
14:59 mtj         oops, corrected markdown typo ^
14:55 Joubu       thx mtj
14:55 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18367 minor, P5 - low, ---, nick, Pushed to Master , Fix untranslatable string from Bug 18264
14:55 Joubu       kidclamp: could you take a look at bug 18367 comment 8 please?
14:48 mtj         ..i have not compared yet
14:48 mtj         Joubu: heres the kanban page -> https://tree.taiga.io/project/joubu-koha-rm-1711/task/131
14:23 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18055 enhancement, P5 - low, ---, baptiste.wojtkowski, Signed Off , Speed up '00-strict.t' test
14:23 Joubu       I did not find much, see bug 18055 comment 32
14:22 mtj         ..basically, there are some tests that jenkins can safely run in parallel, that speed the build up a bit :0)
14:21 Joubu       I did not manage to do it, I lost myself into Makefile.pl
14:20 mtj         ill try some tests before i update your kanban page
14:20 mtj         ^ that would be a good win
14:16 Joubu       I also wanted to try skipping the copy to blib on jenkins
14:16 Joubu       mtj: I have created a card on the kanban few days ago: https://tree.taiga.io/project/joubu-koha-rm-1711/us/125
14:14 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18572 major, P5 - low, ---, nick, Pushed to Stable , Improper branchcode  set during OPAC renewal
14:14 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18826 major, P5 - low, ---, jonathan.druart, Pushed to Stable , REST API tests do not clean up
14:14 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18955 major, P5 - low, ---, fridolin.somers, Pushed to Stable , autocomplete is on in OPAC password recovery
14:14 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18152 major, P1 - high, ---, stephane.delaune, Pushed to Stable , UNIMARC bib records imported with invalid 'a' char in label pos.9
14:14 jenkins     * fridolin.somers: Increment version for 17.05.02 release
14:14 jenkins     * fridolin.somers: Update release notes for 17.05.02 release
14:14 jenkins     * root: Translation updates for Koha 17.05.02
14:14 jenkins     * fridolin.somers: Bug 18572: Remove AddRenewal parameter
14:14 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18910 critical, P5 - low, ---, jonathan.druart, Pushed to Stable , Regression: Z39.50 wrong conversion in Unimarc by Bug 18152
14:14 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18966 blocker, P5 - low, ---, jonathan.druart, Pushed to Stable , Move of checkouts - Deal with duplicate IDs at DBMS level
14:14 jenkins     * fridolin.somers: Bug 18572 - QA Followup
14:14 jenkins     * fridolin.somers: Bug 18572 - Improper branchcode set during OPAC renewal
14:13 jenkins     * fridolin.somers: Bug 18826 - (QA Followup) Add mock SessionStorage to patrons.t
14:13 jenkins     * fridolin.somers: Bug 18826: rollback transaction for api tests
14:13 jenkins     * fridolin.somers: Bug 18955 - autocomplete is on in OPAC password recovery
14:13 jenkins     * fridolin.somers: Bug 18910: Revert "Bug 18152 : fix unimarc label in SetMarcUnicodeFlag"
14:13 jenkins     * fridolin.somers: Bug 18910: Revert "Bug 18152: Add tests"
14:13 jenkins     * fridolin.somers: (17.05.x) Bug 18966: Do not deal with duplicate issue_id on checkin
14:13 jenkins     Project Koha_17.05.x_D8 build #6: STILL UNSTABLE in 1 hr 58 min: https://jenkins.koha-community.org/job/Koha_17.05.x_D8/6/
14:04 mtj         Joubu: i will email you some 'prove' changes to reduce your build time
13:58 mtj         i have the 16.5 patch queued in jenkins for testing
13:57 mtj         ..the bug is that the issues->old_issues move, happens twice
13:56 mtj         https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65294
13:56 mtj         cait: i added a followup for 16.11 and 16.5
13:54 cait        Joubu: what's the bug? are you writing a follow-up?
13:47 mtj         ^ ..search for 'prove -j 2'
13:46 mtj         https://jenkins.koha-community.org/job/Koha_16.05.x_D8/41/consoleText
13:45 mtj         small changes to the 'prove' command
13:45 Joubu       mtj: what kind of improvements?
13:44 cait        need mor einformation tho :)
13:44 cait        starting in about 3 hours or so
13:44 mtj         Joubu: i have some recent improvements that reduce my 16.5 builds by 40 mins...
13:44 cait        i am not releasing now
13:44 cait        hm?
13:40 huginn      Joubu: The operation succeeded.
13:40 Joubu       @later tell cait Do not release as it, you will need a followup for 18966 and 16.11
13:37 marcelr     we will have another patch ;)
13:37 Joubu       marcelr: as you want. But what will happen if you find a bug that affect all the releases that have just been released? :D
13:36 marcelr     Joubu: ^
13:35 Joubu       cait: around? you will need a followup for 18966 and 16.11
13:35 marcelr     would it make sense to still spend some time on the master patch tomorrow ?
13:35 marcelr     ok
13:35 Joubu       marcelr: sounds like it is for 16.11 and 16.05, no 17.05 or master
13:31 mtj         Joubu: i can do, np
13:30 mtj         17.05 looks ok to me
13:30 Joubu       yes, what I said just after
13:30 marcelr     ?
13:30 marcelr     Joubu: sure that it is not in 16.11 and higher
13:30 fridolin1   Joubu: ouch it concerns 17.05 ?
13:30 Joubu       or will you?
13:30 Joubu       mtj: do you want me to provide a followup?
13:29 Joubu       mtj: good catch inded!
13:29 Joubu       pfiou
13:29 Joubu       ha no, for 16.11
13:29 Joubu       you will have to release again
13:29 wahanui     I haven't seen 'what', Joubu
13:29 Joubu       fridolin1: seen what mtj just said?
13:27 fridolin1   Joubu: oki thanks
13:27 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18982 normal, P5 - low, ---, jonathan.druart, Pushed to Master , selenium tests needs too many prerequisites
13:27 Joubu       fridolin1: bug 18982 will help selenium tests to pass on 17.05
13:22 mtj         the 18966 patch is not running in production.. so must be a different error
13:21 mtj         hmm, no. i think not
13:20 marcelr     same error?
13:20 JesseM      Wondering if anyone else has come across this issue? When placing a hold on a title that has hundreds of items that have all been barcoded slowing koha down to a crawl?
13:20 marcelr     hey frido or cait was talking too about unique key volation
13:19 mtj         the tests pass ok, with the 2nd line removed
13:16 marcelr     would not expect such things after so many people worked on it ?
13:16 marcelr     delete the line
13:16 marcelr     thats your confirmation
13:15 mtj         DBD::mysql::db do failed: Duplicate entry '50' for key 'PRIMARY' [for Statement "INSERT INTO old_issues SELECT * FROM issues WHERE issue_id = ?"] at /home/mason/g/k/16.05.x/C4/Circulation.pm line 2171.
13:15 marcelr     ah good
13:15 mtj         marcelr: hi, and yes lots of errors/warnings!
13:15 marcelr     are the warnings suppressed?
13:15 marcelr     it sounds ok mtj
13:15 mtj         am i correct here, anyone?
13:14 marcelr     dont you have warnings?
13:14 mtj         $dbh->do(q|INSERT INTO old_issues SELECT * FROM issues WHERE issue_id = ?|, undef, $issue_id);
13:14 mtj         but the existing line has not been removed, as expected...?
13:13 marcelr     you will always have issues with issues, i suppose
13:13 mtj         +        my $old_checkout = Koha::OldIssue->new($issue->unblessed)->store;
13:13 mtj         a new line is added in the patch...
13:12 mtj         $dbh->do(q|INSERT INTO old_issues SELECT * FROM issues WHERE issue_id = ?|, undef, $issue_id);
13:12 mtj         my $old_checkout = Koha::OldIssue->new($issue->unblessed)->store;
13:12 mtj         # Create the old_issues entry
13:12 mtj         heres the patch for 16.11 -> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65206
13:12 mtj         hmm, typo might be for 16.11 and 16.5...
13:11 marcelr     mtj++ # stay sharp :)
13:10 mtj         the AddReturn() sub seems to move the issue row to old_issues twice
13:07 mtj         hey folks, i think there might be a typo/bug in 18966 - for 17.05 and lower...
13:05 marcelr     hi Joubu
13:03 Joubu       Hello #koha
12:57 endmar      I was using smarthost
12:56 endmar      <kidclamp> do you think this is the perfect way http://kohageek.blogspot.com/2012/09/configure-gmail-with-postfix-to-send.html
12:53 JesseM      That is true
12:52 edveal      But that doesn’t always equate to a great soccer game.
12:52 endmar      <kidclamp> I was doing all
12:52 edveal      Yes it will be fast and furious with lots of goals I am sure.
12:52 edveal      LOL don’t much care. Allstar teams never really have time to gel and they are compeating against a team in their preseason. It is all about seeing European starts and putting buts in the seats. Never great games.
12:52 JesseM      I think it will be an exciting match to watch
12:49 JesseM      edveal: what do you think about the match coming up against MLS allstars and FC Barcelona ?
12:48 edveal      Sorry for our Jamacan friends but hey someone had to win. LOL
12:48 edveal      Yes it was!!!
12:47 JesseM      Same here edveal. It was a good game
12:47 edveal      JesseM I stayed up too late watching the USA soccer team last night I am still sleepy as well.
12:46 kidclamp    so the email isn't queueing even - did you specifically populate username and password - or did you allow to auto generate? it only works if both fields are filled out explicitly i believe
12:45 endmar      I just get this
12:45 JesseM      still sleepy
12:45 endmar      Empty set (0.00 sec)
12:45 JesseM      morning #koha
12:45 endmar      Hi Kidcalmp
12:45 JesseM      morning 3koha
12:38 kidclamp    I think that code is correct
12:38 kidclamp    enter into mysql or the reports module
12:37 kidclamp    SELECT * FROM message_queue WHERE letter_code='ACCTDETAILS'
12:18 endmar      how can I do that?
12:18 kidclamp    you can check the message_queue via sql to see if themessage was created
12:18 endmar      I was having this message throgh my email Cron <swebshet@swebshet> __KOHA_USER__ $KOHA_CRON_PATH/../migration_tools/rebuild_zebra.pl -b -a -z >/dev/null
12:17 kidclamp    is the process_message_queue cronjob running?
12:16 endmar      I can send email through command line after I installed postfix
12:15 endmar      and I do enable the system prefrence
12:15 endmar      Hi kidclamp, sure I was adding patrons account
12:04 kidclamp    hi endmar - did you enter both a username and password when creating the account? and do you have the system preference enabled and an email set?
11:48 endmar      Hello All, I didn't get emails from koha while I was adding a new patron
11:45 cait        endmar: sorry, I don't know
11:45 cait        fridolin1: ok, i will follow tonight
11:40 fridolin1   cait: i start release v17.05.02
11:40 fridolin1   cait: yep indeed
11:37 endmar      what does this indicates
11:37 endmar      is coming through my email
11:37 endmar      Cron <swebshet@swebshet> __KOHA_USER__ $KOHA_CRON_PATH/../migration_tools/rebuild_zebra.pl -b -a -z >/dev/null
11:30 cait        sorry!
11:29 cait        now i got it
11:29 cait        ok
11:29 cait        count
11:29 cait        ah, they cound separately
11:28 cait        going to look at schema
11:27 cait        hm
11:27 cait        because the entry won't getmoved correctly and will be lost if we don't reset the pks after mysql restart?
11:27 cait        this is about the mysql script, it doesn't hurt to include it there
11:26 cait        i am with fridolin, i think we need it
11:26 cait        marcelr: but data will still get lost
11:10 jenkins     * fridolin.somers: Bug 18931 - Follow up - Typo fix in template for holds
11:10 jenkins     * fridolin.somers: Bug 18931: (followup) Tidy text
11:10 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18931 enhancement, P5 - low, ---, jonathan.druart, Pushed to Stable , Add a "data corrupted" section on the about page
11:10 jenkins     * fridolin.somers: Bug 18931 - Follow up - Typo fix in SQL statement
11:10 jenkins     * fridolin.somers: Bug 18931: Add items/deleteditems tables
11:10 jenkins     * fridolin.somers: Bug 18931: Add a "data corrupted" section on the about page - MySQL AI
11:10 jenkins     Project Koha_17.05.x_D8 build #5: STILL UNSTABLE in 1 hr 56 min: https://jenkins.koha-community.org/job/Koha_17.05.x_D8/5/
10:44 fridolin1   thanks a lot marcelr
10:43 fridolin1   yep
10:42 marcelr     this table should not be a problem; if we had done issue like this, we would have been fine
10:42 fridolin1   oki then
10:42 fridolin1   ohhh cool
10:41 marcelr     SELECT biblionumber, format, marcflavour, metadata FROM biblio_metadata WHERE biblionumber=?
10:41 marcelr     INSERT INTO deletedbiblio_metadata (biblionumber, format, marcflavour, metadata)
10:41 marcelr     the id is not useless, it is the pk but it is just techincal
10:40 marcelr     no you do not insert the id
10:40 fridolin1   ahhh so you mean id could be useless ?
10:40 fridolin1   if generated id already exists => Bang
10:40 fridolin1   marcelr: yep but on delete, biblio_metadata is copied to deletedbiblio_metadata
10:39 marcelr     AND marcflavour=?
10:39 marcelr     AND format='marcxml'
10:39 marcelr     WHERE biblionumber=?
10:39 marcelr     FROM biblio_metadata
10:39 marcelr     SELECT metadata
10:38 marcelr     iirc metadata is searched by biblionumber
10:37 marcelr     yeah but the crux is do you use the id
10:37 fridolin1   i think
10:37 fridolin1   so same problem with deletedbiblio_metadata
10:37 fridolin1   marcelr: mmm but biblio_metadata.id is autoincremental like others
10:31 marcelr     fridolin1: deletedbiblio metadata has a separate id and biblionumber; if you search for the biblionumber, the id is not relevant
10:28 fridolin1   arf yep
10:26 cait        but then we need to split the script for the different versions
10:26 cait        fridolin1: good catch
09:35 fridolin1   Joubu: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix is missing deletedbiblio_metadata no ?
09:04 fridolin1   ok thanks cait
09:04 cait        zebra is not always helpful in its error message... or almost never
09:04 cait        vincent_: i'd check if it's on your fresh installation too
09:03 cait        and asked Joubu, not sure if you had that alreqdy
09:03 cait        i know that for my patches i don't need to push 18651 first, because i hadn't pushed it yet
09:02 cait        fridolin1: not sure if it's different for you and me - but i'd start there
08:40 vincent_    anyway, with information you gave me, I'm starting a fresh install jessie/koha-17.05 and will try to copy database :)
08:33 vincent_    I got about 40 line of this kind of warning ...
08:32 vincent_    sorry to annoy with my newbie question (please tell me if it's not the right place to ask), I got some warning when I reindex: "zebraidx(23405) [warn] Index 'Music-number' not found in attset(s)" do you know if it's a big issue I must fix before upgrading ?
08:20 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18966 blocker, P5 - low, ---, jonathan.druart, Pushed to Master , Move of checkouts - Deal with duplicate IDs at DBMS level
08:20 fridolin1   cait: to be sure, I have to intergrate Bug 18966 and dependancies right
08:19 vincent_    is it safe to start a fresh install on a debian stretch or should I still use a debian jessie ?
08:15 vincent_    got some reading: https://wiki.koha-community.org/wiki/Switching_to_dom_indexing
08:13 vincent_    doing a complete reindex should not be more complicated than a 'koha-rebuild-zebra -f' isn't it ?
08:13 vincent_    maybe I can just create a new empty instance and compare file between instance ?
08:12 cait        hi khall
08:12 cait        so comparing might not be easy
08:12 cait        ... not sure i can explain that right
08:12 wahanui     the indexes are not in the database, so you have to do a complete reindex after restoring the database
08:12 cait        well the indexes
08:12 cait        we switched from grs1 to dom indexing - the way to configure the index files
08:11 cait        i am not sure if 3.12 was using dom indexing yet
08:11 cait        hm that makes it a bit harder
08:09 vincent_    and I do not know if anything was changed in the koha/zebra conf
08:09 vincent_    I'm looking for the koha-common package version 3.12 to compare configuration file (especially the zebra configuration) in fact I have to upgrade an installation that I do not install myself...
08:08 cait        know the process, but not a sysadmin myself
08:08 cait        vincent_: for the exact commands someone else might be more helpful
08:07 mtj         cait: awesome :0)
08:06 cait        hm i'd say so
08:05 vincent_    thanks cait, so I still need to create an instance on the new server new koha and fill it with the old database ?
08:05 cait        waiting for fridolin to push, sorry, can't be faster
08:05 cait        just started work and don't have the laptop with the keys and all
08:04 cait        8-10 hours from now i guess :)
08:04 cait        i will do it once i get home
08:04 cait        hi mtj
08:04 mtj         hiya cait, i will try for a 16.5 release today
08:04 cait        to the zebra files
08:04 cait        as we also enhance indexing configuration, i'd recommend not to copy there but redo/just copy&paste changes if you have made additions
08:04 vincent_    ok :)
08:02 cait        maybe graphics/css file for th opac if you have created your own
08:02 cait        but if you haven't done customization on the files that shoudl be it
08:02 cait        if you have changed zebra indexes maybe
08:02 cait        nope
08:02 vincent_    is there anything else that the database to copy ? (I mean some configuration files in /etc/ for example or other stuff)
08:02 cait        have a look at the configuration options before creating your instance
08:02 cait        you could all activate that on the new server and then move your database
08:01 cait        or if you want to start using https/letsencrypt
08:01 cait        if you install from scratch a new version - it's also recommended to use plack and memcache now
08:01 cait        it will happen automatically
08:01 cait        you don#t need to run it
08:01 cait        and if you can afford it a test system to test the update process before actually doing it would be very recommended too - there might be some warns and errors in the update that you need to take a closer look at
08:01 vincent_    I can install a fresh new koha on a fresh new server (debian jessie or stretch), copy the database and just run some upgrade script ?
08:00 cait        so you can restore the old state if something goes wrong
08:00 cait        key to updates like that is backups of course
08:00 cait        so you are already using a packaged version
08:00 cait        that's good!
07:59 cait        ah
07:59 cait        the web installer/updater will take care of updating the database structures detecting the difference in the version number from the database to the installation
07:59 vincent_    koha was installed (and still running) on a debian squeeze via the koha repository (deb http://debian.koha-community.org/koha squeeze main)
07:59 cait        and import it there
07:59 cait        then export the database from your old installation
07:59 wahanui     17
07:59 cait        16.11 or 17.05
07:59 cait        i think one of the more preferred methods is setting up a new server with the version you ant to upgrade to
07:58 vincent_    well, I'm not sure what upgrade path I should take
07:57 cait        what do you want to know?
07:57 cait        hi vincent_
07:56 vincent_    I need some help for upgrading an old koha installation (3.12), could you help me ?
07:55 wahanui     bonjour, vincent_
07:55 vincent_    Hello
07:51 cait        i will do it tonight
07:51 cait        can you ping me?
07:51 cait        cool
07:51 huginn      04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18966 blocker, P5 - low, ---, jonathan.druart, Pushed to Master , Move of checkouts - Deal with duplicate IDs at DBMS level
07:51 fridolin1   cait: i will test bug 18966 and then push
07:50 cait        fridolin1: are you pushing today?
07:50 fridolin1   bonjour marcel
07:50 cait        hi marcelr
07:49 marcelr     hi gaetan_B fridolin1 and cait
07:47 * cait      waves
07:38 fridolin1   hiet here
07:26 gaetan_B    hello
06:56 marcelr     hi #koha
04:05 jenkins     Project Koha_Master_D8 build #232: FIXED in 1 hr 59 min: https://jenkins.koha-community.org/job/Koha_Master_D8/232/
04:05 wahanui     o/ '`'`'`'`'`'`'`'`'`
04:05 jenkins     Yippee, build fixed!
03:14 wizzyrea    also possibly your vagrant is out of date.
02:52 wizzyrea    hey there
02:25 * Francesca waves
01:58 wizzyrea    try deleting/moving from your home directory  .vagrant and .vagrant.d
01:57 wizzyrea    if you run up against a timeout during server version negotiating with devbox
01:57 wizzyrea    for posterity