| Time |
S |
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 |
|
koha-jenkins |
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 |
|
koha-jenkins |
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 |
|
ashimema[m] |
sure there's 5 low hanging fruit bugs in that QA queue :) |
| 08:40 |
|
ashimema[m] |
and... |
| 08:40 |
|
ashimema[m] |
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 |
|
ashimema[m] |
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 |
|
enkidu |
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 |
|
marcelr |
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 |
|
Joubu |
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 |
|
jajm |
(not tested) |
| 09:51 |
|
cait |
enkidu: i think we use them without pin in those cases |
| 09:52 |
|
cait |
no pin = no auth, just the cardnumber/login |
| 09:52 |
|
marcelr |
Joubu jajm: can have a look later |
| 09:52 |
|
marcelr |
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 |
|
jajm |
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 |
|
cait |
filed it |
| 10:00 |
|
cait |
bbl |
| 10:01 |
|
|
vfernandes joined #koha |
| 10:01 |
|
enkidu |
sip2 checks databases instead of ldap, |
| 10:02 |
|
enkidu |
this is the problem but we werenot able to find a workaround about this |
| 10:02 |
|
enkidu |
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 |
|
marcelr |
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 |
|
marcelr |
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 |
|
Joubu |
without problem |
| 10:45 |
|
marcelr |
hmm |
| 10:45 |
|
marcelr |
too bad; i will have to blame myself :) |
| 10:45 |
|
Joubu |
sorry :) |
| 10:45 |
|
Joubu |
"Congratulations, installation complete" |
| 10:45 |
|
marcelr |
;) |
| 10:45 |
|
marcelr |
i have a new database with zero tables for now |
| 10:46 |
|
marcelr |
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 |
|
kohaputti |
or only CGI? |
| 12:27 |
|
kohaputti |
with plack I get: |
| 12:27 |
|
kohaputti |
DBD::mysql::db do failed: Table 'example_koha.systempreferences' doesn't exist [for Statement " |
| 12:27 |
|
kohaputti |
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 |
|
Joubu |
restart* |
| 12:34 |
|
|
oleonard joined #koha |
| 12:34 |
|
kohaputti |
Joubu, no help |
| 12:35 |
|
kohaputti |
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 |
|
kohaputti |
Joubu, does it need some special apache config to work? |
| 12:36 |
|
kohaputti |
(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 |
|
kohaputti |
and maybe the error messages are "normal" |
| 12:40 |
|
kohaputti |
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 |
|
cait |
88 is a great new look for the QA queue |
| 14:48 |
|
cait |
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 |
|
cait |
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 |
|
ashimema[m] |
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 |
|
huginn |
News from kohagit: Bug 17896: load BakerTaylor module with use <http://git.koha-community.org/[…]230b36e472d86b4f0> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: (QA follow-up) Fix TT closing braces <http://git.koha-community.org/[…]64fd460d4bad7878f> |
| 15:46 |
|
huginn |
News from kohagit: Bug 24676: Remove <p/> typo in opac-auth.tt <http://git.koha-community.org/[…]5753461097be025b3> |
| 15:46 |
|
huginn |
News from kohagit: Bug 22359: Prevent undercollection at the server <http://git.koha-community.org/[…]05224611d61b86890> |
| 15:46 |
|
huginn |
News from kohagit: Bug 22359: Improvements to payment collection inputs <http://git.koha-community.org/[…]8646ec7fd51ba0650> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: Use To.json in request.tt <http://git.koha-community.org/[…]790e1e0a794a036a5> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: Use TO.json in value_builder/unimarc_field_4XX.tt <http://git.koha-community.org/[…]fd722559ce05a9d48> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: Use To.json in results.tt <http://git.koha-community.org/[…]a9a689068f717e18d> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: Fix for the advanced editor <http://git.koha-community.org/[…]219daa91f5b141ac2> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: Use To.json in authorities.tt <http://git.koha-community.org/[…]5885f33e44ca157e5> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: Use To.json in preferences.tt <http://git.koha-community.org/[…]76ea5370ca25230f4> |
| 15:46 |
|
huginn |
News from kohagit: Bug 23777: Fix auth finder escaping <http://git.koha-community.org/[…]893157a06581adfb0> |
| 15:46 |
|
huginn |
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 |
|
huginn |
News from kohagit: Bug 17510: update MMT-related unit tests <http://git.koha-community.org/[…]0c02ee9c34d15859c> |
| 16:09 |
|
huginn |
News from kohagit: Bug 17510: enable use of subfield 0 in MMT actions <http://git.koha-community.org/[…]a41cfc4bc8cd2f62a> |
| 16:09 |
|
huginn |
News from kohagit: Bug 22655: Adding holds rules to Onboarding tool <http://git.koha-community.org/[…]4696273d5cb85552b> |
| 16:09 |
|
huginn |
News from kohagit: Bug 24588: Prevent e-mails from Koha to be flagged as spam <http://git.koha-community.org/[…]4ceb72f16ead54c06> |
| 16:09 |
|
huginn |
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 |
|
koha-jenkins |
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 |
|
koha-jenkins |
Project Koha_Master_D8 build #705: FAILURE in 2 min 20 sec: https://jenkins.koha-community[…]ha_Master_D8/705/ |
| 16:18 |
|
koha-jenkins |
Project Koha_Master_D9_MDB_Latest build #142: FAILURE in 2 min 24 sec: https://jenkins.koha-community[…]9_MDB_Latest/142/ |
| 16:18 |
|
koha-jenkins |
Project Koha_Master_D9 build #1159: FAILURE in 2 min 35 sec: https://jenkins.koha-community[…]a_Master_D9/1159/ |
| 16:19 |
|
koha-jenkins |
Project Koha_19.05_D9 build #139: UNSTABLE in 39 min: https://jenkins.koha-community[…]oha_19.05_D9/139/ |
| 16:20 |
|
koha-jenkins |
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 |
|
koha-jenkins |
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 |
|
koha-jenkins |
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 |
|
Pit-Work |
browser spits out: |
| 18:08 |
|
Pit-Work |
Software error: |
| 18:08 |
|
Pit-Work |
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 |
|
Pit-Work |
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 |
|
Pit-Work |
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 |
|
koha-jenkins |
Project Koha_19.05_D9 build #141: FIXED in 29 min: https://jenkins.koha-community[…]oha_19.05_D9/141/ |
| 18:25 |
|
koha-jenkins |
Project Koha_Master_D9_My8 build #168: STILL FAILING in 2 min 39 sec: https://jenkins.koha-community[…]aster_D9_My8/168/ |
| 18:27 |
|
koha-jenkins |
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 |
|
koha-jenkins |
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 |
|
corilynn |
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 |
|
corilynn |
nothing like following a pattern :) |
| 19:37 |
|
corilynn |
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 |
|
Pit-Work |
the created ists are sort of missing |
| 20:18 |
|
Pit-Work |
lists |
| 20:18 |
|
Pit-Work |
and any item that was part of a list thrown en error if you click on it after a search |
| 20:18 |
|
Pit-Work |
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 |
|
koha-jenkins |
Project Koha_19.11_D9 build #58: FIXED in 33 min: https://jenkins.koha-community[…]Koha_19.11_D9/58/ |
| 20:33 |
|
koha-jenkins |
Yippee, build fixed! |
| 20:33 |
|
koha-jenkins |
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 |
|
corilynn |
what version were you running before the update? |
| 20:35 |
|
Pit-Work |
well when i go to administration _> lists nothing showes up |
| 20:36 |
|
Pit-Work |
shows* |
| 20:37 |
|
Pit-Work |
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 |
|
corilynn |
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 |
|
Pit-Work |
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 |
|
Pit-Work |
oh we were on 3.xx |
| 20:38 |
|
corilynn |
ah |
| 20:38 |
|
corilynn |
oh, wow |
| 20:38 |
|
corilynn |
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 |
|
Pit-Work |
actually warnings i think |
| 20:38 |
|
corilynn |
that's good |
| 20:38 |
|
Pit-Work |
DB and index converted smoothly |
| 20:39 |
|
Pit-Work |
god i cant type today |
| 20:39 |
|
corilynn |
I read bad typing :) |
| 20:39 |
|
corilynn |
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 |
|
corilynn |
("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 |
|
Pit-Work |
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 |
|
Pit-Work |
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 |
|
Pit-Work |
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 |
|
Pit-Work |
hmmmm |
| 20:47 |
|
Pit-Work |
look liek i tried that a while ago |
| 20:47 |
|
Pit-Work |
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 |
|
Pit-Work |
and see if it exists |
| 20:50 |
|
corilynn |
ok, the file is /virtualshelves/shelves.pl |
| 20:50 |
|
corilynn |
from the root of koha |
| 20:52 |
|
corilynn |
here's the table! http://schema.koha-community.o[…]helfcontents.html |
| 20:55 |
|
corilynn |
so, for 3.22.xx the schema was a little different |
| 20:55 |
|
corilynn |
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 |
|
corilynn |
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 |
|
Pit-Work |
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 |
|
Pit-Work |
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 |
|
corilynn |
when you get into MySQL use <nameofyourdatabase>; then run "select * from virtualshelves limit 10;" |
| 21:05 |
|
corilynn |
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 |
|
corilynn |
ALTER TABLE virtualshelves |
| 21:07 |
|
corilynn |
ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified |
| 21:07 |
|
corilynn |
; |
| 21:08 |
|
corilynn |
UPDATE virtualshelves |
| 21:08 |
|
corilynn |
SET created_on = lastmodified, lastmodified = lastmodified; |
| 21:08 |
|
corilynn |
(I copied that from the installer script) |
| 21:08 |
|
corilynn |
l8r! |
| 21:08 |
|
corilynn |
Good luck |
| 21:08 |
|
Pit-Work |
thgansk!!!! |
| 21:08 |
|
Pit-Work |
thanks!!! |
| 21:08 |
|
Pit-Work |
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 |
|
Pit-Work |
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 |
|
davidnind |
@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 |
|
Pit-Work |
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 |
