[Phpmyadmin-devel] Weird error

[Michal Čihař]

Hi

Dne Thu, 10 Feb 2011 08:11:23 +0100
Michal Čihař <michal at cihar.com> napsal(a):

> 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 );

Okay, the reason is that there is bookmark with table name, which does
contain this SQL. I think there should be indication that phpMyAdmin is
using bookmarked query and I will work on this.

-- 
	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- 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/eccd12f4/attachment.sig>