Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL example causes errors #302

Open
foundryspatial-duncan opened this issue Dec 8, 2016 · 0 comments
Open

MySQL example causes errors #302

foundryspatial-duncan opened this issue Dec 8, 2016 · 0 comments

Comments

@foundryspatial-duncan
Copy link

When I try to run the example SQL dump, LittleBear_ODM_1.1.1_MySQL.sql, it throws some errors when adding the foreign keys:

Cannot add or update a child row: a foreign key constraint fails (`odmtest`.`#sql-1_4`, CONSTRAINT `FK_DataValues_OffsetTypes` FOREIGN KEY (`OffsetTypeID`) REFERENCES `offsettypes` (`OffsetTypeID`) ON DELETE NO ACTION ON UPDATE NO ACTION)

This is using specifically the gdevt/mysql-case-insensitive Docker image.
On a MySQL server that does have case sensitive table names, I got even more errors, but this one looks like it's caused by the datavalues table having a value of 0 for OffsetTypeID but the offsettypes table only has values for 1 and 2.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant