3305
MariaDBERRORNotableSpatial / GISHIGH confidence
Spatial Reference System projection parameter is missing
Production Risk
Low — DDL fails cleanly.
How to reproduce
trigger — this will error
trigger — this will error
-- CREATE SRS with a PROJCS WKT that omits a required PARAMETER clause.
expected output
ERROR 3305 (SR002): Mandatory parameter missing from SRS definition.
Fix
Include all required parameters
Include all required parameters
-- Add PARAMETER["central_meridian", 0] etc. to the PROJCS WKT.
Why this works
MySQL validates that all projection-specific mandatory parameters are present.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3305 ER_SRS_PROJ_PARAMETER_MISSING
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev