search

ODM2 / WOFpy

A server-side implementation of CUAHSI's Water One Flow service stack in Python.
http://odm2.github.io/WOFpy/
9 stars 9 forks source link

LBR MySQL Small ODM2 example fails to load in MySQL 5.7 #74

Open miguelcleon opened 7 years ago

miguelcleon commented 7 years ago

The latest version of MySQL (5.7) won’t load the samplingfeature geometries in the LBR database (https://github.com/ODM2/ODM2/blob/master/usecases/littlebearriver/sampledatabases/odm2_mysql/LBR_MySQL_SmallExample.sql). Importing the database fails while loading samplingfeatures on MySQL 5.7. So right now you need version 5.6 if your installing MySQL fresh.

This post on stack over flow discusses this problem:

http://stackoverflow.com/questions/34311195/mysql-import-cannot-get-geometry-object-from-data-you-send-to-the-geometry-fiel

emiliom commented 7 years ago

For follow-ups, the error apparently is this one (based on the stack overflow thread, above):

Error 'Cannot get geometry object from data you send to the GEOMETRY field' on query.

And here's a Google search on that error message and MySQL 5.7, to help us get at the source of this problem.

My hunch is that this isn't a fundamental incompatibility with 5.7 per se, but rather an issue with how the MySQL LBR SQL load file was created (with a previous MySQL version) that makes it less portable for loading into newer MySQL versions. Will need to investigate.

emiliom commented 7 years ago

Forgot to add: As mentioned in our installation document, the LBR test database has been successfully tested with MySQL 5.6 and 5.5 (not just 5.6).