← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
00:41 | inlibro joined #koha | |
00:42 | dcook_ joined #koha | |
01:41 | inlibro joined #koha | |
02:41 | inlibro joined #koha | |
03:41 | inlibro joined #koha | |
04:33 | lukeG1 joined #koha | |
04:42 | inlibro joined #koha | |
04:42 | kathryn joined #koha | |
05:05 | chriss joined #koha | |
05:41 | alexbuckley joined #koha | |
05:42 | inlibro joined #koha | |
05:55 | cait joined #koha | |
06:09 | kathryn joined #koha | |
06:23 | lmstrand joined #koha | |
06:36 | did joined #koha | |
06:39 | lds joined #koha | |
06:42 | inlibro joined #koha | |
06:43 | TimothyAlexis joined #koha | |
06:43 | TimothyAlexis | I ran upgradedatabase.pl and need to downgrade... |
06:43 | Can I do this? | |
06:46 | cait | there i sno way to downgrade |
06:46 | is this for development ? | |
06:48 | hm i have to run, bbl | |
06:51 | cait joined #koha | |
06:53 | cait joined #koha | |
06:53 | alex_a joined #koha | |
06:54 | alex_a | Bonjour |
06:55 | fridolin joined #koha | |
06:56 | cait joined #koha | |
06:57 | cait1 joined #koha | |
06:58 | fridolin | hi |
07:06 | sophie_m joined #koha | |
07:06 | TimothyAlexis | We are running 20.05.03 and I ran upgradedatabase.pl when on master, it upgraded the database to 20.06.00.015 before I cancelled the upgrade. |
07:09 | kohaputti joined #koha | |
07:09 | lds joined #koha | |
07:28 | TimothyAlexis | We'll restore it from backup, it was only a test server so it's fine. |
07:33 | cait1 | backup would be safest then |
07:33 | ah... too late | |
07:37 | ashimema[m] | mornin' |
07:37 | cait1 | guten morgen :) |
07:42 | inlibro joined #koha | |
07:59 | TimothyAlexis joined #koha | |
07:59 | magnuse | \o/ |
08:00 | ashimema[m] | /0\ |
08:02 | TimothyAlexis | Is this wrong? |
08:02 | https://wiki.koha-community.or[…]/Database_updates | |
08:03 | Says: INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) | |
08:03 | Example from an entry already in sysprefs.sql: | |
08:03 | ('OpacMaintenance','0','','If ON, enables maintenance warning in OPAC','YesNo'), | |
08:04 | magnuse | no, they are different |
08:04 | TimothyAlexis | Looks like it's (variable, value, options, explanation, type) |
08:04 | magnuse | look at updatedatabase.pl if you want examples |
08:04 | ah, i thought you meant the INSERT IGNORE bit, sorry | |
08:05 | but yeah, the order there might be different for historical reasons or something :-) | |
08:05 | TimothyAlexis | So the order should be changed in the wiki? |
08:06 | magnuse | but using the order from sysprefs.sql in updatedatabase.pl should not be a problem |
08:06 | i don't think changing it in the wiki would hurt | |
08:11 | TimothyAlexis | Great |
08:11 | ashimema[m] | the order doesn't really matter so long as the variables and values line up in the example ;) |
08:12 | so yeah.. if they don't line up on the wiki.. that should certainly be fixed | |
08:12 | if you get it wrong in a patch I'm pretty sure that would be caught during SO/QA/RM checks though | |
08:13 | TimothyAlexis | OK, so I have an .sql file in the atomicupdate folder and I ran updatedatabase.pl |
08:13 | Was it supposed to be implemented? | |
08:20 | ashimema[m] | hmm |
08:20 | I think .sql should still work.. but .perl is recommended these days | |
08:21 | did you add any output into your .sql... | |
08:22 | I always literally copy this https://git-test.koha-communit[…]ate/skeleton.perl | |
08:22 | and then replace with the sql I need as neccessary | |
08:22 | P.S. That's a preview of the new git servers we're working on | |
08:23 | TimothyAlexis | Ok, I changed it to a .perl file, is this correcT then? |
08:23 | $dbh->do( "ALTER TABLE systempreferences ADD COLUMN OpacMetaDescription varchar(160)" ); | |
08:23 | NewVersion( $DBversion, XXXXX, "Add system preference to set meta description for the OPAC"); | |
08:24 | cait1 | TimothyAlexis: i usually copy the skeleton.perl one - but it looks about right, i think you are missing the version chck if |
08:25 | TimothyAlexis | the rest is like the skeleton :) |
08:25 | ashimema[m] | er.. |
08:25 | TimothyAlexis | DBversion = 'XXX'; # will be replaced by the RM |
08:25 | etc | |
08:25 | ashimema[m] | what are you trying to achieve TimothyAlexis.. that looks like you're adding a column to the table.. which I'd be really surprised by? |
08:26 | TimothyAlexis | indeed |
08:26 | cait1 | oh righti missed that |
08:26 | TimothyAlexis | That was incorrect |
08:27 | * ashimema[m] | sent a long message: < https://matrix.org/_matrix/med[…]TVNEK/message.txt > |
08:27 | ashimema[m] | I'd expect something along those lines |
08:27 | https://git-test.koha-communit[…].pl#L22752-L22760 | |
08:27 | example from updatedatabase | |
08:28 | but of course.. in the atmomicupdate version you leave the XXX as is in the version | |
08:28 | hope that makes sense | |
08:28 | TimothyAlexis | $dbh->do( "INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES ('OpacMetaDescription','','','This description will show in search engine results (160 characters).','Textarea');" ); |
08:29 | ashimema[m] | so.. start with the skeliton.. then if you need a bit of help on how to achieve something perhaps take a look through updatedatabase for a simlar pattern to copy.. |
08:29 | that's a good general approach to start with. | |
08:29 | looks perfect now to me :) | |
08:29 | ooh.. I have a morning call to go to | |
08:29 | bbiab | |
08:30 | lds joined #koha | |
08:36 | TimothyAlexis | So, I have that .perl file in the atomicupdate folder, but when I'm running updatedatabase.pl it only made the updates that were already in master |
08:37 | ashimema[m] | odd |
08:38 | TimothyAlexis | Is something supposed to add it to updatedatabase.pl ? :/ |
08:39 | ashimema[m] | nope |
08:39 | it should be found and run | |
08:39 | is the file executable? | |
08:40 | TimothyAlexis | Thank you |
08:41 | * ashimema[m] | isn't actually sure the file needs to be executable.. I'm sure it's just read then executed inside updatedatabase rather than executed as it's own unit |
08:42 | inlibro joined #koha | |
08:45 | TimothyAlexis | ^_^; |
08:45 | I got this: Cannot open /etc/koha/log4perl.conf (No such file or directory) at /usr/local/share/perl/5.28.1/Log/Log4perl/Config/BaseConfigurator.pm line 51. | |
08:47 | cait1 | check your system information tab |
08:47 | i think you might have not set up lockdir | |
08:59 | TimothyAlexis | Hmm |
09:01 | nlegrand | ohayou |
09:02 | ashimema[m] | nlegrand |
09:02 | wahanui | nlegrand are you following the trello board? |
09:02 | ashimema[m] | nice to see oyu :) |
09:02 | you're next desks patches are in my queue.. but it's a long queue I'm afraid | |
09:03 | wouldn't mind someone testing the cash registers at login level bug I have based atop your desks work though ;) | |
09:05 | dj joined #koha | |
09:07 | BobB joined #koha | |
09:25 | reiveune joined #koha | |
09:31 | reiveune left #koha | |
09:42 | inlibro joined #koha | |
10:10 | TimothyAlexis | I have lockdir set up but am still getting the same error when running updatedatabase.pl |
10:13 | cait joined #koha | |
10:20 | cait joined #koha | |
10:25 | kohaputti | TimothyAlexis, how have you set log4perl_conf setting in koha-conf.xml? |
10:25 | maybe it is pointing to that non-existent file | |
10:38 | khall joined #koha | |
10:38 | TimothyAlexis | kohaputti: thank you |
10:38 | kohaputti++ | |
10:43 | inlibro joined #koha | |
10:44 | TimothyAlexis | It's surprising that this happens all of a sudden. |
10:44 | I corrected the location in koha-conf | |
10:44 | Now the error is: Can't open __LOG_DIR__/z3950-error.log (No such file or directory) at /usr/local/share/perl/5.28.1/Log/Log4perl/Appender/File.pm line 151. | |
10:49 | ashimema[m] | permissions on that directory |
10:49 | hang on LOG_DIR.. did you actually replace that placeholder with a real location? | |
10:55 | khall_ joined #koha | |
10:56 | TimothyAlexis | I don't understand why I have to do this all of a sudden? :\ |
10:57 | ashimema[m] | Did anything change?.. it's a systemd thing that made this an issue in the first place |
10:58 | TimothyAlexis | I assumed __LOG_DIR__ is a global special constant like __FILE__ |
10:58 | ashimema[m] | what kind of install is this on and how are you running updatedatabase? |
10:58 | TimothyAlexis | I did perl updatedatabase.pl |
10:59 | ashimema[m] | any THING type strings in koha-conf.xml are placeholders which should be replaced during make install/make upgrade or the install process of a package etc |
10:59 | what install type are you using? | |
11:00 | so this could likely be that your running the update as an unauthorized user.. for example.. | |
11:00 | koha-shell will get your the right environment if it's a pacakge install for example | |
11:01 | TimothyAlexis | We have a couple of options here... |
11:01 | Because we are working with different versions. | |
11:02 | What is install type? | |
11:02 | ashimema[m] | as in... how was Koha installed |
11:02 | you can use the debian packages | |
11:02 | you can use the source and build it.. | |
11:03 | TimothyAlexis | I have a machine running debian 10 which I connect to. |
11:03 | Then a colleague has created some deployment script to do some stuff. | |
11:04 | ashimema[m] | if you build it you can use the 'standard' or 'development' options to have it install differently |
11:04 | ah.. | |
11:04 | ok.. is this InLibro.. I can't remember where you're from Timothy | |
11:04 | You may be best asking that colleague how the deployment works | |
11:04 | TimothyAlexis | I work at Lund University |
11:04 | ashimema[m] | with the various options, various different sets of environmental features are required to be set for everything to play nicely. |
11:05 | as devs here.. we're suggesting koha-testing-docker as the easiest way to get setup for testing and development and then the debian packages as the best way to do production deployments | |
11:05 | Cool.. Lund.. I'm sure I've worked with Lund before :) | |
11:06 | TimothyAlexis | I was running koha-testing-docker for a while |
11:07 | But it stopped working so I stopped using it :) | |
11:07 | ashimema[m] | :(.. that's a shame |
11:09 | TimothyAlexis | Well, I think I should fix it and use that specifically for developing on master |
11:10 | kohaputti | kohadevbox might be worth looking into also, it is not that hard to setup either, although it is probably 6 months now already when i used it the last time. The nice thing with kohadevbox was that I could use the ansible playbooks on any host I wanted, not just the vagrant vm that is the default suggestion |
11:11 | ..but koha-testing-docker is probably the more widely used(?) so maybe better go with that | |
11:12 | you can also use the different database software with that | |
11:13 | in case you want to fix some bug that is only in MySQL and not in mariadb, etc. | |
11:14 | TimothyAlexis | Thank you for the input kohaputti |
11:15 | * ashimema[m] | is really old fashioned and still has an old fashioned 'dev' type install he uses primarily for development.. but that's not the best idea.. I also use koha-testing-docker side by side with it and should really migrate my whole workflow in that direction |
11:17 | jzairo joined #koha | |
11:20 | TimothyAlexis | I think it makes sense. |
11:28 | lds joined #koha | |
11:29 | oleonard | Hi all |
11:29 | magnuse | kia ora oleonard |
11:42 | TimothyAlexis | Ok, so I've set up koha-testing-docker again |
11:43 | When I do ku I get this | |
11:43 | WARNING: The COVERAGE variable is not set. Defaulting to a blank string. | |
11:43 | inlibro joined #koha | |
11:43 | TimothyAlexis | WARNING: The CPAN variable is not set. Defaulting to a blank string. |
11:43 | fridolin joined #koha | |
11:44 | TimothyAlexis | and also this: |
11:44 | koha_1 | Cannnot open file No such file or directory at /kohadevbox/misc4dev/cp_debian_files.pl line 35. | |
11:44 | koha_koha_1 exited with code 2 | |
11:45 | oleonard | TimothyAlexis the WARNINGs are safe to ignore I think... I'm pretty sure I see that too |
11:45 | TimothyAlexis | OK |
11:45 | oleonard | I'm not sure about the other thing. What platform are you installing on? |
11:48 | TimothyAlexis | I think this is Ubuntu 18 |
11:48 | Yeah Ubuntu 18.04.5 LTS | |
11:49 | I just cloned koha-testing-docker and koha-community, I already had the settings in .bashrc from before | |
11:51 | oleonard | Do you have a misc4dev directory? |
11:51 | TimothyAlexis | Is the /kohadevbox something which happens inside the docker? |
11:51 | oleonard | Yes |
11:52 | I guess I don't know whether that error means you can or can't use "kshell" to get into the instance | |
11:54 | TimothyAlexis | Well, I had to start it to run kshell |
11:54 | and this time it did work :/ | |
11:57 | Well that's good :D | |
11:57 | haha | |
12:01 | OK one step closer | |
12:01 | DEV atomic update: bug_26454-add_OpacMetaDescription_syspref.perl | |
12:01 | Atomic update generated errors: Bareword "XXXXX" not allowed while "strict subs" in use at (eval 1442) line 6. | |
12:02 | Is XXXXX supposed to be the bug number? | |
12:06 | dcook_ joined #koha | |
12:07 | magnuse | Sounds like XXXXX is not properly quoted? |
12:10 | TimothyAlexis: if you have NewVersion( $DBversion, XXXXX, "Add system preference to set meta description for the OPAC"); you need to quote the literal XXXXX. | |
12:10 | TimothyAlexis | I'm thinking XXXXX needs to be replaced with the bug number. |
12:11 | I did it and it worked. :D | |
12:12 | Aaah and I got a working koha-testing-docker in the process, that's great. | |
12:43 | inlibro joined #koha | |
12:45 | ashimema[m] | TimothyAlexis++ |
12:45 | Well done :) | |
12:46 | fridolin1 joined #koha | |
12:49 | marie-luce joined #koha | |
13:08 | jajm joined #koha | |
13:10 | ashimema[m] | nlegrand still around? |
13:16 | Dyrcona joined #koha | |
13:28 | khall joined #koha | |
13:43 | inlibro joined #koha | |
13:48 | did joined #koha | |
13:54 | marcelr joined #koha | |
13:54 | marcelr | hi #koha |
13:55 | henryb joined #koha | |
13:55 | marcelr | anyone able to reproduce the js error from bug 26471 on catalogue/detail in master ? sourcemap pdfmake etc |
13:55 | huginn | Bug http://bugs.koha-community.org[…]_bug.cgi?id=26471 normal, P5 - low, ---, oleonard, NEW , Datatables js error on missing pdfmake.min.js.map |
14:35 | ashimema[m] | @later tell cait I re-based bug 24381 for you |
14:35 | huginn | ashimema[m]: The operation succeeded. |
14:37 | lukeG joined #koha | |
14:37 | fridolin joined #koha | |
14:42 | oleonard | marcelr I'm not seeing that |
14:43 | inlibro joined #koha | |
14:44 | marcelr | oleonard: ok |
14:47 | not sure what is going on there; datatables is a disaster | |
14:47 | oleonard | What do you mean? |
14:47 | marcelr | always trouble using it with all its parameters etc |
14:48 | i saw aleisha mentioning this error earlier on another report btw | |
14:49 | oleonard joined #koha | |
14:49 | marcelr | maybe it is triggered by some misconfiguration, but does not explain error on catalogue/detail |
14:50 | oleonard | marcelr: DataTables isn't installed with PDF functionality so I don't know why you'd be getting an error unless you have an updated/different version |
14:51 | marcelr | git grep on pdfmake |
14:52 | oleonard | Oh I see the error is only in Chrome not Firefox |
14:52 | marcelr | no i see it in firefox |
14:53 | oleonard | Oh I see the error only in Chrome not Firefox |
14:53 | https://datatables.net/forums/[…]to-load-sourcemap | |
14:54 | marcelr | what is your FF version ? |
14:54 | oleonard | 80.0.1 on macOS |
14:54 | marcelr | i have 80.0.1 on win |
14:55 | cait joined #koha | |
14:56 | cait | ashimema++ :) thank you |
14:57 | oleonard | I was wrong, DataTables in the staff client is compiled with pdfmake. Yet we don't use it. |
14:58 | marcelr | oleonard: Seeing the error in Chrome too |
14:58 | didnt see the warn on older Koha version | |
14:58 | oleonard | To be fair it is only a warning and doesn't affect functionality as far as I can tell |
14:59 | marcelr | yeah probably |
14:59 | ok thx | |
14:59 | have to go | |
15:00 | bye #koha | |
15:00 | fridolin1 joined #koha | |
15:02 | fridolin1 left #koha | |
15:13 | kohaputti joined #koha | |
15:17 | * ashimema[m] | is filling the qa queue today |
15:29 | ashimema[m] | @marcelr I added a few xslt enhancement bugs to the qa queue.. should be fairly easy ones to work through qa if/when you have a moment.. and it would keep cait happy as they're hers ;) |
15:29 | huginn | ashimema[m]: I'll give you the answer just as soon as RDA is ready |
15:29 | wahanui | i already had it that way, huginn. |
15:44 | inlibro joined #koha | |
16:00 | edveal joined #koha | |
16:30 | lukeG | hi |
16:30 | cait | lukeG: now i feel a little guilty? |
16:31 | lukeG | cait: i would say you are 100% correct, I forgot about the IP part |
16:31 | cait | ok - we have some libraries use that featuere |
16:44 | inlibro joined #koha | |
17:44 | inlibro joined #koha | |
18:44 | inlibro joined #koha | |
19:39 | kathryn joined #koha | |
19:44 | inlibro joined #koha | |
20:08 | jzairo joined #koha | |
20:42 | jzairo joined #koha | |
20:43 | cait | @seen dnind |
20:43 | huginn | cait: I have not seen dnind. |
20:43 | cait | @seen davidn |
20:43 | huginn | cait: I have not seen davidn. |
20:44 | inlibro joined #koha | |
20:48 | kidclamp joined #koha | |
21:00 | alexbuckley joined #koha | |
21:09 | mtj | @seen davidnind |
21:09 | huginn | mtj: davidnind was last seen in #koha 6 days, 23 hours, 56 minutes, and 34 seconds ago: <davidnind> I will leave you to it, off to my day job... |
21:09 | mtj | hi cait :0) |
21:09 | cait | ah thx mtj :) |
21:09 | and hi! | |
21:09 | davidnind++ | |
21:20 | mtj | hi hi! |
21:20 | @later tell joubu: i added a patch for bug 22417 | |
21:20 | huginn | mtj: The operation succeeded. |
21:30 | irma joined #koha | |
21:31 | dj joined #koha | |
21:32 | BobB joined #koha | |
21:45 | inlibro joined #koha | |
22:09 | kathryn_ joined #koha | |
22:13 | kathryn__ joined #koha | |
22:27 | edveal joined #koha | |
22:45 | inlibro joined #koha | |
22:48 | lukeG1 joined #koha | |
22:58 | edveal left #koha | |
22:58 | lukeG joined #koha | |
23:06 | dcook_ | @later tell cait no worries that's great! |
23:06 | huginn | dcook_: The operation succeeded. |
23:06 | dcook_ | oops.. |
23:06 | dcook | :D |
23:18 | kathryn__ joined #koha | |
23:44 | ashimema[m] | Bug 22417 |
23:44 | huginn | Bug http://bugs.koha-community.org[…]_bug.cgi?id=22417 new feature, P5 - low, ---, jonathan.druart, In Discussion , Add a task queue |
23:45 | inlibro joined #koha | |
23:55 | koha-jenkins | Project Koha_Master_U2010 build #1: SUCCESS in 44 min: https://jenkins.koha-community[…]a_Master_U2010/1/ |
← Previous day | Today | Next day → | Search | Index