search

performant-software / Neatline

A lightweight framework for building interactive maps and publishing them on the web.
www.neatline.org
Other
105 stars 34 forks source link

MariaDB - > MySQL Migration GEOMETRY Issue? Running 2.6.4 #511

Open WorksAtAUni opened 2 months ago

WorksAtAUni commented 2 months ago

Did anyone ever resolve the GEOMETRY bug and or migration issues from MariaDB to MySQL 8 fully? Or is this a question of somehow identifying every misaligned record fixing it, and moving

We've looked for Nulls, and they aren't there and my reading of this: https://github.com/performant-software/Neatline/issues/490

I think, seems to direct us to update to the MySQL data type to POLYGON (on create table?) and figure out manually how the polygon is busted and then migrate?

And that sort of leads to this comment but not sure if the feature was implemented.
https://github.com/scholarslab/Neatline/tree/bug/mysql-functions and looking at https://github.com/performant-software/Neatline/issues/292 underneath (unimplemented feature) seems to tell me we have things to do but curious what others have done to make it go properly?

We are running the latest plugin that I am aware of, 2.6.4

Just feel like I missed a post or a step somewhere that would make this all go away... lol (and we have a lot of sites)

WorksAtAUni commented 2 months ago

Are we in the uncomfortable position of having to either delete problematic records and recreate them or somehow identifying and addressing the underlying issue ourselves and seeing if it is delete/recreate/somehow edit for each record (the NULL troubleshooting advice didn't turn anything up). MySQL supports Geometry collections as used with MariaDB (I think, pretty sure) and just wondering if there is an approach beyond getting up to speed on WKT or if there is an ETL approach that has worked for you all?