Skip to content

Error 1170 When using MariaDB #15

Description

@JoshSmithCode

When using MariaDB there seems to be an inherit violation of the version column ebing used as a primary key without a key length being specified.

See the error -
Migration execution error: Request to mariadb://root:_@host.docker.internal:3306/ocaml_blog failed: Error 1170, BLOB/TEXT column 'version' used in key specification without a key length. Query: "CREATE TABLE IF NOT EXISTS petrol_blog_schema_version_db (version TEXT PRIMARY KEY\nNOT NULL)".

I was looking for a way to overwrite or set preferred column types for these values, but none seem to exist. Not sure if that would be the preferred way to fix or if there's something more elegant, but for now I assume I could just swap to another DB driver as I'm only working on a small-scale project.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions