Bug 24442 - Setup Database fails: Cannot delete or update parent row: foreign key constraint fails
Summary: Setup Database fails: Cannot delete or update parent row: foreign key constra...
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: 19.11
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-01-17 07:34 UTC by Seema Albal
Modified: 2020-11-30 21:44 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Seema Albal 2020-01-17 07:34:15 UTC
I have the SQL server on Google Cloud which is a remote DB. The setup succeeded and I got the web installer running. In the web installer, the setup of database fails. 
On checking the db, there are some 52 tables that are created in the database. 

The setup fails because ISAM engine is disabled. Found that Cloud SQL has disabled ISAM and only uses InnoDB.

Is there a workaround to setup Koha on Google Cloud?
Comment 1 Katrin Fischer 2020-01-17 09:42:20 UTC
Hi Seema, 

as this is more of an installation issue/setup question, please ask your question on the mailing list (https://koha-community.org/support/koha-mailing-lists/) instead - many more people will be reading you there and be able to help out with their experience. If it's determined to be a bug, we can reopen this one later. Only bugs and enhancement requests should be reported on bugzilla.