← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:28 | kohaputti joined #koha | |
| 02:14 | Scott-CSPL joined #koha | |
| 02:14 | deb-CSPL joined #koha | |
| 04:15 | cait joined #koha | |
| 04:59 | alexbuckley joined #koha | |
| 06:08 | chris1 joined #koha | |
| 06:46 | ashimema | <_oftc_alexbu "hi all, I have a problem. I am t"> Interesting alexbuckley |
| 06:47 | Oh, likely missed you | |
| 06:47 | Certainly sounds like a bug.. we've not done any such upgrades ourselves yet | |
| 06:47 | In fact, I probably wouldn't even notice if I had | |
| 06:50 | sansar joined #koha | |
| 06:54 | sans joined #koha | |
| 06:59 | alexbuckley joined #koha | |
| 07:10 | fridolin joined #koha | |
| 07:10 | fridolin | hi there |
| 07:31 | marcelr joined #koha | |
| 07:37 | AndrewIsh joined #koha | |
| 07:38 | reiveune joined #koha | |
| 07:38 | reiveune | hello |
| 07:38 | wahanui | hi, reiveune |
| 07:40 | andreashm joined #koha | |
| 07:47 | paul_p joined #koha | |
| 07:48 | marcelr | hi #koha |
| 07:55 | alex_a joined #koha | |
| 07:56 | alex_a | bonjour |
| 07:56 | wahanui | what's up, alex_a |
| 07:58 | cait joined #koha | |
| 08:02 | * magnuse | also has a varying number of tables in instances of varying age |
| 08:15 | andreashm joined #koha | |
| 08:57 | ashimema | irc are you there |
| 09:13 | chris1 joined #koha | |
| 09:26 | paul_p_ joined #koha | |
| 09:29 | Archie^ joined #koha | |
| 09:29 | Archie^ | good morning Ladies and Gents ;) |
| 09:31 | hey guys is DDMS auto increment fix instruction up to date? i'm looking at it and it says to modify /etc/mysql/my.cnf and was wondering is this same for both mariaDB and mysql? | |
| 09:31 | coz the document has only "!includedir conf.d and mysql.conf.d| | |
| 09:31 | so maybe i should modify those? | |
| 09:34 | i'm pretty sure we need to change it to modify mysqld.cnf but i would like someone to confirm this | |
| 09:37 | cait joined #koha | |
| 09:40 | Archie^ | hey cait maybe you can confirm my suspicion? |
| 09:50 | alexbuckley joined #koha | |
| 10:03 | andreashm joined #koha | |
| 10:39 | andreashm joined #koha | |
| 10:40 | andreashm joined #koha | |
| 10:41 | andreashm joined #koha | |
| 11:03 | Archie^ joined #koha | |
| 11:18 | andreashm joined #koha | |
| 11:38 | Archie^ | how does ISSN staging works? I've added the record but if i go to serials, it does not show me the added record :/ |
| 11:39 | cait | serials shows only subscriptions |
| 11:39 | so you have to add a subscription for your record, that does not happen automatically | |
| 11:39 | i think you have a wrong idea about what the module does :) | |
| 11:43 | Archie^ | i have to add subscription to journal? for instance National geographic journal should be added there? |
| 11:47 | cait | you only use the serials module if you want to track the issues |
| 11:47 | track = check if you received everything yu paid for, have an information about when th enext issue will be arrive etc. | |
| 11:47 | if you have a paid subscription for national geographic you might wan tto do that | |
| 11:47 | but you can also use kioha without the serials module | |
| 11:47 | Archie^ | ahh, but is there a way to check all journals ? |
| 11:48 | cait | check what? |
| 11:48 | Archie^ | again lets say i upload all national geographic ISSN via marc xml (100 monthly issues) Is there a way to find all these issues ? coz it does not appear in catalogue |
| 11:49 | cait | it should |
| 11:49 | if you staged and imported correctly all records will appear in the catalog, independent if they are serials or not | |
| 11:49 | Archie^ | mkey, prolly making some sort of mistake then. tn |
| 11:49 | tnx cait | |
| 11:49 | cait | most serials have only one record for the serial itself, having a record for each issue is possible, but not the most common |
| 11:50 | koha would attach issues to the serial record - not creating individual ones, if using the serials module | |
| 11:51 | Archie^ | right so after configurating serials module will koha pick up all the records for that serial? |
| 11:53 | checking with Demos that are on Koha website ;D all of the serial modules are empty | |
| 11:55 | cait | no, ther is no automatism, because it would never work |
| 11:55 | you create a subscription in the serials module and link it to the record | |
| 11:55 | the module will then let you search on your created subscriptions | |
| 11:58 | khall++ thx for comments | |
| 12:00 | Archie^ | ahh ok thank you |
| 12:21 | paul_p joined #koha | |
| 12:38 | oleonard joined #koha | |
| 12:40 | oleonard | Hi #koha |
| 12:48 | alex_a joined #koha | |
| 12:51 | kidclamp | hi |
| 12:51 | wahanui | privet, kidclamp |
| 13:12 | cait | hi oleonard and kidclamp |
| 13:12 | andreashm joined #koha | |
| 13:12 | kidclamp | hi cait |
| 13:16 | nikola joined #koha | |
| 13:17 | nikola | hi |
| 13:17 | any one here | |
| 13:17 | ???? | |
| 13:18 | cait | yes |
| 13:18 | there are many here, but not always talking :) | |
| 13:18 | nikola | currently im installing koha in ubuntu 18.04? |
| 13:18 | but i can"t find my opac | |
| 13:19 | Dyrcona joined #koha | |
| 13:22 | alex_a_ joined #koha | |
| 13:22 | oleonard | nikola: Did you do a package installation? |
| 13:22 | nikola | which package? |
| 13:23 | oleonard | https://wiki.koha-community.or[…]ki/Koha_on_Debian |
| 13:25 | nikola | yes |
| 13:25 | but i cant find the opac | |
| 13:26 | oleonard | Have you followed those instructions up to this step? https://wiki.koha-community.or[…]the_web_interface |
| 14:26 | caroline1 joined #koha | |
| 15:08 | oleonard | Is anyone around who is familiar with the auto_increment bug? |
| 15:08 | I'm fielding a question about it and am not sure about some aspects of the fix. | |
| 15:08 | Is a change to MySQL required, or has Koha adapted to the bug? | |
| 15:09 | ashimema | sorry oleonard, that's not one of my expertise area's |
| 15:09 | cait | newer versions have |
| 15:09 | but not the one in current debian | |
| 15:09 | i have looked up the versions where the bug is fixed recently, let me find it | |
| 15:09 | oleonard | cait: So an upgrade to MySQL is required in order to prevent the bug from reoccurring? |
| 15:09 | cait | MariaDB 10.2.4 Release Notes |
| 15:09 | https://mariadb.com/kb/en/libr[…]24-release-notes/ | |
| 15:10 | MySQL: https://dev.mysql.com/doc/refm[…]nt-initialization | |
| 15:10 | 5.7 and earlier have the bug, in 8.0 it will work | |
| 15:10 | is what my notes say | |
| 15:10 | you can use the script on the wiki page until then | |
| 15:12 | oleonard | That MySQL page is just a description of the problem, correct? Not a description of the fix? |
| 15:13 | cait | which page are you looking at? |
| 15:14 | In MySQL 5.7 and earlier, the auto-increment counter is stored only in main memory, not on disk. To initialize an auto-increment counter after a server restart, InnoDB would execute the equivalent of the following statement on the first insert into a table containing an AUTO_INCREMENT column. SELECT MAX FROM table_name FOR UPDATE; In MySQL 8.0, this behavior is changed. The current maximum auto-increment counter value is written | |
| 15:14 | to the redo log each time it changes and is saved to an engine-private system table on each checkpoint. These changes make the current maximum auto-increment counter value persistent | |
| 15:14 | the fix for 5.7 and earlier is on the koha wiki | |
| 15:14 | it's a script that gets executed when the mysql server is restarted and makes sure that the pk will not get doubled up by resetting the auto_increment counters to the right values | |
| 15:17 | corilynn joined #koha | |
| 15:21 | Joubu | Hi #koha |
| 15:24 | cait | welcome back Joubu :) |
| 15:29 | alex_a_ | Joubu, \o |
| 15:31 | CrispyBran joined #koha | |
| 15:36 | CrispyBran | I am noticing a LOT of notice duplications in the All libraries of the Notices & slips. Am I looking at it wrong or is there something off with our notice templates? |
| 15:37 | We're experiencing some internet issues at the moment, so it would help to have a outside set of eyes looking at it. | |
| 15:37 | https://media.trillian.im/medi[…]Ti4oIdulPrQ%3D%3D | |
| 15:41 | Looks like it isn't just the all libraries. I see duplication within some libraries as well. | |
| 15:47 | CrispyBran left #koha | |
| 15:51 | cait | it's only display, you can ignore possibly - i think there was a bug showing one entry per messaging type |
| 15:51 | (email, print) | |
| 15:51 | which version is thiis? | |
| 15:52 | bug 22002 | |
| 15:52 | huginn` | Bug http://bugs.koha-community.org[…]_bug.cgi?id=22002 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , Each message_transport_type in the letters table is showing as a separate notice in Tools > Notices and slips |
| 15:53 | cait | it looks like it#s only fixed in 18.11 not in 18.05 |
| 15:53 | JesseM: coudl you take another look at bug 22002? rebased patch might have been missed | |
| 15:56 | oh | |
| 15:57 | @later tell CrispyBran check irc logs for anwer to your question | |
| 15:57 | huginn` | cait: The operation succeeded. |
| 16:12 | andreashm joined #koha | |
| 16:21 | corilynn | alex_a_ are you equal to "Alex Arnaud" ? |
| 16:21 | alex_a_ | corilynn, yes! |
| 16:21 | corilynn | excellent! |
| 16:21 | wahanui | darn tootin' it is. |
| 16:21 | alex_a_ | corilynn, nice to see you there :) |
| 16:23 | corilynn | I opened up a chat windoe, alex_a_ |
| 16:24 | window | |
| 16:31 | cait | corilynn: for hints see the irc regulars page on the wiki :) |
| 16:31 | irc regulars? | |
| 16:31 | wahanui | irc regulars is probably https://wiki.koha-community.org/wiki/IRC_Regulars |
| 16:42 | corilynn | thx cait! |
| 16:45 | fridolin left #koha | |
| 16:53 | oleonard | Still fielding some questions about this MySQL autoincrement bug... Are there any Koha-specific concerns related to upgrading MySQL to 8.0? |
| 16:53 | reiveune | bye |
| 16:53 | reiveune left #koha | |
| 16:55 | cait | oleonard: i haven't seen anyone doing it yet |
| 16:56 | we will stick with what is in Debian | |
| 16:57 | oleonard | cait: So your advice would be to apply fix described on the wiki, not to do an upgrade? |
| 16:57 | cait | i haven't tested the other option, but we have implemented the wiki fix |
| 16:57 | tcohen | hi all |
| 16:58 | cait | i think restart of mysql takes a bit longer becuase of it, butit seems to work ok |
| 16:58 | hi tcohen :) | |
| 16:58 | about to run off - bbl :) | |
| 16:59 | oleonard | tcohen: What do you think? Upgrade MySQL or perform the autoincrement fix described on the wiki for older MySQL? |
| 17:00 | * oleonard | is being asked questions which are above his pay grade |
| 17:00 | Joubu | it depends on the MySQL version available in your distro |
| 17:00 | tcohen | we use the autoincrement fix |
| 17:03 | blou__ joined #koha | |
| 17:03 | deb-CSPL joined #koha | |
| 17:03 | Scott-CSPL joined #koha | |
| 17:07 | cait | i've been 'taught' it's alwys better to use what is packaged for your distro - so if that is mysql 5.7, we'll use that until it changes |
| 17:07 | cait left #koha | |
| 17:07 | blou_ joined #koha | |
| 17:07 | deb-CSPL joined #koha | |
| 17:07 | Scott-CSPL joined #koha | |
| 17:12 | Joubu | Looks like I am rusty, what's the difference between $order->biblio->serial and $order->subscriptionid? |
| 17:13 | can we have biblio.serial != 1 and $order->subscriptionid not null? | |
| 17:15 | $order->subscriptionid is set if we are creating an order from a subscription | |
| 17:18 | caroline1 joined #koha | |
| 17:36 | caroline1 joined #koha | |
| 17:53 | CrispyBran joined #koha | |
| 17:53 | CrispyBran left #koha | |
| 17:56 | oleonard-away | Has anyone here ever configured Zebra to search by Accelerated Reader levels? |
| 18:02 | cait joined #koha | |
| 18:29 | andreashm joined #koha | |
| 18:31 | blou__ joined #koha | |
| 18:31 | Scott-CSPL joined #koha | |
| 18:34 | blou_ joined #koha | |
| 18:35 | Scott-CSPL joined #koha | |
| 18:35 | deb-CSPL joined #koha | |
| 18:43 | kidclamp | i have palyed with it oleonard-away |
| 18:45 | andreashm joined #koha | |
| 18:52 | caroline1 joined #koha | |
| 19:05 | oleonard | kidclamp: I'm helping a small library with their Koha setup and they're interested in using Accelerated Reader levels. I've got a report working for them but it'd be nice to be able to give them the ability to search |
| 19:06 | kidclamp | https://bugs.koha-community.or[…]_bug.cgi?id=20078 |
| 19:06 | huginn` | Bug 20078: enhancement, P5 - low, ---, nick, RESOLVED FIXED, Indexes 'arl' (Accelerated reading level) and 'arp' (Accelerated reading point) not usable in search menus |
| 19:07 | kidclamp | some hints there oleonard |
| 19:07 | oleonard | Cool, thanks |
| 19:14 | caroline1 joined #koha | |
| 19:17 | ashimema | That may even be backportable as is oleonard .. I didn't because it was an enhancement but I didn't really check how hard it might be |
| 19:28 | lisettelatah joined #koha | |
| 19:32 | oleonard | Thanks ashimema, they're on 17.11 and I don't know when they'll be able to upgrade |
| 19:36 | kathryn joined #koha | |
| 19:51 | alexbuckley joined #koha | |
| 19:54 | indradg joined #koha | |
| 19:56 | oleonard | Bye #koha |
| 20:08 | carlsons joined #koha | |
| 20:09 | carlsons | hi all |
| 20:15 | kohaputti joined #koha | |
| 20:17 | csmith joined #koha | |
| 20:18 | Guest1435 | hi, does anyone know how to make a patron give a notice when certain fields are incomplete? |
| 20:18 | caroline1 | Guest1435: like if their address is missing? |
| 20:18 | Guest1435 | yes |
| 20:19 | googling, but seems my search queries aren't catching what i want | |
| 20:19 | caroline1 | There is the "Gone no address" flag that you can put in their account |
| 20:19 | It will prevent from doing circulation actions and put a message in their account | |
| 20:19 | Guest1435 | oh thanks caroline, where would i find that? |
| 20:20 | caroline1 | In the patron account, click on "Edit" |
| 20:20 | Then go down and there is a section called "Patron account flags" | |
| 20:20 | in "Gone no address" click yes and save | |
| 20:20 | Guest1435 | oh okay, thanks. so that has to be done individually for each patron? |
| 20:21 | caroline1 | hmm, I don't know if it's possible to change by batch... |
| 20:21 | let me see | |
| 20:21 | it would be in Tools > Patron batch modification | |
| 20:22 | csmith_ja joined #koha | |
| 20:22 | csmith_ja | sorry about that caroline, my irc client disconnected me |
| 20:22 | caroline1> it would be in Tools > Patron batch modification, last message i got | |
| 20:23 | caroline1 | it's the last I sent :) |
| 20:23 | csmith_ja | so i can set it to notify if address, last name, or whichever "essential" field may be missing |
| 20:23 | so as the person registering users looks up a user, they see that the record is incomplete | |
| 20:23 | caroline1 | Well, actually, there is only one flag, but you can tell your staff that if there is that flag, check all the essential info |
| 20:24 | csmith_ja | oh okay, thanks. hopefully this generation will be willing to accept that lol |
| 20:24 | also, i have a theory of sorts, just wondering if you could confirm it or not for me | |
| 20:25 | caroline1 | Just checked and the batch patron modification doesn't allow to add the gone no address flag... :( |
| 20:25 | If you have access to the database, you can change it directly | |
| 20:25 | csmith_ja | can i create a query to scan for fields and list patron names that have "null" value in them? |
| 20:25 | i dont | |
| 20:26 | but i will see about asking | |
| 20:26 | caroline1 | yes you can |
| 20:26 | in Reports | |
| 20:26 | something like | |
| 20:27 | SELECT cardnumber FROM borrowers WHERE surname IN ("", NULL) OR address IN ("", NULL) | |
| 20:27 | add as many "OR" as you need | |
| 20:28 | csmith_ja | oh thanks, that took the work out for me lol :D |
| 20:28 | caroline1 | :) you're welcome (hopefully it works!) |
| 20:28 | csmith_ja | was about to go through the table relationships to find the trail |
| 20:28 | i going to check it right now and let you know | |
| 20:29 | will test with the two for now | |
| 20:33 | hi caroline, it worked | |
| 20:33 | caroline1 | yay! |
| 20:33 | csmith_ja | will modify it further for more information so its more friendly to people that will be using it XD |
| 20:34 | thanks much | |
| 20:34 | caroline1 | no prob, good luck |
| 20:34 | csmith_ja | <^_^> |
| 20:34 | thanks | |
| 20:38 | cait | caroline1++ |
| 20:43 | csmith_ja joined #koha | |
| 20:48 | alexbuckley | hey ashimema just seen your note, thanks for replying! Yeah I changed the command I used to run the koha-upgrade-schema from nohup to -i and that appears to have fixed some of the issues |
| 20:49 | as nohup was repeating several of the db upgrade steps it was most strange | |
| 20:49 | it also dropped the aqbasket table which definitely shouldn't have been removed | |
| 22:44 | caroline1 | bye all! |
| 22:46 | andreashm joined #koha | |
| 23:11 | philor joined #koha | |
| 23:34 | philor | could someone tell me if this is broken for everyone, or just for me? |
| 23:34 | 18.05.06 (from a demo site), edit a bib with double-quotes in the title like "A" is for alibi, in the basic editor, everything's fine | |
| 23:34 | 18.05.08, edit it, the text input is blank because the quotes aren't escaped, so it's |value="" a="| etc. |
← Previous day | Today | Next day → | Search | Index