#2389 (ok 2.10.1) #1050 - Table \'<table name>\' already exists

[William]

phpmyadmin: 2.10.0.2 (although this bug has been here since version 2.7 i think, if not earlier)

MySQL: 4.1.19-community-nt

browser: IE / Opera / Firefox

whenever i try creating a new table in a database it says the table already exists. which is not the case...

i have an idea it has to do with:
$cfg['DefaultTabTable'] = 'sql.php';

when one clicks on the table in the left frame it displays records rather than table structure. its the only thing i have out of the ordinary. the problem happens when you click on the database name on the left frame then "create new table". my suspitions is that the sql.php page remebers what the last sql statement entered was. in this case its create table. so it tries to submit it again. the table gets created in the first place though. more an anoyance than anything else cause a "fix" is to just click on the newly created table in the left frame.

this happens EVER table i try create...

---------------------------
Error
SQL query:

CREATE TABLE `db_regions` (

`ID` INT( 3 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 75 ) NULL ,
`disabled` TINYINT( 1 ) NULL DEFAULT '0'
) ENGINE = innodb;

MySQL said:

#1050 - Table 'db_regions' already exists

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

Confirmed, when
$cfg['DefaultTabTable'] = 'sql.php';

[Sebastian Mendel]

Logged In: YES
user_id=326580
Originator: NO

i did not test, but running other data manipulation statements could lead to data loss - should be fixed before 2.10.0.3

[William]

Logged In: YES
user_id=1671112
Originator: YES

thanks guys. keep up the good work. phpmyadmin is the best

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

I think the fix can wait until 2.10.1, because the bug depends on changing $cfg['DefaultTabTable'] which is probably not so common.

[Sebastian Mendel]

Logged In: YES
user_id=326580
Originator: NO

seems to be a duplicate of or related to

bug #1675997 viewing bookmarked sql queries
https://sf.net/tracker/?func=detail&aid=1675997&group_id=23067&atid=377408

[William]

Logged In: YES
user_id=1671112
Originator: YES

its not the same. i think...

$cfg['DefaultTabTable'] = 'sql.php'; should be common. makes more sence to go to the records... well as a developer it makes more sence. i used to HATE phpmyadmin before i found the "fix". the one other developer i know that uses phpmyadmin (not in our office) also uses sql.php. dont know of anyone else.. well.. other than our office. ive set it all up to use sql.php

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: NO

The reason I'm saying it must be not so common, is that in the navigation frame we have a browse icon next to each table, to do just that.

Please don't HATE phpMyAdmin for this :)

[William]

Logged In: YES
user_id=1671112
Originator: YES

i cant work without phpmyadmin... wish phpmyadmin had the whole thing that access has about creating sql.. that way it would be the BESTEST database programme EVER. lol

i create web apps similer to phpmyadmin. phpmyadmin is my "goal" lol

i never thought setting one of these bug reports would get the response ive got. so never bothered before. im impressed

[Sebastian Mendel]

Logged In: YES
user_id=326580
Originator: NO

shouldn't db_sql.php be used instead of sql.php?

[Sebastian Mendel]

Logged In: YES
user_id=326580
Originator: NO

forget about the last one ...