phpMyAdmin

Bugs item #776789, was opened at 2003-07-24 11:17
Message generated for change (Comment added) made by aig
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=776789&group_id=23067

Category: Relations,Comments,History,...
Group: 2.5.2
Status: Open
Resolution: Fixed
Priority: 1
Submitted By: Ilya Aniskovets (aig)
Assigned to: Marc Delisle (lem9)
>Summary: (not in 2.5.3) Unable to insert record with FK in another db

Initial Comment:
I want to insert record in table 'intranet.user' but get 
this error:

SHOW TABLE STATUS FROM `intranet` 
LIKE 'human_resources.staff' 

Incorrect table name 'human_resources.staff'

I am using mysql 4.0.13 and INNODB tables with 
FOREIGN KEYS

Structure of tables in attached file


----------------------------------------------------------------------

>Comment By: Ilya Aniskovets (aig)
Date: 2003-07-25 18:57

Message:
Logged In: YES 
user_id=218271

10 minutes ago i checkout cvs from server:
cvs -
d:pserver:anonymous@...
min login 
 
cvs -z3 -
d:pserver:anonymous@...
min co

but this bug is not fixed:
//-START-
Error

SQL-query :  

SHOW TABLE STATUS FROM `intranet` 
LIKE 'human_resources.employees' 

MySQL said: 


Incorrect table name 'human_resources.employees'
//-END-

in attached jpeg file - error message



----------------------------------------------------------------------

Comment By: Marc Delisle (lem9)
Date: 2003-07-25 16:12

Message:
Logged In: YES 
user_id=210714

fixed in cvs

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=776789&group_id=23067

[Phpmyadmin-trk-bugs] [ phpmyadmin-Bugs-776789 ] (not in 2.5.3) Unable to insert record with FK in another db From: SourceForge.net <noreply@so...> - 2003-07-25 15:19 Bugs item #776789, was opened at 2003-07-24 11:17 Message generated for change (Settings changed) made by aig You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377408&aid=776789&group_id=23067 Category: Relations,Comments,History,... >Group: Latest CVS Status: Open Resolution: Fixed >Priority: 5 Submitted By: Ilya Aniskovets (aig) Assigned to: Marc Delisle (lem9) Summary: (not in 2.5.3) Unable to insert record with FK in another db Initial Comment: I want to insert record in table 'intranet.user' but get this error: SHOW TABLE STATUS FROM `intranet` LIKE 'human_resources.staff' Incorrect table name 'human_resources.staff' I am using mysql 4.0.13 and INNODB tables with FOREIGN KEYS Structure of tables in attached file ---------------------------------------------------------------------- Comment By: Ilya Aniskovets (aig) Date: 2003-07-25 18:57 Message: Logged In: YES user_id=218271 10 minutes ago i checkout cvs from server: cvs - d:pserver:anonymous@... min login cvs -z3 - d:pserver:anonymous@... min co but this bug is not fixed: //-START- Error SQL-query : SHOW TABLE STATUS FROM `intranet` LIKE 'human_resources.employees' MySQL said: Incorrect table name 'human_resources.employees' //-END- in attached jpeg file - error message ---------------------------------------------------------------------- Comment By: Marc Delisle (lem9) Date: 2003-07-25 16:12 Message: Logged In: YES user_id=210714 fixed in cvs ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=377408&aid=776789&group_id=23067

11 messages have been excluded from this view by a project administrator.