LBR MySQL Small ODM2 example fails to load in MySQL 5.7

[miguelcleon]

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]

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]

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).