| 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/ |
