[Phpmyadmin-devel] Designer troubles

Isaac Bennetch bennetch at gmail.com
Tue Aug 6 17:00:45 CEST 2013

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 at 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.clktrk
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

More information about the Developers mailing list