Skip to content

Errors Loading Stub file When using MySQL Geometry #224

@coogle

Description

@coogle

I have a table of about 1,700 rows of data using the following schema (screenshot). I wanted to convert this table into a seeder file but it doesn't seem to be working.

image

The generation part works okay it seems, no errors at least. It does produce a bit of a funky formatted seed file though. See the following screenshot:

image

What I've discovered is that, for some reason, the seeder script breaks immediately after trying to insert the next block based on chunksize.. e.g. if chunksize == 1, it breaks on the 2nd insert...

The error I am getting is as follows:

SQLSTATE[22003]: Numeric value out of range: 1416 Cannot get geometry object from data you send to the GEOMETRY field (SQL: insert into `dump_sites` (`created_at`, `description`, `id`, `location`, `name`, `price_range`, `updated_at`) values
.....

It appears that this export generator doesn't support geometric data?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions