search

grimzy / laravel-mysql-spatial

MySQL Spatial Data Extension integration with Laravel.
Other
796 stars 316 forks source link

Syntax error with Laravel 8, MariaDB 10.6 and SRID #179

Open kakojak opened 3 years ago

kakojak commented 3 years ago

I wanna switch from MySQL 8.0 to MariaDB 10.6 but its not possible with version 4 of laravel-mysql-spatial.

Migration: $table->point('coordinates',4326)->nullable(); $table->multiPolygon('boundaries',4326)->nullable();

Not possible with MariaDB -> error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '4326, boundaries MULTIPOLYGON null srid 4326' at line 1

With MySQL 8.0 it works fine.

H-ishak commented 2 years ago

MariaDB doesnt support creating a column with an SRID i think

B2rana commented 11 months ago

Any fix for this issue?