[Phpmyadmin-devel] Weird error

[Michal Čihař]

Hi all

I've just noticed this and don't have time to debug and the tracker is
not working, so I'm reporting it here.

When trying to browse empty table, I get following error:

#1050 - Table 'ASSIGNMENT' already exists

CREATE TABLE ASSIGNMENT(
ProjectID Int NOT NULL ,
EmployeeNumber Int NOT NULL ,
HoursWorked Numeric( 6, 2 ) NULL ,
CONSTRAINT ASSIGNMENT_PK PRIMARY KEY ( ProjectID, EmployeeNumber ) ,
CONSTRAINT ASSIGN_PROJ_FK FOREIGN KEY ( ProjectID ) REFERENCES
PROJECT( ProjectID ) ON UPDATE NO ACTION ON DELETE CASCADE , CONSTRAINT
ASSIGN_EMP_FK FOREIGN KEY ( EmployeeNumber ) REFERENCES
EMPLOYEE( EmployeeNumber ) ON UPDATE NO ACTION ON DELETE NO ACTION );

Yes, phpMyAdmin is trying to CREATE TABLE, when going to following URL:

http://demo.phpmyadmin.net/master-config/sql.php?db=Ashley&table=ASSIGNMENT

The dump of this database can be found here:

http://tmp.cihar.com/Ashley.sql

-- 
	Michal Čihař | http://cihar.com | http://phpmyadmin.cz
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20110210/7a89e051/attachment.sig>