3306
MySQLERRORNotableSpatial / GISHIGH confidence
Spatial Reference System not found
Production Risk
Low — query fails; no data is modified.
How to reproduce
trigger — this will error
trigger — this will error
SELECT ST_AsText(ST_GeomFromText('POINT(0 0)', 99999));expected output
ERROR 3306 (SR001): There's no spatial reference system with SRID 99999.
Fix
Use a known SRID
Use a known SRID
SELECT ST_AsText(ST_GeomFromText('POINT(0 0)', 4326));Why this works
SRID 4326 is the WGS 84 geographic CRS and is always available.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3306 ER_SRS_NOT_FOUND3
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev