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=ASSIGNM...
The dump of this database can be found here:
http://tmp.cihar.com/Ashley.sql
Dne Thu, 10 Feb 2011 08:11:23 +0100 Michal Čihař michal@cihar.com napsal(a):
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.
I gave it yet another try, so it is now in bug tracker as well:
https://sourceforge.net/tracker/?func=detail&aid=3177136&group_id=23...
On Thu, Feb 10, 2011 at 12:19 PM, Michal Čihař michal@cihar.com wrote:
Dne Thu, 10 Feb 2011 08:11:23 +0100 Michal Čihař michal@cihar.com napsal(a):
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.
I gave it yet another try, so it is now in bug tracker as well:
https://sourceforge.net/tracker/?func=detail&aid=3177136&group_id=23...
I dumped that database in my local server. and it doesn't show that error. but why are u creating database on browser ?
-- Michal Čihař | http://cihar.com | http://phpmyadmin.cz
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Muhammad Adnan Twitter: @hiddenpearls I blog too do u know ? http:// www.imblog.info Failure takes you higher than success ..!
Hi
Dne Thu, 10 Feb 2011 08:11:23 +0100 Michal Čihař michal@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.
-
Adnan -
Michal Čihař