← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:10 | inlibro joined #koha | |
| 00:11 | Margaret_ joined #koha | |
| 00:14 | koha-jenkins | Project Koha_19.11_D9 build #56: SUCCESS in 33 min: https://jenkins.koha-community[…]Koha_19.11_D9/56/ |
| 00:21 | Project Koha_19.11_D8 build #59: SUCCESS in 36 min: https://jenkins.koha-community[…]Koha_19.11_D8/59/ | |
| 00:21 | ere_away joined #koha | |
| 00:25 | morrism joined #koha | |
| 00:29 | alexbuckley joined #koha | |
| 00:59 | koha-jenkins | Project Koha_19.11_U18 build #53: ABORTED in 7 hr 52 min: https://jenkins.koha-community[…]oha_19.11_U18/53/ |
| 01:01 | morrism joined #koha | |
| 01:10 | inlibro joined #koha | |
| 01:13 | mtj | hi hayley, i added an 5min timeout to that jenkins job, hopefully it will fix this type of random problem |
| 01:13 | hayley | thanks mtj! :) |
| 01:13 | mtj | ..it seems to get stuck pulling a docker image :/ |
| 01:13 | hayley | yeah not ideal! |
| 01:14 | alexbuckley joined #koha | |
| 01:16 | mtj | if it works well, we should really add a timeout abort to all jenkins jobs |
| 01:16 | AnnaBoten joined #koha | |
| 01:18 | mtj | hmm, the hung job seemed to hold up the entire job queue.. i cant explain that |
| 01:22 | koha-jenkins | Project Koha_18.11_D8 build #260: SUCCESS in 22 min: https://jenkins.koha-community[…]oha_18.11_D8/260/ |
| 01:25 | morrism joined #koha | |
| 01:49 | tosca joined #koha | |
| 01:50 | koha-jenkins | Project Koha_18.11_D9 build #261: SUCCESS in 27 min: https://jenkins.koha-community[…]oha_18.11_D9/261/ |
| 01:51 | Project Koha_19.11_U18 build #54: STILL UNSTABLE in 52 min: https://jenkins.koha-community[…]oha_19.11_U18/54/ | |
| 02:06 | mtj | ah, i think i was wrong about the hung queue.. thats good :) |
| 02:10 | inlibro joined #koha | |
| 02:12 | koha-jenkins | Project Koha_18.11_D8 build #261: SUCCESS in 22 min: https://jenkins.koha-community[…]oha_18.11_D8/261/ |
| 02:28 | alexbuckley joined #koha | |
| 02:31 | koha-jenkins | Project Koha_18.11_D9 build #262: SUCCESS in 39 min: https://jenkins.koha-community[…]oha_18.11_D9/262/ |
| 02:40 | lukeG joined #koha | |
| 02:45 | wizzyrea joined #koha | |
| 03:11 | inlibro joined #koha | |
| 03:25 | morrism joined #koha | |
| 03:43 | morrism joined #koha | |
| 03:56 | hayley | hello, is anyone around who can reset my password on koha-community wordpress? |
| 04:11 | inlibro joined #koha | |
| 04:25 | morrism joined #koha | |
| 05:04 | morrism joined #koha | |
| 05:11 | inlibro joined #koha | |
| 05:26 | morrism joined #koha | |
| 05:43 | StomproJ joined #koha | |
| 06:00 | chriss joined #koha | |
| 06:11 | inlibro joined #koha | |
| 06:25 | morrism joined #koha | |
| 07:07 | ere_away joined #koha | |
| 07:08 | * magnuse | waves |
| 07:11 | inlibro joined #koha | |
| 07:13 | did joined #koha | |
| 07:19 | marcelr joined #koha | |
| 07:19 | marcelr | hi #koha |
| 07:26 | morrism joined #koha | |
| 07:35 | reiveune joined #koha | |
| 07:35 | reiveune | hello |
| 08:01 | alex_a joined #koha | |
| 08:01 | alex_a | Bonjour |
| 08:03 | magnuse joined #koha | |
| 08:03 | cait joined #koha | |
| 08:04 | paul_p joined #koha | |
| 08:06 | andreashm joined #koha | |
| 08:09 | davidnind joined #koha | |
| 08:11 | inlibro joined #koha | |
| 08:14 | sophie_m joined #koha | |
| 08:25 | morrism joined #koha | |
| 08:35 | did1 joined #koha | |
| 08:40 | ashimema[m] | I'm out for the morning today.. setting #koha the challenge of getting my queue back up to 15 or more by this afternoon ;) |
| 08:40 | sure there's 5 low hanging fruit bugs in that QA queue :) | |
| 08:40 | and... | |
| 08:40 | good morning #koha | |
| 08:51 | mtj | hi ashimema[m]: i did manage to get jessie passing - with a backported libcpan-meta-perl |
| 08:51 | ashimema[m] | 😀 |
| 08:52 | That's great.. Jenkins is already happy as I added the drops to the Dockerfile. But it's great to know that packed people will be catered for a little longer | |
| 09:12 | inlibro joined #koha | |
| 09:25 | ere_away joined #koha | |
| 09:25 | morrism joined #koha | |
| 09:31 | enkidu joined #koha | |
| 09:32 | sophie_m1 joined #koha | |
| 09:32 | enkidu | Hi all |
| 09:33 | does anybody use LDAP and SIP2 for selfcheck machines? | |
| 09:40 | marcelr joined #koha | |
| 09:40 | marcelr | Argument "" isn't numeric in numeric gt (>) at /usr/share/koha/koha-tmpl/opac-tmpl/bootstrap/en/includes/masthead.inc line 52. File not found : /js/locale_data.js at /usr/share/koha/Koha/Template/Plugin/Asset.pm line 84. |
| 09:40 | anyone else seeing that in qa tools ^^ | |
| 09:44 | Joubu | I saw a lot in the output of jenkins |
| 09:44 | andreashm joined #koha | |
| 09:44 | Joubu | there is a fix I think |
| 09:45 | bug 24661, but you are on that one I guess | |
| 09:45 | huginn | Bug http://bugs.koha-community.org[…]_bug.cgi?id=24661 normal, P5 - low, ---, julian.maurice, Pushed to master , Inclusion of locale-related javascript files is broken |
| 09:51 | jajm | marcelr, Joubu, for the "file not found" warning, i think you can just add 'lang' => 'en' to https://gitlab.com/koha-commun[…]e/Template.pm#L90 |
| 09:51 | (not tested) | |
| 09:51 | cait | enkidu: i think we use them without pin in those cases |
| 09:52 | no pin = no auth, just the cardnumber/login | |
| 09:52 | marcelr | Joubu jajm: can have a look later |
| 09:52 | thx | |
| 09:53 | jajm | but isn't it dangerous to process templates in qa tool ? it's easy to make qa tool to execute arbitrary perl code |
| 09:55 | Joubu | how dangerous? more than doing it in the tests? |
| 09:57 | jajm | not more... but when i was doing qa, the first thing i was always doing is run the qa tool, even before looking at the patch, but i looked at the test file before executing them |
| 09:59 | it's easy to forget that qa tool can execute code from the patch, while when you run tests you are aware of that | |
| 10:00 | enkidu | cait, there is a bug about it https://bugs.koha-community.or[…]w_bug.cgi?id=9936 |
| 10:00 | huginn | Bug 9936: normal, P5 - low, ---, koha-bugs, NEW , SIP2 should work with LDAP and CAS |
| 10:00 | cait | enkidu: yes, i know :) |
| 10:00 | filed it | |
| 10:00 | bbl | |
| 10:01 | vfernandes joined #koha | |
| 10:01 | enkidu | sip2 checks databases instead of ldap, |
| 10:02 | this is the problem but we werenot able to find a workaround about this | |
| 10:02 | customer want auth. | |
| 10:02 | andreashm joined #koha | |
| 10:12 | inlibro joined #koha | |
| 10:34 | tallerjoy joined #koha | |
| 10:40 | marcelr | ashimema[m], Joubu: can you install Koha in current master; i have an internal server error on the language step |
| 10:41 | DBD::mysql::st execute failed: Table 'koha_master.language_descriptions' doesn't exist [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/C4/Languages.pm line 389. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValu | |
| 10:41 | DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT description FROM language_descriptions WHERE subtag=? AND lang=? AND type=?" with ParamValues: 0='en', 1='en', 2='language'] at /usr/share/koha/C4/Languages.pm line 390. | |
| 10:44 | Joubu | marcelr: which step? |
| 10:44 | marcelr | choose language |
| 10:44 | Joubu | I am at "Select your MARC flavor" |
| 10:44 | without problem | |
| 10:45 | marcelr | hmm |
| 10:45 | too bad; i will have to blame myself :) | |
| 10:45 | Joubu | sorry :) |
| 10:45 | "Congratulations, installation complete" | |
| 10:45 | marcelr | ;) |
| 10:45 | i have a new database with zero tables for now | |
| 10:46 | no data errors at all | |
| 10:58 | davidnind left #koha | |
| 10:59 | Joubu | @later tell marcelr Can you QA 24545 please? I really would like to not spend months on that one... |
| 10:59 | huginn | Joubu: The operation succeeded. |
| 11:04 | andreashm joined #koha | |
| 11:12 | inlibro joined #koha | |
| 11:14 | andreashm joined #koha | |
| 11:30 | khall joined #koha | |
| 11:31 | khall joined #koha | |
| 11:59 | andreashm joined #koha | |
| 12:12 | inlibro joined #koha | |
| 12:22 | khall joined #koha | |
| 12:24 | magnuse_ joined #koha | |
| 12:25 | morrism joined #koha | |
| 12:26 | kohaputti | hmm, is it possible to run the koha installer with plack? |
| 12:26 | or only CGI? | |
| 12:27 | with plack I get: | |
| 12:27 | DBD::mysql::db do failed: Table 'example_koha.systempreferences' doesn't exist [for Statement " | |
| 12:27 | SELECT * FROM systempreferences WHERE 1 = 0 "] at /usr/share/koha/lib/Koha/Database.pm line 114. | |
| 12:31 | enkidu joined #koha | |
| 12:31 | did joined #koha | |
| 12:33 | kohaputti | my best guess is that it is not possible so I guess I will make an exception for installer to run with cgi |
| 12:33 | Joubu | kohaputti: retart plack |
| 12:33 | restart* | |
| 12:34 | oleonard joined #koha | |
| 12:34 | kohaputti | Joubu, no help |
| 12:35 | so I have created empty example_koha db but now I would need to run the installer to populate it with the koha schema | |
| 12:35 | oleonard | Hi all |
| 12:35 | Joubu | the installer runs ok under plack |
| 12:35 | kohaputti | mhm, I wonder what's my issue then |
| 12:36 | Joubu, does it need some special apache config to work? | |
| 12:36 | (I'm doing my own apache configs) | |
| 12:37 | Joubu | kohaputti: I would create a new Koha instance, then run the installer, dump the db, remove the instance |
| 12:37 | alex_a joined #koha | |
| 12:39 | kohaputti | oooh... wait maybe it works but I forgot plack is running through socket and I was expecting a listening port to appear |
| 12:40 | and maybe the error messages are "normal" | |
| 12:40 | my apache config is still messed up so it doesn't route packets to the socket most likely | |
| 12:41 | Dyrcona joined #koha | |
| 12:43 | andreashm joined #koha | |
| 12:45 | kohaputti | yay, got it working. I missed "Listen 8080" directive from apache config |
| 12:53 | iGNUjee[m] joined #koha | |
| 13:12 | inlibro joined #koha | |
| 13:15 | andreashm joined #koha | |
| 13:15 | morrism joined #koha | |
| 13:25 | morrism joined #koha | |
| 13:34 | mtj[m] joined #koha | |
| 13:42 | khall joined #koha | |
| 13:50 | andreashm joined #koha | |
| 14:08 | talljoy joined #koha | |
| 14:13 | inlibro joined #koha | |
| 14:13 | morrism joined #koha | |
| 14:15 | andreashm joined #koha | |
| 14:17 | ValterBarreira[m] joined #koha | |
| 14:19 | urra[m] joined #koha | |
| 14:19 | mjlassila joined #koha | |
| 14:20 | oleonard | So many comings and goings. Stay a while y'all. Set a spell. |
| 14:21 | koha-jenkins | Project Koha_18.11_U18 build #250: ABORTED in 13 hr: https://jenkins.koha-community[…]ha_18.11_U18/250/ |
| 14:21 | oleonard | Take your shoes off. |
| 14:30 | andreashm joined #koha | |
| 14:31 | magnuse_ | 13 hr does not sound good for jenkins... |
| 14:31 | lukeG joined #koha | |
| 14:31 | oleonard | Nobody wants to pull that kinda shift |
| 14:36 | magnuse_ | nope |
| 14:37 | wizzyrea joined #koha | |
| 14:46 | cait | overowrked = failing a lot |
| 14:48 | 88 is a great new look for the QA queue | |
| 14:48 | go team! | |
| 14:52 | khall_ joined #koha | |
| 14:53 | tuxayo[m]1 joined #koha | |
| 14:57 | Joubu | 88, great? hum.. |
| 14:58 | cait | compared to 140 a few days ago... |
| 14:58 | the tendency is good, 30 would make me feel relaxed | |
| 15:02 | koha-jenkins | Project Koha_18.11_U18 build #251: SUCCESS in 41 min: https://jenkins.koha-community[…]ha_18.11_U18/251/ |
| 15:13 | inlibro joined #koha | |
| 15:15 | * oleonard | marks 58 bugs "failed QA" so cait can relax |
| 15:16 | cait | heh |
| 15:24 | khall joined #koha | |
| 15:32 | ashimema[m] | haha.. I see my queue hit 15! |
| 15:32 | exactly the number I challenged people to this morning.. nice one guys :) | |
| 15:33 | oleonard | ashimema[m]: What kind of cash prize do you have to disperse now? |
| 15:34 | ashimema[m] | didn't you read the small print oleonard ;P |
| 15:35 | * oleonard | didn't even see the challenge! |
| 15:35 | ashimema[m] | more seriously, I owe lots of people drinks of their choice at haskfest.. sorry those who aren't attending :( |
| 15:35 | * oleonard | grumbles |
| 15:35 | * cait | sends oleonard cookies |
| 15:37 | * oleonard | has been medicating regularly with cookies |
| 15:45 | cait | licorice tody.. |
| 15:46 | huginn | News from kohagit: Bug 17896: Remove duplicated use statements <http://git.koha-community.org/[…]7bf7ae8ce720f8fce> |
| 15:46 | News from kohagit: Bug 17896: load BakerTaylor module with use <http://git.koha-community.org/[…]230b36e472d86b4f0> | |
| 15:46 | News from kohagit: Bug 23777: (QA follow-up) Fix TT closing braces <http://git.koha-community.org/[…]64fd460d4bad7878f> | |
| 15:46 | News from kohagit: Bug 24676: Remove <p/> typo in opac-auth.tt <http://git.koha-community.org/[…]5753461097be025b3> | |
| 15:46 | News from kohagit: Bug 22359: Prevent undercollection at the server <http://git.koha-community.org/[…]05224611d61b86890> | |
| 15:46 | News from kohagit: Bug 22359: Improvements to payment collection inputs <http://git.koha-community.org/[…]8646ec7fd51ba0650> | |
| 15:46 | News from kohagit: Bug 23777: Use To.json in request.tt <http://git.koha-community.org/[…]790e1e0a794a036a5> | |
| 15:46 | News from kohagit: Bug 23777: Use TO.json in value_builder/unimarc_field_4XX.tt <http://git.koha-community.org/[…]fd722559ce05a9d48> | |
| 15:46 | News from kohagit: Bug 23777: Use To.json in results.tt <http://git.koha-community.org/[…]a9a689068f717e18d> | |
| 15:46 | News from kohagit: Bug 23777: Fix for the advanced editor <http://git.koha-community.org/[…]219daa91f5b141ac2> | |
| 15:46 | News from kohagit: Bug 23777: Use To.json in authorities.tt <http://git.koha-community.org/[…]5885f33e44ca157e5> | |
| 15:46 | News from kohagit: Bug 23777: Use To.json in preferences.tt <http://git.koha-community.org/[…]76ea5370ca25230f4> | |
| 15:46 | News from kohagit: Bug 23777: Fix auth finder escaping <http://git.koha-community.org/[…]893157a06581adfb0> | |
| 15:46 | News from kohagit: Bug 23482: Fix BakerTaylor cover images on lists <http://git.koha-community.org/[…]c33636b00e4054c13> | |
| 15:55 | Joubu | cheers #koha |
| 16:04 | lisettelatah joined #koha | |
| 16:05 | reiveune | bye |
| 16:05 | reiveune left #koha | |
| 16:05 | Margaret joined #koha | |
| 16:09 | ashimema[m] | anyone fancy QAing bug 24502? |
| 16:09 | huginn | Bug http://bugs.koha-community.org[…]_bug.cgi?id=24502 enhancement, P5 - low, ---, agustinmoyano, Signed Off , Add a query language and param (q=) to the API |
| 16:09 | News from kohagit: Bug 17510: update MMT-related unit tests <http://git.koha-community.org/[…]0c02ee9c34d15859c> | |
| 16:09 | News from kohagit: Bug 17510: enable use of subfield 0 in MMT actions <http://git.koha-community.org/[…]a41cfc4bc8cd2f62a> | |
| 16:09 | News from kohagit: Bug 22655: Adding holds rules to Onboarding tool <http://git.koha-community.org/[…]4696273d5cb85552b> | |
| 16:09 | News from kohagit: Bug 24588: Prevent e-mails from Koha to be flagged as spam <http://git.koha-community.org/[…]4ceb72f16ead54c06> | |
| 16:09 | News from kohagit: Bug 11161: Relabel 'child fund' to 'sub fund' in staff interface <http://git.koha-community.org/[…]6cb599b96bf9550f7> | |
| 16:09 | ashimema[m] | it's got PQA's either side of it in a dependancy chain.. |
| 16:13 | inlibro joined #koha | |
| 16:13 | koha-jenkins | Project Koha_19.05_U18 build #146: SUCCESS in 31 min: https://jenkins.koha-community[…]ha_19.05_U18/146/ |
| 16:13 | Project Koha_19.05_D8 build #143: SUCCESS in 34 min: https://jenkins.koha-community[…]oha_19.05_D8/143/ | |
| 16:15 | cait left #koha | |
| 16:16 | koha-jenkins | Project Koha_Master_D9_My8 build #167: FAILURE in 2 min 47 sec: https://jenkins.koha-community[…]aster_D9_My8/167/ |
| 16:16 | Project Koha_Master_D8 build #705: FAILURE in 2 min 20 sec: https://jenkins.koha-community[…]ha_Master_D8/705/ | |
| 16:18 | Project Koha_Master_D9_MDB_Latest build #142: FAILURE in 2 min 24 sec: https://jenkins.koha-community[…]9_MDB_Latest/142/ | |
| 16:18 | Project Koha_Master_D9 build #1159: FAILURE in 2 min 35 sec: https://jenkins.koha-community[…]a_Master_D9/1159/ | |
| 16:19 | Project Koha_19.05_D9 build #139: UNSTABLE in 39 min: https://jenkins.koha-community[…]oha_19.05_D9/139/ | |
| 16:20 | Project Koha_Master_U18 build #629: FAILURE in 1 min 51 sec: https://jenkins.koha-community[…]a_Master_U18/629/ | |
| 16:21 | * ashimema[m] | wonders if jajm might like to take a look at the updated translation tools tree: https://bugs.koha-community.or[…]raph.cgi?id=24262 |
| 16:23 | ashimema[m] | I walking the tree now signing off myself.. but I'm not a major user of the translation features.. would love an SO/QA step done by someone who seems to be more familiar with the workflows as they stand. |
| 16:37 | koha-jenkins | Project Koha_Master_D9 build #1160: STILL FAILING in 2 min 34 sec: https://jenkins.koha-community[…]a_Master_D9/1160/ |
| 16:39 | alex_a_ joined #koha | |
| 16:58 | did1 joined #koha | |
| 16:59 | lisettelatah joined #koha | |
| 17:13 | inlibro joined #koha | |
| 17:13 | huginn | News from kohagit: Bug 24588: (RM follow-up) Update debian/control <http://git.koha-community.org/[…]20be044ad17899a19> |
| 17:14 | koha-jenkins | Project Koha_19.05_D9 build #140: STILL UNSTABLE in 39 min: https://jenkins.koha-community[…]oha_19.05_D9/140/ |
| 17:20 | cait joined #koha | |
| 17:23 | koha-jenkins | Project Koha_19.05_U18 build #147: SUCCESS in 31 min: https://jenkins.koha-community[…]ha_19.05_U18/147/ |
| 17:23 | Project Koha_19.05_D8 build #144: SUCCESS in 34 min: https://jenkins.koha-community[…]oha_19.05_D8/144/ | |
| 17:26 | lukeG joined #koha | |
| 17:50 | koha-jenkins | Project Koha_19.11_D8 build #60: UNSTABLE in 27 min: https://jenkins.koha-community[…]Koha_19.11_D8/60/ |
| 17:52 | Project Koha_Master_D9 build #1161: STILL FAILING in 2 min 28 sec: https://jenkins.koha-community[…]a_Master_D9/1161/ | |
| 17:53 | Pit-Work joined #koha | |
| 17:58 | koha-jenkins | Project Koha_19.11_D9 build #57: UNSTABLE in 44 min: https://jenkins.koha-community[…]Koha_19.11_D9/57/ |
| 18:08 | Pit-Work | i have an issue with accessing records that are part of lists after updating a very updated koha server to a new version |
| 18:08 | browser spits out: | |
| 18:08 | Software error: | |
| 18:08 | Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.created_on' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 269 | |
| 18:09 | i know there is a mismatch between old version and new version tables, but im in no shape or form versed enough in LAMP to track this down myself | |
| 18:09 | can anybody perhaps point me in the right direction? | |
| 18:13 | inlibro joined #koha | |
| 18:15 | koha-jenkins | Project Koha_19.11_U18 build #55: STILL UNSTABLE in 51 min: https://jenkins.koha-community[…]oha_19.11_U18/55/ |
| 18:20 | tuxayo[m]1 joined #koha | |
| 18:22 | koha-jenkins | Yippee, build fixed! |
| 18:22 | Project Koha_19.05_D9 build #141: FIXED in 29 min: https://jenkins.koha-community[…]oha_19.05_D9/141/ | |
| 18:25 | Project Koha_Master_D9_My8 build #168: STILL FAILING in 2 min 39 sec: https://jenkins.koha-community[…]aster_D9_My8/168/ | |
| 18:27 | Project Koha_Master_D8 build #706: STILL FAILING in 2 min 9 sec: https://jenkins.koha-community[…]ha_Master_D8/706/ | |
| 18:28 | Margaret_ joined #koha | |
| 18:29 | killer_bee[m] joined #koha | |
| 18:29 | koha-jenkins | Project Koha_Master_D9_MDB_Latest build #143: STILL FAILING in 2 min 24 sec: https://jenkins.koha-community[…]9_MDB_Latest/143/ |
| 19:00 | Project Koha_19.05_U18 build #148: SUCCESS in 31 min: https://jenkins.koha-community[…]ha_19.05_U18/148/ | |
| 19:06 | lisettelatah joined #koha | |
| 19:06 | khall joined #koha | |
| 19:13 | inlibro joined #koha | |
| 19:28 | corilynn joined #koha | |
| 19:32 | talljoy | quiet in here |
| 19:33 | oleonard | All day. 'cept for Jenkins. |
| 19:33 | davidnind joined #koha | |
| 19:35 | sophie_m joined #koha | |
| 19:36 | koha-jenkins | Project Koha_19.05_D8 build #145: SUCCESS in 36 min: https://jenkins.koha-community[…]oha_19.05_D8/145/ |
| 19:36 | corilynn | oleonard, used your red underline patch to make a new one :) |
| 19:37 | Bug 24709 could use a little sign off | |
| 19:37 | huginn | Bug http://bugs.koha-community.org[…]_bug.cgi?id=24709 enhancement, P5 - low, ---, carnold, Needs Signoff , Advanced editor - show space after delimiter visually |
| 19:37 | oleonard | yeah I saw that bug report go by. Well done. |
| 19:37 | corilynn | thx |
| 19:37 | nothing like following a pattern :) | |
| 19:37 | ever-body loves the red underline and now they want to detect spaces after delimiters | |
| 19:44 | enkidu joined #koha | |
| 19:50 | morrism joined #koha | |
| 19:53 | ValterBarreira[m] joined #koha | |
| 19:56 | oleonard | Have a good weekend y'all |
| 19:59 | aaru_swartz[m] joined #koha | |
| 20:14 | inlibro joined #koha | |
| 20:18 | Pit-Work | so i think i see where my problem with errors after a major update are stemming from |
| 20:18 | the created ists are sort of missing | |
| 20:18 | lists | |
| 20:18 | and any item that was part of a list thrown en error if you click on it after a search | |
| 20:18 | i just have no idea where the lists are stored if i wanted to reimport or restore them | |
| 20:23 | lukeG joined #koha | |
| 20:24 | koha-jenkins | Yippee, build fixed! |
| 20:24 | Project Koha_19.11_D9 build #58: FIXED in 33 min: https://jenkins.koha-community[…]Koha_19.11_D9/58/ | |
| 20:33 | Yippee, build fixed! | |
| 20:33 | Project Koha_19.11_D8 build #61: FIXED in 38 min: https://jenkins.koha-community[…]Koha_19.11_D8/61/ | |
| 20:35 | corilynn | Pit-Work, what do you mean by "sort of missing"? |
| 20:35 | what version were you running before the update? | |
| 20:35 | Pit-Work | well when i go to administration _> lists nothing showes up |
| 20:36 | shows* | |
| 20:37 | but it says "showing results 1-20 out of 51 | |
| 20:37 | corilynn | interesting |
| 20:37 | Pit-Work | but stills ays no matching records found |
| 20:37 | corilynn | ok, so what version were you on, and what did you upgrade to? |
| 20:37 | The link to the schema is here: http://schema.koha-community.org/ | |
| 20:37 | Pit-Work | and when clicking an object from the user side thats part of a list brings this |
| 20:37 | Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.created_on' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 269 | |
| 20:37 | oh we were on 3.xx | |
| 20:38 | corilynn | ah |
| 20:38 | oh, wow | |
| 20:38 | and you are on what now? | |
| 20:38 | Pit-Work | upgraded to whatever was recent few months back |
| 20:38 | corilynn | ok |
| 20:38 | Pit-Work | wents smooth threv 2 mnor errors at the time |
| 20:38 | actually warnings i think | |
| 20:38 | corilynn | that's good |
| 20:38 | Pit-Work | DB and index converted smoothly |
| 20:39 | god i cant type today | |
| 20:39 | corilynn | I read bad typing :) |
| 20:39 | ok, so it says for 3.22 the lists schema was: http://schema.koha-community.o[…]patron_lists.html | |
| 20:40 | Pit-Work | but this is not about patrons though |
| 20:40 | corilynn | 19.11 has the same table, but I think it's different: http://schema.koha-community.o[…]patron_lists.html |
| 20:40 | ("patron" is a relative term in Koha... it means "user" to the real world) | |
| 20:40 | Pit-Work | i know |
| 20:41 | corilynn | let me look at the code in /usr/share/koha/lib/Koha/Objects.pm real quick |
| 20:42 | Pit-Work | https://imgur.com/a/STdSeF6 |
| 20:42 | this is the list im talking about | |
| 20:43 | corilynn | yup |
| 20:43 | Pit-Work | 4th from top left |
| 20:43 | corilynn | we use those lists here |
| 20:43 | Pit-Work | i actually have objects.pm open but i cant code to or read code to save my life |
| 20:43 | corilynn | it's a red herring anyway, that's just the generic code |
| 20:44 | Pit-Work | yeh usually i can trace my way around DB or files though |
| 20:44 | this has me lost | |
| 20:44 | corilynn | oh, they're "shelves" |
| 20:45 | Pit-Work | as i cont see any "fied list" in db schema |
| 20:45 | for current nor old version | |
| 20:45 | corilynn | cgi-bin/koha/virtualshelves/shelves.pl |
| 20:45 | Pit-Work | let me open that up real quick |
| 20:47 | hmmmm | |
| 20:47 | look liek i tried that a while ago | |
| 20:47 | when i do nano "/cgi-bin/koha/virtualshelves/shelves.pl" | |
| 20:47 | corilynn | that's the page that the lists go to , but i don't see a "shelf" table |
| 20:47 | Pit-Work | i get blank |
| 20:47 | corilynn | the whole page is blank? |
| 20:48 | Pit-Work | let me browse to the dir |
| 20:48 | and see if it exists | |
| 20:50 | corilynn | ok, the file is /virtualshelves/shelves.pl |
| 20:50 | from the root of koha | |
| 20:52 | here's the table! http://schema.koha-community.o[…]helfcontents.html | |
| 20:55 | so, for 3.22.xx the schema was a little different | |
| 20:55 | http://schema.koha-community.o[…]rtualshelves.html | |
| 20:55 | Margaret joined #koha | |
| 20:56 | corilynn | vs. http://schema.koha-community.o[…]rtualshelves.html |
| 20:58 | koha-jenkins | Project Koha_19.11_U18 build #56: STILL UNSTABLE in 34 min: https://jenkins.koha-community[…]oha_19.11_U18/56/ |
| 20:59 | Pit-Work | aaaah found the dang file |
| 20:59 | urra[m] joined #koha | |
| 20:59 | Pit-Work | . /usr/share/koha/intranet/cgi-bin/virtualshelves/ |
| 20:59 | iGNUjee[m] joined #koha | |
| 20:59 | corilynn | both schemas have created_on |
| 20:59 | I'm wondering if it's a problem with the SQL itself | |
| 21:01 | Pit-Work | so i inherited this thing from somebody years back and it ran as needed and i didnt need to touch it till the update |
| 21:01 | thing started as a virtual box install on somebodys laptop on already outdated debian 6 | |
| 21:01 | corilynn | lol |
| 21:01 | Pit-Work | at one point they said lets roll with it, but instead of fresh start they were liek we need to use this persons stuff |
| 21:02 | corilynn | so, can you do mysql? |
| 21:02 | Pit-Work | as they had 1k records in as part of a trial |
| 21:02 | can i do it? i have acces to the database | |
| 21:02 | corilynn | sweet, can you connect and run a quick sql query? |
| 21:03 | Pit-Work | sure just a sec let me look up the credentials |
| 21:04 | corilynn | ugh, hubby nagging me to go home |
| 21:05 | when you get into MySQL use <nameofyourdatabase>; then run "select * from virtualshelves limit 10;" | |
| 21:05 | check to see if the "created_on" field is in there | |
| 21:07 | Pit-Work | im on it |
| 21:07 | corilynn | if it's not there, then: |
| 21:07 | ALTER TABLE virtualshelves | |
| 21:07 | ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified | |
| 21:07 | ; | |
| 21:08 | UPDATE virtualshelves | |
| 21:08 | SET created_on = lastmodified, lastmodified = lastmodified; | |
| 21:08 | (I copied that from the installer script) | |
| 21:08 | l8r! | |
| 21:08 | Good luck | |
| 21:08 | Pit-Work | thgansk!!!! |
| 21:08 | thanks!!! | |
| 21:08 | ill do that | |
| 21:14 | inlibro joined #koha | |
| 21:33 | lisettelatah joined #koha | |
| 22:14 | inlibro joined #koha | |
| 22:23 | Pit-Work | corilynn i know you are not here, but i want everyone to know that you are awesome and fixed my issues!!! THANK YOU! |
| 22:23 | i will find you next time you log in and thank you personally! | |
| 22:27 | davidnind | Pit-WorK: great to hear! (You can also send an @later tell name message) |
| 22:27 | @later tell Pit-Work Great to hear that you were able to resolve the issue! | |
| 22:27 | huginn | davidnind: The operation succeeded. |
| 22:28 | davidnind | ^^ an example |
| 22:35 | Pit-Work | aaah great good to know there is a bot! |
| 22:36 | i shall | |
| 22:46 | tuxayo[m] joined #koha | |
| 22:48 | Pit-Work | @later tell corilynn THANK YOU! Thank You! thank you! You did it, your solution worked, that pesky missing table "created_on" was screwing all the lists and any record that was part of any list up. I am forever greatful and so is out Librarian/Archivist! |
| 22:48 | huginn | Pit-Work: The operation succeeded. |
| 23:14 | inlibro joined #koha | |
| 23:18 | ashimema[m] joined #koha |
← Previous day | Today | Next day → | Search | Index