| Time |
S |
Nick |
Message |
| 00:05 |
|
|
eythian joined #koha |
| 01:44 |
|
|
Sean_He joined #koha |
| 02:20 |
|
alohabot |
🎠🵠Koha '21.05.x' packages pushed to 'koha-staging' repo 🥫ðŸ’🥔 |
| 02:28 |
|
koha-jenkins |
Project Koha_21.05_U18 build #194: SUCCESS in 38 min: https://jenkins.koha-community[…]ha_21.05_U18/194/ |
| 02:29 |
|
koha-jenkins |
Project Koha_21.05_U20 build #204: SUCCESS in 40 min: https://jenkins.koha-community[…]ha_21.05_U20/204/ |
| 02:43 |
|
koha-jenkins |
Project Koha_21.05_D10 build #281: SUCCESS in 54 min: https://jenkins.koha-community[…]ha_21.05_D10/281/ |
| 02:48 |
|
tuxayo |
dcook: what happen when you try to run ES? |
| 02:49 |
|
tuxayo |
Could it be related to that? https://gitlab.com/koha-commun[…]elasticsearch-run |
| 02:50 |
|
dcook |
tuxayo: Nah, it's not that. I've already taken care of that part. |
| 02:50 |
|
dcook |
I think I just don't get any search results from ES |
| 02:50 |
|
tuxayo |
:o |
| 02:50 |
|
dcook |
Tried changing options and re-indexing and :S |
| 02:50 |
|
dcook |
I'm probably just missing some step |
| 02:50 |
|
tuxayo |
So at least it indexes? |
| 02:51 |
|
dcook |
Not sure in hindsight |
| 02:51 |
|
dcook |
It's been a few weeks since I last tried |
| 02:51 |
|
dcook |
Need to sit down and look at it but.. yeah so behind at the moment |
| 02:51 |
|
dcook |
Hmm Tomas mentioned setting something to "yes" in the .env file. Maybe that's the key.. |
| 02:52 |
|
tuxayo |
bug 27667 can help to check if ES returns of the right number of indexed record |
| 02:53 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=27667 enhancement, P5 - low, ---, fridolin.somers, Pushed to master , Display the number of non-indexed records |
| 02:53 |
|
tuxayo |
I guess you already have KOHA_ELASTICSEARCH=1 |
| 02:56 |
|
|
fridolin joined #koha |
| 02:58 |
|
wajasu |
its funny. i've been hitting koha-community.org for 3+ weeks now. It always says "Introducing Koha 20.05" [Try in now] |
| 02:59 |
|
wajasu |
Even if I reload or reboot machine. So do I really have to slear my cache to see it move to 22.05? |
| 02:59 |
|
wajasu |
firefox on archlinux |
| 03:00 |
|
koha-jenkins |
Project Koha_21.05_U16 build #203: SUCCESS in 1 hr 9 min: https://jenkins.koha-community[…]ha_21.05_U16/203/ |
| 03:00 |
|
wajasu |
my friend hit the site and saw 21.11 I think today. |
| 03:01 |
|
wajasu |
mu laptop show 22.05 today. |
| 03:02 |
|
wajasu |
it's wordpress, so it's probably caching in my firefox. |
| 03:03 |
|
koha-jenkins |
Yippee, build fixed! |
| 03:03 |
|
koha-jenkins |
Project Koha_21.05_D12 build #130: FIXED in 34 min: https://jenkins.koha-community[…]ha_21.05_D12/130/ |
| 03:03 |
|
wahanui |
Congratulations! |
| 03:03 |
|
tuxayo |
wajasu: I see "Introducing Koha 22.05", that's weird you have not that |
| 03:04 |
|
tuxayo |
> my friend hit the site and saw 21.11 I think today. |
| 03:04 |
|
tuxayo |
super weird |
| 03:04 |
|
wajasu |
it through me off because the dashboard show 21.xx. that's why i was working to add the 22.05 |
| 03:05 |
|
tuxayo |
In the PC that shows 20.05, can you try in private browsing? |
| 03:05 |
|
tuxayo |
> it's wordpress, so it's probably caching in my firefox. |
| 03:05 |
|
tuxayo |
2 years old cache that's too much. Did you even come to the website two years ago? |
| 03:06 |
|
tuxayo |
Is the news section up to date for you? |
| 03:06 |
|
tuxayo |
You should see stuff from July 26th, 2022 |
| 03:06 |
|
tuxayo |
Just bellow the "try now" |
| 03:07 |
|
wajasu |
4 or 6 years ago and 10/12 before that. maybe i got a version with bad expiry. bu i know i've wipe all my cache in the past months, since i was developing web sites. |
| 03:08 |
|
wajasu |
wow. i see the new values now. |
| 03:08 |
|
wajasu |
it might have to due with the 26th being ahead of Florida. In an hour it will be the 26th. |
| 03:09 |
|
wajasu |
well i didn't touch refreshing my cache. so i just wanted to mention this before I did and it just cleaned up. |
| 03:09 |
|
tuxayo |
Website site TZ is new zealan |
| 03:09 |
|
tuxayo |
*zealand |
| 03:09 |
|
tuxayo |
That would be weird that it would affect something |
| 03:10 |
|
wajasu |
the weird thing was that i've seen 20.05 for 3 weeks. never saw 21.xx and now here we are at 22.05 |
| 03:11 |
|
wajasu |
maybe the web page was edited and they just hit publish today. |
| 03:12 |
|
wajasu |
i started working on db autoincrement today. |
| 03:12 |
|
wajasu |
4 borrowers messaed up. 16 items messed up |
| 03:13 |
|
wajasu |
borrower has 66 child relations ships as schemaspy shows. |
| 03:14 |
|
wajasu |
i might just delete those 4 borrowers, but what a pain investigating other tables. |
| 03:14 |
|
wajasu |
tmrw i'll investigat the items. |
| 03:15 |
|
wajasu |
my librarian said it might just be items he deleted, or that he marked missing. will have to see. |
| 03:20 |
|
wajasu |
i brought up might site on a 1GB ram box, but if i nav to about->systeminfo, the second session caused the site to go down. so i need to figure out how to run with memcached (if possible), or maybe plack disabled. |
| 03:20 |
|
wajasu |
i tried disabled plack, but it still crashed. |
| 03:20 |
|
wajasu |
i might need more swap. only 512M |
| 03:24 |
|
tuxayo |
At least more swap indeed |
| 03:25 |
|
tuxayo |
1 ram + 0.5 swap isn't enough for two worders |
| 03:25 |
|
tuxayo |
*workers |
| 03:26 |
|
tuxayo |
> maybe the web page was edited and they just hit publish today. |
| 03:26 |
|
tuxayo |
It was already 22.05 in the past |
| 03:26 |
|
tuxayo |
https://web.archive.org/web/20[…]ha-community.org/ |
| 03:26 |
|
tuxayo |
puzzling |
| 03:31 |
|
wajasu |
i commented out the memcached in koha-conf and it seems that things arent crashing. but 75M to spare is too close for comfort. |
| 03:32 |
|
wajasu |
maybe i need to bump to a 2GB RAM node for $5 more per month. |
| 03:32 |
|
wajasu |
i probably has 2-4G of ram in that old 2010 PC I ran it on all these years. |
| 03:33 |
|
wajasu |
who knows. if i had the memcached configured then, maybe the hard drive wouldn't have been working so hard. |
| 03:34 |
|
wajasu |
its a 1GBnano on linode.com right now. |
| 03:45 |
|
koha-jenkins |
Yippee, build fixed! |
| 03:45 |
|
koha-jenkins |
Project Koha_21.05_D11 build #232: FIXED in 59 min: https://jenkins.koha-community[…]ha_21.05_D11/232/ |
| 03:45 |
|
wahanui |
Congratulations! |
| 04:07 |
|
wajasu |
i think that the autoincrement fix init-file should be included in koha-common install so new installations and existing don't continue to cause the problem |
| 04:08 |
|
wajasu |
noting that if a bug fix is available, the file would be/could be detected and removed in that update |
| 04:28 |
|
dcook |
wajasu: koha-common doesn't install MySQL |
| 04:28 |
|
dcook |
That reminds me though.. |
| 04:29 |
|
dcook |
https://bugs.mysql.com/bug.php?id=77743 |
| 04:29 |
|
dcook |
Not sure how that translate to MariaDB off the top of my head.. |
| 04:30 |
|
dcook |
Actually.. maybe an unrelated bug |
| 04:30 |
|
dcook |
Anyway, hopefully the older versions of MariaDB/MySQL will be supported soon and then we won't have to worry about this issue anymore.. |
| 04:44 |
|
wajasu |
oh. i guess you are waiting for them not to use MAX(primarykey column). our having two tables where we "move |
| 04:44 |
|
koha-jenkins |
Project Koha_21.05_D11 build #233: SUCCESS in 59 min: https://jenkins.koha-community[…]ha_21.05_D11/233/ |
| 04:45 |
|
wajasu |
" the row to deletedXXXX is what caused it. |
| 04:46 |
|
wajasu |
i guess moving the row out was for performance reasons, for joins, indexes. |
| 04:47 |
|
wajasu |
i guess koha-create could add the init-file if not present :) |
| 04:49 |
|
wajasu |
or in system info tab, add a button ito add it if it doesn't exist. but the koha intra app would need to run as root |
| 04:50 |
|
wajasu |
or maybe the init.d koha-common could at service startup. |
| 04:51 |
|
wajasu |
does the problem exist in postgres? |
| 04:52 |
|
wajasu |
what a headache |
| 04:52 |
|
wajasu |
i'll be through fixing records by tomorrow i hope. |
| 05:01 |
|
wajasu |
playing with running 1GB with 1 plack worker things work wihtout OOM killer for starman on Debian 11 mariab. |
| 05:02 |
|
wajasu |
but just 50M of ram to survive isnt practical |
| 05:35 |
|
|
fridolin joined #koha |
| 06:33 |
|
|
reiveune joined #koha |
| 06:33 |
|
reiveune |
hello |
| 06:53 |
|
paulderscheid[m] |
Bonjour #koha |
| 06:58 |
|
|
cait joined #koha |
| 07:06 |
|
dcook |
wajasu: The autoincrement issue doesn't exist in newer versions of MySQL/MariaDB. They patched it. Just an issue for older versions. |
| 07:07 |
|
dcook |
Like we use newer database servers that don't have that problem |
| 07:07 |
|
dcook |
With postgres you usually use sequences which work differently so no the problem doesn't happen with postgres |
| 07:07 |
|
dcook |
I think their autoincrement might auto generate a sequence actually.. was reading something the other day |
| 07:07 |
|
dcook |
Oh well done work for the day. Dooooone. |
| 07:17 |
|
cait |
good morning #koha |
| 07:32 |
|
cait |
hm I just realized the manuals on pootle stop at 21.05 |
| 09:07 |
|
Joubu |
How do I retrieve the result from a REST API request when using Test::Mojo? |
| 09:15 |
|
Joubu |
$t->tx->res->body |
| 09:18 |
|
|
fridolin left #koha |
| 10:20 |
|
|
khall joined #koha |
| 10:38 |
|
|
oha joined #koha |
| 10:40 |
|
oha |
hi there. quick question: what's the typical/expected delay for the debian packages to be available after a new release (22.05.03 in this case)? thanks |
| 10:54 |
|
cait |
oha: usually they come out pretty fast these days |
| 10:55 |
|
cait |
less than a week |
| 10:59 |
|
|
khall_ joined #koha |
| 10:59 |
|
oha |
ok, thanks. had the impression that in the past it happened on the same day :) |
| 11:01 |
|
oleonard |
Hi #koha |
| 11:11 |
|
|
thd joined #koha |
| 11:21 |
|
tcohen |
hola #koha |
| 11:26 |
|
oleonard |
Hi tcohen |
| 11:30 |
|
oleonard |
jajm around? |
| 11:33 |
|
cait |
hi oleonard and tcohen |
| 11:46 |
|
mtj |
hi folks, any chance we can remove installer/data/mysql/atomicupdate/bug_30899.pl, for the 22.05.03 release? |
| 11:46 |
|
cait |
oh i thought it had been done :( |
| 11:47 |
|
cait |
it will be rerun as it was already in 22.05.02 |
| 11:47 |
|
cait |
not sure what we can do now as it has been released? |
| 11:48 |
|
tcohen |
I think lukeg will cut a new release |
| 11:48 |
|
cait |
does he know? |
| 11:48 |
|
tcohen |
because there was a typo on the version as well |
| 11:48 |
|
mtj |
...perhaps add patch for bz-31108 too? |
| 11:48 |
|
tcohen |
he's asleep for a few more hours |
| 11:48 |
|
cait |
Waht about bug 31108? |
| 11:48 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=31108 blocker, P1 - high, ---, mtj, Pushed to master , rename ./t/00-check-atomic-updates.pl extension to *.t |
| 11:49 |
|
tcohen |
mtj: good idea! |
| 11:50 |
|
mtj |
cait: bz-31108 has a test to detect left-over atomic/*.t files |
| 11:54 |
|
cait |
oh yes, that's a good one |
| 11:55 |
|
mtj |
no probs, ill send him an email - will hold off pushing a 22.05 package |
| 11:55 |
|
cait |
mtj++ |
| 11:56 |
|
tcohen |
oh, that's great mtj |
| 11:59 |
|
alohabot |
🎠🦠Koha '21.11.x' packages pushed to 'koha' repo 🥈🌎🚀 |
| 12:14 |
|
Joubu |
git pre-push hook for RM and RMaints should already have that test ;) |
| 12:14 |
|
tcohen |
is there something about that on the wiki? |
| 12:17 |
|
mtj |
tcohen: this perhaps -> https://wiki.koha-community.or[…]Git_pre-push_hook |
| 12:21 |
|
tcohen |
yeah, was about to paste |
| 12:21 |
|
tcohen |
I already have it on my box |
| 12:21 |
|
tcohen |
but didn't have the reference to share |
| 12:22 |
|
mtj |
tcohen: ill try to build a newer libdatetime-perl, for bionic |
| 12:22 |
|
tcohen |
mtj++ |
| 12:26 |
|
tcohen |
rmaints please use https://wiki.koha-community.or[…]Git_pre-push_hook |
| 12:33 |
|
cait |
i don't think they all read back here |
| 12:33 |
|
cait |
maybe email? |
| 12:35 |
|
|
Anne joined #koha |
| 12:36 |
|
huginn |
News from kohagit: Bug 31211: (QA follow-up) Add class to new list element for error <https://git.koha-community.org[…]0cbcd21851e4d9c9c> |
| 12:36 |
|
huginn |
News from kohagit: Bug 31229: (bug 30063 follow-up) fix column visibility <https://git.koha-community.org[…]9a1a1c402be867eba> |
| 12:36 |
|
huginn |
News from kohagit: Bug 31211: Check slips and notices for valid Template Toolkit and report errors <https://git.koha-community.org[…]c35195a498b5342ae> |
| 12:36 |
|
huginn |
News from kohagit: Bug 21982: Circulation statistics wizard does not count deleted items <https://git.koha-community.org[…]8810792d25c6dc47b> |
| 12:37 |
|
Anne |
Hi there, I was wrong when I installed Koha. I choose Marc instead of unimarc. So I need to reinstall it... How to do this ? |
| 12:39 |
|
cait |
Where are you located Anne? |
| 12:39 |
|
cait |
and how did you install? |
| 12:43 |
|
Anne |
Thanks Cait : I'm in Belguim. I used commands line such as sudo koha-create --create-db biblio |
| 12:44 |
|
cait |
I think you might need to remove the instance and start over |
| 12:44 |
|
cait |
and use the koha-create command witht he UNIMARC option |
| 12:46 |
|
koha-jenkins |
Project Koha_Master_D11_ES6 build #38: SUCCESS in 8 min 7 sec: https://jenkins.koha-community[…]aster_D11_ES6/38/ |
| 12:48 |
|
Anne |
Ok Cait, I'll try this. Thanks |
| 12:48 |
|
|
marie-luce joined #koha |
| 12:49 |
|
cait |
Anne: and then in the web installer also pick UNIMARC - so it all matches up |
| 13:07 |
|
koha-jenkins |
Project Koha_Master_D11_ES7 build #40: SUCCESS in 8 min 9 sec: https://jenkins.koha-community[…]aster_D11_ES7/40/ |
| 13:12 |
|
mtj |
does anyone know why the 22.05 builds are failing? |
| 13:16 |
|
mtj |
hi tuxayo, can you push a v21.05.16 tag pweese |
| 13:16 |
|
mtj |
oops, v21.05.17 tag |
| 13:18 |
|
koha-jenkins |
Project Koha_Master_U20 build #510: SUCCESS in 39 min: https://jenkins.koha-community[…]a_Master_U20/510/ |
| 13:25 |
|
koha-jenkins |
Project Koha_Master_D11_My8 build #939: UNSTABLE in 47 min: https://jenkins.koha-community[…]ster_D11_My8/939/ |
| 13:28 |
|
cait |
hm, studying our coding guidelines: all SQL must be in the C4/xxxx.pm or Koha/xxxx.pm (xxxx being the module your SQL refers to) |
| 13:29 |
|
cait |
... didn't we say no SQL in the Koha namespace? |
| 13:30 |
|
cait |
tcohen/Joubu? |
| 13:31 |
|
tcohen |
mtj: missing misc4dev in the docker image? |
| 13:31 |
|
tcohen |
cait: generally, yes |
| 13:31 |
|
tcohen |
what is the question context? |
| 13:31 |
|
cait |
so is this a case where we should update the coding guidelines? |
| 13:31 |
|
cait |
bug 29145 |
| 13:31 |
|
huginn |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=29145 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Allow patrons to have overdue items that would not result in debarment when removing overdue debarments |
| 13:32 |
|
tcohen |
that one should be FQA for more tahn one reason |
| 13:32 |
|
cait |
yes, I am just looking into it |
| 13:32 |
|
cait |
sysprefs.sql is missing |
| 13:32 |
|
cait |
0,1 shuld be used in .pref |
| 13:34 |
|
tcohen |
new sub without POD, lacking tests on a sensible area |
| 13:34 |
|
tcohen |
old style coding in Koha::Patron |
| 13:35 |
|
koha-jenkins |
Yippee, build fixed! |
| 13:35 |
|
koha-jenkins |
Project Koha_Master_D10 build #761: FIXED in 55 min: https://jenkins.koha-community[…]a_Master_D10/761/ |
| 13:35 |
|
wahanui |
Congratulations! |
| 13:35 |
|
tcohen |
has_overdues feels like the wrong place for this too |
| 13:36 |
|
tcohen |
overduerules is about messaging and restricting the patron |
| 13:36 |
|
tcohen |
items are overdue regardless what overduerules says |
| 13:36 |
|
cait |
I think you might want to add your own notes too :) |
| 13:37 |
|
mtj |
tcohen: hmm, misc4dev is loaded ok, but some sql files seem to be unavailable |
| 13:37 |
|
cait |
but maybe let me post mine first |
| 13:38 |
|
cait |
tcohen: can you run the script for creating the next dev meeting agenda |
| 13:38 |
|
cait |
? |
| 13:38 |
|
cait |
I'd like to add the SQL question |
| 13:39 |
|
cait |
and also the info on LTS |
| 13:41 |
|
|
caroline joined #koha |
| 13:42 |
|
tcohen |
I think it is done |
| 13:42 |
|
tcohen |
the calendar stuff never worked for me |
| 13:42 |
|
cait |
it isN#t |
| 13:42 |
|
cait |
not listed in the wiki |
| 13:42 |
|
cait |
and we better figure it out before Joubu leaves |
| 13:42 |
|
cait |
:) |
| 13:42 |
|
tcohen |
https://wiki.koha-community.or[…]Next_IRC_meetings |
| 13:42 |
|
cait |
oh, just updated, on the wiki now |
| 13:42 |
|
cait |
sorry, reload took a while |
| 13:43 |
|
cait |
it was not there a few minutes ago |
| 13:45 |
|
koha-jenkins |
Project Koha_Master_U22 build #156: SUCCESS in 1 hr 7 min: https://jenkins.koha-community[…]a_Master_U22/156/ |
| 13:48 |
|
mtj |
folks, whats the misc4dev repo? https://gitlab.com/koha-community/koha-misc4dev ? |
| 13:49 |
|
tcohen |
yes |
| 13:50 |
|
mtj |
ah yep |
| 13:57 |
|
mtj |
ah, its the $VERSION = "22.05.03.00" typo, thats causing the 22.05 build fails |
| 13:59 |
|
mtj |
https://jenkins.koha-community.org/view/22.05/ |
| 14:00 |
|
mtj |
np, email sent |
| 14:02 |
|
tcohen |
I'm in a chat with lukeg |
| 14:11 |
|
koha-jenkins |
Project Koha_Master_D11_MDB_Latest build #1033: SUCCESS in 45 min: https://jenkins.koha-community[…]_MDB_Latest/1033/ |
| 14:16 |
|
|
reks joined #koha |
| 14:22 |
|
|
lukeg joined #koha |
| 14:27 |
|
koha-jenkins |
Project Koha_Master build #2126: STILL UNSTABLE in 1 hr 11 min: https://jenkins.koha-community[…]Koha_Master/2126/ |
| 14:36 |
|
koha-jenkins |
Project Koha_Master_D11_ES7 build #41: SUCCESS in 9 min 2 sec: https://jenkins.koha-community[…]aster_D11_ES7/41/ |
| 14:40 |
|
alohabot |
🎠🦄 Koha 'master' packages pushed to 'koha-staging' repo ðŸ¥ðŸ¥®ðŸ§€ |
| 14:41 |
|
tuxayo |
mtj: oops forgot when I was waiting for the CI. Done! |
| 14:43 |
|
tuxayo |
mtj: «whats the misc4dev repo» A lot of stuff used in spinning up ktd and KohaDevBox |
| 14:43 |
|
|
khall joined #koha |
| 14:48 |
|
caroline |
Just to confirm, adding release notes text is useless if it's released in an older version right? e.g. https://bugs.koha-community.or[…]_bug.cgi?id=18392 was released in 22.05.00, so it's too late to add release notes text. Should we remove the keyword release-notes-needed so that it doesn't appear in the list anymore? |
| 14:48 |
|
huginn |
Bug 18392: enhancement, P5 - low, ---, nick, RESOLVED FIXED, Allow exporting circulation conditions as CSV or spreadsheet |
| 14:53 |
|
koha-jenkins |
Project Koha_Master_D12 build #220: SUCCESS in 1 hr 8 min: https://jenkins.koha-community[…]a_Master_D12/220/ |
| 14:56 |
|
koha-jenkins |
Project Koha_Master_D11_MDB_Latest build #1034: SUCCESS in 45 min: https://jenkins.koha-community[…]_MDB_Latest/1034/ |
| 14:58 |
|
tcohen |
caroline: yes |
| 14:58 |
|
tcohen |
is it in the manual? |
| 14:58 |
|
tcohen |
nm, that's another keyword |
| 14:58 |
|
caroline |
Not yet, I can add the Manual keyword and remove the release-notes-needed |
| 15:00 |
|
tcohen |
that's what I'd do |
| 15:00 |
|
|
bag joined #koha |
| 15:10 |
|
reiveune |
bye |
| 15:10 |
|
|
reiveune left #koha |
| 15:13 |
|
|
khall_ joined #koha |
| 15:38 |
|
Anne |
I've just reinstalled Koha. But now I've got an internal error server when I try to access the Web installer. In plack-error.log I've got : Auth ERROR: Cannot get_session() at /usr/share/koha/lib/C4/Auth.pm line 1009. Is this a significant error ? If so, how can I fix it ? |
| 15:38 |
|
cait |
did you restart all the things? |
| 15:42 |
|
|
Anne joined #koha |
| 15:42 |
|
wajasu |
dcook: thanks for letting me know that the newer mysql/mariadb doesn't have the autoincrement problem so I dont have to put the init-file in place on my new Debian11/mariadb upgrade |
| 15:45 |
|
wajasu |
so though we move to deleted table, the memory and the periodic redo log for innodb record the max autoincrment value. |
| 15:46 |
|
wajasu |
so upon startup the redo log/data dictionary is used to restore what the MAX is for the table. |
| 15:47 |
|
wajasu |
so our moving rows from to deleted doesn't break the autoincrment in the newer mysql/mariadb versions mention in the wiki. |
| 15:47 |
|
Anne |
cait : I restarted koha-zebra, koha-plack, apache (and always the same error). do I need to restart something else? |
| 15:48 |
|
wajasu |
the only time things can get messed up is with an abnormal exit of mysqld (OOM) where the redolog doesn't get flushed to disk. |
| 15:53 |
|
wajasu |
Anne: i think sessions might be stored in memcached if its used. someone here may know. so maybe check if memcached is started. |
| 15:53 |
|
cait |
Anne: did you add the instance with the same name as before? |
| 15:53 |
|
cait |
but restarting memcahced is also a godo idea |
| 15:54 |
|
wajasu |
service koha-common restart or systemctl koha-common restart may help |
| 15:56 |
|
Anne |
thanks guys ! I restarted memcached and it works now ;) |
| 15:57 |
|
cait |
great! |
| 16:35 |
|
|
reks joined #koha |
| 16:37 |
|
|
lukeg joined #koha |
| 16:40 |
|
|
m23 joined #koha |
| 16:44 |
|
|
cait joined #koha |
| 16:47 |
|
|
Oak joined #koha |
| 17:28 |
|
|
Oak joined #koha |
| 18:51 |
|
wajasu |
is the issues table the one that record checkouts? |
| 18:53 |
|
caroline |
wajasu, yes |
| 19:38 |
|
|
fridolin joined #koha |
| 19:38 |
|
fridolin |
yellow |
| 19:42 |
|
|
fridolin1 joined #koha |
| 19:59 |
|
|
keiths joined #koha |
| 19:59 |
|
keiths |
After upgrading to the latest (22.05.02.000), I am getting 500 errors when a search should return a biblio entry. This happens on the OPAC and when I do a search under the cataloging section in the staff site. I am able to search for patrons with no apparent problem.(I did have quite a bit of trouble updating my database) I ran rebuild zebra and it made no difference. How do I detect what is causing this problem? _______________________________________ |
| 20:04 |
|
lukeg |
keiths: do the error logs give you any further info.? |
| 20:21 |
|
tuxayo |
tcohen: Hola :) If I want to reach Spanish speaking librarians to make signoff sessions, where can I go? |
| 20:21 |
|
tuxayo |
What happened to es.koha-community.org ? |
| 20:22 |
|
tuxayo |
There isn't much traffic in https://lists.koha-community.o[…]ipermail/koha-es/ |
| 20:22 |
|
keiths |
Getting This error: |
| 20:22 |
|
keiths |
[Tue Jul 26 20:18:03.948868 2022] [cgi:error] [pid 3214] [client 37.19.200.146:54230] AH01215: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'reserves.patron_expiration_date' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 312: /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer: http://sati.pustaka-digital.asia/ [Tue Jul 26 20:18:03.997828 2022] [cgi:error] [pid 3214] [client 37.19. |
| 20:25 |
|
|
lukeg joined #koha |
| 20:25 |
|
tuxayo |
keiths: did you recently upgrade your Koha? from which version to which version? |
| 20:27 |
|
keiths |
Yes, recently upgraded to 22.05. I was at 21 (something). The database upgrade has a quite a few problems/errors |
| 20:28 |
|
keiths |
I just manually added the missing field to the table and the error disappears. Hope that won't effect things going forward. |
| 20:32 |
|
keiths |
Is there a way to test the data structure to be sure it is correct? I have run the schema update several times |
| 20:32 |
|
wajasu |
finally. got the patrons cleaned up. spent all day recontiling all those 66 child tables. |
| 20:33 |
|
wajasu |
now i have to work on items. 16 items with autoincrement problems. |
| 20:39 |
|
tuxayo |
keiths: reserves.patron_expiration_date is missing |
| 20:39 |
|
tuxayo |
https://gitlab.com/koha-commun[…]revs/211200010.pl |
| 20:40 |
|
tuxayo |
Ah I though «manually added the missing field to the table» was during the update. |
| 20:40 |
|
tuxayo |
Did you do something about the update errors? |
| 20:40 |
|
tuxayo |
Do you still have the error log? |
| 20:41 |
|
tuxayo |
wajasu: congrats |
| 20:41 |
|
wajasu |
thx |
| 20:42 |
|
wajasu |
so biblionumber is the same as biblioitemnumber in the items table. same values with each other in my |
| 20:42 |
|
wajasu |
db |
| 20:42 |
|
tuxayo |
I'm not sure |
| 20:42 |
|
tuxayo |
let me query some database |
| 20:45 |
|
wajasu |
select * from items where biblionumber != biblioitemnumber; returned 0 rows. |
| 20:45 |
|
keiths |
tuxayo: I saw that and modified it manually. Works Now. Don't know why the schema update didn't work |
| 20:48 |
|
tuxayo |
wajasu: ok if in your base they are not different you are safe to assume that |
| 20:49 |
|
tuxayo |
I recall some columns are usually in sync but once saw an offset of a few numbers |
| 20:49 |
|
tuxayo |
keiths: so you already manually did the upgrades that failed when you did the upgrade? |
| 20:53 |
|
koha-jenkins |
Project Koha_22.05_U18 build #40: NOW UNSTABLE in 39 min: https://jenkins.koha-community[…]oha_22.05_U18/40/ |
| 20:54 |
|
wajasu |
keiths: if you used mysql commandline client, look in your ~/.mysql_history file, you can save those fixes to a text file, then put them on the koha pastebin |
| 20:59 |
|
wajasu |
intersting that biblioitemnumber is not in deleteditems table. |
| 20:59 |
|
wajasu |
but that not stopping my autoincrement investigation |
| 21:01 |
|
koha-jenkins |
Yippee, build fixed! |
| 21:01 |
|
koha-jenkins |
Project Koha_22.05_U22 build #35: FIXED in 48 min: https://jenkins.koha-community[…]oha_22.05_U22/35/ |
| 21:01 |
|
wahanui |
Congratulations! |
| 21:04 |
|
keiths |
wajasu: thanks. |
| 21:05 |
|
wajasu |
bummer. for my autoincrement problem, deleteditems have different biblio number from the corresponding items |
| 21:15 |
|
koha-jenkins |
Project Koha_22.05_U20 build #39: NOW UNSTABLE in 1 hr 2 min: https://jenkins.koha-community[…]oha_22.05_U20/39/ |
| 21:47 |
|
koha-jenkins |
Project Koha_22.05_D11 build #43: NOW UNSTABLE in 1 hr 10 min: https://jenkins.koha-community[…]oha_22.05_D11/43/ |
| 22:04 |
|
tcohen |
hi all |
| 22:20 |
|
fridolin1 |
tcohen: le bonjour cher RM |
| 22:33 |
|
tuxayo |
tcohen: Hola :) If I want to reach Spanish speaking librarians to make signoff sessions, where can I go? |
| 22:33 |
|
tuxayo |
There isn't much traffic in https://lists.koha-community.o[…]ipermail/koha-es/ |
| 23:39 |
|
koha-jenkins |
Project Koha_22.05_D11 build #44: STILL UNSTABLE in 1 hr 9 min: https://jenkins.koha-community[…]oha_22.05_D11/44/ |
