#3871 (ok 4.0.0-rc2) "check referential integrity" broken across databases

[Alexander Schuch]

When configuring relations between tables using the phpMyAdmin relation feature, and these tables are in different databases, phpMyAdmin creates broken SELECT query in Operations > Check referential integrity - it completely ignores foreign_db set in relation configuration.

As a result, MySQL complains "Table 'table2.field2' doesn't exist". The query should refer to it as "database2.table2.field2" as "table2.field2" is not present in current database.

[Kasun Chathuranga]

Hi,
I do not understand how you set these relations between different databases using the interface. Do you manually set these relations in phpmyadmin.pma__relation table?

[Alexander Schuch]

Yes, manually.

[Marc Delisle]

Fix for 4.0.0-rc2:
https://github.com/phpmyadmin/phpmyadmin/commit/6a39a4445af0863adea037559e21914887f2ac4b