[Koha] Error during Koha 20.11 installation

[Pocholo Fermin]

Hi there,

I'm trying to setup Koha 20.11 on my Ubuntu 20.04 LTS server. I followed the steps in Koha on ubuntu - packages page (https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Appendix_A:_Named-based_vs._IP-based_installations).

I installed MySQL server instead of MariaDB. I can visit the administration website to continue with the Koha web installer. I can login with the given username and password. The succeeding setup steps are fine. But when I get to the step "Now we're ready to create the database tables and fill them with some default data."...I am getting the following error and cannot further proceed with the setup.

The following error occurred while importing the database structure:

[Sun Apr 18 15:05:07 2021] install.pl: DBD::mysql::st execute failed: Cannot drop table 'auth_types' referenced by a foreign key constraint 'auth_subfield_structure_ibfk_1' on table 'auth_subfield_structure'. at /usr/share/perl5/DBIx/RunSQL.pm line 279, <$args{...}> line 1. [Sun Apr 18 15:05:07 2021] install.pl: Something went wrong loading file /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql ([SQL ERROR]: [Sun Apr 18 15:05:07 2021] install.pl: -- [Sun Apr 18 15:05:07 2021] install.pl: -- Table structure for table `auth_types` [Sun Apr 18 15:05:07 2021] install.pl: -- [Sun Apr 18 15:05:07 2021] install.pl: [Sun Apr 18 15:05:07 2021] install.pl: DROP TABLE IF EXISTS `auth_types` [Sun Apr 18 15:05:07 2021] install.pl: ) at /usr/share/koha/lib/C4/Installer.pm line 564.

Please contact your system administrator

Any idea how I can resolve this?
Thank you very much for your assistance.

Best regards,
Pocholo
Pocholo Fermin | Head of Information Technology | Secondary School
Butuka Academy | p: P. O. Box 2007 Vision City Waigani NCD
a: Sec 128 Lot 18 Pari Road Kila Kila, National Capital District, PG
p: +675 340 2836 | Ext 8000 | m: +675 7834 8984 | w: www.butukaacademy.ac.pg<https://www.butukaacademy.ac.pg>

Breach of Confidentiality

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.