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?
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.
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@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.clk... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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@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.clk... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@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.clk... _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Isaac Bennetch -
Marc Delisle