| Time |
S |
Nick |
Message |
| 00:01 |
|
|
Francesca joined #koha |
| 00:38 |
|
|
kathryn joined #koha |
| 00:38 |
|
|
kathryn joined #koha |
| 00:52 |
|
|
StomproJ joined #koha |
| 01:04 |
|
|
tcohen joined #koha |
| 01:20 |
|
|
cait joined #koha |
| 01:25 |
|
|
JoshB joined #koha |
| 02:29 |
|
|
JoshB joined #koha |
| 03:34 |
|
|
papa joined #koha |
| 03:51 |
|
|
Francesca joined #koha |
| 04:03 |
|
|
mario joined #koha |
| 04:40 |
|
|
Francesca joined #koha |
| 04:56 |
|
|
mario joined #koha |
| 05:20 |
|
|
Francesca joined #koha |
| 05:26 |
|
|
Francesca joined #koha |
| 05:28 |
|
|
AndrewIsh joined #koha |
| 05:33 |
|
|
Francesca joined #koha |
| 05:38 |
|
|
Francesca joined #koha |
| 06:11 |
|
|
drojf joined #koha |
| 06:11 |
|
drojf |
morning #koha |
| 06:16 |
|
drojf |
nice, 2/3 of the dependency packages in the repository are not needed anymore |
| 06:37 |
|
|
Francesca joined #koha |
| 06:39 |
|
|
Francesca joined #koha |
| 06:43 |
|
|
rocio left #koha |
| 06:48 |
|
* magnuse |
waves |
| 06:56 |
|
|
mario joined #koha |
| 07:06 |
|
|
LibraryClaire joined #koha |
| 07:12 |
|
LibraryClaire |
morning #koha |
| 07:14 |
|
|
laurence joined #koha |
| 07:14 |
|
|
fridolin joined #koha |
| 07:21 |
|
|
cait joined #koha |
| 07:37 |
|
|
alex_a joined #koha |
| 07:39 |
|
alex_a |
bonjour |
| 07:40 |
|
magnuse |
@wunder enbo |
| 07:40 |
|
huginn |
magnuse: The current temperature in Bodo, Norway is 2.0°C (8:20 AM CET on November 23, 2016). Conditions: Light Rain Showers. Humidity: 100%. Dew Point: 2.0°C. Windchill: -2.0°C. Pressure: 29.74 in 1007 hPa (Steady). |
| 07:40 |
|
magnuse |
and that rain has frozen on the ground - very nice |
| 07:40 |
|
* LibraryClaire |
waves |
| 07:41 |
|
LibraryClaire |
@wunder Konstanz |
| 07:41 |
|
huginn |
LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is 8.5°C (8:39 AM CET on November 23, 2016). Conditions: Clear. Humidity: 94%. Dew Point: 8.0°C. Windchill: 8.0°C. Pressure: 30.01 in 1016 hPa (Steady). |
| 07:41 |
|
LibraryClaire |
had a glowing yellow sunrise behind the mountains this morning. very nice. I need a better camera |
| 07:42 |
|
mtj |
hey #koha |
| 07:42 |
|
mtj |
drojf: awesome news re: packages... that sounds like progress hey? :0) |
| 07:47 |
|
|
Francesca joined #koha |
| 07:50 |
|
magnuse |
kia ora mtj |
| 07:50 |
|
|
reiveune joined #koha |
| 07:51 |
|
reiveune |
hello |
| 07:52 |
|
magnuse |
bonjour reiveune |
| 07:52 |
|
reiveune |
salut magnuse |
| 07:53 |
|
mtj |
heia magnuse, reiveune |
| 07:53 |
|
|
sophie_m joined #koha |
| 07:53 |
|
magnuse |
bonjour sophie_m |
| 07:53 |
|
sophie_m |
hello magnuse |
| 07:54 |
|
sophie_m |
hi #koha |
| 07:55 |
|
alex_a |
hello LibraryClaire and magnuse |
| 08:13 |
|
drojf |
mtj: looks like most were needed for debian squeeze, some for wheezy but only 1/3 is still needed for jessie. time for some cleaning |
| 08:13 |
|
drojf |
@wunder sxf |
| 08:13 |
|
huginn |
drojf: The current temperature in Berlin Schoenefeld, Germany is 5.0°C (8:50 AM CET on November 23, 2016). Conditions: Mist. Humidity: 100%. Dew Point: 5.0°C. Pressure: 30.09 in 1019 hPa (Steady). |
| 08:16 |
|
|
sameeenz joined #koha |
| 08:16 |
|
|
AndrewIsh joined #koha |
| 08:19 |
|
|
gaetan_B joined #koha |
| 08:20 |
|
gaetan_B |
hello |
| 08:29 |
|
Joubu |
https://github.com/Koha-Commun[…]notes_16_11_00.md |
| 08:29 |
|
Joubu |
Does someone know where are the release notes? |
| 08:29 |
|
wahanui |
the release notes are in misc/release_notes |
| 08:29 |
|
Joubu |
in a pdf format for instance |
| 08:32 |
|
Joubu |
http://download.koha-community[…]a-16.11.00.tar.gz returns 403 |
| 08:33 |
|
Joubu |
@later tell wizzyrea don't know if you can do someting but http://download.koha-community[…]a-16.11.00.tar.gz returns 403 |
| 08:33 |
|
huginn |
Joubu: The operation succeeded. |
| 08:37 |
|
Joubu |
@later tell khall I guess you are already aware of it but the release notes have not been attached to your email |
| 08:37 |
|
huginn |
Joubu: The operation succeeded. |
| 08:39 |
|
AndrewIsh |
mornin' #koha |
| 08:40 |
|
AndrewIsh |
@wunder machynlleth |
| 08:40 |
|
huginn |
AndrewIsh: The current temperature in Machynlleth, Machynlleth, United Kingdom is 6.2°C (8:39 AM GMT on November 23, 2016). Conditions: . Humidity: 93%. Dew Point: 5.0°C. Windchill: 6.0°C. Pressure: 30.06 in 1017.8 hPa (Rising). |
| 08:40 |
|
AndrewIsh |
is anyone able to point me in the direction of any docs detailing the necessary steps for creating new permissions and binding to them in the templates? |
| 08:41 |
|
AndrewIsh |
we've created a db update script to add the permissions to the permissions table |
| 08:41 |
|
AndrewIsh |
and added appropriate lines to koha-tmpl/intranet-tmpl/prog/en/includes/permissions.inc |
| 08:41 |
|
AndrewIsh |
but beyond that, i'm not sure what else to do |
| 08:42 |
|
Joubu |
add it to installer/data/mysql/userpermissions.sql |
| 08:42 |
|
Joubu |
that's all |
| 08:43 |
|
Joubu |
you may want to this permission to existing users |
| 08:44 |
|
Joubu |
if it's what you want, take a look at db rev 3.23.00.052 |
| 08:45 |
|
Joubu |
then to know if the logged in user has the permission, from the template you can do something like CAN_module_permission |
| 08:45 |
|
AndrewIsh |
Joubu: ah, excellent, i will, thanks :) |
| 08:45 |
|
Joubu |
`git grep CAN_ **/*.tt` for the examples |
| 08:45 |
|
AndrewIsh |
aha, that was going to be my next question |
| 08:45 |
|
Joubu |
(a 'add' was missing in one of my previous sentence) |
| 08:46 |
|
AndrewIsh |
i've been looking at those, there appears to be multiple levels to it, just looking at biblio-view-menu.inc, it has "CAN_user_tools_view_system_logs", there's a permission called "view_system_logs", is the "user_tools" some sort of higher level? |
| 08:48 |
|
Joubu |
AndrewIsh: have a look at the userflags and permissions table |
| 08:49 |
|
Joubu |
there is a "module" which is the userflags.flag column (reports for instance) |
| 08:50 |
|
Joubu |
then a list of permissions for this "module": permissions.code (create_reports, delete_reports for instance) |
| 08:50 |
|
Joubu |
(what you said basically) |
| 08:53 |
|
AndrewIsh |
ahaaaaa, right, that makes sense. so that enables you to distinguish between permissionX on different areas of the application, makes sense |
| 08:53 |
|
AndrewIsh |
cool, i think i understand now, i'll go and give it a try. thanks Joubu :) |
| 08:55 |
|
Joubu |
AndrewIsh: the tricky part is when you want to understand how things are going on behind the first trees you see |
| 08:55 |
|
Joubu |
Have a look at borrowers.flags and C4::Auth::haspermissions, if you want to go deeper |
| 08:56 |
|
Joubu |
but you should not need that for basic/normal permission checks |
| 08:57 |
|
AndrewIsh |
Joubu: indeed. i spent some time yesterday afternoon unpicking it but still couldn't figure out exactly how it worked. thanks for the pointers, i'll have a look at that table and sub, it'll be useful to know what's going on in the background :) |
| 09:11 |
|
|
alex_a joined #koha |
| 09:12 |
|
|
Viktor_ joined #koha |
| 09:14 |
|
magnuse |
bonjour alex_a and Viktor_ |
| 09:15 |
|
Viktor_ |
Bonjour magnuse |
| 09:15 |
|
alex_a |
bonjour again magnuse :D |
| 09:16 |
|
|
Francesca joined #koha |
| 09:31 |
|
|
Francesca joined #koha |
| 09:32 |
|
|
cait joined #koha |
| 09:43 |
|
eythian |
@wunder jordaan, ams |
| 09:43 |
|
huginn |
eythian: The current temperature in Ten Kateplein, Amsterdam, Netherlands is 10.9°C (10:31 AM CET on November 23, 2016). Conditions: Mist. Humidity: 80%. Dew Point: 8.0°C. Pressure: 30.07 in 1018 hPa (Rising). |
| 09:44 |
|
|
laurence joined #koha |
| 10:12 |
|
|
alex_a joined #koha |
| 11:08 |
|
|
Viktor_ joined #koha |
| 11:15 |
|
|
ribasushi joined #koha |
| 11:20 |
|
|
irma joined #koha |
| 11:27 |
|
|
ibeardslee joined #koha |
| 12:07 |
|
Viktor_ |
KohaDevbox - is it the files in the kohaclone dir I’m supposed to edit? I’m trying to learn to use kohadevbox instead of my old dev install. Got a new box up, SSH into it, cd kohaclone, new branch and edited kohaclone/koha-tmpl/opac-tmpl/bootstrap/modules/opac-main.tt. But when I update localhost:8080 I see no change even after clearing caches. What obvious thing am I missing?… |
| 12:09 |
|
Viktor_ |
Any help appreciated - I haven’t got my sea legs with kohadevbox for sure :) |
| 12:11 |
|
|
siriom joined #koha |
| 12:11 |
|
siriom |
morning. |
| 12:11 |
|
wahanui |
Ah, morning. The cat must be wanting breakfast. |
| 12:12 |
|
siriom |
anyone want to give a poor soul a hand with a koha problem ? |
| 12:13 |
|
Viktor_ |
morning siriom |
| 12:13 |
|
siriom |
morning chief. |
| 12:13 |
|
Viktor_ |
What’s your problem? Maybe I know who knows what to do at least :) |
| 12:14 |
|
siriom |
had koha running on suse 12 , upgraded to suse 13 and now searchs return weird diamonds instead of special latin chars |
| 12:14 |
|
siriom |
diamond with a question mark inside instead of say "ç" or "ã" |
| 12:15 |
|
Viktor_ |
Sounds like some character encoding problem that I’m not quilified to answer. I just configure it to UTF-8 wherever there is an option and hope for the best :) |
| 12:15 |
|
siriom |
locale issue ? perl issue ? been banging my head on it and can t find the answer |
| 12:15 |
|
siriom |
utf 8 but where ? everything does seem to be utf8 |
| 12:17 |
|
AndrewIsh |
Hey all. Does anyone know if it's possible to call DBIx::Class::ResultSet methods on Koha::Items objects? As per the code below: |
| 12:17 |
|
pastebot |
"AndrewIsh" at 127.0.0.1 pasted "my $items = Koha::Items->searc" (6 lines) at http://paste.koha-community.org/179 |
| 12:17 |
|
Viktor_ |
siriom Only search? That narrows it a tiny bit at least. If everything is the same otherwise I’d suspect some library that Zebra uses has changed in suse |
| 12:18 |
|
AndrewIsh |
Is there some magical incantation for calling dbic methods on Koha objects? |
| 12:20 |
|
siriom |
great so what do i do to check / fix it ? |
| 12:22 |
|
Viktor_ |
siriom Well I’m not really qualified to answer that I’m afraid :( I guess sending a question to the list might give better results. But be prepared for the answer â€Use Debian like recommended and it’ll workâ€. |
| 12:22 |
|
siriom |
the database is fine , i just checked ... |
| 12:22 |
|
|
rsantellan joined #koha |
| 12:22 |
|
rsantellan |
good morning #koha |
| 12:22 |
|
siriom |
ok , how do i sent it to the list ? im a first time user here chief. |
| 12:22 |
|
siriom |
morning |
| 12:23 |
|
AndrewIsh |
Viktor_: Your devbox problem is interesting. I've been using it for about a month and was immediately able to see changes when editing files in ~/kohaclone. Have you perhaps modified your SYNC_REPO env variable? |
| 12:25 |
|
Viktor_ |
siriom You have the general list and perhaps the devlist accessible from https://koha-community.org/sup[…]ha-mailing-lists/ Just sign up and ask away. Then you’re not as dependent on catching the eye of someone at the right moment. Best of luck |
| 12:25 |
|
AndrewIsh |
Viktor_: https://github.com/digibib/koh[…]content-sync_repo |
| 12:26 |
|
Viktor_ |
AndrewIsh Thanks! Actually I haven’t touched SUNC_REPO. Only configured my name, email and bz login. |
| 12:27 |
|
Viktor_ |
AndrewIsh Then SSH and used pico to edit opac-main.tt (changed the â€Home†bredcrumb on a new branch just to see that it worked). |
| 12:29 |
|
AndrewIsh |
Viktor_: Interesting. I'm not sure then, that's a weird one. Sorry! |
| 12:31 |
|
siriom |
signing up to the mailing list then 1 sec |
| 12:31 |
|
Viktor_ |
Thanks for the help AndrewIsh - Have the feeling it’s something really obvious that will make me embarresed when I figure it out :) |
| 12:32 |
|
* cait |
waves at Viktor_ |
| 12:32 |
|
cait |
nice to see you around :) |
| 12:34 |
|
cait |
Viktor_: are you using plack or memcached? |
| 12:34 |
|
cait |
restating those might make it work |
| 12:34 |
|
cait |
also: are you looking at the english templates? (one of my errors often...) |
| 12:35 |
|
Viktor_ |
Hi cait Nice to see you too! |
| 12:36 |
|
Viktor_ |
Don’t know actually - I’m using what’s default in kohadevbox :) But you are right - it feels like a caching problem (since there is only â€en†installed) |
| 12:36 |
|
cait |
we missed you |
| 12:37 |
|
Viktor_ |
cait It’s nice to be back! But also very nice to see swedish libraries taking charge and establishing a network that’s now very active. |
| 12:37 |
|
magnuse |
ah, looking at the swedish templates was my first guess |
| 12:37 |
|
magnuse |
try "sudo service memcached restart"? |
| 12:38 |
|
magnuse |
are you looking at koha from the right port? |
| 12:38 |
|
magnuse |
the output that you get from "vagrant up" will say how ports are set up |
| 12:39 |
|
magnuse |
often opac on 2200 and intranet on 8081, i think |
| 12:39 |
|
Viktor_ |
magnuse I tried â€sudo service memcached restartâ€. No output and no difference. |
| 12:39 |
|
magnuse |
pr opac on 2201, maybe |
| 12:39 |
|
magnuse |
s/pr/or/ |
| 12:40 |
|
Viktor_ |
Hm. It gives me some Opac on 8080 |
| 12:40 |
|
Viktor_ |
Not sure it’s the right one though :) Will have to look at the output. |
| 12:40 |
|
magnuse |
yeah, scroll back through the output from "vagrant up" |
| 12:41 |
|
Viktor_ |
Saw that kohadevbox got a new version the other day so thought I’d give it a try. Very nice actually. |
| 12:41 |
|
|
irma joined #koha |
| 12:41 |
|
magnuse |
yeah, tcohen and others have really pushed it along |
| 12:43 |
|
druthb |
magnuse! |
| 12:43 |
|
wahanui |
magnuse is afraid that we added another 10000 bugs while he was eating pizza. |
| 12:43 |
|
magnuse |
druthb! |
| 12:43 |
|
wahanui |
hmmm... druthb is an amazing person |
| 12:44 |
|
* druthb |
gives wahanui the evil eye. |
| 12:44 |
|
magnuse |
or, "the nominee", as we like to call her |
| 12:44 |
|
* druthb |
gives magnuse the evil eye, too |
| 12:44 |
|
Viktor_ |
But at least I’m not making any really obvious mistakes then. Ports seems to be correct (8080 opac, 8081 intra) |
| 12:47 |
|
magnuse |
hm, let me check what mine sets up |
| 12:47 |
|
|
meliss joined #koha |
| 12:48 |
|
|
oleonard joined #koha |
| 12:49 |
|
pastebot |
"magnuse" at 127.0.0.1 pasted "vagrant up" (23 lines) at http://paste.koha-community.org/180 |
| 12:50 |
|
magnuse |
Viktor_: the two interesting lines are "80 (guest) => 2201 (host) (adapter 1)" |
| 12:50 |
|
magnuse |
and "8080 (guest) => 8081 (host) (adapter 1)" |
| 12:50 |
|
cait |
hm mine works on 8080 and 8081 |
| 12:51 |
|
Viktor_ |
magnuse Thanks. I do get the opac at 8080 |
| 12:51 |
|
magnuse |
weird, then :-) |
| 12:51 |
|
magnuse |
i do not have an uptodate kohadevbox |
| 12:51 |
|
magnuse |
maybe things were changed |
| 12:51 |
|
Viktor_ |
I’m trying to break the intranet instead and we’ll se if something happens. |
| 12:52 |
|
magnuse |
try "wget localhost" inside the devbox and see if you see the changes there? |
| 12:54 |
|
Viktor_ |
magnuse Smart - and no I didn’t! |
| 12:55 |
|
|
jzairo joined #koha |
| 12:58 |
|
|
NateC joined #koha |
| 13:00 |
|
magnuse |
ah, interesting |
| 13:01 |
|
magnuse |
you're sure you saved your edit? ;-) |
| 13:01 |
|
|
alex_a joined #koha |
| 13:01 |
|
Viktor_ |
It’s there when I open it again, and the files lists as modified by â€git statusâ€. So I hope so :) |
| 13:03 |
|
Viktor_ |
Is there a way to restart plack in kohadevbox (if it’s active). I tried koha restart —plack as the Debian packages suggest but it’s an unknown command. |
| 13:03 |
|
rsantellan |
Viktor_: try with sudo koha-plack |
| 13:04 |
|
magnuse |
sudo koha-plack --restart kohadev |
| 13:04 |
|
|
sophie_m joined #koha |
| 13:05 |
|
|
alex_a joined #koha |
| 13:05 |
|
Viktor_ |
rsantellan magnuse YAY!!!! |
| 13:05 |
|
Viktor_ |
I literally jumped and hit my hand on the roof just now :) |
| 13:06 |
|
magnuse |
lol |
| 13:06 |
|
Viktor_ |
Best day at work for a long time - thanks a lot! |
| 13:07 |
|
rsantellan |
jajaja :) |
| 13:07 |
|
magnuse |
jätteskönt! |
| 13:08 |
|
Viktor_ |
Might go home early now before anything breaks again ;) |
| 13:11 |
|
|
kidclamp joined #koha |
| 13:11 |
|
|
siriom joined #koha |
| 13:24 |
|
|
meliss left #koha |
| 13:24 |
|
|
meliss joined #koha |
| 13:39 |
|
|
Dyrcona joined #koha |
| 13:54 |
|
|
laurence left #koha |
| 13:56 |
|
|
nengard joined #koha |
| 13:56 |
|
|
drojf joined #koha |
| 14:29 |
|
* magnuse |
calls it a day - have fun #koha! |
| 14:29 |
|
magnuse |
oh and bag++ khall++ |
| 14:34 |
|
|
alex_a_ joined #koha |
| 14:34 |
|
pastebot |
"drojf" at 127.0.0.1 pasted "16.11 upgrade mysql error" (7 lines) at http://paste.koha-community.org/181 |
| 14:34 |
|
drojf |
asking again, should i be concerned about this? ^ |
| 14:34 |
|
drojf |
there will be a few thousand people asking about it soon |
| 14:39 |
|
eythian |
error 150 is a very annoying one to diagnose |
| 14:39 |
|
eythian |
I've seen it a bit, with no real understanding of what was happening. |
| 14:39 |
|
eythian |
but, you may well see a fair bit of it. |
| 14:40 |
|
eythian |
I think it often means that making this change would break a foreign constraint, or something like that |
| 14:40 |
|
rsantellan |
it could mean that or that the default values of the field is incorrect |
| 14:41 |
|
rsantellan |
the best thing to do is separate the alter column and the fk creation |
| 14:44 |
|
AndrewIsh |
anyone who's up to speed on Koha::Objects around? i'm trying to call ->get_column() on the return of a Koha::Items->search() call. i'm getting undef returned. looking at the AUTOLOAD sub for Koha/Object.pm, i can see that get_column is one of the whitelisted methods |
| 14:45 |
|
drojf |
i added it to bug 17216. i will not release a package before i get an answer :P |
| 14:45 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=17216 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Add a new table to store authorized value categories |
| 14:48 |
|
|
jbeno joined #koha |
| 14:52 |
|
oleonard |
Hi barton |
| 14:52 |
|
oleonard |
A belated Happy Birthday to you |
| 14:53 |
|
barton |
ah, thanks! |
| 14:55 |
|
Joubu |
AndrewIsh: get_column should be called on a Koha::Object, not a set, right? |
| 14:55 |
|
barton |
https://www.youtube.com/watch?v=GVwTbWmOsfw <= the 'Day after the birthday' song. |
| 14:57 |
|
barton |
which spookily was the first suggestion by youtube when I started looking up Paul Simon. |
| 14:57 |
|
oleonard |
Youtube knows. |
| 14:57 |
|
AndrewIsh |
Joubu: i wanting to call it on the Koha::Objects set, to get all values from a column, as in: my @barcodes = $results->get_column('barcode')->all; |
| 14:58 |
|
barton |
... it's coincidence when it comes on the radio the day after your birthday when you're making a long distance drive for thanksgiving... |
| 14:58 |
|
oleonard |
Where you headed? |
| 14:58 |
|
AndrewIsh |
Joubu: it's not a whitelisted method on Koha::Objects |
| 14:59 |
|
Joubu |
AndrewIsh: yes, so you need to provide tests |
| 14:59 |
|
barton |
oh, that happened to me 20 years ago. I was headed for St. Louis. |
| 14:59 |
|
khall |
drojf: I haven't been able to trigger that error you are getting : \ |
| 15:00 |
|
AndrewIsh |
Joubu: yes, so i gather from @ashimema, i just wanted to check i wasn't missing something ;-) |
| 15:00 |
|
Joubu |
nope, it's the way to go, you are just the first one to need it :) |
| 15:00 |
|
AndrewIsh |
Joubu: huzzah! |
| 15:01 |
|
|
alex_a joined #koha |
| 15:01 |
|
Joubu |
AndrewIsh: it's preferable to whitelist it on a separate bug |
| 15:01 |
|
drojf |
khall: got it on two upgrades from 16.05 :/ |
| 15:01 |
|
AndrewIsh |
Joubu: yep, makes sense |
| 15:03 |
|
khall |
drojf: ack! |
| 15:03 |
|
khall |
Joubu: did you see what drojf posted? I can't get the error to happen : \ |
| 15:03 |
|
Joubu |
drojf: I will be on it soon |
| 15:03 |
|
Joubu |
khall: ^ :) |
| 15:04 |
|
khall |
thanks Joubu! |
| 15:04 |
|
drojf |
thanks Joubu and khall |
| 15:05 |
|
LibraryClaire |
gotta run - literally |
| 15:05 |
|
LibraryClaire |
laters #koha |
| 15:05 |
|
|
LibraryClaire left #koha |
| 15:11 |
|
Joubu |
drojf: how do you get this error? |
| 15:12 |
|
drojf |
Joubu: by upgrading a 16.05 package install to 16.11 |
| 15:12 |
|
Joubu |
So I should get it updating an old DB, right? |
| 15:12 |
|
drojf |
yes |
| 15:12 |
|
Joubu |
let me test |
| 15:12 |
|
drojf |
i have not tried a new install. but i got this on two different systems |
| 15:15 |
|
Joubu |
drojf: ok don't get it, but I know what I think |
| 15:16 |
|
Joubu |
It cannot add the constraint on marc_subfield_structure |
| 15:17 |
|
Joubu |
select count(*) from marc_subfield_structure where authorised_value not in (select distinct(authorised_value) from authorised_value_categories) |
| 15:17 |
|
Joubu |
drojf: ^ |
| 15:19 |
|
Joubu |
13171 UPDATE marc_subfield_structure SET authorised_value = NULL WHERE authorised_value = ';'; |
| 15:19 |
|
Joubu |
this looks definitely wrong |
| 15:19 |
|
Joubu |
='' instead of =';' |
| 15:21 |
|
drojf |
sorry grabbed a coffee |
| 15:21 |
|
Joubu |
f**** nopaste vi mode |
| 15:21 |
|
Joubu |
I guess you have some marc_subfield_structure.authorised_value="" which have not been set to NULL |
| 15:21 |
|
Joubu |
because of the wrong query |
| 15:21 |
|
drojf |
i get 0 for that select query. in case you wanted me to run it |
| 15:22 |
|
Joubu |
and can you retry the whole upgrade after modiying l. 13171 with WHERE authorised_value = ""; # instead of =";" |
| 15:23 |
|
Joubu |
=';'; |
| 15:23 |
|
Joubu |
well, you got it |
| 15:23 |
|
drojf |
ah yes that looks odd |
| 15:29 |
|
Joubu |
drojf, khall: I have attached a followup on 17216, I am 99% sure it comes from this typo, but I'd like to get drojf confirmation because to see it pushed |
| 15:30 |
|
Joubu |
s/because/before |
| 15:31 |
|
|
Dyrcona joined #koha |
| 15:31 |
|
drojf |
Joubu: can't roll back the whole db atm to try, but running it manually makes the update affect 23646 rows instead of 0 |
| 15:31 |
|
drojf |
which i guess is a good thing ;) |
| 15:32 |
|
|
fridolin left #koha |
| 15:32 |
|
|
JoshB joined #koha |
| 15:33 |
|
|
rocio joined #koha |
| 15:35 |
|
Joubu |
drojf: and so you should be able to add the FK |
| 15:38 |
|
khall |
thanks Joubu! |
| 15:38 |
|
|
lisettelatah joined #koha |
| 15:48 |
|
drojf |
Joubu: makes sense. i'll roll a package with it and leave feedback on the bug. thanks! |
| 15:57 |
|
bag |
morning |
| 16:00 |
|
|
mario joined #koha |
| 16:04 |
|
|
alex_a joined #koha |
| 16:25 |
|
|
jbeno1 joined #koha |
| 16:46 |
|
|
LibraryClaire joined #koha |
| 17:12 |
|
reiveune |
bye |
| 17:12 |
|
|
reiveune left #koha |
| 17:43 |
|
|
jc_ joined #koha |
| 17:44 |
|
jc_ |
Hi, my library is using Koha 3.18, and i'm just wondering if newer versions have the tag 264 included yet |
| 17:53 |
|
cait |
jc_: you can catalog using 264 and it will be searchable and show up in the result lst and on the detail pages |
| 17:59 |
|
cait |
kf |
| 17:59 |
|
jc_ |
cait: but it's not in the marc framework? |
| 18:00 |
|
cait |
i am not sure 3.18 can do all that yet |
| 18:00 |
|
cait |
it's old by now |
| 18:00 |
|
cait |
16.11 was released yesterday - 3.20, 2.22, 16.05, 16.11 - 2 years |
| 18:04 |
|
|
NateC joined #koha |
| 18:04 |
|
|
NateC left #koha |
| 18:05 |
|
|
cait left #koha |
| 18:45 |
|
|
rocio1 joined #koha |
| 18:56 |
|
|
jzairo left #koha |
| 18:56 |
|
|
jzairo joined #koha |
| 19:17 |
|
|
z0k_ joined #koha |
| 19:21 |
|
rangi |
morning |
| 19:23 |
|
drojf |
hi rangi |
| 19:26 |
|
oleonard |
Hi rangi |
| 19:38 |
|
LibraryClaire |
hi rangi |
| 20:09 |
|
|
drojf joined #koha |
| 20:10 |
|
|
kathryn joined #koha |
| 20:12 |
|
|
Francesca joined #koha |
| 20:35 |
|
|
cait joined #koha |
| 20:44 |
|
|
Francesca joined #koha |
| 20:47 |
|
wizzyrea |
@later tell joubu I don't routinely manage that but I will have a look. Hopefully someone else has sorted you out by now. |
| 20:47 |
|
huginn |
wizzyrea: The operation succeeded. |
| 20:58 |
|
|
rocio joined #koha |
| 21:05 |
|
|
NateC joined #koha |
| 21:09 |
|
|
mario joined #koha |
| 21:27 |
|
|
JoshB left #koha |
| 21:57 |
|
|
sameeenz joined #koha |
| 22:08 |
|
|
alohalog` joined #koha |
| 22:10 |
|
|
mtj joined #koha |
| 22:15 |
|
|
drojf joined #koha |
| 22:16 |
|
drojf |
evening |
| 22:16 |
|
bag |
afternoon |
| 22:16 |
|
wahanui |
afternoon is good |
| 22:18 |
|
* cait |
waves |
| 22:18 |
|
drojf |
hi bag and cait |
| 22:21 |
|
drojf |
hmpf the nightly build server ran out of disk space. apparently upgrading two pbuilder images to jessie made the difference. lol |
| 22:23 |
|
|
alohalog` joined #koha |
| 22:34 |
|
|
mtj joined #koha |
| 22:42 |
|
wizzyrea |
rangi++ for fixing the 16.11 download links |
| 22:51 |
|
|
Francesca joined #koha |
| 22:56 |
|
|
dcook joined #koha |
| 22:59 |
|
wizzyrea |
@later tell joubu rangi sorted the download links thanks for pointing out that problem |
| 22:59 |
|
huginn |
wizzyrea: The operation succeeded. |
| 23:00 |
|
|
irma joined #koha |
| 23:04 |
|
|
Francesca joined #koha |
| 23:26 |
|
|
papa joined #koha |
| 23:29 |
|
|
papa joined #koha |
| 23:32 |
|
wizzyrea |
this page on the website, I poked it and out came an entire hive of bees. |
| 23:33 |
|
drojf |
wizzyrea: that's how the web works |
| 23:33 |
|
* wizzyrea |
cries |
| 23:34 |
|
dcook |
O_O |
| 23:34 |
|
dcook |
Thanks for your email drojf :) |
| 23:34 |
|
dcook |
Bees are one of the few things that I just... nope |
| 23:34 |
|
dcook |
I can handle snakes more than bees |
| 23:35 |
|
dcook |
Spiders more than bees |
| 23:35 |
|
drojf |
you can have all the spiders |
| 23:35 |
|
drojf |
bees are nice! |
| 23:35 |
|
drojf |
unless you poke and stuff :D |
| 23:35 |
|
dcook |
hehe |
| 23:35 |
|
dcook |
Honey is pretty great |
| 23:36 |
|
dcook |
And bees do sound nice |
| 23:36 |
|
|
papa joined #koha |
| 23:37 |
|
drojf |
i am not sure but i think i am quite happy that spiders don't have a sound |
| 23:37 |
|
cait |
bees are prettier than spiders |
| 23:37 |
|
dcook |
drojf: I was just thinking about that |
| 23:38 |
|
* dcook |
doesn't miss finding spiders in his towels after showers in Vancouver.. |
| 23:38 |
|
dcook |
Or walking into spider webs in the garden at my old place... |
| 23:38 |
|
dcook |
Spider web in the face in Australia is a bit terrifying |
| 23:39 |
|
drojf |
a friend of mine has been to australia and nope |
| 23:39 |
|
drojf |
not going there |
| 23:39 |
|
drojf |
ever |
| 23:39 |
|
drojf |
:D |
| 23:40 |
|
drojf |
"this picture shows 75187 spiders, but they are not that huge and usually stay on their corners" |
| 23:40 |
|
drojf |
*in |
| 23:41 |
|
dcook |
hehe |
| 23:41 |
|
dcook |
It's actually not that bad overall |
| 23:41 |
|
dcook |
I think I've only seen maybe two deadly spiders, and they stayed in their corners indeed |
| 23:41 |
|
dcook |
Neither was in my house either |
| 23:41 |
|
dcook |
I've seen more pretty birds than deadly things : ) |
| 23:41 |
|
dcook |
Of course, I'm a city dweller >_> |
| 23:42 |
|
dcook |
Oh, we also have deadly crocadiles |
| 23:42 |
|
dcook |
http://www.parksaustralia.gov.[…]staying-safe.html |
| 23:42 |
|
dcook |
"Bringing a boat? Saltwater crocodiles can attack people in boats - the smaller the boat the greater the risk. - See more at: http://www.parksaustralia.gov.[…]-safe.html#sthash.yRXrMOSJ.dpuf" |
| 23:43 |
|
drojf |
so you walk around and think "oh look there is that crazy huge spider but i know it is not deadly so i don't care at all"? |
| 23:43 |
|
dcook |
Pretty much |
| 23:43 |
|
dcook |
The bigger the spider, the nicer they probably are |
| 23:43 |
|
dcook |
The little ones are the really awful ones I think |
| 23:43 |
|
drojf |
i live in an area where spiders are just disgusting for being spiders, i don't expect anything to be deadly, but it creeps me out :P |
| 23:43 |
|
dcook |
So if I see a big one, I encourage it to eat all the bugs :3 |
| 23:43 |
|
dcook |
Yeah, that was me in Canada |
| 23:43 |
|
dcook |
I think the only deadly things there are bears, wolves, cougars, and moose |
| 23:44 |
|
dcook |
Not that you usually have to worry about moose |
| 23:44 |
|
dcook |
Well deer can be deadly too... people think they're so cute |
| 23:44 |
|
dcook |
But a big buck could destroy a human |
| 23:44 |
|
dcook |
Actually, I think even the deadly Australian spiders haven't killed anyone in decades |
| 23:44 |
|
dcook |
Although a little girl was killed by a snake a few months ago I think :( |
| 23:45 |
|
drojf |
i blame spiders |
| 23:45 |
|
dcook |
February |
| 23:45 |
|
dcook |
"The Eastern brown snake is responsible for around 60% of deaths caused by snakebite in Australia." O_O |
| 23:45 |
|
dcook |
But really it's not that bad. When I moved here, I figured most people don't die from spiders and snakes, so I'll probably be fine |
| 23:45 |
|
dcook |
Oh, we also have sharks.. |
| 23:46 |
|
dcook |
Sharks, snakes, spiders |
| 23:46 |
|
drojf |
not sure if i want to know the numbers of *weirdanimal*-bites in general |
| 23:46 |
|
dcook |
hehe |
| 23:46 |
|
dcook |
Probably not |
| 23:46 |
|
dcook |
In Canada, I used to think that we pretended that it wasn't insanely cold outside |
| 23:46 |
|
dcook |
In Australia, I think we pretend that it's not insanely dangerous in some areas |
| 23:46 |
|
drojf |
cold > spiders |
| 23:47 |
|
* dcook |
thumbs up |
| 23:47 |
|
drojf |
in fact, cold kills spiders |
| 23:47 |
|
dcook |
I do miss how there were no bugs in the cold |
| 23:47 |
|
drojf |
unless, very furry spiders |
| 23:47 |
|
dcook |
hehe |
| 23:47 |
|
dcook |
Spiders in parkas.. |
| 23:47 |
|
drojf |
lol |
| 23:47 |
|
jcamins |
drojf: mutant ice spiders are more dangerous than other spiders. |
| 23:48 |
|
jcamins |
They're found only in Canada. |
| 23:48 |
|
jcamins |
Ask anyone. |
| 23:48 |
|
drojf |
thanks jcamins very helpful reminder. i think i might just stay up for a little longer to forget about that picture before i start dreaming |
| 23:48 |
|
jcamins |
You're welcome! |
| 23:48 |
|
jcamins |
:D |
| 23:48 |
|
jcamins |
Now, here's a question: where are my cocoa nibs? |
| 23:49 |
|
drojf |
you know that there is no possible answer that does not involve the belly of a spider at this point |
| 23:50 |
|
cait |
ew |
| 23:50 |
|
cait |
where did the bees go? |
| 23:51 |
|
dcook |
sorry :p |
| 23:54 |
|
dcook |
For all Google's money and power, they sure make it hard to give useful feedback for bugs.. |
| 23:55 |
|
jcamins |
Here's the problem: I'm not sure I have any cacao nibs. |
| 23:55 |
|
dcook |
jcamins: That's probably where they are then |
| 23:58 |
|
jcamins |
dcook: no, I'm not saying "I don't think I have any cacao nibs," I'm saying "I have absolutely no idea whether I have cacao nibs." |
| 23:58 |
|
jcamins |
I found charoli. |
| 23:58 |
|
|
Francesca joined #koha |
| 23:59 |
|
jcamins |
Ha! I did have! |
| 23:59 |
|
jcamins |
And I found them. |
