phpMyAdmin - "Please enter a valid length"

Question

I'm trying to create a table in phpMyAdmin, and I keep getting the same error no matter how I manipulate the SQL code. This is the preview SQL that phpMyAdmin generates

CREATE TABLE `puppies`.`animals` ( 
    `id` INT(11) NOT NULL AUTO_INCREMENT , 
    `puppy_name` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , 
    `breed_id` INT(11) NOT NULL , 
    `description` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , 
    `price` DECIMAL(10,2) NOT NULL , 
    `picture_url` VARCHAR(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , 
    `sold` TINYINT(1) NOT NULL , 
    PRIMARY KEY (`id`)
) ENGINE = InnoDB;

I've tried it with multiple variations of brackets and commas.

Answer 1

I have also faced the same issue and what I did was clicked on Preview SQL and copy the sql query and paste it in the SQL Run

Answer 2

To those still experiencing this, and don't want to wait for it to randomly work again:

I just encountered this, and cannot find any explanation other than some bug.

I tried:

CREATE TABLE `database`.`measurement_types` ( 
    `TypeID` INT(2) NOT NULL AUTO_INCREMENT , 
    `Name` VARCHAR(32) NOT NULL , 
    `Description` VARCHAR(256) NOT NULL , 
    PRIMARY KEY (`TypeID`)) ENGINE = InnoDB;

Which produced the same "Please enter valid length" error

Tried a few times with different length values, but kept getting the same error.

--SOLUTION--

So I just created the table with a single column first, then altered it with the two other columns like so:

CREATE TABLE `database`.`measurement_types` ( 
    `TypeID` INT(2) NOT NULL AUTO_INCREMENT , 
    PRIMARY KEY (`TypeID`)) ENGINE = InnoDB;

And then:

ALTER TABLE `measurement_types` 
    ADD `Name` VARCHAR(32) NOT NULL AFTER `TypeID`, 
    ADD `Description` VARCHAR(256) NOT NULL AFTER `Name`;

And that worked.

I also tried to delete the table and create it with the first SQL again, and this time it worked. Seems pretty random