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