Error: 1252 - SQLSTATE: 42000 ER_SPATIAL_CANT_HAVE_NULL

Description:
Message: All parts of a SPATIAL index must be NOT NULL

MySql-Server , , , , ,

  1. admin
    May 7th, 2009 at 00:45 | #1

    Spatial indexes are created using SPATIAL INDEX statement and are available only for MyISAM tables. Index columns must be NOT NULL and column prefix lenghts are not allowed (in MySQL 5.1). See Spatial Extensions for details at http://dev.mysql.com/doc/refman/5.1/en/spatial-extensions.html.

  1. No trackbacks yet.