Help save net neutrality! Learn more.
Close

#388 Not user-friendly error on varchar column without length

4.0.3
closed-wont-fix
nobody
2
2014-08-08
2014-02-24
No

While creating table, when you add a column with type varchar and don't specify its lenght, you get and SQL error

Syntax error near 'NULL ) COMMENT=''' at line 4 23:36:44 SQL command
CREATE TABLE `group` (
  `id` int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `label` varchar(32) NOT NULL,
  `description` varchar NULL
) COMMENT=''; -- 0.000 s

Better and more user friendly would be something like: Please fill the <column> column length.

Discussion

  • Jakub Vrána

    Jakub Vrána - 2014-02-25
    • status: open --> closed-wont-fix
     
  • Jakub Vrána

    Jakub Vrána - 2014-02-25

    Adminer tries to be general and just passes the DB errors to the user. The length is already marked as required in the form though.

     

Log in to post a comment.