Bug #29792 Cannot create table because of field count

• Submitted: 13 Jul 2007 18:15
• Modified: 15 Jul 2007 0:43
• Reporter: Hui Ling Tan
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0
• OS: Any
• CPU Architecture: Any

[13 Jul 2007 18:15] Hui Ling Tan

Description:
i downloaded the MySQL Server 5.0 from the MySQL website~ i installed it and i can create a database using phpmyadmin 2.10.0.2~ however, i can't create a table using phpmyadmin~ i did put a number for the number of fields. But, when i click on "GO", it says SQL error, saying that "The field count is empty!". i really did put a number in the textbox, i don't know why it can't worked. I am using a PHP5 version and using IIS server on Windows XP~ Everything seems okay, just only the create table cannot worked.

How to repeat:
I don't get what does this mean.

[13 Jul 2007 21:43] MySQL Verification Team

Thank you for the bug report. Are you able to create tables using the
mysql client?. Thanks in advance.

[15 Jul 2007 0:18] Hui Ling Tan

I tried your suggestion of creating table using MySQL client. But it did not work. This is how i create table using the client:

mysql> CREATE Category (CatID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, CatName VARCHAR(30));

Now is the error message:
ERROR1064 (42000): You have an error in your SQL syntax; check the manual that correspond to your MySQL server version for the right syntax to use near 'Category (CatID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, CatName VARCHAR(30)' at line 1

[15 Jul 2007 0:29] MySQL Verification Team

Thank you for the feedback. This isn't a bug instead it is a wrong
syntax creating a table, please read the Manual how to use and use
SQL commands. Thanks in advance.

mysql> CREATE Category (CatID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> CatName VARCHAR(30));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
use near 'Category (CatID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
CatName VARCHAR(30))' at line 1

mysql> CREATE Table Category (CatID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> CatName VARCHAR(30));
Query OK, 0 rows affected (0.13 sec)

[15 Jul 2007 0:43] Hui Ling Tan

Thanks for your help. But why is it that phpmyadmin can't create a table?

[21 Aug 2007 18:55] john peters

Check this out :
http://forum.php-myadmin.ru/viewtopic.php?pid=1862
Its in Russian, but this was the suggested "workaround" which worked for me, ie: comment out these lines

//            unset($_REQUEST[$key]);
//            unset($_GET[$key]);
//            unset($_POST[$key]);
//            unset($GLOBALS[$key]);

in libraries.commonlib.php (under your phpmyadmin install)