Skip to content

MySQL no longer needs length of int variables to be specified #1701

Open
@brucemiranda

Description

The schema.php files have table declaration arrays. These arrays have lengths for the int datatypes. However mySQL now gives a warning when trying to apply a length to an int datatype. However because of the way the comparison of the table description and the schema arrays works, emoncms marks these as Updates to be applied. But these can never be applied and so you land up in a loop.
This is true atleast on mySQL Version 8.0.25-0ubuntu0.20.04.1

Issue and Solution discussed here. https://community.openenergymonitor.org/t/update-database-changes-not-being-applied/18049

Either need to update the schema definitions to remove the int lengths or create a more intelligent table description comparison

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