6 Aug
2013
6 Aug
'13
6 p.m.
Thanks Marc for the tips, however I had been clearing my cache. This was with
master, 4.0.5, and 4.0.0. However, I was able to isolate the problem. The short
version is this:
When creating InnoDB relations, MySQL requires both the foreign and referenced
keys to be INDEXed. I had mistakenly forgot to INDEX my foreign key. That's
apparently what caused the problem. I still think there's a shortcoming with PMA
in this regard because there should be a user-friendly notice
displayed (probably
we are trying to using some depreciated function, which is why I imagine the new
page opens), but I haven't taken the time to look at this yet in detail.
On Mon, Aug 5, 2013 at 6:05 PM, Marc Delisle <marc(a)infomarc.info> wrote:
Le 2013-08-05 17:31, Isaac Bennetch a écrit :
Hi,
I'm seeing an odd behavior with Designer. Trying to create a relation,
I click the Create relation button (about four in from the left in the
menu), then select a table's primary key and then click on a column in
a different table. I get a prompt: "Create relation OK / Cancel" --
selecting OK does not create the relation and instead opens a new
browser window with the main phpMyAdmin page loaded. Does anyone else
see this behavior?
Hi Isaac,
which branch and which browser?
By the way, if you are running from a git working directory, ensure you
clear your browser's cache and reload your page whenever you checkout a
branch.
--
Marc Delisle
http://infomarc.info
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.cl…
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel(a)lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel