MariaDB Error 1687 – ER_SPATIAL_MUST_HAVE_GEOM_COL

In this post, you’ll learn more about the MariaDB Error 1687 ER_SPATIAL_MUST_HAVE_GEOM_COL with the details of the error message and why you receive this error

Maria DB Error Description

MariaDB Error 1687 – ER_SPATIAL_MUST_HAVE_GEOM_COL with the sqlState 42000

Error Description for the MariaDB Error ER_SPATIAL_MUST_HAVE_GEOM_COL

A SPATIAL index may only contain a geometrical type column