IRC log for #koha, 2022-01-11

All times shown according to UTC.

Time S Nick Message
00:06 koha-jenkins Project Koha_21.05_D9 build #127: SUCCESS in 59 min: https://jenkins.koha-community[…]oha_21.05_D9/127/
00:28 fridolin joined #koha
01:00 AndrewFH joined #koha
01:21 AndrewFH joined #koha
03:20 MarkHofstetter joined #koha
03:25 MarkHofstetter joined #koha
04:45 smrt joined #koha
04:53 fridolin joined #koha
05:12 MarkHofstetter joined #koha
05:18 lmstrand joined #koha
05:32 purauf joined #koha
05:34 purauf Sir, can i download VirtualBox from https://www.virtualbox.org/wiki/Downloads (Windows hosts), is it safe????
05:42 MarkHofstetter joined #koha
06:02 chriss joined #koha
06:11 fridolin joined #koha
06:11 purauf Sir, can i download VirtualBox from https://www.virtualbox.org/wiki/Downloads (Windows hosts), is it safe????
07:10 alex_a joined #koha
07:10 alex_a Bonjour
07:10 wahanui hi, alex_a
07:12 cait joined #koha
07:15 cait1 joined #koha
07:30 reiveune joined #koha
07:30 reiveune hello
07:36 davidnind joined #koha
07:47 cait1 khall++
07:47 cait1 kidclamp++
07:58 lds joined #koha
08:17 alex_a_ joined #koha
09:13 Pavlis joined #koha
09:13 Pavlis Hi i need help
09:14 purauf joined #koha
09:36 davidnind left #koha
10:27 fribeiro joined #koha
10:29 vfernandes joined #koha
10:46 fribeiro Hello everyone. I'm updating Koha from 18.05.02 to 21.05.07 but when I execute the updatedatabase.pl, I get an error: DBI Exception: DBD::mysql::db do failed: Can't create table `koha`.`#sql-1_5` (errno: 150 "Foreign key constraint is incorrectly formed")
10:47 fribeiro After some debugging, I think its because one column has COLLATE but the other one doesn't
10:47 fribeiro Has anyone experienced this?
10:47 fribeiro Did anyone experienced this?
10:47 Joubu do you have the exact version where it crashes?
10:49 fribeiro First error is at 18.12.00.004. But after fixing that, it crashes again at 19.06.00.043
10:49 fribeiro Both when adding foreign key to accountlines table
10:52 Joubu and you identified that the table 'branches' does not have COLLATE=utf8mb4_unicode_ci, is that correct?
10:52 fribeiro Branches table have. Accountlines doesnt
10:53 fribeiro If i change the line to "ALTER TABLE accountlines ADD branchcode VARCHAR( 10 ) COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER manager_id"
10:53 fribeiro The foreign key is added correctly
10:54 Joubu did you identify other table that does not have this collate?
10:55 Joubu All tables must have COLLATE=utf8mb4_unicode_ci, since 3.19.00.006
10:59 fribeiro Executing this -> SHOW TABLE STATUS where collation not like "utf8mb4_unicode_ci"
10:59 fribeiro I get accountlines, accountoffsets, action_logs and alert
10:59 fribeiro All of them with utf8_general_ci
11:02 Joubu I have no idea why, but it's wrong
11:03 Joubu ALTER TABLE $table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
11:03 Joubu try that for the 4 tables
11:05 janPasi joined #koha
11:11 oleonard Hi #koha
11:44 fribeiro @Joubu that alter table worked
11:44 huginn` fribeiro: downloading the Perl source
11:44 fribeiro Thanks you
11:44 fribeiro *Thank
11:52 tcohen buen día, #koha
12:00 AndrewFH joined #koha
12:01 cait joined #koha
13:14 AndrewFH joined #koha
13:52 * cait1 waves
13:53 cait1 koha++ being a good ILS in my workshop today
13:53 cait1 wahanui botsnack cookie
13:53 wahanui thanks cait1 :)
14:05 oleonard Find any good bugs cait1 ?
14:09 cait1 the usual
14:10 cait1 acutally the filter on paid/unpaid transactions seems to be broken :D
14:10 cait1 but it was a 20.11 one, so not sure about master
14:16 oleonard wahanui: the usual is <reply>That bad hunh?
14:16 wahanui bugger all, i dunno, oleonard
14:16 oleonard wahanui: the usual is <reply>That bad hunh
14:16 wahanui OK, oleonard.
14:16 oleonard the usual
14:16 wahanui That bad hunh
14:22 Dyrcona joined #koha
14:33 lukeg joined #koha
14:45 lukeg joined #koha
14:46 lukeg joined #koha
15:02 koha-jenkins Project Koha_21.05_U_Stable build #130: SUCCESS in 32 min: https://jenkins.koha-community[…].05_U_Stable/130/
15:11 koha-jenkins Yippee, build fixed!
15:11 wahanui Congratulations!
15:11 koha-jenkins Project Koha_21.05_U21 build #68: FIXED in 40 min: https://jenkins.koha-community[…]oha_21.05_U21/68/
15:29 MarkHofstetter joined #koha
15:30 koha-jenkins Project Koha_21.05_D9 build #128: SUCCESS in 59 min: https://jenkins.koha-community[…]oha_21.05_D9/128/
15:35 koha-jenkins Project Koha_21.05_U20 build #136: SUCCESS in 32 min: https://jenkins.koha-community[…]ha_21.05_U20/136/
15:37 koha-jenkins Project Koha_21.05_D12 build #81: UNSTABLE in 1 hr 6 min: https://jenkins.koha-community[…]oha_21.05_D12/81/
15:40 koha-jenkins Project Koha_21.05_U16 build #135: SUCCESS in 1 hr 9 min: https://jenkins.koha-community[…]ha_21.05_U16/135/
15:42 koha-jenkins Project Koha_21.05_U18 build #127: SUCCESS in 1 hr 12 min: https://jenkins.koha-community[…]ha_21.05_U18/127/
15:49 koha-jenkins Project Koha_21.05_D11 build #155: SUCCESS in 38 min: https://jenkins.koha-community[…]ha_21.05_D11/155/
15:58 alex_a_ joined #koha
16:32 alex_a_ joined #koha
16:38 AndrewFH joined #koha
16:41 koha-jenkins Project Koha_21.05_D11 build #156: SUCCESS in 1 hr 1 min: https://jenkins.koha-community[…]ha_21.05_D11/156/
16:47 koha-jenkins Project Koha_21.05_D10 build #199: SUCCESS in 1 hr 9 min: https://jenkins.koha-community[…]ha_21.05_D10/199/
16:54 reiveune bye
16:56 reiveune left #koha
17:35 cait1 left #koha
17:38 cait joined #koha
17:48 koha-jenkins Project Koha_21.05_D10 build #200: SUCCESS in 1 hr 1 min: https://jenkins.koha-community[…]ha_21.05_D10/200/
17:50 AndrewFH joined #koha
20:53 fridolin joined #koha
21:01 AndrewFH joined #koha
22:32 koha-jenkins Project Koha_21.05_U_Stable build #131: SUCCESS in 32 min: https://jenkins.koha-community[…].05_U_Stable/131/
22:36 koha-jenkins Project Koha_21.05_D11 build #157: SUCCESS in 39 min: https://jenkins.koha-community[…]ha_21.05_D11/157/
22:38 AndrewFH joined #koha
22:42 cait joined #koha
22:45 koha-jenkins Yippee, build fixed!
22:45 wahanui Congratulations!
22:45 koha-jenkins Project Koha_21.05_D12 build #82: FIXED in 49 min: https://jenkins.koha-community[…]oha_21.05_D12/82/
22:53 huginn` News from kohagit: Bug 29557: DBRev 21.12.00.006 <https://git.koha-community.org[…]c0015e06132ddc783>
22:53 huginn` News from kohagit: Bug 29788: Fix batch delete item <https://git.koha-community.org[…]ec645fdf3bea60355>
22:53 huginn` News from kohagit: Bug 29790: Restore warning if deletion of serial item fails <https://git.koha-community.org[…]d8e44564754172766>
22:53 huginn` News from kohagit: Bug 29789: Remove unused $error from cataloguing/additem.pl <https://git.koha-community.org[…]1150502f5f91ef87e>
22:53 huginn` News from kohagit: Bug 29788: Make Koha::Item->safe_to_delete use Koha::Result::Boolean <https://git.koha-community.org[…]3d34f0f6f2175d14a>
22:53 huginn` News from kohagit: Bug 29557: (QA follow-up) Add note for translated notices to update statement <https://git.koha-community.org[…]d7f7840db43f3efb0>
22:53 huginn` News from kohagit: Bug 29688: Incorrect use of _() in holds.js <https://git.koha-community.org[…]11a6e4b0bcb49c89d>
22:53 huginn` News from kohagit: Bug 29557: Add auto_account_expired to AUTO_RENEWALS <https://git.koha-community.org[…]a24ad7683c8fb3538>
22:53 huginn` News from kohagit: Bug 29419: Retain user's inputs when suggesting for purchase and match found <https://git.koha-community.org[…]767035211705fe997>
22:53 huginn` News from kohagit: Bug 17127: Remove notes from detail.tt to only use MARCNOTES <https://git.koha-community.org[…]31e61ba569ac9fba6>
22:54 koha-jenkins Project Koha_21.05_D9 build #129: SUCCESS in 58 min: https://jenkins.koha-community[…]oha_21.05_D9/129/
23:04 koha-jenkins Project Koha_21.05_U20 build #137: SUCCESS in 1 hr 4 min: https://jenkins.koha-community[…]ha_21.05_U20/137/
23:08 koha-jenkins Project Koha_21.05_U18 build #128: SUCCESS in 36 min: https://jenkins.koha-community[…]ha_21.05_U18/128/
23:16 koha-jenkins Project Koha_21.05_D10 build #201: SUCCESS in 1 hr 17 min: https://jenkins.koha-community[…]ha_21.05_D10/201/
23:18 koha-jenkins Project Koha_21.05_U16 build #136: SUCCESS in 42 min: https://jenkins.koha-community[…]ha_21.05_U16/136/
23:33 koha-jenkins Project Koha_21.05_U20 build #138: SUCCESS in 48 min: https://jenkins.koha-community[…]ha_21.05_U20/138/
23:41 koha-jenkins Project Koha_21.05_U_Stable build #132: SUCCESS in 32 min: https://jenkins.koha-community[…].05_U_Stable/132/
23:51 koha-jenkins Project Koha_21.05_U21 build #69: SUCCESS in 56 min: https://jenkins.koha-community[…]oha_21.05_U21/69/
23:57 koha-jenkins Project Koha_21.05_D11 build #158: SUCCESS in 38 min: https://jenkins.koha-community[…]ha_21.05_D11/158/

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary