[Phpmyadmin-devel] Designer troubles

[Marc Delisle]

Isaac Bennetch a écrit :
> 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.

This verification is done in Relation view but probably not (correctly) 
done in the Designer. Worth creating a bug ticket.

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


-- 
Marc Delisle
http://infomarc.info