phpMyAdmin Table Creation Error

Balefire

I recently installed version 2.3.3p1 of phpMyAdmin and get an SQL Query error every time I try to create a table inside a database. Creating a simple table with two fields yields the following:

Error

SQL-query :

CREATE TABLE example (

test1 VARCHAR( 66 ) NOT NULL ,
test2 VARCHAR( 25 ) NOT NULL ,
test1 VARCHAR( 66 ) NOT NULL ,
test2 VARCHAR( 25 ) NOT NULL
)

MySQL said:

Duplicate column name 'test1'

It seems to me that phpMyAdmin is attempting to create each table field twice (I only specified a table with 2 fields for this query). I was wondering if anyone else has experienced this and if they know how to fix it. Should I edit phpMyAdmin's table-creation code myself to fix this?

Also, not like it matters, but I'm running MySQL 4.0.4, Apache 2.0.43, and PHP 4.3.0.

notionlogic

Surely the PHPMyAdmin support forum is the best place for this question or have you already posted it there too?

You could try looking at their bugtracker page too

Wien

Balefire

If anyone is interested, I made a quick hack to work around this bug. Inside tbl_create.php, on line 55, change the line from this:

for ($i = 0; $i < $field_cnt; $i++) {

to this:

for ($i = 0; $i < $field_cnt / 2; $i++) {

It seems that for whatever reason, the field_cnt variable is twice as large as it should be.