← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 | 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 | After some debugging, I think its because one column has COLLATE but the other one doesn't | |
| 10:47 | Has anyone experienced this? | |
| 10:47 | 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 | 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 | 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 | The foreign key is added correctly | |
| 10:54 | Joubu | did you identify other table that does not have this collate? |
| 10:55 | 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 | I get accountlines, accountoffsets, action_logs and alert | |
| 10:59 | All of them with utf8_general_ci | |
| 11:02 | Joubu | I have no idea why, but it's wrong |
| 11:03 | ALTER TABLE $table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci | |
| 11:03 | 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 | *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 | wahanui botsnack cookie | |
| 13:53 | wahanui | thanks cait1 :) |
| 14:05 | oleonard | Find any good bugs cait1 ? |
| 14:09 | cait1 | the usual |
| 14:10 | acutally the filter on paid/unpaid transactions seems to be broken :D | |
| 14:10 | 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 | 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 | Project Koha_21.05_U20 build #136: SUCCESS in 32 min: https://jenkins.koha-community[…]ha_21.05_U20/136/ | |
| 15:37 | Project Koha_21.05_D12 build #81: UNSTABLE in 1 hr 6 min: https://jenkins.koha-community[…]oha_21.05_D12/81/ | |
| 15:40 | Project Koha_21.05_U16 build #135: SUCCESS in 1 hr 9 min: https://jenkins.koha-community[…]ha_21.05_U16/135/ | |
| 15:42 | Project Koha_21.05_U18 build #127: SUCCESS in 1 hr 12 min: https://jenkins.koha-community[…]ha_21.05_U18/127/ | |
| 15:49 | 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 | 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 | 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 | News from kohagit: Bug 29788: Fix batch delete item <https://git.koha-community.org[…]ec645fdf3bea60355> | |
| 22:53 | News from kohagit: Bug 29790: Restore warning if deletion of serial item fails <https://git.koha-community.org[…]d8e44564754172766> | |
| 22:53 | News from kohagit: Bug 29789: Remove unused $error from cataloguing/additem.pl <https://git.koha-community.org[…]1150502f5f91ef87e> | |
| 22:53 | News from kohagit: Bug 29788: Make Koha::Item->safe_to_delete use Koha::Result::Boolean <https://git.koha-community.org[…]3d34f0f6f2175d14a> | |
| 22:53 | News from kohagit: Bug 29557: (QA follow-up) Add note for translated notices to update statement <https://git.koha-community.org[…]d7f7840db43f3efb0> | |
| 22:53 | News from kohagit: Bug 29688: Incorrect use of _() in holds.js <https://git.koha-community.org[…]11a6e4b0bcb49c89d> | |
| 22:53 | News from kohagit: Bug 29557: Add auto_account_expired to AUTO_RENEWALS <https://git.koha-community.org[…]a24ad7683c8fb3538> | |
| 22:53 | News from kohagit: Bug 29419: Retain user's inputs when suggesting for purchase and match found <https://git.koha-community.org[…]767035211705fe997> | |
| 22:53 | 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 | Project Koha_21.05_U20 build #137: SUCCESS in 1 hr 4 min: https://jenkins.koha-community[…]ha_21.05_U20/137/ | |
| 23:08 | Project Koha_21.05_U18 build #128: SUCCESS in 36 min: https://jenkins.koha-community[…]ha_21.05_U18/128/ | |
| 23:16 | Project Koha_21.05_D10 build #201: SUCCESS in 1 hr 17 min: https://jenkins.koha-community[…]ha_21.05_D10/201/ | |
| 23:18 | Project Koha_21.05_U16 build #136: SUCCESS in 42 min: https://jenkins.koha-community[…]ha_21.05_U16/136/ | |
| 23:33 | Project Koha_21.05_U20 build #138: SUCCESS in 48 min: https://jenkins.koha-community[…]ha_21.05_U20/138/ | |
| 23:41 | Project Koha_21.05_U_Stable build #132: SUCCESS in 32 min: https://jenkins.koha-community[…].05_U_Stable/132/ | |
| 23:51 | Project Koha_21.05_U21 build #69: SUCCESS in 56 min: https://jenkins.koha-community[…]oha_21.05_U21/69/ | |
| 23:57 | Project Koha_21.05_D11 build #158: SUCCESS in 38 min: https://jenkins.koha-community[…]ha_21.05_D11/158/ |
← Previous day | Today | Next day → | Search | Index