Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Bug - Single enum value results in bad query

Anonymous
2012-03-28
2013-06-06

  • Anonymous
    2012-03-28

    For whatever reason, the bug tracker isn't saving my bug submission, so I'll post it here.

    Using MySQL and Adminer 3.3.4 -

    When I try to set just a single enum length when creating a table, adminer doesn't provide anything in the ENUM() declaration in the query, as highlighted in the attached file, resulting in an errored query. If I add an extra enumerated value, the create table works fine.

    On the lower half of the attached file, it results in the same error if I try to reduce the enumerated column to just one value, as well.

    Screenshot:

     
  • Jakub Vrána
    Jakub Vrána
    2012-04-15

    You need to put single quotes around the single value. Adminer supports 'a','b','c' in enum value (for copy/pasting from somewhere else) so it is required to use single quotes if there is just one line.

    Adminer needs to support also crazy shit like 'don\'t' which is why it cannot be automatic.