Error in Koha 22.05?
Hello, I would like to point out a bug in Koha after the update to 22.05. Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs: The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore. Possibly this phenomenon is caused by the skipped update to the previous version? Many greetings Eberhard Pietzsch
Hi, I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29 Regards Fernando A. Martinez On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, could you please post more information about the issue? What error message are you seeing? Can you access the tables with SQL? Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row size too large. Then have a look at: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1 Hope this helps, Katrin On 05.07.22 12:21, Fernando A. Martinez wrote:
Hi,
I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29
Regards
Fernando A. Martinez
On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, The update completes without errors (log attached). Then I can't log into the system. (mysqlcheck log attached) Regards Fernando A. Martinez On 5/7/22 07:33, Katrin Fischer wrote:
Hi,
could you please post more information about the issue? What error message are you seeing? Can you access the tables with SQL?
Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row size too large.
Then have a look at: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1
Hope this helps,
Katrin
On 05.07.22 12:21, Fernando A. Martinez wrote:
Hi,
I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29
Regards
Fernando A. Martinez
On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
root@dev-bib:~# apt upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done The following packages were automatically installed and are no longer required: libcrypt-openssl-bignum-perl libcrypt-openssl-random-perl libcrypt-openssl-rsa-perl libdata-validate-domain-perl libdata-validate-ip-perl libdbd-sqlite2-perl libmath-base85-perl libnet-domain-tld-perl libnet-ipv6addr-perl libnetaddr-ip-perl libnetwork-ipv4addr-perl libtext-markdown-perl Use 'apt autoremove' to remove them. The following NEW packages will be installed: libauth-googleauth-perl libconvert-base32-perl libcrypt-cbc-perl libcrypt-rijndael-perl libdbd-sqlite3-perl libio-socket-ip-perl libmath-random-mt-perl The following packages have been kept back: libmojolicious-perl The following packages will be upgraded: koha-common libjson-validator-perl libmojo-jwt-perl libmojolicious-plugin-openapi-perl libtemplate-plugin-gettext-perl 5 upgraded, 7 newly installed, 0 to remove and 1 not upgraded. Need to get 46.1 MB of archives. After this operation, 17.0 MB of additional disk space will be used. Do you want to continue? [Y/n] Y Get:1 http://archive.ubuntu.com/ubuntu focal/universe amd64 libconvert-base32-perl all 0.06-1 [6546 B] Get:2 http://archive.ubuntu.com/ubuntu focal/universe amd64 libmath-random-mt-perl amd64 1.17-1build5 [13.1 kB] Get:3 http://archive.ubuntu.com/ubuntu focal/universe amd64 libcrypt-rijndael-perl amd64 1.14-1build1 [17.3 kB] Get:4 http://archive.ubuntu.com/ubuntu focal/universe amd64 libcrypt-cbc-perl all 2.33-2 [23.5 kB] Get:5 http://archive.ubuntu.com/ubuntu focal/universe amd64 libdbd-sqlite3-perl amd64 1.64-1build1 [154 kB] Get:6 http://debian.koha-community.org/koha 22.05/main amd64 libauth-googleauth-perl all 1.03-1 [13.1 kB] Get:7 http://debian.koha-community.org/koha 22.05/main amd64 libjson-validator-perl all 5.99+really5.08-koha1 [98.2 kB] Get:8 http://debian.koha-community.org/koha 22.05/main amd64 libmojo-jwt-perl all 0.09-1-koha1 [12.1 kB] Get:9 http://debian.koha-community.org/koha 22.05/main amd64 libmojolicious-plugin-openapi-perl all 5.99+really5.05-koha1 [67.4 kB] Get:10 http://debian.koha-community.org/koha 22.05/main amd64 libtemplate-plugin-gettext-perl all 0.6-1~koha2 [22.8 kB] Get:11 http://debian.koha-community.org/koha 22.05/main amd64 koha-common all 22.05.02-1 [45.6 MB] Get:12 http://debian.koha-community.org/koha 22.05/main amd64 libio-socket-ip-perl all 0.41-1 [30.5 kB] Fetched 46.1 MB in 1min 59s (386 kB/s) Preconfiguring packages ... Selecting previously unselected package libconvert-base32-perl. (Reading database ... 92638 files and directories currently installed.) Preparing to unpack .../00-libconvert-base32-perl_0.06-1_all.deb ... Unpacking libconvert-base32-perl (0.06-1) ... Selecting previously unselected package libmath-random-mt-perl. Preparing to unpack .../01-libmath-random-mt-perl_1.17-1build5_amd64.deb ... Unpacking libmath-random-mt-perl (1.17-1build5) ... Selecting previously unselected package libauth-googleauth-perl. Preparing to unpack .../02-libauth-googleauth-perl_1.03-1_all.deb ... Unpacking libauth-googleauth-perl (1.03-1) ... Selecting previously unselected package libcrypt-rijndael-perl. Preparing to unpack .../03-libcrypt-rijndael-perl_1.14-1build1_amd64.deb ... Unpacking libcrypt-rijndael-perl (1.14-1build1) ... Selecting previously unselected package libcrypt-cbc-perl. Preparing to unpack .../04-libcrypt-cbc-perl_2.33-2_all.deb ... Unpacking libcrypt-cbc-perl (2.33-2) ... Selecting previously unselected package libdbd-sqlite3-perl:amd64. Preparing to unpack .../05-libdbd-sqlite3-perl_1.64-1build1_amd64.deb ... Unpacking libdbd-sqlite3-perl:amd64 (1.64-1build1) ... Preparing to unpack .../06-libjson-validator-perl_5.99+really5.08-koha1_all.deb ... Unpacking libjson-validator-perl (5.99+really5.08-koha1) over (5.99+really3.14-koha1) ... Preparing to unpack .../07-libmojo-jwt-perl_0.09-1-koha1_all.deb ... Unpacking libmojo-jwt-perl (0.09-1-koha1) over (0.08-1) ... Preparing to unpack .../08-libmojolicious-plugin-openapi-perl_5.99+really5.05-koha1_all.deb ... Unpacking libmojolicious-plugin-openapi-perl (5.99+really5.05-koha1) over (5.99+really2.16-koha1) ... Preparing to unpack .../09-libtemplate-plugin-gettext-perl_0.6-1~koha2_all.deb ... Unpacking libtemplate-plugin-gettext-perl (0.6-1~koha2) over (0.6-1~koha1) ... Preparing to unpack .../10-koha-common_22.05.02-1_all.deb ... Unpacking koha-common (22.05.02-1) over (21.11.09-3) ... Selecting previously unselected package libio-socket-ip-perl. Preparing to unpack .../11-libio-socket-ip-perl_0.41-1_all.deb ... Unpacking libio-socket-ip-perl (0.41-1) ... Setting up libio-socket-ip-perl (0.41-1) ... Setting up libcrypt-rijndael-perl (1.14-1build1) ... Setting up libjson-validator-perl (5.99+really5.08-koha1) ... Setting up libmath-random-mt-perl (1.17-1build5) ... Setting up libcrypt-cbc-perl (2.33-2) ... Setting up libmojolicious-plugin-openapi-perl (5.99+really5.05-koha1) ... Setting up libdbd-sqlite3-perl:amd64 (1.64-1build1) ... Setting up libtemplate-plugin-gettext-perl (0.6-1~koha2) ... Setting up libmojo-jwt-perl (0.09-1-koha1) ... Setting up libconvert-base32-perl (0.06-1) ... Setting up libauth-googleauth-perl (1.03-1) ... Setting up koha-common (22.05.02-1) ... Installing new version of config file /etc/cron.daily/koha-common ... Installing new version of config file /etc/init.d/koha-common ... Installing new version of config file /etc/koha/SIPconfig.xml ... Installing new version of config file /etc/koha/koha-conf-site.xml.in ... Installing new version of config file /etc/koha/zebradb/marc_defs/marc21/biblios/biblio-zebra-indexdefs.xsl ... Upgrading database schema for dev-bib Upgrade to 21.12.00.000 [07:52:52]: Increase DBRev for 21.12 📜 All that is gold does not glitter, 📜 Not all those who wander are lost; 📜 The old that is strong does not wither, 📜 Deep roots are not reached by the frost. Upgrade to 21.12.00.001 [07:52:52]: Bug 29586 - Add Hold Reminder messaging preference if missing Upgrade to 21.12.00.002 [07:52:53]: Bug 13188 - Allow configuration of required fields when a patron is editing their information via the OPAC Added new system preference 'PatronSelfModificationMandatoryField' with value '' Upgrade to 21.12.00.003 [07:52:53]: Bug 29457 - Fee Cancellation records the wrong manager_id WARNING: You may have some incorrect manager_id's recorded against account cancellation lines, please see bugzilla for details. NOTE: You may already have this bugfix applied at an earlier upgrade. Upgrade to 21.12.00.004 [07:52:53]: Bug 26296 - Replace comma with pipe in OPACSuggestion field preferences Upgrade to 21.12.00.005 [07:52:53]: Bug 29778 - Delete orphan additional contents Upgrade to 21.12.00.006 [07:52:53]: Bug 29557 - Add auto_account_expired to AUTO_RENEWALS notice Please update your AUTO_RENEWALS notice manually if you have changed or translated it Upgrade to 21.12.00.007 [07:52:53]: Bug 20076 - Add system preference EmailOverduesNoEmail Upgrade to 21.12.00.008 [07:52:53]: Bug 29495 - Drop issue_id constraint from return_claims table Upgrade to 21.12.00.009 [07:52:54]: Bug 29336 - Resize authorised value category fields to 32 chars Upgrade to 21.12.00.010 [07:52:55]: Bug 21729 - Add new column reserves.patron_expiration_date Upgrade to 21.12.00.011 [07:52:55]: Bug 27946 - Add article request fees Upgrade to 21.12.00.012 [07:52:55]: Bug 24220 - Move OpacMoreSearches to additional contents No OpacMoreSearches preference found. Value was empty or update has already been run. Upgrade to 21.12.00.013 [07:52:56]: Bug 29605 - Resync DB structure for existing installations Ensure NOT NULL on account_offsets.type Ensure additional_contents.code is VARCHAR(100) Ensure additional_contents.lang is VARCHAR(50) Ensure NOT NULL on search_marc_map.marc_type Ensure branchtransfers.cancellation_reason enum values are uppercase Upgrade to 21.12.00.014 [07:52:56]: Bug 29596 - Add Yiddish language Upgrade to 21.12.00.015 [07:52:56]: Bug 29943 - Fix typo in NOTIFY_MANAGER notice Upgrade to 21.12.00.016 [07:52:58]: Bug 30060 - Update user_permissions to add primary key and remove null option from code column Removed any duplicate rows Added a primary key on user_permissions on borrowernumber, module_bit, code Upgrade to 21.12.00.017 [07:52:58]: Bug 30128 - Change language_subtag_registry.description to varchar(255) Upgrade to 21.12.00.018 [07:52:58]: Bug 19532 - Add Recalls Upgrade to 21.12.00.019 [07:52:58]: Bug 27812 - Remove the ability to transmit a patron's plain text password over email The notice template ACCTDETAILS no longer has access to the patron's plain text password. Please update the language of your ACCTDETAILS as needed. Upgrade to 21.12.00.020 [07:52:58]: Bug 24221 - Move OpacMySummaryNote to additional contents No OpacMySummaryNote preference found. Value was empty or update has already been run. Upgrade to 21.12.00.021 [07:52:58]: Bug 30063 - Fix DefaultPatronSearchFields order Upgrade to 21.12.00.022 [07:52:58]: Bug 11083 - Add syspref AuthorityXSLTResultsDisplay Upgrade to 21.12.00.023 [07:52:58]: Bug 20517 - Add SIP2SortBinMapping system preference Upgrade to 21.12.00.024 [07:52:58]: Bug 20398 - Add system preference StaffHighlightedWords Upgrade to 21.12.00.025 [07:52:58]: Bug 29990 - Add new system preference ShowHeadingUse Upgrade to 21.12.00.026 [07:52:58]: Bug 17018 - Split AdvancedSearchTypes for staff and OPAC Upgrade to 21.12.00.027 [07:52:59]: Bug 26346 - Add allow_change_from_staff to virtualshelves table Upgrade to 21.12.00.028 [07:52:59]: Bug 16258 - A preference to enabled/disable edifact Upgrade to 21.12.00.029 [07:52:59]: Bug 30130 - A standard to edi_account Upgrade to 21.12.00.030 [07:52:59]: Bug 30135 - Add EdifactLSQ mapping system preference Upgrade to 21.12.00.031 [07:52:59]: Bug 30481 - DB schema sync for deleteditems Upgrade to 21.12.00.032 [07:52:59]: Bug 30498 - Correct enum search_field.type Upgrade to 21.12.00.033 [07:52:59]: Bug 27783 - Add background_jobs.queue Added background_jobs.queue Upgrade to 21.12.00.034 [07:52:59]: Bug 30237 - Replace ACCDETAILS notice with WELCOME notice Upgrade to 21.12.00.035 [07:52:59]: Bug 30226 - Add the system preference AllowSetAutomaticRenewal Upgrade to 21.12.00.036 [07:53:00]: Bug 28786 - Add syspref TwoFactorAuthentication, fields secret and auth_method Upgrade to 21.12.00.037 [07:53:00]: Bug 27253 - Fix definition of borrowers.updated_on and deletedborrowers.updated_on Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated Updated all NULL values of borrowers.updated_on to GREATEST(date_renewed, dateenrolled, lastseen): 0 rows updated Fixed definition of borrowers.updated_on Fixed definition of deletedborrowers.updated_on Upgrade to 21.12.00.038 [07:53:00]: Bug 29648 - Move NumSavedReports to table settings and allow tables_settings.default_display_length to be NULL NumSavedReports value '20' moved to table settings Upgrade to 21.12.00.039 [07:53:00]: Bug 29092 - Add timestamp to account-fines table column settings Upgrade to 21.12.00.040 [07:53:00]: Bug 30565 - Update table stockrotationrotas Upgrade to 21.12.00.041 [07:53:00]: Bug 30449 - Check borrower_attribute_types FK constraint Upgrade to 21.12.00.042 [07:53:00]: Bug 30572 - Adjust search_marc_to_field.sort Upgrade to 21.12.00.043 [07:53:00]: Bug 30108 - Add preference OPACMandatoryHoldDates Upgrade to 21.12.00.044 [07:53:00]: Bug 29894 - Add 2FA (de)enabling notices Upgrade to 21.12.00.045 [07:53:00]: Bug 14242 - Add OPACSuggestionAutoFill system preference Upgrade to 21.12.00.046 [07:53:00]: Bug 22785 - Add chosen column to import_record_matches chosen column added to import_record_matches Upgrade to 21.12.00.047 [07:53:00]: Bug 28138 - Add system preference RequirePaymentType Upgrade to 21.12.00.048 [07:53:01]: Bug 30291 - Renaming recalls table columns Upgrade to 21.12.00.049 [07:53:01]: Bug 30563 - Add system preference RequireCashRegister Upgrade to 21.12.00.050 [07:53:01]: Bug 29924 - Add password expiration Added password_expiry_days to categories Added password_expiration_date field to borrowers Added password_expiration_date field to borrowers Upgrade to 21.12.00.051 [07:53:01]: Bug 29925 - Add password reset option Upgrade to 21.12.00.052 [07:53:01]: Bug 30290 - Modify AR notices, include TOC line Upgrade to 21.12.00.053 [07:53:01]: Bug 30611 - Add STAFF_PASSWORD_RESET notice Upgrade to 21.12.00.054 [07:53:02]: Bug 23352 - Adding new column 'subscription.ccode' Upgrade to 21.12.00.055 [07:53:02]: Bug 13412 - Add GenerateAuthorityField667 and GenerateAuthorityField670 system preferences Upgrade to 21.12.00.056 [07:53:02]: Bug 30728 - Allow opting out of real-time holds queue updating possible Upgrade to 21.12.00.057 [07:53:02]: Bug 30852 - Add index to article_requests.debit_id Upgrade to 22.05.00.000 [07:53:02]: Koha 22.05.00 release Upgrade to 22.05.00.001 [07:53:02]: Bug 23659 - Add DefaultHoldPickupLocation syspref Added DefaultHoldPickupLocation syspref Upgrade to 22.05.02.000 [07:53:02]: Koha 22.05.02 release DEV atomic update /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/bug_30899.pl [07:53:02]: Bug 30899 - Check borrower_attribute_types FK constraint (30449 follow-up) Connection to the memcached servers '__MEMCACHED_SERVERS__' failed. Are the unix socket permissions set properly? Is the host reachable? If you ignore this warning, you will face performance issues Updated the es-ES translations. Enabling plugins on node rabbit@dev-bib: rabbitmq_stomp The following plugins have been configured: rabbitmq_stomp Applying plugin configuration to rabbit@dev-bib... Plugin configuration unchanged. Failed to enable unit: Unit /run/systemd/generator.late/koha-common.service is transient or generated. Processing triggers for man-db (2.9.1-1) ... Processing triggers for systemd (245.4-4ubuntu3.17) ... ============================================= root@dev-bib:~# mysqlcheck -p koha_test borrowers Enter password: koha_test.borrowers Warning : InnoDB: The B-tree of index PRIMARY is corrupted. Warning : InnoDB: Index 'cardnumber' contains 1594 entries, should be 18446744073709551615. Warning : InnoDB: Index 'userid' contains 1594 entries, should be 18446744073709551615. Warning : InnoDB: Index 'categorycode' contains 1594 entries, should be 18446744073709551615. Warning : InnoDB: Index 'branchcode' contains 1594 entries, should be 18446744073709551615. Warning : InnoDB: Index 'surname_idx' contains 1594 entries, should be 18446744073709551615. Warning : InnoDB: Index 'firstname_idx' contains 1594 entries, should be 18446744073709551615. Warning : InnoDB: Index 'othernames_idx' contains 1594 entries, should be 18446744073709551615. Warning : InnoDB: Index 'sms_provider_id' contains 1594 entries, should be 18446744073709551615. error : Corrupt root@dev-bib:~# mysqlcheck -p koha_test deletedborrowers Enter password: koha_test.deletedborrowers Warning : InnoDB: The B-tree of index GEN_CLUST_INDEX is corrupted. Warning : InnoDB: Index 'borrowernumber' contains 200 entries, should be 18446744073709551615. Warning : InnoDB: Index 'cardnumber' contains 200 entries, should be 18446744073709551615. Warning : InnoDB: Index 'sms_provider_id' contains 200 entries, should be 18446744073709551615. error : Corrupt root@dev-bib:~# Fernando A. Martinez On 5/7/22 08:04, Fernando A. Martinez wrote:
Hi,
The update completes without errors (log attached). Then I can't log into the system. (mysqlcheck log attached) Regards
Fernando A. Martinez
On 5/7/22 07:33, Katrin Fischer wrote:
Hi,
could you please post more information about the issue? What error message are you seeing? Can you access the tables with SQL?
Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row size too large.
Then have a look at: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1
Hope this helps,
Katrin
On 05.07.22 12:21, Fernando A. Martinez wrote:
Hi,
I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29
Regards
Fernando A. Martinez
On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Attached you see an dump of the borrowers table. You can see at the insert statement that the contents are shifted by a few bytes. Some attributes are new compared with earliver versions of Koha. (I have edited the encrypted password) Eberhard
Katrin Fischer <katrin.fischer.83@web.de> hat am 05.07.2022 12:33 CEST geschrieben:
Hi,
could you please post more information about the issue? What error message are you seeing? Can you access the tables with SQL?
Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row size too large.
Then have a look at: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1
Hope this helps,
Katrin
On 05.07.22 12:21, Fernando A. Martinez wrote:
Hi,
I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29
Regards
Fernando A. Martinez
On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Eberhard, I'm interested to see your borrowers table, too. Can you try to resend the dump file (or copy and paste a few rows into the message thread)? The attachment didn't come through. -Evan Stewart On Tue, Jul 5, 2022 at 6:20 AM Dr. Eberhard Pietzsch <eberhard@pietzsch.org> wrote:
Attached you see an dump of the borrowers table. You can see at the insert statement that the contents are shifted by a few bytes. Some attributes are new compared with earliver versions of Koha.
(I have edited the encrypted password)
Eberhard
Katrin Fischer <katrin.fischer.83@web.de> hat am 05.07.2022 12:33 CEST geschrieben:
Hi,
could you please post more information about the issue? What error message are you seeing? Can you access the tables with SQL?
Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row size too large.
Then have a look at: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1
Hope this helps,
Katrin
On 05.07.22 12:21, Fernando A. Martinez wrote:
Hi,
I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29
Regards
Fernando A. Martinez
On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Eberhard, I am not sure if the problem would be visible in the data. Maybe some ideas what to try instead: * Can you reset the password of your user? This would require the password recovery feature to be enabled. * Can you log in with a new superlibrarian account created from command line? (http://kohageek.blogspot.com/2018/07/create-super-librarian-by-command-line....) * What is the message shown when you try to log in? Is there anything visible in the logs when the login fails? Hope this helps, Katrin On 05.07.22 14:19, Dr. Eberhard Pietzsch wrote:
Attached you see an dump of the borrowers table. You can see at the insert statement that the contents are shifted by a few bytes. Some attributes are new compared with earliver versions of Koha.
(I have edited the encrypted password)
Eberhard
Katrin Fischer <katrin.fischer.83@web.de> hat am 05.07.2022 12:33 CEST geschrieben:
Hi,
could you please post more information about the issue? What error message are you seeing? Can you access the tables with SQL?
Is this the error maybe: DBI Exception: DBD::mysql::db do failed: Row size too large.
Then have a look at: *Bug 28267* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267> - Koha-common package upgrade problem from 20.05.xx to 20.11.04-1
Hope this helps,
Katrin
On 05.07.22 12:21, Fernando A. Martinez wrote:
Hi,
I have the same problem. Corrupted tables: borrowers and deletedborrowers. Update: Koha 22.05.02 over Koha 21.11.09 Ubuntu 20.04 LTS MySQL version 8.0.29
Regards
Fernando A. Martinez
On 5/7/22 04:35, Dr. Eberhard Pietzsch wrote:
Hello,
I would like to point out a bug in Koha after the update to 22.05.
Koha is also included in the package management of Ubuntu 22.04 LTS and can be updated together with Ubuntu. I had skipped the short time preceding Koha update because of errors. However, the current update to 22.05 apparently also contains bugs:
The structure of the borrowers table seems to have been changed compared to previous versions. Existing user data are not correctly loaded into the new structured table with the update, so that no login, e.g. as superlibrarian, is possible anymore.
Possibly this phenomenon is caused by the skipped update to the previous version?
Many greetings Eberhard Pietzsch _______________________________________________
Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Dr. Eberhard Pietzsch -
Evan Stewart -
Fernando A. Martinez -
Katrin Fischer