Time Nick Message 00:06 koha-jenkins Project Koha_21.05_D9 build #127: SUCCESS in 59 min: https://jenkins.koha-community.org/job/Koha_21.05_D9/127/ 05:34 purauf Sir, can i download VirtualBox from https://www.virtualbox.org/wiki/Downloads (Windows hosts), is it safe???? 06:11 purauf Sir, can i download VirtualBox from https://www.virtualbox.org/wiki/Downloads (Windows hosts), is it safe???? 07:10 alex_a Bonjour 07:10 wahanui hi, alex_a 07:30 reiveune hello 07:47 cait1 khall++ 07:47 cait1 kidclamp++ 09:13 Pavlis Hi i need help 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: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 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 15:02 koha-jenkins Project Koha_21.05_U_Stable build #130: SUCCESS in 32 min: https://jenkins.koha-community.org/job/Koha_21.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.org/job/Koha_21.05_U21/68/ 15:30 koha-jenkins Project Koha_21.05_D9 build #128: SUCCESS in 59 min: https://jenkins.koha-community.org/job/Koha_21.05_D9/128/ 15:35 koha-jenkins Project Koha_21.05_U20 build #136: SUCCESS in 32 min: https://jenkins.koha-community.org/job/Koha_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.org/job/Koha_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.org/job/Koha_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.org/job/Koha_21.05_U18/127/ 15:49 koha-jenkins Project Koha_21.05_D11 build #155: SUCCESS in 38 min: https://jenkins.koha-community.org/job/Koha_21.05_D11/155/ 16:41 koha-jenkins Project Koha_21.05_D11 build #156: SUCCESS in 1 hr 1 min: https://jenkins.koha-community.org/job/Koha_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.org/job/Koha_21.05_D10/199/ 16:54 reiveune bye 17:48 koha-jenkins Project Koha_21.05_D10 build #200: SUCCESS in 1 hr 1 min: https://jenkins.koha-community.org/job/Koha_21.05_D10/200/ 22:32 koha-jenkins Project Koha_21.05_U_Stable build #131: SUCCESS in 32 min: https://jenkins.koha-community.org/job/Koha_21.05_U_Stable/131/ 22:36 koha-jenkins Project Koha_21.05_D11 build #157: SUCCESS in 39 min: https://jenkins.koha-community.org/job/Koha_21.05_D11/157/ 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.org/job/Koha_21.05_D12/82/ 22:53 huginn` News from kohagit: Bug 29557: DBRev 21.12.00.006 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=42491ed1c38de87fdd5ffe2c0015e06132ddc783> 22:53 huginn` News from kohagit: Bug 29788: Fix batch delete item <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=06f1a2429703bee39c2676fec645fdf3bea60355> 22:53 huginn` News from kohagit: Bug 29790: Restore warning if deletion of serial item fails <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=381898d8ca2a78319dfc9e6d8e44564754172766> 22:53 huginn` News from kohagit: Bug 29789: Remove unused $error from cataloguing/additem.pl <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d85328ee3c67ef08d2df7321150502f5f91ef87e> 22:53 huginn` News from kohagit: Bug 29788: Make Koha::Item->safe_to_delete use Koha::Result::Boolean <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=21bc236e57bfaa46b80602e3d34f0f6f2175d14a> 22:53 huginn` News from kohagit: Bug 29557: (QA follow-up) Add note for translated notices to update statement <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f2389de803a8fd59dd739d3d7f7840db43f3efb0> 22:53 huginn` News from kohagit: Bug 29688: Incorrect use of _() in holds.js <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1824b761a8626cb13ea8ba911a6e4b0bcb49c89d> 22:53 huginn` News from kohagit: Bug 29557: Add auto_account_expired to AUTO_RENEWALS <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9c10d754431260150af8336a24ad7683c8fb3538> 22:53 huginn` News from kohagit: Bug 29419: Retain user's inputs when suggesting for purchase and match found <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c780d61f90a385026f2b442767035211705fe997> 22:53 huginn` News from kohagit: Bug 17127: Remove notes from detail.tt to only use MARCNOTES <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f004ad000d288b6288c4cf131e61ba569ac9fba6> 22:54 koha-jenkins Project Koha_21.05_D9 build #129: SUCCESS in 58 min: https://jenkins.koha-community.org/job/Koha_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.org/job/Koha_21.05_U20/137/ 23:08 koha-jenkins Project Koha_21.05_U18 build #128: SUCCESS in 36 min: https://jenkins.koha-community.org/job/Koha_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.org/job/Koha_21.05_D10/201/ 23:18 koha-jenkins Project Koha_21.05_U16 build #136: SUCCESS in 42 min: https://jenkins.koha-community.org/job/Koha_21.05_U16/136/ 23:33 koha-jenkins Project Koha_21.05_U20 build #138: SUCCESS in 48 min: https://jenkins.koha-community.org/job/Koha_21.05_U20/138/ 23:41 koha-jenkins Project Koha_21.05_U_Stable build #132: SUCCESS in 32 min: https://jenkins.koha-community.org/job/Koha_21.05_U_Stable/132/ 23:51 koha-jenkins Project Koha_21.05_U21 build #69: SUCCESS in 56 min: https://jenkins.koha-community.org/job/Koha_21.05_U21/69/ 23:57 koha-jenkins Project Koha_21.05_D11 build #158: SUCCESS in 38 min: https://jenkins.koha-community.org/job/Koha_21.05_D11/158/