Menu

#1688 (in 2.6.3) Invalid SQL when creating table with 0 fields

Latest_Git
fixed
Interface (555)
1
2013-06-11
2005-05-23
No

Begin creating a new table. Specify a name and set the
number of fields to 1. Submit the form without filling
in information for the field. PMA tries to execute this
SQL:

CREATE TABLE `foo` (
) TYPE = innodb

And MySQL complains that this is not valid:

#1064 - You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for
the right syntax to use near ') TYPE = innodb' at line 1

PMA should detect this and prevent the user from
proceeding to the next page until at least one field is
filled out.

Discussion

  • Marc Delisle

    Marc Delisle - 2005-06-06
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2005-06-06
    • priority: 5 --> 1
    • summary: Invalid SQL when creating table with 0 fields --> (in 2.6.3) Invalid SQL when creating table with 0 fields
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2005-06-06

    Logged In: YES
    user_id=210714

    fixed in CVS

     
  • Marc Delisle

    Marc Delisle - 2005-07-03
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed