#4920 (ok 4.4.9) relation view doesn't list fields of table in other database

[Alexander Schuch]

I tested in my own 4.4.7 and on the demo server (http://demo.phpmyadmin.net/QA_4_4/).

• Please set up databases "test1" and "test2" according to the attached dump.
• Navigate to table "test2"."test2".
• Try to set up a relation for field "test1_id" to database "test1", table "test1".

I can select database "test1". The list of tables gets updated. If I select table "test1", the list of fields there does NOT get updated and stays empty.

[Madhura Jayaratne]

Are you trying to setup a internal relations or foreign key relations. I see the column list being update for both of these. See the attached image. Is it different from what you see?

[Alexander Schuch]

I was trying to set up an internal relation (MyISAM tables).

[Alexander Schuch]

Right now I am using Firefox 38.0 and it seems to work there. The other system is using Firefox 26.0 (or 28.0). I did not see any JavaScript error in the developer console, but I haven't carefully looked at it, though.

So depending on which browsers actually are supported, this might be a non-issue. You decide.

[Alexander Schuch]

It actually is Firefox 29.0. I tried QA_4_4 on the demo server right now and it works there now. I tried again on my 4.4.7 installation and it still fails there.

I will try again after updating to the new 4.4.8.

[Alexander Schuch]

I tried in Firefox 29.0 using phpMyAdmin 4.4.8 on my own installation.

When I select another database in the structure view (MyISAM), I get a list of tables in that database.

• HTTP status code: 200
• JSON response contains a property "tables" of type "Array" with the list of tables

When I then select such a table from the drop-down, another JSON request gets fired:

• HTTP status code: 200
• JSON response contains a property "columns", but it is empty

[Alexander Schuch]

The request to fill the tables drop-down has the following query parameters: getDropdownValues, ajax_request, token, db, table, foreign, foreignDb, server.

foreignDb contains the selected target database.

The tables drop-down then is filled but once I select a table, the next request has the query parameters: getDropdownValues, ajax_request, token, db, table, foreign, foreignDb, foreignTable and server.

The issue is that "foreignDb" does not contain the selected "target database", but instead the "source database". "foreignTable" contains the selected target table name.

"source database/table/column" refers to the database/table/column I like to set up a relation for, whereas "target database/table/column" refers to the database/table/column the "source database/table/column" should be linked to.

[Madhura Jayaratne]

Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/d5371be45575a38af9381df4a82d66636460b17e