https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39107
Bug ID: 39107
Summary: kohastructure.sql doesn't load on new MySQL versions
Change sponsored?: ---
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Database
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
I just read the MySQL 9.2 GA announcement so felt tempted to try it with `KTD`.
It doesn't work, so I also tested other versions:
# TL;DR
* 8.0 -> OK
* 8.4 (LTS) -> FAIL
* 9.0 -> FAIL
* 9.1 -> FAIL
* 9.2 -> FAIL
Based on the error, it should be solved easily by adding a UNIQUE constraint.
To reproduce:
1. Run:
$ DB_IMAGE=mysql:9.2 ktd up
=> FAIL: "DBD::mysql::st execute failed: Failed to add the foreign key
constraint. Missing unique key for constraint 'illrequests_safk' in the
referenced table 'authorised_values' at /usr/share/perl5/DBIx/RunSQL.pm line
290, <$args{...}> line 1.
Something went wrong loading file
/kohadevbox/koha/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE
TABLE `"
2. Run:
$ DB_IMAGE=mysql:9.1 ktd up
=> FAIL: "DBD::mysql::st execute failed: Failed to add the foreign key
constraint. Missing unique key for constraint 'illrequests_safk' in the
referenced table 'authorised_values' at /usr/share/perl5/DBIx/RunSQL.pm line
290, <$args{...}> line 1.
Something went wrong loading file
/kohadevbox/koha/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE
TABLE `"
3. Run:
$ DB_IMAGE=mysql:9.0 ktd up
=> FAIL: "DBD::mysql::st execute failed: Failed to add the foreign key
constraint. Missing unique key for constraint 'illrequests_safk' in the
referenced table 'authorised_values' at /usr/share/perl5/DBIx/RunSQL.pm line
290, <$args{...}> line 1.
Something went wrong loading file
/kohadevbox/koha/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE
TABLE `"
4. Run:
$ DB_IMAGE=mysql:8.4 ktd up
=> FAIL: "DBD::mysql::st execute failed: Failed to add the foreign key
constraint. Missing unique key for constraint 'illrequests_safk' in the
referenced table 'authorised_values' at /usr/share/perl5/DBIx/RunSQL.pm line
290, <$args{...}> line 1.
Something went wrong loading file
/kohadevbox/koha/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE
TABLE `"
5. Run:
$ DB_IMAGE=mysql:8.0 ktd up
=> SUCCESS: It starts correctly.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
